← ClaudeAtlas

postgres-referencelisted

Worked SQL/DDL examples for PostgreSQL conventions — data types, indexing (B-tree/GIN/ GiST/BRIN), constraints, queries, EXPLAIN, JSON/arrays, and Rails-specific patterns. CONSULT when writing migrations, schema, or SQL and you need the idiomatic example or an index/constraint pattern. Reference loaded on demand — the always-apply rules live in the `postgresql-universal` and `postgresql-rails` rules.
mik2win/foureyes · ★ 2 · AI & Automation · score 72
Install: claude install-skill mik2win/foureyes
# PostgreSQL — worked examples Companion to the `postgresql-universal` and `postgresql-rails` rules. Read the reference file (in this skill's folder) for what you need: - **Universal** — types, indexes, constraints, queries, EXPLAIN, JSON/arrays → `references/universal.md` - **Rails-specific** — migrations, schema, ActiveRecord ↔ Postgres patterns → `references/rails.md`