SQL playground
Join, filter and aggregate collections with a read-only processing engine.
Query limits and engine behavior
Only SELECT and WITH are allowed. Queries use a 30-second DuckDB timeout, a 1,000-row preview and an 8 MiB result limit. Automatic mode selects DuckDB for joins, filters, sorts or aggregates over collections with 250,000+ records; simple queries stay native. First use builds a disk-backed cache. DuckDB spills within the configured memory and temporary storage limits. Use _json for original normalized values. Exports require a complete result.
Table names and columns
Use the table identifiers below. For nested objects, use json_extract(account, '$.region'). Quote identifiers that contain spaces or dots.
demo-users.json
c_6bec78d9d490aac9cf30b996_record_id · _ordinal · _json · active · amount · category · country · email · id · name · note · profile · role · timestamp ·
demo-users.ndjson
c_f19dc18b7fb48565287b8d99_record_id · _ordinal · _json · active · amount · category · country · email · id · name · note · profile · role · timestamp ·
demo-orders.yaml
c_1d57012bdb0f791d29f9cf66_record_id · _ordinal · _json · active · amount · category · currency · email · id · name · note · product_id · profile · quantity · status · timestamp · user_id ·
demo-events.xml
c_02f97cf24103dd67b45b084c_record_id · _ordinal · _json · active · amount · category · duration_ms · email · event_type · id · name · note · profile · session_id · timestamp · user_id ·
demo-products.toml
c_b2351145548edb8423ad19d2_record_id · _ordinal · _json · records ·
demo-products.csv
c_73d9998f1d7a3ef70a529f22_record_id · _ordinal · _json · active · amount · category · country · currency · duration_ms · email · event_type · id · name · note · product_id · profile · quantity · role · session_id · sku · status · stock · timestamp · user_id ·
Saved queries
Save a query to reuse it or expose it through the API.
Recent queries
2026-10-11T20:15:37.81633707Z · 4 ms
SELECT * FROM "c_6bec78d9d490aac9cf30b996" LIMIT 100
2026-10-11T20:13:44.971669697Z · 3 ms
SELECT * FROM "c_6bec78d9d490aac9cf30b996" LIMIT 100
2026-10-11T20:09:48.965079876Z · 3 ms
SELECT * FROM "c_6bec78d9d490aac9cf30b996" LIMIT 100
2026-10-11T19:52:29.831714893Z · 1 ms
SELECT * FROM "c_f19dc18b7fb48565287b8d99" WHERE _ordinal = 1
2026-10-11T19:51:56.162019638Z · 3 ms
SELECT * FROM "c_f19dc18b7fb48565287b8d99"
2026-10-11T19:51:49.178061893Z · 0 ms · failed
SELECT * FROM "c_f19dc18b7fb48565287b8d99
unterminated SQL quote
2026-10-11T19:51:43.725450779Z · 0 ms · failed
SELECT * FROM "c_f19dc18b7fb48565287b8d99
unterminated SQL quote
2026-10-11T19:51:12.967546195Z · 41 ms
SELECT * FROM "c_f19dc18b7fb48565287b8d99" LIMIT 100