QuestDB is an open-source column-oriented time-series database designed for high-throughput ingestion and fast queries over timestamped data.
Use this playground to test designated timestamps, SAMPLE BY, LATEST ON, time ranges, and time-series aggregations without installing or configuring QuestDB.
This page sends your script to a hosted, network-isolated QuestDB 9.4.3 runtime. Every Run executes the whole editor contents against a fresh database, then discards its database state and files. It does not run the database in your browser and it never connects to your own database.
Available output: HTML result tables, psql-style text, and CSV. The schema panel shows a bounded catalogue captured after successful execution. Large output may be truncated, and package installation, remote network access, persistent storage, and external database connections are not supported.
Build a QuestDB script in the editor with syntax highlighting and editor assistance.
Run the complete script against a fresh isolated database sandbox.
Review rows, messages, errors, and execution time in the results panel.
Your draft stays in this browser, and Share creates a separate snapshot link.
CREATE TABLE readings (
ts TIMESTAMP,
sensor SYMBOL,
value DOUBLE
) TIMESTAMP(ts);
INSERT INTO readings VALUES
('2026-01-01T00:00:00.000000Z', 'a', 10.0),
('2026-01-01T00:01:00.000000Z', 'a', 12.0);
SELECT ts, sensor, avg(value) FROM readings SAMPLE BY 1m;The editor uses Monaco, the engine behind VS Code, with language-aware editing tools and familiar keyboard controls.
Write your query in the editor, then click Run (or press Ctrl/Cmd + Enter) to execute it.
Results appear instantly in the output panel below, along with any errors and how long the query took.
Nothing to install and no account to create — queries run in a hosted, isolated database sandbox.
Smart autocomplete and syntax highlighting for your query language
Real-time error underlines, bracket matching, and code folding
Multi-cursor editing plus find & replace (Ctrl/Cmd + F)
One-click formatting to tidy up long queries
Copy to clipboard and download your script
Built on Monaco — the same editor that powers VS Code
Run the whole editor script and see its native results
Output shows returned rows, messages, errors, and execution time
Start from a clean database every run, so experiments never clash
Switch between light and dark themes
Adjust font size and other editor settings
Toggle side-by-side or top/bottom layouts
Enter distraction-free fullscreen mode
Generate a shareable link to your exact query in one click — no login needed
Your work autosaves to your browser, so you can pick up where you left off
Copy your query to the clipboard or download it as a file
Run query: Ctrl/Cmd + Enter
Find & replace: Ctrl/Cmd + F
Open the full shortcut list from the keyboard icon in the toolbar