MySQL MCP Server
by chenlinyang
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_DB | No | 目标数据库名称（多数据库模式留空） | |
| MYSQL_SSL | No | 启用 SSL/TLS 加密（默认："false"） | |
| MYSQL_HOST | No | MySQL 服务器主机（默认："127.0.0.1"） | |
| MYSQL_PASS | Yes | MySQL 密码 | |
| MYSQL_PORT | No | MySQL 服务器端口（默认："3306"） | |
| MYSQL_USER | No | MySQL 用户名（默认："root"） | |
| MYSQL_CACHE_TTL | No | 缓存生存时间（毫秒）（默认："60000"） | |
| MYSQL_LOG_LEVEL | No | 日志级别（默认："info"） | |
| MYSQL_POOL_SIZE | No | 连接池大小（默认："10"） | |
| MYSQL_RATE_LIMIT | No | 每分钟最大查询数（默认："100"） | |
| MYSQL_SOCKET_PATH | No | 本地连接的 Unix 套接字路径（例如，"/tmp/mysql.sock"） | |
| ALLOW_DDL_OPERATION | No | 启用 DDL 操作（默认："false"） | |
| MULTI_DB_WRITE_MODE | No | 在多数据库模式下启用写入操作（默认："false"） | |
| MYSQL_QUERY_TIMEOUT | No | 查询超时（毫秒）（默认："30000"） | |
| MYSQL_ENABLE_LOGGING | No | 启用查询日志记录（默认："false"） | |
| MYSQL_METRICS_ENABLED | No | 启用性能指标（默认："false"） | |
| ALLOW_DELETE_OPERATION | No | 启用 DELETE 操作（默认："false"） | |
| ALLOW_INSERT_OPERATION | No | 启用 INSERT 操作（默认："false"） | |
| ALLOW_UPDATE_OPERATION | No | 启用 UPDATE 操作（默认："false"） | |
| SCHEMA_DDL_PERMISSIONS | No | 模式特定的 DDL 权限 | |
| SCHEMA_DELETE_PERMISSIONS | No | 模式特定的 DELETE 权限 | |
| SCHEMA_INSERT_PERMISSIONS | No | 模式特定的 INSERT 权限（例："development:true,test:true,production:false"） | |
| SCHEMA_UPDATE_PERMISSIONS | No | 模式特定的 UPDATE 权限 | |
| MYSQL_MAX_QUERY_COMPLEXITY | No | 最大查询复杂度分数（默认："1000"） | |
| MYSQL_DISABLE_READ_ONLY_TRANSACTIONS | No | 禁用只读事务强制（默认："false"） |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/chenlinyang/mcp-server-mysql'
If you have feedback or need assistance with the MCP directory API, please join our Discord server