postgres
The generalist Postgres skill the ecosystem was missing — schema, indexing, extensions and migrations, from a Postgres company.
Install
$ npx skills add timescale/pg-aiguide --skill postgresOr install the whole bundle: npx skills add timescale/pg-aiguide
Best for
Any Postgres decision where the default answer is wrong: choosing between B-tree and GIN, partitioning a large table, or picking an index type for pgvector at your data size.
Not ideal for
MySQL or SQL Server work. It is Postgres-specific by design, including the extension ecosystem (pgvector, PostGIS, TimescaleDB) that makes Postgres advice non-transferable.
About this skill
Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations. Trigger when asked to design or modify PostgreSQL tables, schemas or data models; choose data types, constraints, indexes or partitioning strategies; work with pgvector embeddings, semantic search or RAG; set up full-text, hybrid or BM25 search; use PostGIS for spatial data; set up TimescaleDB hypertables for time-series; or plan and execute safe schema migrations with zero downtime.
Score breakdown
Score breakdown
rubric 1.0Composite 0–100 score derived from 9 verifiable signals. See the rubric →
Related skills
PlanetScale's schema branching and index-aware queries, packaged for agents.
Supabase done right. RLS policies, edge functions, realtime, auth — in idiomatic patterns.
Prisma migrations and queries by the book. Index-aware, migration-safe, type-correct.
