mcpField
P
postgres

postgres

github.com/timescaleData & databases1.9k1.4k installsUpdated 1w ago
Repository

About postgres

postgres is a collection of specialized skills for PostgreSQL work, with task-specific references for database exploration, table design, search, TimescaleDB, and migrations. It is for developers who need focused SQL patterns and procedures for a particular database task.

Key features

  1. 01Explore existing database structures read-only
  2. 02Design standard and PostGIS tables
  3. 03Set up pgvector and hybrid search
  4. 04Configure and assess TimescaleDB hypertables
  5. 05Plan production database migrations

Use cases

  1. 01Inspect tables and routines in an existing database
  2. 02Design tables for spatial or vector search
  3. 03Assess existing tables for hypertable conversion
  4. 04Plan production schema changes

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/timescale/pg-aiguide --skill postgres

After installing, type/postgresin Claude Code to confirm it loaded.

Details

From the project README

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.
Search
  • pgvector-semantic-search — Vector similarity search with pgvector: HNSW/IVFFlat indexes, halfvec storage, quantization, filtered search, and tuning. Use for embeddings, RAG, or semantic search.
  • postgres-hybrid-text-search — Hybrid search combining BM25 keyword search with pgvector semantic search using RRF. Use when combining keyword and meaning-based search.
TimescaleDB
  • setup-timescaledb-hypertables — Hypertable creation, compression, retention policies, continuous aggregates, and indexes. Use when setting up TimescaleDB from scratch.
  • find-hypertable-candidates — SQL queries to analyze existing tables and score them for hypertable conversion. Use when evaluating which tables to migrate.
  • migrate-postgres-tables-to-hypertables — Step-by-step migration: partition column selection, in-place vs blue-green, validation. Use when executing a migration.
Migrations
  • postgres-database-migration — DDL lock reference, safe migration patterns, timeout strategies, rollback planning, and fork-based testing. Use when planning or executing schema changes on production databases.

How to Use

  1. Identify which reference matches the user's task from the descriptions above.
  2. Load the reference file to get detailed instructions and SQL patterns.
  3. For tasks spanning multiple areas (e.g., "design a table with vector search"), load multiple references as needed.

Comments

Markdown supported