io.github.andezdev/tokenlite-mysql-mcp

Command

Environment

• DB_HOST

  MySQL Host address (defaults to localhost)

• DB_PORT

  MySQL Port (defaults to 3306)

• DB_USER

  MySQL Username (defaults to root)

• DB_PASSWORDsecret

  MySQL Password (defaults to empty string)

• DB_NAMErequired

  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)