A secure, efficient, and intelligent MySQL server for the Model Context Protocol
To add tokenlite-mysql-mcp to Claude, run the install command below or copy the ready-made config for Claude Code, Claude Desktop, Cursor and VS Code further down. Restart your client after adding it and its tools show up in your next conversation. It needs 27 environment variables, listed below.
Install
npx -y @andezdev/tokenlite-mysql-mcp@4.1.0Environment variables
DB_HOSTSet in your MCP configDB_PORTSet in your MCP configDB_USERSet in your MCP configDB_PASSWORDSet in your MCP configDB_NAMESet in your MCP configMCP_EXPLAIN_MAX_SCAN_ROWSSet in your MCP configMCP_QUERY_ROW_LIMITSet in your MCP configMCP_SAFE_QUERY_MAX_ROWSSet in your MCP configMCP_SAFE_QUERY_ENABLE_BLOCKINGSet in your MCP configMCP_METADATA_PATHSet in your MCP configMCP_TEMPLATES_PATHSet in your MCP configTOOL_PREFIXSet in your MCP configMCP_RATE_LIMIT_RPMSet in your MCP configMYSQL_QUERY_TIMEOUTSet in your MCP configMYSQL_CONNECTION_LIMITSet in your MCP configMYSQL_CONNECT_TIMEOUTSet in your MCP configMYSQL_RETRY_ATTEMPTSSet in your MCP configMYSQL_RETRY_DELAY_MSSet in your MCP configMYSQL_QUEUE_LIMITSet in your MCP configMCP_DDL_CACHE_TTLSet in your MCP configMCP_LOG_LEVELSet in your MCP configALLOW_INSERT_OPERATIONSet in your MCP configALLOW_UPDATE_OPERATIONSet in your MCP configALLOW_DELETE_OPERATIONSet in your MCP configALLOW_DDL_OPERATIONSet in your MCP configDB_SSLSet in your MCP configDB_SSL_REJECT_UNAUTHORIZEDSet in your MCP configInstall with your client
claude mcp add tokenlite-mysql --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@4.1.0
Run this in a terminal to add the server to Claude Code.
What this does
tokenlite-mysql-mcp exposes a set of tools to Claude over the Model Context Protocol. After you add it to claude_desktop_config.json (snippet above) and restart Claude Desktop, those tools become callable inside any conversation.
Requirements
This server needs the following environment variables to be set before it can run:
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
Set these via the env object in your MCP config (see claude_desktop_config.json snippet above).
Frequently asked questions
How do I install tokenlite-mysql-mcp?
Run the Claude Code command in the install section to add tokenlite-mysql-mcp to Claude Code, or copy the ready-made config for your client from the install section on this page. Restart your client afterwards and the tools appear in your next conversation.
Which clients work with tokenlite-mysql-mcp?
This page carries setup and config for Claude Code, Claude Desktop, Cursor and VS Code. Any other MCP client that accepts a standard server config can connect to tokenlite-mysql-mcp as well.
Does tokenlite-mysql-mcp need an API key?
Yes. Before it can run, set these environment variables: 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. They go in the env block of your MCP config.
Imported from the Official MCP Registry. The details above come from the registry entry; the maker can claim this listing to correct them, add docs, and see its traffic.
Is this your MCP server?
Claim this listing to see its traffic, fix details yourself, and skip the review queue on future updates.
Add this badge to your README
Show visitors this server is listed in the ClaudeRules directory. The badge links straight to this listing.
[](https://clauderules.net/mcp/io-github-andezdev-tokenlite-mysql-mcp)<a href="https://clauderules.net/mcp/io-github-andezdev-tokenlite-mysql-mcp" target="_blank" rel="noopener noreferrer"><img src="https://clauderules.net/api/badge/io-github-andezdev-tokenlite-mysql-mcp" alt="Listed on clauderules.net" /></a>More Database MCP servers
GitHub
Connect AI assistants to GitHub - manage repos, issues, PRs, and workflows through natural language.
Serena MCP: the IDE for your agent
A powerful toolkit for coding, providing semantic retrieval and editing capabilities.
MCP Toolbox for Databases
MCP Toolbox for Databases enables your agent to connect to your database.
Figma-Context-MCP
Give your coding agent access to your Figma data. Implement designs in any framework in one-shot.