Tokenlite Mysql MCP Server

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

claude mcp add tokenlite-mysql-mcp -e 'DB_NAME=<DB_NAME>' -- npx -y @andezdev/tokenlite-mysql-mcp

{
  "mcpServers": {
    "tokenlite-mysql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@andezdev/tokenlite-mysql-mcp"
      ],
      "env": {
        "DB_NAME": "<DB_NAME>"
      }
    }
  }
}

[mcp_servers.tokenlite-mysql-mcp]
command = "npx"
args = ["-y", "@andezdev/tokenlite-mysql-mcp"]
env = { DB_NAME = "<DB_NAME>" }

{
  "mcpServers": {
    "tokenlite-mysql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@andezdev/tokenlite-mysql-mcp"
      ],
      "env": {
        "DB_NAME": "<DB_NAME>"
      }
    }
  }
}

{
  "servers": {
    "tokenlite-mysql-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@andezdev/tokenlite-mysql-mcp"
      ],
      "env": {
        "DB_NAME": "<DB_NAME>"
      }
    }
  }
}

Put your own value in place of <DB_NAME> (MySQL Database name). The author’s registry entry marks it as required.

Optional settings from the registry entry, left out of the block above: DB_HOST (MySQL Host address (defaults to localhost)), DB_PORT (MySQL Port (defaults to 3306)), DB_USER (MySQL Username (defaults to root)), DB_PASSWORD (MySQL Password (defaults to empty string)), 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)).