Skip to main content
Glama

MySQL MCP Server

MIT License
56
1
  • Apple
  • Linux

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MYSQL_HOSTYesMySQL server addresslocalhost
MYSQL_PORTNoMySQL port number3306
MYSQL_USERYesMySQL usernameroot
MYSQL_TIMEOUTNoConnection timeout in milliseconds60000
MYSQL_DATABASENoDefault database name
MYSQL_PASSWORDYesMySQL password
MYSQL_CONNECTION_LIMITNoConnection pool size10

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
mysql_connect

连接到 MySQL 数据库

mysql_disconnect

断开 MySQL 数据库连接

mysql_list_databases

列出所有数据库

mysql_create_database

创建数据库

mysql_drop_database

删除数据库

mysql_list_tables

列出指定数据库的所有表

mysql_describe_table

查看表结构

mysql_create_table

创建表

mysql_drop_table

删除表

mysql_query

执行 SQL 查询

mysql_insert

插入数据到表

mysql_update

更新表数据

mysql_delete

删除表数据

mysql_export_data

导出表数据到文件

mysql_import_data

从文件导入数据到表

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