What problem does it solve? Teams working on PostgreSQL-backed features often lack a consistent process for diagnosing database impact, specifying schemas, writing reversible migrations, and reviewing query performance, leading to inconsistent tables, missing indexes, and slow queries in production. ## Core Features & Use Cases - Phase-based database guidance: Provides checklists for diagnosing affected tables and relationships, specifying schemas with constraints and indexes, implementing migrations, and evaluating query performance. - Migration conventions: Enforces a recommended implementation order with UP and DOWN migrations verified via psql. - Query quality review: Requires EXPLAIN ANALYZE verification, forbids SELECT * in production code, and checks for duplicate indexes. - Use Case: When adding a new feature that stores call records, use this Skill during design to specify the table, foreign keys, and indexes, then during implementation to write and test reversible migrations, and finally during review to confirm no sequential scans on large tables. ## Quick Start Ask the AI to apply the db-postgresql skill to design the schema and migrations for the new feature you are specifying.
