README.md•1.16 kB
# 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)