Skip to main content
Glama
wenb1n-dev

mysql_mcp_server

by wenb1n-dev

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MYSQL_HOSTYesMySQL database host
MYSQL_PORTNoMySQL database port3306
MYSQL_USERYesMySQL database username
MYSQL_DATABASEYesMySQL database name
MYSQL_PASSWORDYesMySQL database password

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

NameDescription
execute_sqlC

在MySQL5.6s数据库上执行SQL

get_chinese_initialsB

创建表结构时,将中文字段名转换为拼音首字母字段

get_table_nameB

根据表中文名搜索数据库中对应的表名

get_table_descC

根据表名搜索数据库中对应的表结构,支持多表查询

get_table_indexC

根据表名搜索数据库中对应的表索引,支持多表查询

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

TDQS

B3.1/5.0

Scored across 5 tools

Disambiguation3/5

The tools have distinct primary purposes (SQL execution, field name conversion, table structure/index/name retrieval), but there is some overlap between get_table_desc, get_table_index, and get_table_name as they all involve table metadata retrieval, which could cause confusion about which to use for specific queries. Descriptions help clarify, but the boundaries are not perfectly clear.

Naming Consistency5/5

All tool names follow a consistent verb_noun pattern using snake_case (e.g., execute_sql, get_table_desc), with no deviations in style or convention. This predictability makes it easy for agents to understand and navigate the tool set.

Tool Count4/5

With 5 tools, the count is reasonable and well-scoped for a MySQL server, covering core operations like SQL execution and table metadata access. It is slightly lean but not insufficient, as it avoids bloat while providing essential functionality.

Completeness2/5

The tool set is severely incomplete for a MySQL database server. It lacks basic CRUD operations (e.g., create_table, update_data, delete_table), data manipulation beyond raw SQL, and lifecycle management tools, leaving significant gaps that will hinder agent workflows and cause failures in typical database interactions.

Maintenance

ActivityInactive
ResponsivenessUnresponsive