pg-aiguide

name	pg-aiguide
description	PostgreSQL and TimescaleDB skill collection from Timescale's pg-aiguide. Covers table design, hypertables, pgvector semantic search, and hybrid text search. **Trigger when user asks to:** - Design PostgreSQL tables or schemas - Work with TimescaleDB hypertables - Implement semantic search with pgvector - Set up hybrid text search in PostgreSQL - Migrate tables to hypertables

PostgreSQL AI Guide (Timescale)

This skill aggregates PostgreSQL and TimescaleDB expertise from Timescale's pg-aiguide project.

Sub-skills

Each sub-directory contains a specialized SKILL.md:

• design-postgres-tables — General PostgreSQL table design, data types, indexing, constraints, JSONB patterns
• find-hypertable-candidates — Identify tables that would benefit from conversion to TimescaleDB hypertables
• migrate-postgres-tables-to-hypertables — Step-by-step migration of standard PostgreSQL tables to hypertables
• pgvector-semantic-search — Semantic search implementation using pgvector extension
• postgres-hybrid-text-search — Hybrid full-text + semantic search in PostgreSQL
• setup-timescaledb-hypertables — Initial setup and configuration of TimescaleDB hypertables

Refer to the individual sub-skill SKILL.md files for detailed instructions and references.