A solid reference for OLTP performance work across PostgreSQL, MySQL, SQL Server, Oracle, and SQLite. The core value is in the structured approach: measurement-first triage using pg_stat_statements or slow query logs, EXPLAIN plan interpretation with platform-specific guidance, and index design that explicitly warns against over-indexing. The templates cover the operational reality of schema migrations (Flyway/Liquibase), replication setup, and backup/recovery workflows. What stands out is the separation between OLTP optimization (here) and OLAP workloads (punted to a separate data lake skill), which reflects how these problems actually differ in practice. Best for teams running transactional databases who need checklists and decision trees rather than theory.
npx skills add https://github.com/vasilyu1983/ai-agents-public --skill data-sql-optimization