| 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.
