mysql_mcp_server

by wenb1n-dev
Verified

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

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
execute_sql

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

get_chinese_initials

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

get_table_name

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

get_table_desc

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

get_table_index

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

ID: 3w3wd880vr