# find-hypertable-candidates

> Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/Ti…

Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables.

**Trigger when user asks to:**
- Analyze database tables for hypertable conversion potential
- Identify time-series or event tables in an existing schema
- Evaluate if a table would benefit from Timescale/TimescaleDB
- Audit PostgreSQL tables for migration to Timescale/TimescaleDB/TigerData
- Score or rank tables for hypertable candidacy


**Keywords:** hypertable candidate, table analysis, migration assessment, Timescale, TimescaleDB, time-series detection, insert-heavy tables, event logs, audit tables

Provides SQL queries to analyze table statistics, index patterns, and query patterns. Includes scoring criteria (8+ points = good candidate) and pattern recognition for IoT, events, transactions, and sequential data.

- Type: Skill
- Made by: timescale
- Category: Databases
- Formats: Skills
- Version: d05e422
- Source: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/find-hypertable-candidates
- Page: https://pluginboard.ai/skills/find-hypertable-candidates

## 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 find-hypertable-candidates 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/find-hypertable-candidates

### Claude

In Claude (web or desktop): Download the find-hypertable-candidates 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/find-hypertable-candidates

### Gemini

In Gemini: Download the find-hypertable-candidates 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/find-hypertable-candidates

### GitHub Copilot

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.copilot/skills/find-hypertable-candidates
```

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

### Cursor

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.cursor/skills/find-hypertable-candidates
```

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

### Claude Code

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.claude/skills/find-hypertable-candidates
```

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

### Codex

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.agents/skills/find-hypertable-candidates
```

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

### Antigravity

In Antigravity: Copy the find-hypertable-candidates 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/find-hypertable-candidates

### Gemini CLI

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.gemini/skills/find-hypertable-candidates
```

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

### Replit

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates .agents/skills/find-hypertable-candidates
```

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

### OpenClaw

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.openclaw/skills/find-hypertable-candidates
```

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

### OpenCode

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.config/opencode/skills/find-hypertable-candidates
```

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

### Hermes Agent

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.hermes/skills/find-hypertable-candidates
```

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

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