Free tool

SQL Playground

SQLite in this tab — a commerce star schema, JSON events, an org tree, and your own tables. Paste a SELECT, CTE, QUALIFY, ILIKE, DATEADD, IFF, EXPLAIN, or CREATE/INSERT. Warehouse dialect is rewritten when we can. Highlight a statement and Run only that. Ctrl+Enter. CSV or a file below.

Loading SQL engine…

Schema — click to insert

· 200 rows
- INTEGER
- VARCHAR
- VARCHAR
- DOUBLE
- VARCHAR
- TIMESTAMP
· 12 rows
- VARCHAR
- VARCHAR
- VARCHAR
- DATE
· 400 rows
- INTEGER
- VARCHAR
- VARCHAR
- TIMESTAMP
- JSON TEXT
· 5 rows
- VARCHAR
- VARCHAR
- VARCHAR
- DOUBLE
· ~250 rows
- INTEGER
- VARCHAR
- INTEGER
- DOUBLE
· ~180 rows
- INTEGER
- INTEGER
- VARCHAR
- DOUBLE
- TIMESTAMP
· 8 rows
- INTEGER
- VARCHAR
- INTEGER
- VARCHAR
- DOUBLE

Example queries

Load your own CSV as a table

First row = headers. Paste or pick a file. Stays in this tab until you reset.

Recent queries (this browser)