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 |
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 | |
Latest Blog Posts
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/pickstar-2002/mysql-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server