# Find Hypertable Candidates (agent skill)

> Find Hypertable Candidates is an agent skill (a SKILL.md file) from timescale/pg-aiguide. It is used to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables. It works with Claude Code, Codex, Cursor, Gemini CLI and OpenCode and has 1,857 GitHub stars across a repository of 2 listed skills.

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…

## Key facts

| Fact | Value |
|---|---|
| Repository | https://github.com/timescale/pg-aiguide |
| Skill path | skills/find-hypertable-candidates/SKILL.md |
| Skill name | find-hypertable-candidates |
| GitHub stars | 1,857 |
| Installs on skills.sh | not listed |
| License | Apache-2.0 |
| Skills in repo | 2 |
| Plugin marketplace | aiguide |
| Official | no |
| Works with | Claude Code, Codex, Cursor, Gemini CLI, OpenCode |
| Category | Data & analysis |
| Last commit | Sep 25, 2026 |

## When it triggers

- 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 f

## Add this skill

### Claude Code

```sh
/plugin marketplace add timescale/pg-aiguide
/plugin install pg@aiguide
```

In the Claude apps, zip the skill folder and upload it under Customize > Skills > + > Upload a skill (code execution must be on).

### ChatGPT / Codex

```sh
git clone --depth 1 https://github.com/timescale/pg-aiguide.git
cp -r pg-aiguide/skills/find-hypertable-candidates .agents/skills/find-hypertable-candidates   # repo; ~/.agents/skills for all projects
```

### Cursor

```sh
git clone --depth 1 https://github.com/timescale/pg-aiguide.git
cp -r pg-aiguide/skills/find-hypertable-candidates .cursor/skills/find-hypertable-candidates   # project; ~/.cursor/skills for all projects
```

Sources (checked 2026-10-07): https://code.claude.com/docs/en/skills, https://support.claude.com/en/articles/12512180-using-skills-in-claude, https://learn.chatgpt.com/docs/build-skills, https://cursor.com/docs/context/skills

---

Canonical page: https://appsgit.com/skills/timescale-find-hypertable-candidates
Source: appsgit (https://appsgit.com), the app store for github. Data from the GitHub API, refreshed nightly.
Machine access: JSON API https://appsgit.com/api/v1/apps (OpenAPI: https://appsgit.com/openapi.json), MCP server https://mcp.appsgit.com/mcp, full index https://appsgit.com/llms-full.txt.