MCP MySQL Server

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
PORTNoThe port on which the server runs3000
API_KEYYesAPI key to protect the endpoints
DB_HOSTNoMySQL database hostlocalhost
DB_NAMEYesMySQL database name
DB_PORTNoMySQL database port3306
DB_USERYesMySQL database username
NODE_ENVNoThe environment mode for the serverdevelopment
DB_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

No tools