Postgres Hypertable Migration

Postgres Hypertable Migration 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 Postgres Hypertable Migration

Copy Postgres Hypertable Migration 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/migrate-postgres-tables-to-hypertables ~/.claude/skills/migrate-postgres-tables-to-hypertables

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/migrate-postgres-tables-to-hypertables/SKILL.md in timescale/pg-aiguide
Installs to: ~/.claude/skills/migrate-postgres-tables-to-hypertables
Collection: One of 10 skills cataloged from this repository
Category: DevOps — 798 skills

What Postgres Hypertable Migration does

Postgres Hypertable Migration plans and executes migration of PostgreSQL tables to TimescaleDB hypertables, including partition column selection, chunk interval calculation, constraint handling, and validation. Use it after identifying candidate tables to convert with minimal downtime.

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

Documentation

README

Excerpt

-- Find potential partition columns
SELECT column_name, data_type, is_nullable
FROM information_schema.columns
WHERE table_name = 'your_table_name'
  AND data_type IN ('timestamp', 'timestamptz', 'bigint', 'integer', 'date')
ORDER BY ordinal_position;

Requirements: Time-based (TIMESTAMP/TIMESTAMPTZ/DATE) or sequential integer (INT/BIGINT)

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

Frequently asked about Postgres Hypertable Migration

What else does timescale publish alongside Postgres Hypertable Migration?
Postgres Hypertable Migration is one of 10 skills that DirSkills catalogs from timescale/pg-aiguide, the repository it ships in. Its siblings there include Find Hypertable Candidates, Ghost Database and PGVector Semantic Search. Each one is a separate skill with its own page in this directory, installs the same way Postgres Hypertable Migration 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 Postgres Hypertable Migration compare to other DevOps skills?
Postgres Hypertable Migration ranks #289 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 Postgres Hypertable Migration against them. Open each page to compare what they document and how they install.