timescaledb
npx machina-cli add skill aiskillstore/marketplace/timescaledb --openclawTimescaledb 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
Source
git clone https://github.com/aiskillstore/marketplace/blob/main/skills/2025emma/timescaledb/SKILL.mdView on GitHub Overview
This skill provides comprehensive assistance with TimescaleDB development, leveraging official documentation. It covers hypertables, continuous aggregates, compression, and real-time analytics to help you design scalable time-series schemas, optimize performance, and implement robust analytics pipelines.
How This Skill Works
The skill draws from official TimescaleDB docs and reference files (hypertables, compression, continuous aggregates, time buckets) to answer questions, provide code examples, and guide feature usage. It helps you locate relevant docs via view and offers practical patterns and troubleshooting steps.
When to Use It
- Working with timescaledb
- Asking about timescaledb features or APIs
- Implementing timescaledb solutions
- Debugging timescaledb code
- Learning timescaledb best practices
Quick Start
- Step 1: Install TimescaleDB and enable the extension in PostgreSQL.
- Step 2: Create a hypertable and insert time-series data.
- Step 3: Create a continuous aggregate or enable compression and run sample queries.
Best Practices
- Start with getting_started or tutorials for fundamentals.
- Read the relevant reference files (hypertables.md, continuous_aggregates.md, compression.md, api.md) for features.
- Use the quick reference patterns as templates for your queries.
- Validate performance and storage options using performance.md and time_buckets.md docs.
- Use the 'view' tool to read targeted reference files when needed.
Example Use Cases
- Designing a sensor data pipeline using hypertables for scalable writes.
- Creating continuous aggregates to power dashboards with up-to-date rollups.
- Enabling native compression to reduce storage for historical data.
- Building real-time analytics on event streams using time_bucket and hyperfunctions.
- Debugging extension installation or API usage with guidance from getting_started/docs.
