vitalyDV/mysql-mcp
3.3
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.
Tools
3
Resources
0
Prompts
0
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)
