Postgres

Design and operate PostgreSQL schemas, queries, indexes, and migrations with performance and safety in mind. Use when modeling data, tuning queries, creating migrations, or troubleshooting database behavior.

nikopj01 Updated

File contents

PostgreSQL

Workflow

  1. Model entities, constraints, and relationships explicitly.
  2. Write parameterized queries and avoid dynamic SQL concatenation.
  3. Add indexes based on query patterns and validate with EXPLAIN ANALYZE.
  4. Keep migrations forward-only, reversible where possible, and tested on staging data.
  5. Monitor slow queries, connection usage, and lock contention.

nikopj01/codex-skills/tree/main/postgres commit 2e636ebf97

Frequently asked questions

npx skillmds@latest add nikopj01/postgres