Review PostgreSQL and MySQL migrations, queries, and schema designs.
npx skills add https://github.com/paultyng/skill-issue --skill review-database-paultyng
Please help me install this Agent Skill. Skill: review-database Source: https://github.com/paultyng/skill-issue/tree/main/skills/review-database Command: npx skills add https://github.com/paultyng/skill-issue --skill review-database-paultyng
Undetected database issues like unsafe migrations, slow unindexed queries, and poor schema design cause production outages, performance degradation, and data loss that are costly and time-consuming to fix after deployment.
Use the review-database skill to scan your project's database migration files, queries, and schema code for safety risks, performance issues, and design flaws.
High-intent search queries and answers about installing and using this skill.
Database migration review identifies unsafe PostgreSQL and MySQL operations that cause downtime, running automated squawk linting on migration files to flag table locks and data loss risks before they hit production.
Slow query performance in sharded databases often stems from scatter queries, cross-shard transactions, and poor sharding key selection, which database review detects by analyzing application query code and schema definitions.
Database schema review includes specialized checks for horizontally sharded databases using Vitess, Citus, or Spanner, catching scatter queries, cross-shard transactions, and poor sharding key selection that cause performance degradation.
Query and schema analysis detects missing indexes, improper connection and transaction handling, and flawed schema design for both PostgreSQL and MySQL environments by scanning application query code and schema definitions.
Pre-deployment database safety validation is needed when preparing to deploy new database migrations, scanning migration files and related application code to catch operations that would lock tables and cause production outages during rollout.
JesusFigueroa25Optimize PostgreSQL and MySQL database performance through schema, query, and indexing analysis.
t-stringsStandardize versioned database migration scripts with rollback support and execution logs.
its-BasudebaAutomate Laravel environment validation, static analysis, and deployment readiness checks.
voidrotAnalyze and optimize PostgreSQL queries using EXPLAIN ANALYZE and indexing strategies.
