# migrate-postgres-tables-to-hypertables

> Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration…

Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation.

**Trigger when user asks to:**
- Migrate or convert PostgreSQL tables to hypertables
- Execute hypertable migration with minimal downtime
- Plan blue-green migration for large tables
- Validate hypertable migration success
- Configure compression after migration

**Prerequisites:** Tables already identified as candidates (use find-hypertable-candidates first if needed)

**Keywords:** migrate to hypertable, convert table, Timescale, TimescaleDB, blue-green migration, in-place conversion, create_hypertable, migration validation, compression setup

Step-by-step migration planning including: partition column selection, chunk interval calculation, PK/constraint handling, migration execution (in-place vs blue-green), and performance validation queries.

- Type: Skill
- Made by: timescale
- Category: Databases
- Formats: Skills
- Version: 6cf16f5
- Source: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/migrate-postgres-tables-to-hypertables
- Page: https://pluginboard.ai/skills/migrate-postgres-tables-to-hypertables

## 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 migrate-postgres-tables-to-hypertables 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/migrate-postgres-tables-to-hypertables

### Claude

In Claude (web or desktop): Download the migrate-postgres-tables-to-hypertables 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/migrate-postgres-tables-to-hypertables

### Gemini

In Gemini: Download the migrate-postgres-tables-to-hypertables 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/migrate-postgres-tables-to-hypertables

### GitHub Copilot

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.copilot/skills/migrate-postgres-tables-to-hypertables
```

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

### Cursor

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.cursor/skills/migrate-postgres-tables-to-hypertables
```

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

### Claude Code

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.claude/skills/migrate-postgres-tables-to-hypertables
```

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

### Codex

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.agents/skills/migrate-postgres-tables-to-hypertables
```

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

### Antigravity

In Antigravity: Copy the migrate-postgres-tables-to-hypertables 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/migrate-postgres-tables-to-hypertables

### Gemini CLI

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.gemini/skills/migrate-postgres-tables-to-hypertables
```

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

### Replit

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables .agents/skills/migrate-postgres-tables-to-hypertables
```

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

### OpenClaw

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.openclaw/skills/migrate-postgres-tables-to-hypertables
```

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

### OpenCode

Run in your terminal:

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

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

### Hermes Agent

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.hermes/skills/migrate-postgres-tables-to-hypertables
```

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

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