Mysql Debug

MySQL Debug

Debug MySQL or MariaDB database issues: databases, tables, processes, connections, server status, slow queries, lock contention.

Inputs

Workflow

1. Bootstrap

• persona_load("developer") — database tools (or database persona if available)
• check_known_issues("mysql"), check_known_issues("database"), check_known_issues("mariadb")

2. Database Discovery

• mysql_databases() — list databases
• If database: mysql_tables(database=database) — list tables

3. Table Inspection

• If database: mysql_describe(database=database) — table structure
• If database: mysql_show_create_table(database=database) — CREATE TABLE

4. Process and Connection Checks

• If check_processes: mysql_processlist() — active processes
• mysql_status() — server status
• mysql_query("SELECT id, user, host, db, command, time, state, LEFT(info, 100) AS query_preview FROM information_schema.processlist WHERE command != 'Sleep' AND time > 5 ORDER BY time DESC LIMIT 10;") — slow queries

5. Analysis

• Flag long-running queries (>5s)
• Parse Threads_connected; flag if > 50
• Check connection usage vs max_connections; flag if > 80%
• Flag "Locked" or "Waiting for" in processlist

6. Failure Learning

• "access denied" → learn_tool_fix("mysql_databases", "access denied", "MySQL authentication failed", "Verify credentials and user permissions")
• "connection refused" / "can't connect" → learn_tool_fix("mysql_databases", "connection refused", "MySQL not running or not accessible", "Start with podman start mysql or systemctl start mysqld")

7. Memory

• memory_session_log("MySQL debug on {host}", "database=X, healthy=Y, issues=Z")

Key MCP Tools

• persona_load, check_known_issues, learn_tool_fix, memory_session_log
• mysql_databases, mysql_tables, mysql_describe, mysql_show_create_table
• mysql_processlist, mysql_status, mysql_query