playbooks

home / skills / timescale / pg-aiguide

timescale/pg-aiguide

MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.

6 skills
GitHub

Sponsored

design-postgres-tables

timescale/pg-aiguide

1.5k
This skill helps you design robust PostgreSQL tables by applying best practices for keys, normalization, indexing, constraints, and data types.
migrate-postgres-tables-to-hypertables

timescale/pg-aiguide

1.5k
This skill guides migrating PostgreSQL tables to TimescaleDB hypertables with configuration, planning, and validation to maximize performance.
setup-timescaledb-hypertables

timescale/pg-aiguide

1.5k
This skill helps you design TimescaleDB hypertables with optimal partitioning, compression, retention, and continuous aggregates to improve time-series
find-hypertable-candidates

timescale/pg-aiguide

1.5k
This skill analyzes a PostgreSQL schema to identify hypertable candidates and guides migration with TimescaleDB best practices.
pgvector-semantic-search

timescale/pg-aiguide

1.5k
This skill guides you to configure pgvector semantic search in PostgreSQL, optimizing recall and speed for large embedding datasets.
postgres-hybrid-text-search

timescale/pg-aiguide

1.5k
This skill enables hybrid text search in PostgreSQL by combining BM25 keyword search with semantic vectors using RRF for improved relevance.