mysql-mcp
If you are the rightful owner of mysql-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
The MySQL MCP Server is a Model Context Protocol server designed for interacting with MySQL databases.
MySQL MCP Server
This project implements an MCP (Model Context Protocol) server for working with MySQL database.
Repository
This project is available on GitHub: https://github.com/vitalyDV/mysql-mcp
Clone the repository
git clone https://github.com/vitalyDV/mysql-mcp.git
cd mysql-mcp
npm install
add config to mcp.json
{
"mcpServers": {
"mysql_mcp_readonly": {
"command": "node",
"args": [
"./mysql-mcp/index.js"
],
"env": {
"MYSQL_HOST": "127.0.0.1",
"MYSQL_PORT": "3306",
"MYSQL_USER": "root",
"MYSQL_PASS": "",
"MYSQL_DB": "db",
}
}
}
}
Environment Variables
MYSQL_HOST
- MySQL server hostMYSQL_PORT
- MySQL server portMYSQL_USER
- MySQL usernameMYSQL_PASS
- MySQL passwordMYSQL_DB
- MySQL database name
Available MCP tools
query
- execute SQL queries (only SELECT, SHOW, EXPLAIN, DESCRIBE)table-schema
- get table structurelist-tables
- get list of all tables in the database
Available MCP resources
table://{name}
- get data from the specified table (up to 100 rows)