Content
# MySQL MCP Server
A MySQL implementation of the Model Context Protocol (MCP) server. This server allows AI models to interact with MySQL databases through a standardized interface.
## Features
- List available database tables
- Get table schemas
- Execute read-only SQL queries
- Safe transaction handling with automatic rollback
## Installation
```bash
npm install
npm run build
```
## Usage
### Claude Desktop App
```
code ~/Library/Application\ Support/Claude/claude_desktop_config.json
```
```json
{
"mcpServers": {
"mysql": {
"command": "node",
"args": [
"/ABSOLUTE/PATH/TO/PARENT/FOLDER/mysql-mcp-server/dist/index.js",
],
"env": {
"MYSQL_HOST": "127.0.0.1",
"MYSQL_PORT": "3306",
"MYSQL_USER": "root",
"MYSQL_PASSWORD": "",
"MYSQL_DATABASE": "test"
}
}
}
}
```
Replace the env config with yours!
## License
MIT
Connection Info
You Might Also Like
MarkItDown MCP
Python tool for converting files and office documents to Markdown.
Fetch
Model Context Protocol Servers
Filesystem
Model Context Protocol Servers
beyond-mcp
It's time to push beyond MCP Servers... Right?
agentor
Fastest way to build, prototype and deploy AI Agents or ANY LLM Application...
ZeroZen
Your hyper-personal, always-on, open-source AI companion.