# setup-timescaledb-hypertables

> Use this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especial…

Use this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for time-series, IoT, metrics, events, or log data. Use this to improve the performance of any insert-heavy table.

**Trigger when user asks to:**
- Create or design SQL schemas/tables AND Timescale/TimescaleDB/TigerData/Tiger Cloud is available
- Set up hypertables, compression, retention policies, or continuous aggregates
- Configure partition columns, segment_by, order_by, or chunk intervals
- Optimize time-series database performance or storage
- Create tables for sensors, metrics, telemetry, events, or transaction logs

**Keywords:** CREATE TABLE, hypertable, Timescale, TimescaleDB, time-series, IoT, metrics, sensor data, compression policy, continuous aggregates, columnstore, retention policy, chunk interval, segment_by, order_by

Step-by-step instructions for hypertable creation, column selection, compression policies, retention, continuous aggregates, and indexes.

- Type: Skill
- Made by: timescale
- Category: Databases
- Formats: Skills
- Version: 0c7912b
- Source: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/setup-timescaledb-hypertables
- Page: https://pluginboard.ai/skills/setup-timescaledb-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 setup-timescaledb-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/setup-timescaledb-hypertables

### Claude

In Claude (web or desktop): Download the setup-timescaledb-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/setup-timescaledb-hypertables

### Gemini

In Gemini: Download the setup-timescaledb-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/setup-timescaledb-hypertables

### GitHub Copilot

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.copilot/skills/setup-timescaledb-hypertables
```

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

### Cursor

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.cursor/skills/setup-timescaledb-hypertables
```

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

### Claude Code

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.claude/skills/setup-timescaledb-hypertables
```

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

### Codex

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.agents/skills/setup-timescaledb-hypertables
```

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

### Antigravity

In Antigravity: Copy the setup-timescaledb-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/setup-timescaledb-hypertables

### Gemini CLI

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.gemini/skills/setup-timescaledb-hypertables
```

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

### Replit

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables .agents/skills/setup-timescaledb-hypertables
```

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

### OpenClaw

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.openclaw/skills/setup-timescaledb-hypertables
```

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

### OpenCode

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.config/opencode/skills/setup-timescaledb-hypertables
```

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

### Hermes Agent

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.hermes/skills/setup-timescaledb-hypertables
```

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

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