Schema | MySQL MCP

MySQL MCP

Overview Schema Source Related Servers Discussions Admin

Server Configuration

Describes the environment variables required to run the server.

Name	Required	Description	Default
`MYSQL_HOST`	Yes	MySQL server host address
`MYSQL_PORT`	No	MySQL server port	3306
`MYSQL_USER`	Yes	MySQL username
`MYSQL_DATABASE`	Yes	MySQL database name
`MYSQL_PASSWORD`	Yes	MySQL password
`MYSQL_CONNECTION_TIMEOUT`	No	Connection timeout in seconds	10
`MYSQL_CONNECT_RETRY_COUNT`	No	Number of connection retry attempts	3

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

Features and capabilities supported by this server

Protocol revision2025-11-25

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Tools

Functions exposed to the LLM to take actions

Name	Description
execute_queryA	执行SQL查询语句，返回查询结果 `Args: query: SQL查询语句 params: 查询参数，用于参数化查询，防止SQL注入 db_config: 数据库连接配置参数，如果为None则使用默认配置 Returns: 包含查询结果的字典`
list_tablesA	列出指定数据库中的所有表 `Args: database_name: 数据库名称，如果为None则使用默认数据库 db_config: 数据库连接配置参数，如果为None则使用默认配置 Returns: 包含表列表的字典`
describe_tableA	获取表结构 `Args: table_name: 表名 db_config: 数据库连接配置参数，如果为None则使用默认配置 Returns: 包含表结构信息的字典`
create_tableB	创建新表 `Args: table_name: 表名 columns_def: 列定义，例如 "id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), age INT" db_config: 数据库连接配置参数，如果为None则使用默认配置 Returns: 包含创建结果的字典`
insert_dataB	向表中插入数据 `Args: table_name: 表名 data: 要插入的数据，字段名和值的字典 db_config: 数据库连接配置参数，如果为None则使用默认配置 Returns: 包含插入结果的字典`
update_dataB	更新表中的数据 `Args: table_name: 表名 data: 要更新的数据，字段名和值的字典 condition: WHERE条件子句 params: 条件参数列表 db_config: 数据库连接配置参数，如果为None则使用默认配置 Returns: 包含更新结果的字典`
delete_dataB	从表中删除数据 `Args: table_name: 表名 condition: WHERE条件子句 params: 条件参数列表 db_config: 数据库连接配置参数，如果为None则使用默认配置 Returns: 包含删除结果的字典`
use_databaseC	切换到指定的数据库 `Args: database_name: 数据库名称 db_config: 数据库连接配置参数，如果为None则使用默认配置 Returns: 包含切换结果的字典`

Prompts

Interactive templates invoked by user choice

Name	Description
No prompts

Resources

Contextual data attached and managed by the client

Name	Description
No resources

Deploy Server

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

TDQS

A3.6/5.0

Scored 2026-04-29 15:10 across 8 tools

Disambiguation5/5

Each tool has a unique and clearly defined purpose targeting different database operations (e.g., create table, insert data, execute query). There is no ambiguity or overlap among the tools.

Naming Consistency5/5

All tool names follow a consistent verb_noun pattern in snake_case (e.g., create_table, list_tables, update_data). This makes the naming predictable and easy to understand.

Tool Count5/5

With 8 tools, the server is well-scoped for basic MySQL database operations. The count is appropriate, covering essential CRUD and metadata operations without being too sparse or bloated.

Completeness4/5

The tool set covers core operations like table creation, data manipulation, and querying. However, it is missing important DDL operations such as DROP TABLE or ALTER TABLE, which could be considered minor gaps.

Maintenance

ActivityInactive

ResponsivenessNo issues

Resources

GitHub Repository

Need Help?

Related Servers