tokenlite-mysql-mcp
io.github.andezdev/tokenlite-mysql-mcp ยท version 4.1.0
Community listing. Not installed or verified by cosmic-mcp. Read the source and its permissions before you run it.
A secure, efficient, and intelligent MySQL server for the Model Context Protocol
https://github.com/andezdev/tokenlite-mysql-mcpQuick facts
- Listing: Community
- Published Jun 7, 13:33 UTC
- Transport: stdio
- Package: npm
@andezdev/tokenlite-mysql-mcp4.1.0 - Listed by cosmic-mcp: Nov 9, 04:25 UTC
Details
- Repository: https://github.com/andezdev/tokenlite-mysql-mcp
- npm: https://www.npmjs.com/package/@andezdev/tokenlite-mysql-mcp
- Needs settings:
DB_HOSTDB_PORTDB_USERDB_PASSWORDDB_NAMEMCP_EXPLAIN_MAX_SCAN_ROWSMCP_QUERY_ROW_LIMITMCP_SAFE_QUERY_MAX_ROWSMCP_SAFE_QUERY_ENABLE_BLOCKINGMCP_METADATA_PATHMCP_TEMPLATES_PATHTOOL_PREFIXMCP_RATE_LIMIT_RPMMYSQL_QUERY_TIMEOUTMYSQL_CONNECTION_LIMITMYSQL_CONNECT_TIMEOUTMYSQL_RETRY_ATTEMPTSMYSQL_RETRY_DELAY_MSMYSQL_QUEUE_LIMITMCP_DDL_CACHE_TTLMCP_LOG_LEVELALLOW_INSERT_OPERATIONALLOW_UPDATE_OPERATIONALLOW_DELETE_OPERATIONALLOW_DDL_OPERATIONDB_SSLDB_SSL_REJECT_UNAUTHORIZED
Setup snippets
Generated from the registry entry. cosmic-mcp has not run or reviewed this server; values in angle brackets are yours to fill in.
Run it locally (npm)
npx -y '@andezdev/[email protected]'Claude Desktop (claude_desktop_config.json)
{
"mcpServers": {
"tokenlite-mysql-mcp": {
"args": [
"-y",
"@andezdev/[email protected]"
],
"command": "npx",
"env": {
"ALLOW_DDL_OPERATION": "<your allow ddl operation>",
"ALLOW_DELETE_OPERATION": "<your allow delete operation>",
"ALLOW_INSERT_OPERATION": "<your allow insert operation>",
"ALLOW_UPDATE_OPERATION": "<your allow update operation>",
"DB_HOST": "<your db host>",
"DB_NAME": "<your db name>",
"DB_PASSWORD": "<your db password>",
"DB_PORT": "<your db port>",
"DB_SSL": "<your db ssl>",
"DB_SSL_REJECT_UNAUTHORIZED": "<your db ssl reject unauthorized>",
"DB_USER": "<your db user>",
"MCP_DDL_CACHE_TTL": "<your mcp ddl cache ttl>",
"MCP_EXPLAIN_MAX_SCAN_ROWS": "<your mcp explain max scan rows>",
"MCP_LOG_LEVEL": "<your mcp log level>",
"MCP_METADATA_PATH": "<your mcp metadata path>",
"MCP_QUERY_ROW_LIMIT": "<your mcp query row limit>",
"MCP_RATE_LIMIT_RPM": "<your mcp rate limit rpm>",
"MCP_SAFE_QUERY_ENABLE_BLOCKING": "<your mcp safe query enable blocking>",
"MCP_SAFE_QUERY_MAX_ROWS": "<your mcp safe query max rows>",
"MCP_TEMPLATES_PATH": "<your mcp templates path>",
"MYSQL_CONNECTION_LIMIT": "<your mysql connection limit>",
"MYSQL_CONNECT_TIMEOUT": "<your mysql connect timeout>",
"MYSQL_QUERY_TIMEOUT": "<your mysql query timeout>",
"MYSQL_QUEUE_LIMIT": "<your mysql queue limit>",
"MYSQL_RETRY_ATTEMPTS": "<your mysql retry attempts>",
"MYSQL_RETRY_DELAY_MS": "<your mysql retry delay ms>",
"TOOL_PREFIX": "<your tool prefix>"
}
}
}
}Claude Code
claude mcp add 'tokenlite-mysql-mcp' -- npx -y '@andezdev/[email protected]'Cursor (.cursor/mcp.json)
{
"mcpServers": {
"tokenlite-mysql-mcp": {
"args": [
"-y",
"@andezdev/[email protected]"
],
"command": "npx",
"env": {
"ALLOW_DDL_OPERATION": "<your allow ddl operation>",
"ALLOW_DELETE_OPERATION": "<your allow delete operation>",
"ALLOW_INSERT_OPERATION": "<your allow insert operation>",
"ALLOW_UPDATE_OPERATION": "<your allow update operation>",
"DB_HOST": "<your db host>",
"DB_NAME": "<your db name>",
"DB_PASSWORD": "<your db password>",
"DB_PORT": "<your db port>",
"DB_SSL": "<your db ssl>",
"DB_SSL_REJECT_UNAUTHORIZED": "<your db ssl reject unauthorized>",
"DB_USER": "<your db user>",
"MCP_DDL_CACHE_TTL": "<your mcp ddl cache ttl>",
"MCP_EXPLAIN_MAX_SCAN_ROWS": "<your mcp explain max scan rows>",
"MCP_LOG_LEVEL": "<your mcp log level>",
"MCP_METADATA_PATH": "<your mcp metadata path>",
"MCP_QUERY_ROW_LIMIT": "<your mcp query row limit>",
"MCP_RATE_LIMIT_RPM": "<your mcp rate limit rpm>",
"MCP_SAFE_QUERY_ENABLE_BLOCKING": "<your mcp safe query enable blocking>",
"MCP_SAFE_QUERY_MAX_ROWS": "<your mcp safe query max rows>",
"MCP_TEMPLATES_PATH": "<your mcp templates path>",
"MYSQL_CONNECTION_LIMIT": "<your mysql connection limit>",
"MYSQL_CONNECT_TIMEOUT": "<your mysql connect timeout>",
"MYSQL_QUERY_TIMEOUT": "<your mysql query timeout>",
"MYSQL_QUEUE_LIMIT": "<your mysql queue limit>",
"MYSQL_RETRY_ATTEMPTS": "<your mysql retry attempts>",
"MYSQL_RETRY_DELAY_MS": "<your mysql retry delay ms>",
"TOOL_PREFIX": "<your tool prefix>"
}
}
}
}VS Code (.vscode/mcp.json)
{
"servers": {
"tokenlite-mysql-mcp": {
"args": [
"-y",
"@andezdev/[email protected]"
],
"command": "npx",
"env": {
"ALLOW_DDL_OPERATION": "<your allow ddl operation>",
"ALLOW_DELETE_OPERATION": "<your allow delete operation>",
"ALLOW_INSERT_OPERATION": "<your allow insert operation>",
"ALLOW_UPDATE_OPERATION": "<your allow update operation>",
"DB_HOST": "<your db host>",
"DB_NAME": "<your db name>",
"DB_PASSWORD": "<your db password>",
"DB_PORT": "<your db port>",
"DB_SSL": "<your db ssl>",
"DB_SSL_REJECT_UNAUTHORIZED": "<your db ssl reject unauthorized>",
"DB_USER": "<your db user>",
"MCP_DDL_CACHE_TTL": "<your mcp ddl cache ttl>",
"MCP_EXPLAIN_MAX_SCAN_ROWS": "<your mcp explain max scan rows>",
"MCP_LOG_LEVEL": "<your mcp log level>",
"MCP_METADATA_PATH": "<your mcp metadata path>",
"MCP_QUERY_ROW_LIMIT": "<your mcp query row limit>",
"MCP_RATE_LIMIT_RPM": "<your mcp rate limit rpm>",
"MCP_SAFE_QUERY_ENABLE_BLOCKING": "<your mcp safe query enable blocking>",
"MCP_SAFE_QUERY_MAX_ROWS": "<your mcp safe query max rows>",
"MCP_TEMPLATES_PATH": "<your mcp templates path>",
"MYSQL_CONNECTION_LIMIT": "<your mysql connection limit>",
"MYSQL_CONNECT_TIMEOUT": "<your mysql connect timeout>",
"MYSQL_QUERY_TIMEOUT": "<your mysql query timeout>",
"MYSQL_QUEUE_LIMIT": "<your mysql queue limit>",
"MYSQL_RETRY_ATTEMPTS": "<your mysql retry attempts>",
"MYSQL_RETRY_DELAY_MS": "<your mysql retry delay ms>",
"TOOL_PREFIX": "<your tool prefix>"
},
"type": "stdio"
}
}
}Related servers
- Harness Verified domain
Start Claude Code and Codex agents the person can watch, wait for them and read their answers. - docs-mcp Verified domain
Remote MCP server for Tandem docs, install guides, SDKs, workflows, and agent setup help. - spotdb Verified domain
Ephemeral data sandbox for AI workflows with guardrails and security - Adako: ad ops for AI assistants Verified domain
Google, Meta, LinkedIn and ChatGPT Ads for AI assistants. Every change needs your approval. - Aidoo for Odoo Verified domain
Query and update your Odoo ERP in plain language, under your own Odoo access rules. - EXTREMELY agency Verified domain
Your agency of AI agents in your AI app: what agents did, approvals, requests, jobs and reports.