MySQL MCP Server

MIT License
157
  • Linux
  • Apple

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MYSQL_HOSTYesDatabase hostlocalhost
MYSQL_PORTNoDatabase port (defaults to 3306 if not specified)3306
MYSQL_USERYesMySQL username
MYSQL_DATABASEYesMySQL database name
MYSQL_PASSWORDYesMySQL 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

Execute an SQL query on the MySQL server