Claude MarketplacesSubmit
timescale avatar

Setup Timescaledb Hypertables

timescale/pg-aiguide

This walks you through setting up TimescaleDB hypertables with all the options that actually matter: partition columns, segment_by for grouping hot query paths, order_by for compression, and sparse indexes to skip decompression. It's built for insert-heavy patterns like metrics, IoT sensors, event logs, or transaction records. The segment_by guidance is especially useful since most people either skip it or add too many columns. One thing to know: it assumes you want columnstore compression by default, which you probably do unless you're using pgvector. The examples are concrete enough that you can adapt them without reading TimescaleDB docs for the third time this month.

skills.sh installs
537
GitHub stars
1.9K
last updated
Aug 21, 2026
View on GitHub

Install

$ npx -y skills add timescale/pg-aiguide --skill setup-timescaledb-hypertables --agent claude-code

Installs into .claude/skills of the current project.

Files

TimescaleDB Complete Setup

Instructions for insert-heavy data patterns where data is inserted but rarely changed:

  • Time-series data (sensors, metrics, system monitoring)
  • Event logs (user events, audit trails, application logs)
  • Transaction records (orders, payments, financial transactions)
  • Sequential data (records with auto-incrementing IDs and timestamps)
  • Append-only datasets (immutable records, historical data)

Step 1: Create Hypertable

SKILL.md on GitHub

Sponsors

Promote your product hereReach 125k+ visitors monthlyPromote your product hereReach 125k+ visitors monthlyAgent CaffeineSponsoredClose your lid, come back to finished workSnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthlyWaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthlyknobsSponsoredSee your site on any phone, any day, in any language

Details

Repository
github.com/timescale/pg-aiguide
Categories
Backend & APIs, Debugging, Marketing & SEO, Cloud & Infrastructure, Design & UI/UX, Databases
License
Apache-2.0
First seen
Jun 3, 2026

More from timescale/pg-aiguide

All 8

Recommended

More Backend & APIs
1andreadellacorte avatargroove-work-execandreadellacorte/grooveExecute the implementation plan, track progress in the task backend. Use after planning.536skills.sh installs
2manutej avatarspring-boot-developmentmanutej/luxor-claude-marketplaceComprehensive Spring Boot development skill covering auto-configuration, dependency injection, REST APIs, Spring Data, security, and enterprise Java application536skills.sh installs
3andreadellacorte avatargroove-utilities-task-configandreadellacorte/grooveConfigure task backend settings interactively.533skills.sh installs
4andreadellacorte avatargroove-utilities-task-archiveandreadellacorte/grooveArchive a completed task in the configured backend.532skills.sh installs
5mohitmishra786 avatarwasm-wasmtimemohitmishra786/low-level-dev-skillsWebAssembly runtime skill using wasmtime. Use when running WASM modules with wasmtime CLI, working with WASI preview2, using the component model, embedding wasm532skills.sh installs
6davila7 avatarpineconedavila7/claude-code-templatesManaged vector database for production AI applications. Fully managed, auto-scaling, with hybrid search (dense + sparse), metadata filtering, and namespaces. Lo531skills.sh installs