questdb

Build QuestDB ingestion pipelines and Grafana dashboards for time-series data.

18|3|Updated Feb 10, 2026
One-click install
npx skills add https://github.com/questdb/questdb-agent-skill --skill questdb
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: questdb
Source: https://github.com/questdb/questdb-agent-skill/tree/main/questdb
Command: npx skills add https://github.com/questdb/questdb-agent-skill --skill questdb

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

QuestDB enables high-performance time-series data storage and SQL queries specialized for time-series, but developers often struggle to wire ingestion, time-series queries, and visualization in Grafana. This skill provides a structured blueprint to work with QuestDB, including ingestion via ILP, time-series SQL patterns (SAMPLE BY, LATEST ON, ASOF JOIN), and Grafana integration to build real-time dashboards.

Core Features & Use Cases

  • End-to-end QuestDB workflows: schema design for time-series data, high-throughput ingestion, and fast queries.
  • Grafana-ready dashboards: OHLC, VWAP, RSI, Bollinger overlays on candlesticks with proper axis configuration.
  • Reference materials and best practices: QuestDB-specific SQL patterns and pitfalls.

Quick Start

Build a minimal QuestDB pipeline that ingests sample trades and renders a live Grafana candlestick dashboard.

Frequently Asked Questions about questdb

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I ingest real-time trades and order book data into QuestDB?

Ingest real-time trades and order book data into QuestDB by configuring InfluxDB Line Protocol (ILP) connections. This skill provides structured blueprints for high-throughput ILP ingestion alongside time-series schema design.

How do I build a Grafana dashboard with QuestDB for candlestick charts?

Build a Grafana dashboard with QuestDB by configuring the QuestDB data source plugin and applying SQL queries. This skill covers rendering live OHLC, VWAP, RSI, and Bollinger overlays on candlesticks with proper axis configuration.

What is the best way to downsample time-series data using QuestDB SQL?

Downsample time-series data in QuestDB SQL using the SAMPLE BY clause. This skill enforces QuestDB-specific SQL semantics, including SAMPLE BY, LATEST ON, and ASOF JOIN, to handle time-series queries and pitfalls.

Does QuestDB work with Grafana for real-time time-series visualization?

Yes, QuestDB works with Grafana for real-time time-series visualization through dedicated data source plugins. This skill provides reference materials for integrating QuestDB queries to deploy live Grafana dashboards.

How do I join out-of-order time-series tables in QuestDB?

Join out-of-order time-series tables in QuestDB using the ASOF JOIN SQL clause. This skill applies QuestDB-specific SQL semantics to match records based on closest timestamps rather than exact matches.

What are the limitations of QuestDB time-series SQL patterns?

QuestDB time-series SQL limitations include specific pitfalls when applying SAMPLE BY, LATEST ON, and ASOF JOIN semantics. This skill provides best practices and reference materials to avoid common query design errors.