Skip to main content
Glama

MySQL MCP Server

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MYSQL_HOSTNoMySQL server hostnamelocalhost
MYSQL_PORTNoMySQL server port3306
MYSQL_USERNoMySQL usernamemcp101
MYSQL_DATABASENoMySQL database namemcpdb
MYSQL_PASSWORDNoMySQL password123qwe

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
run_sql_query

执行只读 SQL 查询(仅限 SELECT 语句)

create_table

在 MySQL 数据库中创建新表

insert_data

向 MySQL 数据库表插入数据

update_data

更新 MySQL 数据库表中的数据

delete_data

从 MySQL 数据库表中删除数据

execute_sql

执行任意非 SELECT 的 SQL 语句(如 ALTER TABLE、DROP 等)

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/alittleyellowkevin/Mysql-MCP'

If you have feedback or need assistance with the MCP directory API, please join our Discord server