Mysql-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_HOST | Yes | 数据库主机地址 (Database host address) | |
| MYSQL_PORT | Yes | 数据库端口 (Database port) | |
| MYSQL_DATABASE | Yes | 数据库名称 (Database name) | |
| MYSQL_PASSWORD | Yes | 数据库密码 (Database password) | |
| MYSQL_USERNAME | Yes | 数据库用户名 (Database username) | |
| MYSQL_MAX_RETRIES | No | 最大重试次数（默认：3） | 3 |
| MYSQL_QUERY_TIMEOUT | No | 查询超时时间（秒，默认：60） | 60 |
| MYSQL_SECURITY_MODE | No | 安全模式 (readonly/limited_write/full_access，默认：readonly) | readonly |
| MYSQL_ALLOWED_SCHEMAS | No | 允许访问的数据库列表，支持三种配置方式：'*' (允许访问所有有权限的数据库), 'auto' (自动发现有权限的数据库), 'db1,db2,db3' (明确指定数据库列表) | |
| MYSQL_CONNECT_TIMEOUT | No | 连接超时时间（秒，默认：30） | 30 |
| MYSQL_MAX_RESULT_ROWS | No | 最大返回行数（默认：1000） | 1000 |
| MYSQL_ENABLE_QUERY_LOG | No | 是否启用查询日志（true/false，默认：false） | 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 | |