tokenlite-mysql-mcp

Indexed by io.github.andezdev

About

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

Use this server

Add it to your MCP client. The catalogue lists this config verbatim from its source — it does not run, download, or vouch for the server. Review the command before you run it.

Transportstdio (runs a local command)

Env varsDB_HOST DB_PORT DB_USER DB_PASSWORD DB_NAME MCP_EXPLAIN_MAX_SCAN_ROWS MCP_QUERY_ROW_LIMIT MCP_SAFE_QUERY_MAX_ROWS MCP_SAFE_QUERY_ENABLE_BLOCKING MCP_METADATA_PATH MCP_TEMPLATES_PATH TOOL_PREFIX MCP_RATE_LIMIT_RPM MYSQL_QUERY_TIMEOUT MYSQL_CONNECTION_LIMIT MYSQL_CONNECT_TIMEOUT MYSQL_RETRY_ATTEMPTS MYSQL_RETRY_DELAY_MS MYSQL_QUEUE_LIMIT MCP_DDL_CACHE_TTL MCP_LOG_LEVEL ALLOW_INSERT_OPERATION ALLOW_UPDATE_OPERATION ALLOW_DELETE_OPERATION ALLOW_DDL_OPERATION DB_SSL DB_SSL_REJECT_UNAUTHORIZED

Claude Code

claude mcp add --env DB_HOST= --env DB_PORT= --env DB_USER= --env DB_PASSWORD= --env DB_NAME= --env MCP_EXPLAIN_MAX_SCAN_ROWS= --env MCP_QUERY_ROW_LIMIT= --env MCP_SAFE_QUERY_MAX_ROWS= --env MCP_SAFE_QUERY_ENABLE_BLOCKING= --env MCP_METADATA_PATH= --env MCP_TEMPLATES_PATH= --env TOOL_PREFIX= --env MCP_RATE_LIMIT_RPM= --env MYSQL_QUERY_TIMEOUT= --env MYSQL_CONNECTION_LIMIT= --env MYSQL_CONNECT_TIMEOUT= --env MYSQL_RETRY_ATTEMPTS= --env MYSQL_RETRY_DELAY_MS= --env MYSQL_QUEUE_LIMIT= --env MCP_DDL_CACHE_TTL= --env MCP_LOG_LEVEL= --env ALLOW_INSERT_OPERATION= --env ALLOW_UPDATE_OPERATION= --env ALLOW_DELETE_OPERATION= --env ALLOW_DDL_OPERATION= --env DB_SSL= --env DB_SSL_REJECT_UNAUTHORIZED= tokenlite-mysql-mcp -- npx @andezdev/tokenlite-mysql-mcp

Cursor

Add to Cursor

If the button doesn't open Cursor, use the JSON below — Cursor accepts the same mcpServers config.

VS Code

code --add-mcp '{"name":"tokenlite-mysql-mcp","command":"npx","args":["@andezdev/tokenlite-mysql-mcp"],"env":{"DB_HOST":"","DB_PORT":"","DB_USER":"","DB_PASSWORD":"","DB_NAME":"","MCP_EXPLAIN_MAX_SCAN_ROWS":"","MCP_QUERY_ROW_LIMIT":"","MCP_SAFE_QUERY_MAX_ROWS":"","MCP_SAFE_QUERY_ENABLE_BLOCKING":"","MCP_METADATA_PATH":"","MCP_TEMPLATES_PATH":"","TOOL_PREFIX":"","MCP_RATE_LIMIT_RPM":"","MYSQL_QUERY_TIMEOUT":"","MYSQL_CONNECTION_LIMIT":"","MYSQL_CONNECT_TIMEOUT":"","MYSQL_RETRY_ATTEMPTS":"","MYSQL_RETRY_DELAY_MS":"","MYSQL_QUEUE_LIMIT":"","MCP_DDL_CACHE_TTL":"","MCP_LOG_LEVEL":"","ALLOW_INSERT_OPERATION":"","ALLOW_UPDATE_OPERATION":"","ALLOW_DELETE_OPERATION":"","ALLOW_DDL_OPERATION":"","DB_SSL":"","DB_SSL_REJECT_UNAUTHORIZED":""}}'

JSON

{
  "mcpServers": {
    "tokenlite-mysql-mcp": {
      "command": "npx",
      "args": [
        "@andezdev/tokenlite-mysql-mcp"
      ],
      "env": {
        "DB_HOST": "",
        "DB_PORT": "",
        "DB_USER": "",
        "DB_PASSWORD": "",
        "DB_NAME": "",
        "MCP_EXPLAIN_MAX_SCAN_ROWS": "",
        "MCP_QUERY_ROW_LIMIT": "",
        "MCP_SAFE_QUERY_MAX_ROWS": "",
        "MCP_SAFE_QUERY_ENABLE_BLOCKING": "",
        "MCP_METADATA_PATH": "",
        "MCP_TEMPLATES_PATH": "",
        "TOOL_PREFIX": "",
        "MCP_RATE_LIMIT_RPM": "",
        "MYSQL_QUERY_TIMEOUT": "",
        "MYSQL_CONNECTION_LIMIT": "",
        "MYSQL_CONNECT_TIMEOUT": "",
        "MYSQL_RETRY_ATTEMPTS": "",
        "MYSQL_RETRY_DELAY_MS": "",
        "MYSQL_QUEUE_LIMIT": "",
        "MCP_DDL_CACHE_TTL": "",
        "MCP_LOG_LEVEL": "",
        "ALLOW_INSERT_OPERATION": "",
        "ALLOW_UPDATE_OPERATION": "",
        "ALLOW_DELETE_OPERATION": "",
        "ALLOW_DDL_OPERATION": "",
        "DB_SSL": "",
        "DB_SSL_REJECT_UNAUTHORIZED": ""
      }
    }
  }
}

Environment variables are listed by name only — fill in your own values. Entries never carry secrets.