Back to Apps
MySQL MCP Server
by berthojoris
Production-ready MySQL integration with granular permission layers for safe AI-driven database management.
0 stars
2 views
Works in:CursorWindsurfCodexzed
Exposes:ToolsResources
What it does
Provides a high-performance bridge between AI agents and MySQL databases. It features a unique dual-layer permission system (Permissions + Categories) that ensures AI agents can only perform authorized operations, making it suitable for production environments.
Tools
run_select_query: Execute read-only SELECT queries for data analysis.execute_write_query: Perform DML operations like INSERT and UPDATE.read_table_schema: Inspect table structures and columns.list_tables: Explore available tables within the database.execute_ddl: Manage schema changes including CREATE, ALTER, and DROP table.analyze_query: Get optimization hints and explain plans for SQL queries.
Installation
Add this to your AI agent configuration:
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"-y",
"@berthojoris/mcp-mysql-server",
"mysql://user:pass@localhost:3306/mydb",
"list,read,utility"
]
}
}
}
Supported hosts
- Claude Desktop
- Cursor
- Windsurf
- Codex
- Zed
Quick install
npx @berthojoris/mcp-mysql-server mysql://user:pass@localhost:3306/db "list,read,utility"Information
- Pricing
- free
- Published
- 4/22/2026
