tokenlite-mysql-mcp
A secure, efficient, and intelligent MySQL server for the Model Context Protocol
Package Details
@andezdev/tokenlite-mysql-mcp
Environment Variables
MySQL Host address (defaults to localhost)
MySQL Port (defaults to 3306)
MySQL Username (defaults to root)
MySQL Password (defaults to empty string)
MySQL Database name
Threshold for EXPLAIN to block unindexed Full Table Scans (defaults to 1000)
Enable or disable the EXPLAIN guardrail (defaults to true)
Absolute path to your custom metadata.json dictionary
Absolute path to your custom templates.json pre-approved queries
Prefix for tool names, e.g., to run multiple instances (defaults to random prefix like db_a1b2_)
Max execution time for a query in milliseconds to protect against DoS (defaults to 15000)
Max concurrent pool connections (defaults to 10)
Max time to wait for a connection socket to establish in milliseconds (defaults to 10000)
Max retries on transient connection errors (defaults to 3)
Base delay in milliseconds for exponential backoff between retries (defaults to 1000)
Max queued requests when all pool connections are busy to prevent memory leak (defaults to 50)
Time-to-live in seconds for cached DDL statements (defaults to 60)
Minimum severity level for MCP log notifications (defaults to info). Levels: debug, info, notice, warning, error, critical, alert, emergency
Enable INSERT and REPLACE queries (defaults to false)
Enable UPDATE queries (defaults to false)
Enable DELETE and TRUNCATE queries (defaults to false)
Enable Data Definition Language queries like CREATE, ALTER, DROP, RENAME (defaults to false)