# io.github.andezdev/tokenlite-mysql-mcp (npm · @andezdev/tokenlite-mysql-mcp)

A secure, efficient, and intelligent MySQL server for the Model Context Protocol

- Trust score: 77/100 (medium)
- Change this week: +53
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-08-03

## Components

- npm · `@andezdev/tokenlite-mysql-mcp`: 77/100 (this document), [markdown](https://verifymcp.io/servers/andezdev-tokenlite-mysql-mcp/andezdev-tokenlite-mysql-mcp.md), [page](https://verifymcp.io/servers/andezdev-tokenlite-mysql-mcp/andezdev-tokenlite-mysql-mcp)

## Channel facts

- Registry: `npm`
- Package: `@andezdev/tokenlite-mysql-mcp`
- Version: `4.1.0`
- Transport: `stdio`

## Trust breakdown

How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-08-03.

- **Supply Chain Security**: 87/100
  - No malware found by supply-chain analysis.
  - Only part of the dependency tree could be resolved (108 of 112), so this covers what we could see, not the whole tree.
  - No install/post-install scripts declared.
  - Only part of the dependency tree could be resolved (108 of 112), so this covers what we could see, not the whole tree.
- **Provenance & Transparency**: 97/100
  - Source repository is publicly reachable at the declared URL.
  - Cryptographically verified build provenance (signed, bound to andezdev/tokenlite-mysql-mcp).
  - Clear OSI-approved license (MIT).
  - Actively maintained (last published 56 days ago).
  - Disclosure check failed: no security disclosure policy was found in the source repository.
- **Schema Quality & AI Usability**: 82/100
  - 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).
  - AI-judged instruction clarity (good).
  - Tool/resource definitions use about 451 tokens (~75/item across 6 items; 5 tools + 1 resources), lean.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 0/100
  - Stability not yet verified: two runs of the same published version returned different tool surfaces, so we cannot tell a change in the package from a difference in our own sandbox run.
- **Tool Coverage**: 100/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 100% of tool parameters carry a description.
  - Structured output schemas are declared (40% of tools); any adoption earns full credit.
- **Capabilities**: 100/100
  - Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.

**Unverified: 1 category.** A category scored 0 because we could not verify it: a data source with nothing on this package, evidence we could not reach, or a check we could not run. We only credit what we can confirm.

## Install

### Claude

```bash
claude mcp add andezdev-tokenlite-mysql-mcp -- npx -y @andezdev/tokenlite-mysql-mcp
```

### Codex

```bash
codex mcp add andezdev-tokenlite-mysql-mcp -- npx -y @andezdev/tokenlite-mysql-mcp
```

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "andezdev-tokenlite-mysql-mcp": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "@andezdev/tokenlite-mysql-mcp"
      ],
      "enabled": true
    }
  }
}
```

### OpenClaw

```bash
openclaw mcp add andezdev-tokenlite-mysql-mcp --command npx --arg -y --arg @andezdev/tokenlite-mysql-mcp
```

### Hermes

```yaml
mcp_servers:
  andezdev-tokenlite-mysql-mcp:
    command: "npx"
    args: ["-y", "@andezdev/tokenlite-mysql-mcp"]
