mysql-mcp-server
A server application designed on top of MCP to interact with Cursor and MySQL.
Overview
MCPMySQLBoilerPlate is a server application designed to interact with MySQL using the Model Control Protocol (MCP). It provides various tools for database operations, ensuring scalability and maintainability.
To use MCPMySQLBoilerPlate, you can run it using Docker, Docker Compose, or directly with Python. Adjust the database connection settings as needed.
- Interaction with MySQL databases through MCP. - Support for various database operations via executors. - Easy to extend with new tools and functionalities.
- Automating database management tasks.
- Integrating AI models with MySQL for data processing.
- Developing custom database tools for specific needs.
Add to your AI client
Use these steps to connect mysql-mcp-server in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.
Cursor
Add this to your .cursor/mcp.json file in your project root, then restart Cursor.
.cursor/mcp.json
{
"mcpServers": {
"mysql-mcp-server-mineru98": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-mysql-mcp-server-mineru98"
]
}
}
}Claude Desktop
Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.
~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)
{
"mcpServers": {
"mysql-mcp-server-mineru98": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-mysql-mcp-server-mineru98"
]
}
}
}Claude Code
Add this to your project's .mcp.json file. Claude Code will detect it automatically.
.mcp.json (project root)
{
"mcpServers": {
"mysql-mcp-server-mineru98": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-mysql-mcp-server-mineru98"
]
}
}
}VS Code (Copilot)
Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.
.vscode/mcp.json
{
"servers": {
"mysql-mcp-server-mineru98": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-mysql-mcp-server-mineru98"
]
}
}
}Windsurf
Add this to your Windsurf MCP config file, then restart Windsurf.
~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"mysql-mcp-server-mineru98": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-mysql-mcp-server-mineru98"
]
}
}
}Cline
Open Cline settings, navigate to MCP Servers, and add this server configuration.
Cline MCP Settings (via UI)
{
"mcpServers": {
"mysql-mcp-server-mineru98": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-mysql-mcp-server-mineru98"
]
}
}
}FAQ
Can I run this application without Docker?
Yes, you can run it directly using Python after installing the required dependencies.
Is there a way to add new tools?
Yes, you can add new executors in the executors directory and register them in the __init__.py file.
What programming language is used?
The application is developed in Python.