Time-Series Database Specialist

Download SKILL.mdGet Murage How skills work

Open source. macOS, Windows and Linux.

At a glance

What it is

Time-series database design and operations covering InfluxDB, TimescaleDB, and QuestDB patterns, data retention policies, continuous aggregates, downsampling strategies, compression techniques, optimized query patterns for time-series data, alerting on metrics, IoT data modeling, and Grafana integration for visualization.

A skill is a written procedure a bot loads when a job calls for it. This one is a single file, SKILL.md, and the whole file is on this page.

File: SKILL.md
Length: 542 lines2,035 words, about 10 min read
Category: Backend systemsdatabase
Level: Intermediate
License

More backend systems skills.

The full skill.

The whole file, exactly as it downloads. Read it before you rely on it.

SKILL.md

542 lines · 2,035 words

Download

Time-Series Database Specialist

Core Philosophy

Time-series data is unique: it arrives in chronological order, is rarely updated after creation, and queries almost always involve time ranges and aggregations. Successful time-series architecture requires understanding these access patterns and choosing storage engines, schemas, and retention policies that exploit them.

Database Selection Decision Tree

What is your primary use case?
  Metrics/Monitoring (Prometheus-style) -> InfluxDB or VictoriaMetrics
  SQL analytics on time-series -> TimescaleDB (PostgreSQL extension)
  High-throughput financial/IoT ingestion -> QuestDB
  Already using PostgreSQL -> TimescaleDB
  Need ecosystem/Flux language -> InfluxDB
  Maximum write throughput -> QuestDB
  Complex JOINs with relational data -> TimescaleDB

Put this skill to work.

Questions.

What is the Time-Series Database Specialist skill?

How much does it cost?

Nothing. It ships with Murage, which is open source. Your bots run on the AI plan you already have.

Can I change it?

Yes. Open it in Settings → Skills to read, edit or duplicate it. Skill Guard scans it again after every edit.

Give your first job to Murage.

Download the app, connect the AI you already pay for, and tell your Chief of Staff what needs doing. Plan on about ten minutes from install to a working team.

Download Murage

No account needed · Runs on the AI plan you already pay for

What is your primary use case? Metrics/Monitoring (Prometheus-style) -> InfluxDB or VictoriaMetrics SQL analytics on time-series -> TimescaleDB (PostgreSQL extension) High-throughput financial/IoT ingestion -> QuestDB Already using PostgreSQL -> TimescaleDB Need ecosystem/Flux language -> InfluxDB Maximum write throughput -> QuestDB Complex JOINs with relational data -> TimescaleDB

Time-Series Database Specialist

More backend systems skills.

The full skill.

Time-Series Database Specialist

Core Philosophy

Database Selection Decision Tree

Put this skill to work.

Questions.

Give your first job to Murage.

Search murage.ai

Time-Series Database Specialist

More backend systems skills.

The full skill.

Time-Series Database Specialist

Core Philosophy

Database Selection Decision Tree

Put this skill to work.

Questions.

Give your first job to Murage.

Create a bot and use this skill.

Ask Ember to create the bot

Open the bot’s skills

Find Time-Series Database Specialist and switch it on

Ask the bot for the job

About this skill.

TimescaleDB (PostgreSQL Extension)

Setup and Hypertables

Continuous Aggregates

Compression

Data Retention

TimescaleDB Query Patterns

InfluxDB

Data Model (Line Protocol)

InfluxDB Schema Design Rules

Flux Queries (InfluxDB 2.x)

InfluxDB Retention and Downsampling

QuestDB

High-Performance Ingestion

IoT Data Modeling

Schema Design for IoT

Device State Tracking

Alerting on Metrics

Threshold-Based Alerts

Grafana Integration

Data Source Configuration

Optimized Grafana Queries

Downsampling Strategy

Multi-Tier Retention

When to Use

Output Format

Example

Edge Cases