Find Hypertable Candidates
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.
github.com/timescale/pg-aiguide/skills/find-hypertable-candidates (opens in a new tab)
- Multi-skill repo
- Plugin marketplace
- Data & analysis
- Actively maintained
Add this skill
Claude
This repository is a Claude Code plugin marketplace. In Claude Code:
/plugin marketplace add timescale/pg-aiguide
/plugin install pg@aiguideIn the Claude apps, zip the find-hypertable-candidates folder and upload it under Customize > Skills > + > Upload a skill (code execution must be on).
ChatGPT / Codex
Codex reads skills from .agents/skills/ in a repo or ~/.agents/skills/ for every project:
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 projectsStandalone skills also load in the ChatGPT desktop app.
Cursor
Cursor loads skills from .cursor/skills/ (or ~/.cursor/skills/) and also reads .claude/skills/:
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 projectsSource (checked Oct 7, 2026): code.claude.com/docs/en/skills (opens in a new tab), code.claude.com/docs/en/plugin-marketplaces (opens in a new tab), support.claude.com/en/articles/12512180-using-skills-in-claude (opens in a new tab), learn.chatgpt.com/docs/build-skills (opens in a new tab), cursor.com/docs/context/skills (opens in a new tab)
What this skill does
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…
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
More skills in timescale/pg-aiguide
2 skills are listed from this repository.
Similar skills
More data & analysis skills
Migration
JuliusBrussee/caveman
Implement reversible compatibility-safe transitions.
Data & analysisGoDating Web
nexu-io/open-design
A consumer-feeling dating / matchmaking dashboard — left rail navigation, ticker bar of community signals, headline KPIs, a 30-day mutual-matches bar chart, and a match-rate trend block.
Data & analysisTypeScriptDcf Valuation
nexu-io/open-design
Discounted cash flow valuation and intrinsic value analysis for public companies.
Data & analysisTypeScriptFlowai Live Dashboard Template
nexu-io/open-design
Team-management dashboard skill in the FlowAI aesthetic — three tabs (Team Members, Team Details, Activity Log), KPI stat row, member table, role distribution bar chart, online presence and activity…
Data & analysisTypeScriptHow It Works
thedotmack/claude-mem
Explain how claude-mem captures observations, when memory injection kicks in, and where data lives.
Data & analysisTypeScriptWeekly Digests
thedotmack/claude-mem
Generate a serial week-by-week narrative digest of a project's full claude-mem timeline.
Data & analysisTypeScript
What is the Find Hypertable Candidates 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. Its SKILL.md lives at github.com/timescale/pg-aiguide/skills/find-hypertable-candidates.
How do I install the Find Hypertable Candidates skill?
In Claude Code, run /plugin marketplace add timescale/pg-aiguide and then /plugin install pg@aiguide. For Codex or Cursor, copy the find-hypertable-candidates folder into .agents/skills/ or .cursor/skills/.
Is the Find Hypertable Candidates skill free?
Yes. The repository is open source under the Apache-2.0 license.
Is Find Hypertable Candidates maintained?
The repository's most recent commit was on Sep 25, 2026. Its latest release is v0.6.1. appsgit only lists skills from repositories with a commit in the last six months.