Time Series Database Guide

Select and configure time series databases for metrics, IoT data, and event streams with proper retention and downsampling.

Usage

Describe your time series data requirements and this skill will recommend and configure the appropriate solution.

Examples

• "Choose between TimescaleDB and InfluxDB for IoT sensor data"
• "Set up data retention and downsampling policies for metrics"
• "Optimize time series queries for dashboard visualizations"

Guidelines

• Define retention policies based on data age and resolution needs
• Use continuous aggregations or downsampling for long-term data
• Partition data by time for efficient querying and cleanup
• Choose appropriate compression settings for your data patterns
• Plan storage capacity based on ingestion rate and retention