mysql-mcp

# 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 ```bash git clone https://github.com/vitalyDV/mysql-mcp.git cd mysql-mcp npm install ``` ## add config to mcp.json ```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 host - `MYSQL_PORT` - MySQL server port - `MYSQL_USER` - MySQL username - `MYSQL_PASS` - MySQL password - `MYSQL_DB` - MySQL database name ## Available MCP tools - `query` - execute SQL queries (only SELECT, SHOW, EXPLAIN, DESCRIBE) - `table-schema` - get table structure - `list-tables` - get list of all tables in the database ## Available MCP resources - `table://{name}` - get data from the specified table (up to 100 rows)