MCP-MySQL-Ops

MCP-MySQL-Ops is an MCP server that connects AI assistants to MySQL databases to provide database monitoring, performance analysis, and administration tools through natural language queries. Built for database administrators, backend developers, and site reliability engineers, the server integrates with MySQL 5.7.9+ and 8.0+ instances, including AWS RDS and Aurora MySQL deployments. It exposes nineteen specialized tools that query MySQL's Performance Schema and Information Schema while maintaining read-only safety for production environments. Users can inspect running processes, track database capacity, monitor table sizes, and examine storage engine efficiency without manual SQL query construction. The server also provides index utilization insights and identifies slow query bottlenecks using execution statistics. In addition to local stdio communication, MCP-MySQL-Ops supports remote HTTP streaming secured by Bearer token authentication, allowing client applications to safely review system health and cross-database metrics across cloud or on-premise environments.

Category: Databases & Data Stores

Tags: database administration, mysql, performance monitoring, SQL

Visit MCP-MySQL-Ops

How to install and configure MCP-MySQL-Ops

1. Clone the repository and navigate into the directory: bash git clone https://github.com/call518/MCP-MySQL-Ops.git cd MCP-MySQL-Ops 2. Create and configure your environment file: bash cp .env.example .env Update MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE to match your target database. 3. Launch the services using Docker Compose: bash docker-compose up -d 4. For MCP clients using HTTP transport, add the server to your client configuration: json { "mcpServers": { "mcp-mysql-ops": { "type": "streamable-http", "url": "http://your-server:8000/mcp", "headers": { "Authorization": "Bearer your-secure-secret-key-here" } } } } If configuring through OpenWebUI, open Settings > Tools and register the tool URL at http://localhost:8004/mysql-ops.

What you can do with MCP-MySQL-Ops

• Analyze slow queries and bottlenecks by querying MySQL Performance Schema statistics to identify statements consuming disproportionate execution time. - Inspect real-time connection status and active threads to evaluate server concurrency, ongoing process states, and current database workloads. - Audit table size metrics and disk space consumption across multiple databases to plan storage capacity and identify data bloat. - Track index usage and efficiency recommendations to determine missing keys or redundant indexes affecting query execution performance. - Examine InnoDB engine metrics and buffer pool utilization to ensure optimal memory configuration and detect storage engine contention.

Key facts

• https://github.com/call518/MCP-MySQL-Ops
• Databases & Data Stores, Monitoring & Observability
• database administration, mysql, performance monitoring, SQL

Part of MCP Servers

What can MCP-MySQL-Ops do?

MCP-MySQL-Ops provides 19 tools for database monitoring and administration. It inspects slow queries, analyzes table sizes, examines InnoDB storage engine status, tracks index efficiency, monitors active connections, and explores schema structures using standard Information Schema and Performance Schema views.

How do I install MCP-MySQL-Ops?

Clone the repository with git, prepare the environment configuration by copying .env.example to .env, adjust your database connection variables, and run docker-compose up -d. The server can run in stdio mode locally or in streamable-http mode for remote access.

Which database versions are supported by MCP-MySQL-Ops?

MCP-MySQL-Ops supports MySQL 5.7.9 and higher, as well as MySQL 8.0 and above. It features automatic version detection and is compatible with cloud deployments such as AWS RDS and Aurora MySQL using standard read-only user permissions.

Is MCP-MySQL-Ops open source?

Yes, MCP-MySQL-Ops is open source software distributed under the MIT license. You can inspect, modify, and host its code freely. The repository includes Docker configuration files, setup scripts, and automated test data generators for local evaluation.

Does MCP-MySQL-Ops support authentication for remote connections?

Yes, when operating in streamable-http mode, the server supports Bearer token authentication. You can enforce token verification by setting REMOTE_AUTH_ENABLE to true and defining REMOTE_SECRET_KEY in your environment configuration or command-line parameters, ensuring that only authorized MCP clients can execute database tools.