MySQLTuner-perl
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.
MySQLTuner-perl is an MCP server and diagnostic tool that analyzes MySQL, MariaDB, and Percona Server configurations to provide performance optimization recommendations. The tool examines over 900 indicators including buffer pool efficiency, security vulnerabilities, replication status, and schema modeling to generate actionable tuning suggestions. It offers both CLI execution with structured JSON output (--agent-json) and a dedicated Model Context Protocol server daemon that AI assistants can integrate with via stdio. MySQLTuner supports modern AI workflows through resources like mysqltuner://reports/latest.json and tools for applying/rolling back recommendations, making it ideal for autonomous DBA agents and developer assistants.
Key Features
Use Cases
- 01Integrating database health checks into AI-powered DevOps assistants and autonomous DBA agents
- 02Analyzing MySQL/MariaDB performance bottlenecks and receiving prioritized optimization recommendations
- 03Auditing database security configurations for weak passwords, insecure authentication, and SSL/TLS compliance
- 04Monitoring production database capacity and forecasting when resources will be exhausted
- 05Generating actionable remediation plans with rollback-safe SQL statements for configuration changes
- 06Tracking historical database performance trends by comparing reports across multiple runs
Related MCP Servers
View moremarkitdown
Python tool for converting files and office documents to Markdown.
firecrawl
The context API to search, scrape, and interact with the web at scale. 🔥
prompts.chat
f.k.a. Awesome ChatGPT Prompts. Share, discover, and collect prompts from the community. Free and open source — self-host for your organization with complete privacy.
langflow
Langflow is a powerful tool for building and deploying AI-powered agents and workflows.
MySQLTuner-perl — FAQ
What is MySQLTuner-perl MCP server?+
It's a Model Context Protocol server that exposes MySQL/MariaDB database diagnostics and tuning recommendations to AI assistants. The MCP server provides resources like latest audit reports and tools for running analyses and applying configuration changes.
How do I install and run the MCP server?+
Download mysqltuner.pl directly with wget, clone the GitHub repository, or pull the Docker image jmrenouard/mysqltuner. For MCP mode, run the build/mcp_server.py script or Docker container with database credentials as environment variables.
Which AI clients work with MySQLTuner MCP server?+
It supports Claude Desktop, Cursor IDE, VS Code/Cline, Antigravity, and frameworks like LangChain/LlamaIndex through the standard MCP stdio protocol.
What database privileges are required?+
You need SELECT, PROCESS, SHOW DATABASES, EXECUTE, REPLICATION CLIENT/REPLICA, and SHOW VIEW privileges. For MySQL 8.0+ also grant REPLICATION REPLICA; for MariaDB 10.5+ grant BINLOG MONITOR and REPLICA MONITOR.
Is MySQLTuner free to use?+
Yes, MySQLTuner-perl is open source under GPL-3.0 license and free to use. Paid commercial support is available through LightPath and Releem.
Does it require Perl dependencies or CPAN modules?+
Only Perl 5.6+ with perl-doc package is required. The HTML report generation is built-in with zero external dependencies or CPAN modules needed.
How do I install MySQLTuner-perl?+
Open the source repository on GitHub and follow its README. MySQLTuner-perl is a mcp server — MCP Agents Market links you directly to the official repo.
Is MySQLTuner-perl free?+
MySQLTuner-perl is an open-source project hosted on GitHub. Check the repository for its license and any usage requirements.