timescaledb
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.zipInstalls 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 analyticsKey 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
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:
- Re-run the scraper with the same configuration
- The skill will be rebuilt with the latest information
When not to use it
- →General-purpose PostgreSQL administration
- →Non-time-series data modeling
Prerequisites
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.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| timescaledb (this skill) | 1 | 8mo | Review | Intermediate |
| sql-queries | 18 | 5mo | No flags | Intermediate |
| fuzzy-matching | 8 | 6mo | No flags | Advanced |
| sql-pro | 3 | 4mo | No flags | Advanced |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by 2025Emma
View all by 2025Emma →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.
fuzzy-matching
dadbodgeoff
Multi-stage fuzzy matching pipeline for entity reconciliation. PostgreSQL trigram pre-filter, salient overlap check, and multi-factor similarity scoring.
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.
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.
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.
data-engineering
mazelb
|