io.github.andezdev/tokenlite-mysql-mcp
NPM · @ANDEZDEV/TOKENLITE-MYSQL-MCP · SCANNED AUG 3
A secure, efficient, and intelligent MySQL server for the Model Context Protocol
Available components
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. How we score →
Supply Chain Security87
- No malware found by supply-chain analysis.Pass
- Only part of the dependency tree could be resolved (108 of 112), so this covers what we could see, not the whole tree.Partial
- No install/post-install scripts declared.Pass
- Only part of the dependency tree could be resolved (108 of 112), so this covers what we could see, not the whole tree. View diagnostics → Partial
Provenance & Transparency97
- Source repository is publicly reachable at the declared URL. View diagnostics → Pass
- Cryptographically verified build provenance (signed, bound to andezdev/tokenlite-mysql-mcp). View diagnostics → Pass
- Clear OSI-approved license (MIT).Pass
- Actively maintained (last published 56 days ago).Pass
- Disclosure check failed: no security disclosure policy was found in the source repository. See how to fix → Fail
Schema Quality & AI Usability82
- 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).Pass
- AI-judged instruction clarity (good).Pass
- Tool/resource definitions use about 451 tokens (~75/item across 6 items; 5 tools + 1 resources), lean.Pass
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management0
- 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.Unverified
Tool Coverage100
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 100% of tool parameters carry a description.Pass
- Structured output schemas are declared (40% of tools); any adoption earns full credit.Pass
Capabilities100
- Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass
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.
Add this component to your MCP client. Where a client-specific snippet is available, pick your client below and copy it straight into your config; otherwise use the connection detail shown.
npm · @andezdev/tokenlite-mysql-mcp
claude mcp add andezdev-tokenlite-mysql-mcp -- npx -y @andezdev/tokenlite-mysql-mcp
codex mcp add andezdev-tokenlite-mysql-mcp -- npx -y @andezdev/tokenlite-mysql-mcp
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"andezdev-tokenlite-mysql-mcp": {
"type": "local",
"command": [
"npx",
"-y",
"@andezdev/tokenlite-mysql-mcp"
],
"enabled": true
}
}
} openclaw mcp add andezdev-tokenlite-mysql-mcp --command npx --arg -y --arg @andezdev/tokenlite-mysql-mcp
mcp_servers:
andezdev-tokenlite-mysql-mcp:
command: "npx"
args: ["-y", "@andezdev/tokenlite-mysql-mcp"] {
"mcpServers": {
"andezdev-tokenlite-mysql-mcp": {
"command": "npx",
"args": [
"-y",
"@andezdev/tokenlite-mysql-mcp"
]
}
}
} Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 3 Aug 26 0
- 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. security
- 2 Aug 26 +36
- Known CVEs: unverified → partial ▲ security
- Install scripts: unverified → pass ▲ security
- 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 security
- Tool coverage: 100 → unverified ▼ functional
- Security disclosure: fail → unverified ▼ functional
- Schema quality: 100 → unverified ▼ functional
- Schema quality: unverified → good ▲ functional
- MCP protocol: unverified → pass ▲ functional
- Maintenance: unverified → pass ▲ functional
- Dependency health: unverified → partial ▲ functional
- License: unverified → pass ▲ functional
- Licence: MIT functional
- 1 Aug 26 +36
- Malware scan: unverified → pass ▲ security
- Schema quality: unverified → 100 ▲ functional
- Tool coverage: unverified → 100 ▲ functional
- 31 Jul 26 −48
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
- 28 Jul 26 +29
- Schema quality: unverified → 100 ▲ functional
- 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 functional
- 27 Jul 26 24
First indexed and scored.
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 3 Aug 2026 · Analysed npm/@andezdev/[email protected]
Provenance verified
Ecosystem: npm · Outcome: verified
Reason: verified
- Source repo:
- andezdev/tokenlite-mysql-mcp
- Certificate issuer:
- https://token.actions.githubusercontent.com
- Certificate SAN:
- https://github.com/andezdev/tokenlite-mysql-mcp/.github/workflows/release-please.yml@refs/heads/main
- Rekor log index:
- 1747420402
- Predicate type:
- https://slsa.dev/provenance/v1
- Subject digest:
- sha512:6e24367d75bfec59dadd886b4d88be44c0228d95b41b3b5465cf495bb037404a56156f9623ef4582c02d60228ab8a155ebbb74d1326d9256c7c4bc23f
- Discovery method:
- attestation_endpoint
Dependencies 108 packages
108 packages in the resolved dependency tree · 108 deprecated · 34 stale.
The dependency tree was only partially resolved, so these counts may be incomplete.
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability.
db_2zha_execute_safe_query ~123
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.
| Name | Type | Req | Description |
|---|---|---|---|
| sql | string | yes | SQL SELECT statement to execute. |
No output schema declared.
No examples provided.
db_2zha_explain_query ~92
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.
| Name | Type | Req | Description |
|---|---|---|---|
| sql | string | yes | The SELECT query to analyze. |
| Name | Type | Req | Description |
|---|---|---|---|
| rows | array | yes | EXPLAIN output rows |
No examples provided.
db_2zha_ping ~43
Health check: verifies the database connection is alive. Returns JSON with status, MySQL server version, and connection pool stats (active, idle, queued).
Input schema present but exposes no named parameters.
| Name | Type | Req | Description |
|---|---|---|---|
| error | string | — | Error message if status is 'error' |
| pool | object | yes | — |
| server_version | string | — | MySQL server version |
| status | string | yes | Whether the database connection is healthy |
No examples provided.
db_2zha_refresh_schema ~51
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.
Input schema present but exposes no named parameters.
No output schema declared.
No examples provided.
db_2zha_search_schema ~129
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.
| Name | Type | Req | Description |
|---|---|---|---|
| query | string | yes | The name of the table or entity to search for (e.g. 'users', 'invoices'). |
No output schema declared.
No examples provided.