```

### Other

```json
{
  "mcpServers": {
    "andezdev-tokenlite-mysql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@andezdev/tokenlite-mysql-mcp"
      ]
    }
  }
}
```

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-08-03 (score 77, 0)

- [security] Stability: Stability not yet verified: two runs of the same published version returned different tool surfaces, so we cannot tell a change in the package from a difference in our own sandbox run.

### 2026-08-02 (score 77, +36)

- [security improvement] Known CVEs: unverified → partial
- [security improvement] Install scripts: unverified → pass
- [security improvement] Provenance: unverified → pass
- [security] Stability: Stability not yet verified: not enough scan history yet (needs a 30-day window).
- [security] The attested source repository moved: andezdev/tokenlite-mysql-mcp
- [functional regression] Tool coverage: 100 → unverified
- [functional regression] Security disclosure: fail → unverified
- [functional regression] Schema quality: 100 → unverified
- [functional improvement] Schema quality: unverified → good
- [functional improvement] MCP protocol: unverified → pass
- [functional improvement] Maintenance: unverified → pass
- [functional improvement] Dependency health: unverified → partial
- [functional improvement] License: unverified → pass
- [functional] Licence: MIT

### 2026-08-01 (score 41, +36)

- [security improvement] Malware scan: unverified → pass
- [functional improvement] Schema quality: unverified → 100
- [functional improvement] Tool coverage: unverified → 100

### 2026-07-31 (score 5, −48)

- [functional] We updated how we score, so this day's move reflects our rubric, not a change to the server

### 2026-07-28 (score 53, +29)

- [functional improvement] Schema quality: unverified → 100
- [functional improvement] Tool coverage: unverified → 100
- [functional] First check of Tool coverage: 40
- [functional] First check of Schema quality: fail
- [functional] First check of Tool coverage: 100
- [functional] First check of Schema quality: unverified
- [functional] First check of Schema quality: pass

### 2026-07-27 (score 24)

First indexed and scored.

## MCP tools (5)

### `db_2zha_search_schema` (~129 tokens)

CRITICAL TOOL FOR SCHEMA EXPLORATION: Use this FIRST before writing queries. Fuzzy-searches a table name and returns its DDL plus direct parent/child table DDLs (Auto-Join Context), inferred FK hints, and semantic dictionary entries from metadata.json when configured. If templates.json is loaded, reminds you to use the 'query_templates' prompt for business metrics. Do NOT use execute_safe_query for schema exploration.

Input parameters:

- `query` (string, required): The name of the table or entity to search for (e.g. 'users', 'invoices').

### `db_2zha_execute_safe_query` (~123 tokens)

Executes SQL against the database with AST validation. SELECT results are capped by MCP_QUERY_ROW_LIMIT (default 500, AST-injected LIMIT) and include a '-- rows: N (truncated at LIMIT X)' footer when the cap is reached. Unindexed full table scans above MCP_EXPLAIN_MAX_SCAN_ROWS are blocked before execution. CRITICAL: NEVER use this tool (e.g., SHOW TABLES or querying information_schema) to explore schema — use 'search_schema' first.

Input parameters:

- `sql` (string, required): SQL SELECT statement to execute.

### `db_2zha_refresh_schema` (~51 tokens)

Rebuilds the internal Schema Graph from the live database and notifies subscribed MCP resources. Use when search_schema or execute_safe_query fail with missing table/column errors after a schema change.

### `db_2zha_ping` (~43 tokens)

Health check: verifies the database connection is alive. Returns JSON with status, MySQL server version, and connection pool stats (active, idle, queued).

Output parameters:

- `error` (string): Error message if status is 'error'
- `pool` (object)
- `server_version` (string): MySQL server version
- `status` (string): Whether the database connection is healthy

### `db_2zha_explain_query` (~92 tokens)

Returns MySQL EXPLAIN output as CSV for a validated SELECT query. SQL is AST-validated and timeout-protected; ANALYZE and non-SELECT statements are blocked. Unlike execute_safe_query, this does NOT block full table scans — use it to diagnose why a query was blocked or to verify index usage before executing.

Input parameters:

- `sql` (string, required): The SELECT query to analyze.

Output parameters:

- `rows` (array): EXPLAIN output rows

## Diagnostics

Captured diagnostic sections: Provenance, Dependencies. The full working is on the page: https://verifymcp.io/servers/andezdev-tokenlite-mysql-mcp/andezdev-tokenlite-mysql-mcp#diagnostics

## Score history

- 2026-08-03: 77
- 2026-08-02: 77
- 2026-08-01: 41
- 2026-07-31: 5
- 2026-07-30: 53
- 2026-07-28: 53
- 2026-07-27: 24

## Links

- npm package: https://www.npmjs.com/package/@andezdev/tokenlite-mysql-mcp
- Socket report: https://socket.dev/npm/package/@andezdev/tokenlite-mysql-mcp
- Repository: https://github.com/andezdev/tokenlite-mysql-mcp
- Changelog RSS feed: https://verifymcp.io/servers/andezdev-tokenlite-mysql-mcp/andezdev-tokenlite-mysql-mcp/changelog.xml
- Changelog JSON feed: https://verifymcp.io/servers/andezdev-tokenlite-mysql-mcp/andezdev-tokenlite-mysql-mcp/changelog.json
- HTML version of this page: https://verifymcp.io/servers/andezdev-tokenlite-mysql-mcp/andezdev-tokenlite-mysql-mcp