Postgres

A solid reference collection for PostgreSQL work that covers the main complexity areas: table design, vector search with pgvector, hybrid BM25+semantic search, PostGIS spatial queries, and TimescaleDB hypertables. The skill is organized around loading specific references as needed rather than dumping everything at once. The TimescaleDB section is especially practical, with separate guides for setting up fresh hypertables, identifying migration candidates in existing databases, and executing the actual migration. If you're building anything with embeddings or time-series data on Postgres, this consolidates the patterns you'd otherwise be piecing together from docs and blog posts.

skills.sh installs: 1.4K
GitHub stars: 1.9K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add timescale/pg-aiguide --skill postgres --agent claude-code

Installs into .claude/skills of the current project.

Files

PostgreSQL Expert Skills

This skill provides comprehensive PostgreSQL expertise through specialized references. Load the appropriate reference based on the task.

Available References

Existing Databases

schema-exploration — Read-only, question-driven exploration of schemas, tables, views, routines, triggers, RLS, and extensions using pg_catalog. Use to understand an existing database before designing changes or writing queries.

Table Design

design-postgres-tables — Data types, constraints, indexes, JSONB patterns, partitioning, and PostgreSQL best practices. Use for any general table/schema design task.
design-postgis-tables — PostGIS spatial table design: geometry vs geography types, SRIDs, spatial indexing, and location-based query patterns. Use when the task involves geographic or spatial data.

SKILL.md on GitHub