---
name: postgres
slug: postgres-aiguide
score: 55
rubric: 1.0
provenance: verified-org
publisher: TigerData (Timescale)
license: Apache-2.0
capability: read-only
canonical: https://top-agent-skills.com/skill/postgres-aiguide
---

# postgres

The generalist Postgres skill the ecosystem was missing — schema, indexing, extensions and migrations, from a Postgres company.

## Install

### Claude Code

```bash
npx skills add timescale/pg-aiguide --skill postgres
```

## Best for

Any Postgres decision where the default answer is wrong: choosing between B-tree and GIN, partitioning a large table, or picking an index type for pgvector at your data size.

## Not ideal for

MySQL or SQL Server work. It is Postgres-specific by design, including the extension ecosystem (pgvector, PostGIS, TimescaleDB) that makes Postgres advice non-transferable.

## About

Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations. Trigger when asked 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, hybrid or BM25 search; use PostGIS for spatial data; set up TimescaleDB hypertables for time-series; or plan and execute safe schema migrations with zero downtime.

## Compatibility

claude-code

## Metadata

- Categories: databases-schemas
- Surfaces: claude-code
- Tags: PostgreSQL, pgvector, Schema design
- Setup time: 1 min
- Complexity: Low
- Last update: 2026-06-26
- Verified: —
- Source: https://github.com/timescale/pg-aiguide/tree/main/skills/postgres
- Docs: https://github.com/timescale/pg-aiguide/blob/main/skills/postgres/SKILL.md

---

_Indexed by Top Agent Skills. Score breakdown: https://top-agent-skills.com/about/methodology_