# postgres

> Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector…

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

- Type: Skill
- Made by: timescale
- Category: Databases
- Formats: Skills
- Version: 64986c4
- Source: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres
- Page: https://pluginboard.ai/skills/postgres-timescale

## Works with

- ChatGPT
- Claude
- Gemini
- GitHub Copilot
- Cursor
- Claude Code
- Codex
- Antigravity
- Gemini CLI
- Replit
- OpenClaw
- OpenCode
- Hermes Agent

## Install

### ChatGPT

In ChatGPT: Download the postgres folder and zip it, then Plugins → Skills → Create → Upload from your computer. Business and Enterprise plans.

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres

### Claude

In Claude (web or desktop): Download the postgres folder and zip the folder itself, then upload it in Customize → Skills.

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres

### Gemini

In Gemini: Download the postgres folder, then at gemini.google.com click Customize → Skills → Create → Upload and pick the folder (or a .zip of it).

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres

### GitHub Copilot

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres ~/.copilot/skills/postgres
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres

### Cursor

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres ~/.cursor/skills/postgres
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres

### Claude Code

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres ~/.claude/skills/postgres
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres

### Codex

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres ~/.agents/skills/postgres
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres

### Antigravity

In Antigravity: Copy the postgres folder into ~/.gemini/config/skills (Antigravity app and IDE) or ~/.gemini/antigravity-cli/skills (Antigravity CLI).

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres

### Gemini CLI

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres ~/.gemini/skills/postgres
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres

### Replit

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres .agents/skills/postgres
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres

### OpenClaw

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres ~/.openclaw/skills/postgres
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres

### OpenCode

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres ~/.config/opencode/skills/postgres
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres

### Hermes Agent

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/postgres ~/.hermes/skills/postgres
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/postgres

---
From Pluginboard (https://pluginboard.ai).