io.github.andezdev/tokenlite-mysql-mcp

io.github.andezdev/tokenlite-mysql-mcp·v4.1.0·Databases

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

In-path gate · all MCP tools

Using io.github.andezdev/tokenlite-mysql-mcp in Claude, Cursor, Gemini CLI, Cline, or Zed?

MCP tool contracts can change remotely with no version bump. The mcpindex gate pins each contract and HOLDs the call when it drifts-before your agent acts. Zero credentials. This is not the package install for this server itself (use Install this server for that).

Install the mcpindex gate (one command)

Rewrites your MCP host config so each server launches behind the gate. Inspect first: curl -fsSL https://mcpindex.ai/install.sh | less

curl -fsSL https://mcpindex.ai/install.sh | sh

Auditable install path →Watch it hold a drift →

Trust verdict · v1 advisory · method

NOT YET SCREENEDno verdict on file

Verdict not yet evaluated for this tool. The semantic screen takes adversarial cases first; coverage rolls out as the corpus expands (15/150 labels to graduation). The deterministic conformance probe is built but has not yet run on the public corpus, so a recorded verdict here is REVIEW or UNVERIFIED, never a clearing ALLOW. Until a verdict is recorded, an agent should treat this tool as not-yet-cleared and fall back to its own checks. Method: the eval, four-state verdict, honest limits.

Own this server? Screen its description →

Environment variables

DB_HOST

MySQL Host address (defaults to localhost)

DB_PORT

MySQL Port (defaults to 3306)

DB_USER

MySQL Username (defaults to root)

DB_PASSWORD

secret

MySQL Password (defaults to empty string)

DB_NAME

required

MySQL Database name

MCP_EXPLAIN_MAX_SCAN_ROWS

EXPLAIN guardrail: max estimated rows for unindexed full table scans before blocking (defaults to 1000). MCP_SAFE_QUERY_MAX_ROWS is a deprecated alias.

MCP_QUERY_ROW_LIMIT

Max rows returned per SELECT; injected as LIMIT at the AST level (defaults to 500)

MCP_SAFE_QUERY_MAX_ROWS

Deprecated alias for MCP_EXPLAIN_MAX_SCAN_ROWS

MCP_SAFE_QUERY_ENABLE_BLOCKING

Enable or disable the EXPLAIN guardrail (defaults to true)

MCP_METADATA_PATH

Absolute path to your custom metadata.json dictionary

MCP_TEMPLATES_PATH

Absolute path to your custom templates.json pre-approved queries

TOOL_PREFIX

Prefix for tool names, e.g., to run multiple instances (defaults to DB_NAME, e.g. mydb_). Only set to override.

MCP_RATE_LIMIT_RPM

Max tool invocations per minute, sliding window (defaults to 60). Set to 0 to disable.

MYSQL_QUERY_TIMEOUT

Max execution time for a query in milliseconds to protect against DoS (defaults to 15000)

MYSQL_CONNECTION_LIMIT

Max concurrent pool connections (defaults to 10)

MYSQL_CONNECT_TIMEOUT

Max time to wait for a connection socket to establish in milliseconds (defaults to 10000)

MYSQL_RETRY_ATTEMPTS

Max retries on transient connection errors (defaults to 3)

MYSQL_RETRY_DELAY_MS

Base delay in milliseconds for exponential backoff between retries (defaults to 1000)

MYSQL_QUEUE_LIMIT

Max queued requests when all pool connections are busy to prevent memory leak (defaults to 50)

MCP_DDL_CACHE_TTL

Time-to-live in seconds for cached DDL statements (defaults to 60)

MCP_LOG_LEVEL

Minimum severity level for MCP log notifications (defaults to info). Levels: debug, info, notice, warning, error, critical, alert, emergency

ALLOW_INSERT_OPERATION

Enable INSERT and REPLACE queries (defaults to false)

ALLOW_UPDATE_OPERATION

Enable UPDATE queries (defaults to false)

ALLOW_DELETE_OPERATION

Enable DELETE and TRUNCATE queries (defaults to false)

ALLOW_DDL_OPERATION

Enable Data Definition Language queries like CREATE, ALTER, DROP, RENAME (defaults to false)

DB_SSL

Enable TLS for the MySQL connection (defaults to false)

DB_SSL_REJECT_UNAUTHORIZED

Reject self-signed or untrusted TLS certificates when DB_SSL is true (defaults to true)

MCP quality score · maturity, not trust · methodology

freshness

completeness

installability

documentation

stability

Alternatives in Databases

ai.haymon/dbmcp

Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite with PII redaction and write-prevention

ai.smithery/MisterSandFR-supabase-mcp-selfhosted

Manage Supabase projects end to end across database, auth, storage, realtime, and migrations. Moni…

ai.smithery/afgong-sqlite-mcp-server

Explore your Messages SQLite database to browse tables and inspect schemas with ease. Run flexible…

