Find Hypertable Candidates

Find Hypertable Candidates is a DevOps skill for Claude Code, published by timescale in pg-aiguide.

1.8K stars104 forkson timescale/pg-aiguideAdded 2026/08/18Repository updated 2026/06/26

aiai-agentsai-codingclaude-code-pluginclaude-code-pluginsclaude-code-plugins-marketplaceclaude-marketplaceclaude-pluginclaude-skillsdocsdocumentationmcpmcp-serverpostgrespostgresqlskills

Install in seconds

Install Find Hypertable Candidates

Copy Find Hypertable Candidates into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.

terminal

npx degit https://github.com/timescale/pg-aiguide/tree/main/skills/find-hypertable-candidates ~/.claude/skills/find-hypertable-candidates

Requires Node.js. Downloads this skill only — not the rest of the repository — into your Claude Code skills folder.

Without Node.js

git clone https://github.com/timescale/pg-aiguide.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file: skills/find-hypertable-candidates/SKILL.md in timescale/pg-aiguide
Installs to: ~/.claude/skills/find-hypertable-candidates
Collection: One of 10 skills cataloged from this repository
Category: DevOps — 798 skills

What Find Hypertable Candidates does

Find Hypertable Candidates analyzes an existing PostgreSQL database to identify which tables should be converted to Timescale/TimescaleDB hypertables. Use it when auditing tables for time-series or insert-heavy workloads and evaluating hypertable candidacy before migration.

Find Hypertable Candidates is cataloged under DevOps on DirSkills. Find Hypertable Candidates comes from a repository tagged ai, ai-agents, ai-coding, claude-code-plugin and claude-code-plugins.

Documentation

README

Excerpt

PostgreSQL Hypertable Candidate Analysis

Identify tables that would benefit from TimescaleDB hypertable conversion. After identification, use the companion "migrate-postgres-tables-to-hypertables" skill for configuration and migration.

TimescaleDB Benefits

Performance gains: 90%+ compression, fast time-based queries, improved insert performance, efficient aggregations, continuous aggregates for materialization (dashboards, reports, analytics), automatic data management (retention, compression).

Best for insert-heavy patterns:

This is the opening of the README. Read the full README on GitHub.

Frequently asked about Find Hypertable Candidates

What else does timescale publish alongside Find Hypertable Candidates?
Find Hypertable Candidates is one of 10 skills that DirSkills catalogs from timescale/pg-aiguide, the repository it ships in. Its siblings there include Ghost Database, PGVector Semantic Search and PostGIS Spatial Table Design. Each one is a separate skill with its own page in this directory, installs the same way Find Hypertable Candidates does, and is maintained by timescale in that same repository. The rest of the collection is listed on the timescale/pg-aiguide page.
How does Find Hypertable Candidates compare to other DevOps skills?
Find Hypertable Candidates ranks #287 by stars among the 798 DevOps skills in this catalog. The most-starred ones next to it are Backend Patterns, API Connector Builder and Migration. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of Find Hypertable Candidates against them. Open each page to compare what they document and how they install.