Guides implementation and optimization of time-series data using TimescaleDB.

Install

mkdir -p .claude/skills/timescaledb && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/8409" && unzip -o skill.zip -d .claude/skills/timescaledb && rm skill.zip

Installs to .claude/skills/timescaledb

Activation

This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.

TimescaleDB - PostgreSQL extension for high-performance time-series and event data analytics, hypertables, continuous aggregates, compression, and real-time analytics
166 charsno explicit “when” trigger
Intermediate

Key capabilities

  • Provides documentation for hyperfunctions
  • Accesses schema for continuous aggregates
  • Guides implementation of compression policies
  • Navigates API documentation for time-bucket functions
  • Details installation for specific environments

How it works

Reads structured reference documentation files indexed by functional category to provide context-aware technical guidance.

Inputs & outputs

You give it
Specific feature name or code pattern query
You get back
Code snippets, syntax examples, and technical reference markdown

When to use timescaledb

  • Optimize time-series queries
  • Implement continuous aggregates
  • Configure hypertables and compression

About this skill

Timescaledb Skill

Comprehensive assistance with timescaledb development, generated from official documentation.

When to Use This Skill

This skill should be triggered when:

  • Working with timescaledb
  • Asking about timescaledb features or APIs
  • Implementing timescaledb solutions
  • Debugging timescaledb code
  • Learning timescaledb best practices

Quick Reference

Common Patterns

Quick reference patterns will be added as you use the skill.

Example Code Patterns

Example 1 (bash):

rails new my_app -d=postgresql
    cd my_app

Example 2 (ruby):

gem 'timescaledb'

Example 3 (shell):

kubectl create namespace timescale

Example 4 (shell):

kubectl config set-context --current --namespace=timescale

Example 5 (sql):

DROP EXTENSION timescaledb;

Reference Files

This skill includes comprehensive documentation in references/:

  • api.md - Api documentation
  • compression.md - Compression documentation
  • continuous_aggregates.md - Continuous Aggregates documentation
  • getting_started.md - Getting Started documentation
  • hyperfunctions.md - Hyperfunctions documentation
  • hypertables.md - Hypertables documentation
  • installation.md - Installation documentation
  • other.md - Other documentation
  • performance.md - Performance documentation
  • time_buckets.md - Time Buckets documentation
  • tutorials.md - Tutorials documentation

Use view to read specific reference files when detailed information is needed.

Working with This Skill

For Beginners

Start with the getting_started or tutorials reference files for foundational concepts.

For Specific Features

Use the appropriate category reference file (api, guides, etc.) for detailed information.

For Code Examples

The quick reference section above contains common patterns extracted from the official docs.

Resources

references/

Organized documentation extracted from official sources. These files contain:

  • Detailed explanations
  • Code examples with language annotations
  • Links to original documentation
  • Table of contents for quick navigation

scripts/

Add helper scripts here for common automation tasks.

assets/

Add templates, boilerplate, or example projects here.

Notes

  • This skill was automatically generated from official documentation
  • Reference files preserve the structure and examples from source docs
  • Code examples include language detection for better syntax highlighting
  • Quick reference patterns are extracted from common usage examples in the docs

Updating

To refresh this skill with updated documentation:

  1. Re-run the scraper with the same configuration
  2. The skill will be rebuilt with the latest information

When not to use it

  • General-purpose PostgreSQL administration
  • Non-time-series data modeling

Prerequisites

PostgreSQL installationTimescaleDB extension

Limitations

  • Does not execute database queries directly
  • Requires user to manually apply suggested SQL patterns

How it compares

Provides a curated subset of documentation and patterns specific to time-series workflows rather than generic Postgres docs.

Compared to similar skills

timescaledb side by side with the closest alternatives in the catalog.

SkillInstallsUpdatedSafetyDifficulty
timescaledb (this skill)18moReviewIntermediate
sql-queries185moNo flagsIntermediate
fuzzy-matching86moNo flagsAdvanced
sql-pro34moNo flagsAdvanced

Try saying

Example prompts that trigger this skill in your AI assistant.

You might also like

sql-queries

anthropics

Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.). Use when writing queries, optimizing slow SQL, translating between dialects, or building complex analytical queries with CTEs, window functions, or aggregations.

1888

fuzzy-matching

dadbodgeoff

Multi-stage fuzzy matching pipeline for entity reconciliation. PostgreSQL trigram pre-filter, salient overlap check, and multi-factor similarity scoring.

825

sql-pro

sickn33

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems. Use PROACTIVELY for database optimization or complex analysis.

323

postgres-hybrid-text-search

timescale

Use this skill to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF). **Trigger when user asks to:** - Combine keyword and semantic search - Implement hybrid search or multi-modal retrieval - Use BM25/pg_textsearch with pgvector together - Implement RRF (Reciprocal Rank Fusion) for search - Build search that handles both exact terms and meaning **Keywords:** hybrid search, BM25, pg_textsearch, RRF, reciprocal rank fusion, keyword search, full-text search, reranking, cross-encoder Covers: pg_textsearch BM25 index setup, parallel query patterns, client-side RRF fusion (Python/TypeScript), weighting strategies, and optional ML reranking.

112

whodb

clidey

Database operations including querying, schema exploration, and data analysis. Activates for tasks involving PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, Redis, Elasticsearch, or ClickHouse databases.

18

data-engineering

mazelb

|

00

Search skills

Search the agent skills registry