MySQL MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_HOST | Yes | MySQL server address | localhost |
| MYSQL_PORT | No | MySQL port number | 3306 |
| MYSQL_USER | Yes | MySQL username | root |
| MYSQL_TIMEOUT | No | Connection timeout in milliseconds | 60000 |
| MYSQL_DATABASE | No | Default database name | |
| MYSQL_PASSWORD | Yes | MySQL password | |
| MYSQL_CONNECTION_LIMIT | No | Connection pool size | 10 |
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 |
|---|---|
| mysql_connectC | 连接到 MySQL 数据库 |
| mysql_disconnectB | 断开 MySQL 数据库连接 |
| mysql_list_databasesB | 列出所有数据库 |
| mysql_create_databaseD | 创建数据库 |
| mysql_drop_databaseC | 删除数据库 |
| mysql_list_tablesB | 列出指定数据库的所有表 |
| mysql_describe_tableC | 查看表结构 |
| mysql_create_tableD | 创建表 |
| mysql_drop_tableC | 删除表 |
| mysql_queryC | 执行 SQL 查询 |
| mysql_insertC | 插入数据到表 |
| mysql_updateC | 更新表数据 |
| mysql_deleteC | 删除表数据 |
| mysql_export_dataC | 导出表数据到文件 |
| mysql_import_dataC | 从文件导入数据到表 |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 15 tools
Every tool has a clearly distinct purpose with no ambiguity. Each tool targets a specific MySQL operation (e.g., connect/disconnect, create/drop databases/tables, CRUD operations, import/export, listing), and there is no overlap in functionality that would cause misselection.
All tool names follow a consistent 'mysql_' prefix with a verb_noun pattern (e.g., mysql_connect, mysql_create_database, mysql_list_tables). This predictable naming convention makes it easy for agents to understand and use the tools without confusion.
With 15 tools, the server is well-scoped for MySQL database management. Each tool earns its place by covering essential operations like connection handling, database/table lifecycle, data manipulation, and import/export, without being overly heavy or thin for the domain.
The tool set provides complete CRUD and lifecycle coverage for MySQL operations. It includes connection management, database/table creation/deletion, data insertion/update/delete/query, structure inspection, and import/export functionalities, leaving no obvious gaps for typical database workflows.