io.github.andezdev/tokenlite-mysql-mcp

io.github.andezdev/tokenlite-mysql-mcp·v3.1.1·Databases

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

Trust verdict · v1 advisory · method

NOT YET SCREENEDno verdict on file

Verdict not yet evaluated for this tool. The hybrid eval runs adversarial cases first; coverage rolls out as the corpus expands (15 of 150 labels to graduation). Until a verdict is recorded, an agent should treat this tool as not-yet-cleared and fall back to its own checks. Method: hybrid 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_SAFE_QUERY_MAX_ROWS

Threshold for EXPLAIN to block unindexed Full Table Scans (defaults to 1000)

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 random prefix like db_a1b2_)

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)

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

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_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>",
        "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>"
      }
    }
  }
}

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_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>",
        "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>"
      }
    }
  }
}

Cline (cline_mcp_settings.json)

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: v3.1.1
category: Databases
quality: 85 / 100
operator: andezdev

Provenance

Verdict history is anchored to Bitcoin via OpenTimestamps. The free tier returns the current verdict only; the anchored record is served on the authenticated tier.

Links

Repository →