Install this server

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "tokenlite-mysql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@andezdev/tokenlite-mysql-mcp"
      ],
      "env": {
        "DB_HOST": "<db_host>",
        "DB_PORT": "<db_port>",
        "DB_USER": "<db_user>",
        "DB_PASSWORD": "<your-db_password>",
        "DB_NAME": "<db_name>",
        "MCP_EXPLAIN_MAX_SCAN_ROWS": "<mcp_explain_max_scan_rows>",
        "MCP_QUERY_ROW_LIMIT": "<mcp_query_row_limit>",
        "MCP_SAFE_QUERY_MAX_ROWS": "<mcp_safe_query_max_rows>",
        "MCP_SAFE_QUERY_ENABLE_BLOCKING": "<mcp_safe_query_enable_blocking>",
        "MCP_METADATA_PATH": "<mcp_metadata_path>",
        "MCP_TEMPLATES_PATH": "<mcp_templates_path>",
        "TOOL_PREFIX": "<tool_prefix>",
        "MCP_RATE_LIMIT_RPM": "<mcp_rate_limit_rpm>",
        "MYSQL_QUERY_TIMEOUT": "<mysql_query_timeout>",
        "MYSQL_CONNECTION_LIMIT": "<mysql_connection_limit>",
        "MYSQL_CONNECT_TIMEOUT": "<mysql_connect_timeout>",
        "MYSQL_RETRY_ATTEMPTS": "<mysql_retry_attempts>",
        "MYSQL_RETRY_DELAY_MS": "<mysql_retry_delay_ms>",
        "MYSQL_QUEUE_LIMIT": "<mysql_queue_limit>",
        "MCP_DDL_CACHE_TTL": "<mcp_ddl_cache_ttl>",
        "MCP_LOG_LEVEL": "<mcp_log_level>",
        "ALLOW_INSERT_OPERATION": "<allow_insert_operation>",
        "ALLOW_UPDATE_OPERATION": "<allow_update_operation>",
        "ALLOW_DELETE_OPERATION": "<allow_delete_operation>",
        "ALLOW_DDL_OPERATION": "<allow_ddl_operation>",
        "DB_SSL": "<db_ssl>",
        "DB_SSL_REJECT_UNAUTHORIZED": "<db_ssl_reject_unauthorized>"
      }
    }
  }
}

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "tokenlite-mysql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@andezdev/tokenlite-mysql-mcp"
      ],
      "env": {
        "DB_HOST": "<db_host>",
        "DB_PORT": "<db_port>",
        "DB_USER": "<db_user>",
        "DB_PASSWORD": "<your-db_password>",
        "DB_NAME": "<db_name>",
        "MCP_EXPLAIN_MAX_SCAN_ROWS": "<mcp_explain_max_scan_rows>",
        "MCP_QUERY_ROW_LIMIT": "<mcp_query_row_limit>",
        "MCP_SAFE_QUERY_MAX_ROWS": "<mcp_safe_query_max_rows>",
        "MCP_SAFE_QUERY_ENABLE_BLOCKING": "<mcp_safe_query_enable_blocking>",
        "MCP_METADATA_PATH": "<mcp_metadata_path>",
        "MCP_TEMPLATES_PATH": "<mcp_templates_path>",
        "TOOL_PREFIX": "<tool_prefix>",
        "MCP_RATE_LIMIT_RPM": "<mcp_rate_limit_rpm>",
        "MYSQL_QUERY_TIMEOUT": "<mysql_query_timeout>",
        "MYSQL_CONNECTION_LIMIT": "<mysql_connection_limit>",
        "MYSQL_CONNECT_TIMEOUT": "<mysql_connect_timeout>",
        "MYSQL_RETRY_ATTEMPTS": "<mysql_retry_attempts>",
        "MYSQL_RETRY_DELAY_MS": "<mysql_retry_delay_ms>",
        "MYSQL_QUEUE_LIMIT": "<mysql_queue_limit>",
        "MCP_DDL_CACHE_TTL": "<mcp_ddl_cache_ttl>",
        "MCP_LOG_LEVEL": "<mcp_log_level>",
        "ALLOW_INSERT_OPERATION": "<allow_insert_operation>",
        "ALLOW_UPDATE_OPERATION": "<allow_update_operation>",
        "ALLOW_DELETE_OPERATION": "<allow_delete_operation>",
        "ALLOW_DDL_OPERATION": "<allow_ddl_operation>",
        "DB_SSL": "<db_ssl>",
        "DB_SSL_REJECT_UNAUTHORIZED": "<db_ssl_reject_unauthorized>"
      }
    }
  }
}

Cline (cline_mcp_settings.json)

npx -y @andezdev/tokenlite-mysql-mcp

Claude Code (claude mcp add)

claude mcp add --scope user tokenlite-mysql-mcp -- npx -y @andezdev/tokenlite-mysql-mcp

Gemini CLI (gemini mcp add)

gemini mcp add -s user tokenlite-mysql-mcp npx -y @andezdev/tokenlite-mysql-mcp

Verdict API

curl -s mcpindex.ai/api/v1/trust/server/io-github-andezdev-tokenlite-mysql-mcp

Free-tier verdict as JSON: decision + dimensions + severity. Call it from your agent before it invokes a tool it just discovered.

Details

version: v4.1.0
category: Databases
quality: 84 / 100
operator: andezdev

Provenance

Verdict history is anchored to Bitcoin via OpenTimestamps. The anchor proof is public and any skeptic can recompute it offline.

Links

Repository →