Setup Timescaledb Hypertables
timescale/pg-aiguide/skills/setup-timescaledb-hypertablesby timescale187be00d317a51210c132010d947f4546ffb5eefApache-2.0Listed Oct 9, 2026Updated Oct 9, 2026
Use this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for time-series, IoT, metrics, events, or log data. Use this to improve the performance of any insert-heavy table. **Trigger when user asks to:** - Create or design SQL schemas/tables AND Timescale/TimescaleDB/TigerData/Tiger Cloud is available - Set up hypertables, compression, retention policies, or continuous aggregates - Configure partition columns, segment_by, order_by, or chunk intervals - Optimize time-series database performance or storage - Create tables for sensors, metrics, telemetry, events, or transaction logs **Keywords:** CREATE TABLE, hypertable, Timescale, TimescaleDB, time-series, IoT, metrics, sensor data, compression policy, continuous aggregates, columnstore, retention policy, chunk interval, segment_by, order_by Step-by-step instructions for hypertable creation, column selection, compression policies, retention, continuous aggregates, and indexes.
Add to a SourceWeft workspace
- Open the skill in your dashboard and add it to a workspace.
- Enable it for the chats that should use it.
This skill is instructions only: it ships no scripts to execute.
Add to SourceWeftYou will be asked to sign in first, then taken straight to this skill.
Ask your agent to install it
Paste this prompt into Claude Code, Codex, Cursor or another agent that can run commands — or into SourceWeft chat. The agent reads this skill's install guide, shows you its source, license and scripts, and installs it with the SourceWeft CLI once you agree.
Read https://sourceweft.com/skills/gh-timescale-pg-aiguide-setup-timescaledb-hypertables-skills-setup-timescaledb-hypertables-66be5ec6f4674def/install.md and install the skill it describes. Before installing, show me its source, license and whether it ships scripts, and wait for my OK. Ask me before changing anything else on my machine.Install it yourself from a terminal
For Claude Code, Codex, Cursor and other local agents. The SourceWeft CLI fetches the skill from its source repository at the commit scanned here, and verifies every file against the hashes recorded when the skill was scanned. If anything differs, nothing is written.
npx @sourceweft/cli skills install @timescale/setup-timescaledb-hypertablesAdd --agent claude-code, codex, cursor or universal to choose which agent gets it (Claude Code by default).
Upstream installer — not verified by SourceWeft
The open-source skills installer fetches the same pinned commit, but does not check the files against the hashes SourceWeft recorded.
npx skills add https://github.com/timescale/pg-aiguide/tree/187be00d317a51210c132010d947f4546ffb5eef/skills/setup-timescaledb-hypertablesSource and attribution
Source:timescale/pg-aiguideinskills/setup-timescaledb-hypertablesat commit187be00
License: Apache-2.0
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from timescale/pg-aiguide
Pgvector Semantic Search
timescale
Guides setup and tuning of pgvector vector similarity search in PostgreSQL for embeddings, RAG and semantic search.
Design Postgres Tables
timescale
Reference guidance for designing PostgreSQL tables, covering data types, constraints, indexes, JSONB and partitioning.
More in Data & Analytics
Audit Xls
anthropics
Audits spreadsheet formulas and financial models for errors, hardcodes, and integrity issues, then reports findings.
Comps Analysis
anthropics
Builds institutional-grade comparable company analyses as Excel spreadsheets with operating metrics, valuation multiples and statistics.
Audit Xls
anthropics
Audits spreadsheet formulas and financial models for errors, hardcodes, and integrity issues, then reports findings.
Audit Xls
anthropics
Audits spreadsheet formulas and financial models for errors, hardcodes, and integrity issues, then reports findings.
Comps Analysis
anthropics
Builds institutional-grade comparable company analyses as Excel spreadsheets with operating metrics, valuation multiples and statistics.
Audit Xls
anthropics
Audits spreadsheet formulas and financial models for errors, hardcodes, and integrity issues, then reports findings.