Skip to content
Skills Library
Programming · Building & coding

postgres

/postgres

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:** - Explore an existing PostgreSQL database to understand its objects and relationships - 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 hyper

Repository
pg-aiguide ↗
Licence
Apache-2.0
Last repository change
22.10.2026

Assessment and security

90/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content25 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
14
Scripts
0
HTML comments
0
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 22.10.2026, without references to retired models or APIs.

Licence

Apache-2.0, otwarta: można używać i zmieniać, z zachowaniem licencji i informacji o zmianach.

What it does and when to use it

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:** - Explore an existing PostgreSQL database to understand its objects and relationships - 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 hyper

Original author 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:** - Explore an existing PostgreSQL database to understand its objects and relationships - 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 hyper

How it works

  1. Available References
  2. How to Use
Original SKILL.md headings · 32 lines, 289 words
SKILL.md preview
---
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:**
  - Explore an existing PostgreSQL database to understand its objects and relationships
  - 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

  **Keywords:** PostgreSQL, Postgres, SQL, schema, table design, indexes, constraints, pgvector, PostGIS, TimescaleDB, hypertable, semantic search, hybrid search, BM25, time-series, migration
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

### Existing Databases
- **[schema-exploration](references/schema-exploration/guide.md)** — 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](references/design-postgres-tables.md)** — Data types, constraints, indexes, JSONB patterns, partitioning, and PostgreSQL best practices. **Use for any general table/schema design task.**
- **[design-postgis-tables](references/design-postgis-tables.md)** — 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](references/pgvector-semantic-search.md)** — 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](references/postgres-hybrid-text-search.md)** — Hybrid search combining BM25 keyword search with pgvector semantic search using RRF. **Use when combining keyword and meaning-based search.**

### TimescaleDB
- **[setup-timescaledb-hypertables](references/setup-timescaledb-hypertables.md)** — Hypertable creation, compression, retention policies, continuous aggregates, and indexes. **Use when setting up TimescaleDB from scratch.**
- **[find-hypertable-candidates](references/find-hypertable-candidates.md)** — SQL queries to analyze existing tables and score them for hypertable conversion. **Use when evaluating which tables to migrate.**
- **[migrate-postgres-tables-to-hypertables](references/migrate-postgres-tables-to-hypertables.md)** — Step-by-step migration: partition column selection, in-place vs blue-green, validation. **Use when executing a migration.**

### Migrations
- **[postgres-database-migration](references/postgres-database-migration.md)** — 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.
Files in this package (14)
  • SKILL.md 4 KB
  • references/backfill-strategies.md 1 KB
  • references/complete-example.md 1 KB
  • references/design-postgis-tables.md 1 KB
  • references/design-postgres-tables.md 1 KB
  • references/find-hypertable-candidates.md 1 KB
  • references/migrate-postgres-tables-to-hypertables.md 1 KB
  • references/pgvector-semantic-search.md 1 KB
  • references/postgres-database-migration.md 1 KB
  • references/postgres-hybrid-text-search.md 1 KB
  • references/setup-timescaledb-hypertables.md 1 KB
  • references/validation-queries.md 1 KB
  • references/schema-exploration/guide.md 1 KB
  • references/schema-exploration/references 1 KB

Versions

RepositoryScoreLicence
This page · timescale/pg-aiguide90Apache-2.0
magnus919/agent-skills100MIT
nimadorostkar/Claude-Skills-collection100MIT
digitalocean-labs/do-app-platform-skills100MIT
lynricsy/hyperskills100MIT
tuannv14/claude-team-toolkit100MIT
sanjay3290/ai-skills100Apache-2.0
nahid-sparktales/agent-dispatcher90MIT

Database snapshot: 13.11.2026 · package version dfbb48be1107 (SHA-256 digest of the entire package)

Downloads in the last 30 days: 0 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 100postgresql
    PostgreSQL-specific schema design reference for advanced data types (ENUM, array, range, network, domain), storage internals (MVCC, HOT updates, TOAST, heap), and advanced constraints (EXCLUDE, generated columns). Use when designing PostgreSQL schemas, choosing data types,…
  • 100design-postgres-tables
    Use this skill for general PostgreSQL table design. **Trigger when user asks to:** - Design PostgreSQL tables, schemas, or data models when creating new tables and when modifying existing ones. - Choose data types, constraints, or indexes for PostgreSQL - Create user tables,…
  • 95postgresql-table-design
    Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
  • 100pgvector
    pgvector is a PostgreSQL extension that stores vector embeddings in ordinary tables and searches them by similarity, so no separate vector database is needed. Use when someone asks for "vector search in Postgres", "store embeddings", "pgvector", "similarity search", "RAG with…
  • 100postgresql
    Design PostgreSQL-specific schemas covering best practices, data types, indexing, constraints, performance patterns, and advanced features. Use when designing or optimizing PostgreSQL databases.
  • 100laravel-vector-search
    Use when implementing semantic/vector search in Laravel 13 with PostgreSQL + pgvector.

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.