mcp-server-mysql
This MCP server provides read-only access to MySQL databases through SSH tunnels.
The MCP Server for MySQL allows users to securely connect to MySQL databases and execute read-only queries. It is optimized for use with Anthropic's Claude Code CLI, enabling seamless integration for developers. The server supports SSH tunnels, which facilitate secure connections to remote databases, ensuring that sensitive data remains protected during access. In addition to read-only capabilities, this server includes features such as automatic tunnel management, support for multiple projects with different databases, and the ability to perform DDL operations. Users can easily configure their environment and leverage the power of LLMs to inspect database schemas and run SQL queries efficiently.
Compatible with
Install
Claude Desktop
Add to your claude_desktop_config.json:
{
"mcpServers": {
"mcp-server-mysql": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-mcp-server-mysql"
]
}
}
}Config File Location
Mac: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json
Linux: ~/.config/claude/claude_desktop_config.json
Some servers require additional setup - check the GitHub README for specific instructions.
Permissions