/postgres

---
name: postgres
description: |
  Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations.

  **Trigger when user asks to:**
  - Design or modify PostgreSQL tables, schemas, or data models
  - Choose data types, constraints, indexes, or partitioning strategies
  - Work with pgvector embeddings, semantic search, or RAG
  - Set up full-text search, hybrid search, or BM25 ranking
  - Use PostGIS for spatial/geographic data
  - Set up TimescaleDB hypertables for time-series data
  - Migrate tables to hypertables or evaluate migration candidates
  - Plan or execute safe schema migrations with zero downtime
  - Create, fork, or manage databases with Ghost

  **Keywords:** PostgreSQL, Postgres, SQL, schema, table design, indexes, constraints, pgvector, PostGIS, TimescaleDB, hypertable, semantic search, hybrid search, BM25, time-series, migration, Ghost
license: Apache-2.0
metadata:
  author: tigerdata
---

# PostgreSQL Expert Skills

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

## Available References

### Table Design