Plan and review MySQL and InnoDB schema, indexing, query, and operational changes.
npx skills add https://github.com/kanade0404/dotfiles --skill mysql-kanade0404
Please help me install this Agent Skill. Skill: mysql Source: https://github.com/kanade0404/dotfiles/tree/main/.opencode/skills/mysql Command: npx skills add https://github.com/kanade0404/dotfiles --skill mysql-kanade0404
This Skill helps you make safe, measurable MySQL and InnoDB changes by turning schema, index, query, transaction, and operational decisions into clear, evidence-based guidance.
Ask for a MySQL schema, query, or migration review with the table definitions, workload details, and any EXPLAIN output you already have.
High-intent search queries and answers about installing and using this skill.
To optimize slow MySQL queries, analyze EXPLAIN plans to identify non-sargable conditions, design composite and covering indexes, and eliminate N+1 query patterns for measurable performance tuning.
The safest way to run online DDL migrations in InnoDB is to evaluate the least risky ALTER strategy, validate index impact, and prepare rollback steps before touching production data.
To troubleshoot MySQL deadlocks, diagnose lock metrics and concurrency issues, adjust transaction isolation levels, and apply evidence-based validation to resolve conflicts safely.
To choose durable primary keys and partitioning strategies for MySQL schema design, select appropriate data types, character sets, and JSON patterns based on workload requirements and version-aware safety checks.
To handle MySQL replication lag and control connection usage, monitor operational metrics, manage connection pools, and apply evidence-based validation to ensure stable concurrency and operations.
pekralDiagnose MySQL query performance using SQL, schema, and EXPLAIN evidence.
rabbicseAnalyze PostgreSQL execution plans and recommend safe index and query optimizations.
liuridaExpose GORM database metrics to Prometheus for monitoring.
4lermanGenerate SQL queries, introspect schemas, optimize performance, and create migration scripts.
