PluginBench
MCP Server
Active
MIT

io.github.andezdev/tokenlite-mysql-mcp MCP Server

io.github.andezdev/tokenlite-mysql-mcp

RepositoryRegistry

What is the io.github.andezdev/tokenlite-mysql-mcp MCP server?

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

How to install io.github.andezdev/tokenlite-mysql-mcp

Copy-paste configuration for popular MCP clients.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • 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)

Claude Desktop
~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "tokenlite-mysql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@andezdev/tokenlite-mysql-mcp"
      ],
      "env": {
        "DB_HOST": "<YOUR_DB_HOST>",
        "DB_PORT": "<YOUR_DB_PORT>",
        "DB_USER": "<YOUR_DB_USER>",
        "DB_PASSWORD": "<YOUR_DB_PASSWORD>",
        "DB_NAME": "<YOUR_DB_NAME>",
        "MCP_EXPLAIN_MAX_SCAN_ROWS": "<YOUR_MCP_EXPLAIN_MAX_SCAN_ROWS>",
        "MCP_QUERY_ROW_LIMIT": "<YOUR_MCP_QUERY_ROW_LIMIT>",
        "MCP_SAFE_QUERY_MAX_ROWS": "<YOUR_MCP_SAFE_QUERY_MAX_ROWS>",
        "MCP_SAFE_QUERY_ENABLE_BLOCKING": "<YOUR_MCP_SAFE_QUERY_ENABLE_BLOCKING>",
        "MCP_METADATA_PATH": "<YOUR_MCP_METADATA_PATH>",
        "MCP_TEMPLATES_PATH": "<YOUR_MCP_TEMPLATES_PATH>",
        "TOOL_PREFIX": "<YOUR_TOOL_PREFIX>",
        "MCP_RATE_LIMIT_RPM": "<YOUR_MCP_RATE_LIMIT_RPM>",
        "MYSQL_QUERY_TIMEOUT": "<YOUR_MYSQL_QUERY_TIMEOUT>",
        "MYSQL_CONNECTION_LIMIT": "<YOUR_MYSQL_CONNECTION_LIMIT>",
        "MYSQL_CONNECT_TIMEOUT": "<YOUR_MYSQL_CONNECT_TIMEOUT>",
        "MYSQL_RETRY_ATTEMPTS": "<YOUR_MYSQL_RETRY_ATTEMPTS>",
        "MYSQL_RETRY_DELAY_MS": "<YOUR_MYSQL_RETRY_DELAY_MS>",
        "MYSQL_QUEUE_LIMIT": "<YOUR_MYSQL_QUEUE_LIMIT>",
        "MCP_DDL_CACHE_TTL": "<YOUR_MCP_DDL_CACHE_TTL>",
        "MCP_LOG_LEVEL": "<YOUR_MCP_LOG_LEVEL>",
        "ALLOW_INSERT_OPERATION": "<YOUR_ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<YOUR_ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<YOUR_ALLOW_DELETE_OPERATION>",
        "ALLOW_DDL_OPERATION": "<YOUR_ALLOW_DDL_OPERATION>",
        "DB_SSL": "<YOUR_DB_SSL>",
        "DB_SSL_REJECT_UNAUTHORIZED": "<YOUR_DB_SSL_REJECT_UNAUTHORIZED>"
      }
    }
  }
}
Cursor
~/.cursor/mcp.json
{
  "mcpServers": {
    "tokenlite-mysql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@andezdev/tokenlite-mysql-mcp"
      ],
      "env": {
        "DB_HOST": "<YOUR_DB_HOST>",
        "DB_PORT": "<YOUR_DB_PORT>",
        "DB_USER": "<YOUR_DB_USER>",
        "DB_PASSWORD": "<YOUR_DB_PASSWORD>",
        "DB_NAME": "<YOUR_DB_NAME>",
        "MCP_EXPLAIN_MAX_SCAN_ROWS": "<YOUR_MCP_EXPLAIN_MAX_SCAN_ROWS>",
        "MCP_QUERY_ROW_LIMIT": "<YOUR_MCP_QUERY_ROW_LIMIT>",
        "MCP_SAFE_QUERY_MAX_ROWS": "<YOUR_MCP_SAFE_QUERY_MAX_ROWS>",
        "MCP_SAFE_QUERY_ENABLE_BLOCKING": "<YOUR_MCP_SAFE_QUERY_ENABLE_BLOCKING>",
        "MCP_METADATA_PATH": "<YOUR_MCP_METADATA_PATH>",
        "MCP_TEMPLATES_PATH": "<YOUR_MCP_TEMPLATES_PATH>",
        "TOOL_PREFIX": "<YOUR_TOOL_PREFIX>",
        "MCP_RATE_LIMIT_RPM": "<YOUR_MCP_RATE_LIMIT_RPM>",
        "MYSQL_QUERY_TIMEOUT": "<YOUR_MYSQL_QUERY_TIMEOUT>",
        "MYSQL_CONNECTION_LIMIT": "<YOUR_MYSQL_CONNECTION_LIMIT>",
        "MYSQL_CONNECT_TIMEOUT": "<YOUR_MYSQL_CONNECT_TIMEOUT>",
        "MYSQL_RETRY_ATTEMPTS": "<YOUR_MYSQL_RETRY_ATTEMPTS>",
        "MYSQL_RETRY_DELAY_MS": "<YOUR_MYSQL_RETRY_DELAY_MS>",
        "MYSQL_QUEUE_LIMIT": "<YOUR_MYSQL_QUEUE_LIMIT>",
        "MCP_DDL_CACHE_TTL": "<YOUR_MCP_DDL_CACHE_TTL>",
        "MCP_LOG_LEVEL": "<YOUR_MCP_LOG_LEVEL>",
        "ALLOW_INSERT_OPERATION": "<YOUR_ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<YOUR_ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<YOUR_ALLOW_DELETE_OPERATION>",
        "ALLOW_DDL_OPERATION": "<YOUR_ALLOW_DDL_OPERATION>",
        "DB_SSL": "<YOUR_DB_SSL>",
        "DB_SSL_REJECT_UNAUTHORIZED": "<YOUR_DB_SSL_REJECT_UNAUTHORIZED>"
      }
    }
  }
}
Windsurf
~/.codeium/windsurf/mcp_config.json
{
  "mcpServers": {
    "tokenlite-mysql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@andezdev/tokenlite-mysql-mcp"
      ],
      "env": {
        "DB_HOST": "<YOUR_DB_HOST>",
        "DB_PORT": "<YOUR_DB_PORT>",
        "DB_USER": "<YOUR_DB_USER>",
        "DB_PASSWORD": "<YOUR_DB_PASSWORD>",
        "DB_NAME": "<YOUR_DB_NAME>",
        "MCP_EXPLAIN_MAX_SCAN_ROWS": "<YOUR_MCP_EXPLAIN_MAX_SCAN_ROWS>",
        "MCP_QUERY_ROW_LIMIT": "<YOUR_MCP_QUERY_ROW_LIMIT>",
        "MCP_SAFE_QUERY_MAX_ROWS": "<YOUR_MCP_SAFE_QUERY_MAX_ROWS>",
        "MCP_SAFE_QUERY_ENABLE_BLOCKING": "<YOUR_MCP_SAFE_QUERY_ENABLE_BLOCKING>",
        "MCP_METADATA_PATH": "<YOUR_MCP_METADATA_PATH>",
        "MCP_TEMPLATES_PATH": "<YOUR_MCP_TEMPLATES_PATH>",
        "TOOL_PREFIX": "<YOUR_TOOL_PREFIX>",
        "MCP_RATE_LIMIT_RPM": "<YOUR_MCP_RATE_LIMIT_RPM>",
        "MYSQL_QUERY_TIMEOUT": "<YOUR_MYSQL_QUERY_TIMEOUT>",
        "MYSQL_CONNECTION_LIMIT": "<YOUR_MYSQL_CONNECTION_LIMIT>",
        "MYSQL_CONNECT_TIMEOUT": "<YOUR_MYSQL_CONNECT_TIMEOUT>",
        "MYSQL_RETRY_ATTEMPTS": "<YOUR_MYSQL_RETRY_ATTEMPTS>",
        "MYSQL_RETRY_DELAY_MS": "<YOUR_MYSQL_RETRY_DELAY_MS>",
        "MYSQL_QUEUE_LIMIT": "<YOUR_MYSQL_QUEUE_LIMIT>",
        "MCP_DDL_CACHE_TTL": "<YOUR_MCP_DDL_CACHE_TTL>",
        "MCP_LOG_LEVEL": "<YOUR_MCP_LOG_LEVEL>",
        "ALLOW_INSERT_OPERATION": "<YOUR_ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<YOUR_ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<YOUR_ALLOW_DELETE_OPERATION>",
        "ALLOW_DDL_OPERATION": "<YOUR_ALLOW_DDL_OPERATION>",
        "DB_SSL": "<YOUR_DB_SSL>",
        "DB_SSL_REJECT_UNAUTHORIZED": "<YOUR_DB_SSL_REJECT_UNAUTHORIZED>"
      }
    }
  }
}
VS Code
.vscode/mcp.json
{
  "servers": {
    "tokenlite-mysql-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@andezdev/tokenlite-mysql-mcp"
      ],
      "env": {
        "DB_HOST": "<YOUR_DB_HOST>",
        "DB_PORT": "<YOUR_DB_PORT>",
        "DB_USER": "<YOUR_DB_USER>",
        "DB_PASSWORD": "<YOUR_DB_PASSWORD>",
        "DB_NAME": "<YOUR_DB_NAME>",
        "MCP_EXPLAIN_MAX_SCAN_ROWS": "<YOUR_MCP_EXPLAIN_MAX_SCAN_ROWS>",
        "MCP_QUERY_ROW_LIMIT": "<YOUR_MCP_QUERY_ROW_LIMIT>",
        "MCP_SAFE_QUERY_MAX_ROWS": "<YOUR_MCP_SAFE_QUERY_MAX_ROWS>",
        "MCP_SAFE_QUERY_ENABLE_BLOCKING": "<YOUR_MCP_SAFE_QUERY_ENABLE_BLOCKING>",
        "MCP_METADATA_PATH": "<YOUR_MCP_METADATA_PATH>",
        "MCP_TEMPLATES_PATH": "<YOUR_MCP_TEMPLATES_PATH>",
        "TOOL_PREFIX": "<YOUR_TOOL_PREFIX>",
        "MCP_RATE_LIMIT_RPM": "<YOUR_MCP_RATE_LIMIT_RPM>",
        "MYSQL_QUERY_TIMEOUT": "<YOUR_MYSQL_QUERY_TIMEOUT>",
        "MYSQL_CONNECTION_LIMIT": "<YOUR_MYSQL_CONNECTION_LIMIT>",
        "MYSQL_CONNECT_TIMEOUT": "<YOUR_MYSQL_CONNECT_TIMEOUT>",
        "MYSQL_RETRY_ATTEMPTS": "<YOUR_MYSQL_RETRY_ATTEMPTS>",
        "MYSQL_RETRY_DELAY_MS": "<YOUR_MYSQL_RETRY_DELAY_MS>",
        "MYSQL_QUEUE_LIMIT": "<YOUR_MYSQL_QUEUE_LIMIT>",
        "MCP_DDL_CACHE_TTL": "<YOUR_MCP_DDL_CACHE_TTL>",
        "MCP_LOG_LEVEL": "<YOUR_MCP_LOG_LEVEL>",
        "ALLOW_INSERT_OPERATION": "<YOUR_ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<YOUR_ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<YOUR_ALLOW_DELETE_OPERATION>",
        "ALLOW_DDL_OPERATION": "<YOUR_ALLOW_DDL_OPERATION>",
        "DB_SSL": "<YOUR_DB_SSL>",
        "DB_SSL_REJECT_UNAUTHORIZED": "<YOUR_DB_SSL_REJECT_UNAUTHORIZED>"
      }
    }
  }
}
Claude Code
claude mcp add tokenlite-mysql-mcp --env DB_HOST=<YOUR_DB_HOST> --env DB_PORT=<YOUR_DB_PORT> --env DB_USER=<YOUR_DB_USER> --env DB_PASSWORD=<YOUR_DB_PASSWORD> --env DB_NAME=<YOUR_DB_NAME> --env MCP_EXPLAIN_MAX_SCAN_ROWS=<YOUR_MCP_EXPLAIN_MAX_SCAN_ROWS> --env MCP_QUERY_ROW_LIMIT=<YOUR_MCP_QUERY_ROW_LIMIT> --env MCP_SAFE_QUERY_MAX_ROWS=<YOUR_MCP_SAFE_QUERY_MAX_ROWS> --env MCP_SAFE_QUERY_ENABLE_BLOCKING=<YOUR_MCP_SAFE_QUERY_ENABLE_BLOCKING> --env MCP_METADATA_PATH=<YOUR_MCP_METADATA_PATH> --env MCP_TEMPLATES_PATH=<YOUR_MCP_TEMPLATES_PATH> --env TOOL_PREFIX=<YOUR_TOOL_PREFIX> --env MCP_RATE_LIMIT_RPM=<YOUR_MCP_RATE_LIMIT_RPM> --env MYSQL_QUERY_TIMEOUT=<YOUR_MYSQL_QUERY_TIMEOUT> --env MYSQL_CONNECTION_LIMIT=<YOUR_MYSQL_CONNECTION_LIMIT> --env MYSQL_CONNECT_TIMEOUT=<YOUR_MYSQL_CONNECT_TIMEOUT> --env MYSQL_RETRY_ATTEMPTS=<YOUR_MYSQL_RETRY_ATTEMPTS> --env MYSQL_RETRY_DELAY_MS=<YOUR_MYSQL_RETRY_DELAY_MS> --env MYSQL_QUEUE_LIMIT=<YOUR_MYSQL_QUEUE_LIMIT> --env MCP_DDL_CACHE_TTL=<YOUR_MCP_DDL_CACHE_TTL> --env MCP_LOG_LEVEL=<YOUR_MCP_LOG_LEVEL> --env ALLOW_INSERT_OPERATION=<YOUR_ALLOW_INSERT_OPERATION> --env ALLOW_UPDATE_OPERATION=<YOUR_ALLOW_UPDATE_OPERATION> --env ALLOW_DELETE_OPERATION=<YOUR_ALLOW_DELETE_OPERATION> --env ALLOW_DDL_OPERATION=<YOUR_ALLOW_DDL_OPERATION> --env DB_SSL=<YOUR_DB_SSL> --env DB_SSL_REJECT_UNAUTHORIZED=<YOUR_DB_SSL_REJECT_UNAUTHORIZED> -- npx -y @andezdev/tokenlite-mysql-mcp

Related MCP servers

Scrapling MCP Server

Active

Give your AI agent stealth web scraping with Cloudflare bypass and CSS selection, powered by Scrapling.

67k
Python
BSD-3-Clause
View repository →

Chrome DevTools MCP

Active

Give your AI coding agent full control of a live Chrome browser for automation, debugging, and performance analysis.

45k
TypeScript
Apache-2.0
View repository →

com.puter/mcp-server

Active

Let AI agents manage your Puter files, websites, and serverless workers over MCP.

43k
TypeScript
AGPL-3.0
View repository →

io.github.bytedance/mcp-server-browser

Active

Browser automation for AI agents via MCP, powering ByteDance's Agent TARS hybrid GUI/DOM browser control.

37k
TypeScript
Apache-2.0
View repository →

io.github.bytedance/mcp-server-commands

Active

Run arbitrary shell commands from an MCP-connected AI agent.

37k
TypeScript
Apache-2.0
View repository →

io.github.bytedance/mcp-server-filesystem

Active

Filesystem access MCP server from ByteDance's UI-TARS/Agent TARS ecosystem.

37k
TypeScript
Apache-2.0
View repository →