DuckDB Playground
Practise SQL and query CSV, JSON or Parquet files in your browser. Nothing is uploaded.
- 1Write a SQL query
- 2Press Run
- 3Want your own data? Import a file
About the DuckDB Playground
Practise DuckDB SQL and explore data files without installing anything. The playground runs DuckDB simulator inside your browser tab. It starts with a small shop database, and you can import CSV, JSON or Parquet files and query them with SQL.
It is meant for learning SQL, quick analysis and checking small to medium files. It is not a hosted database, so applications cannot connect to it, and the data is cleared when you reload the page.
Questions
Can I query a CSV or Parquet file?
Yes. Import the file and it becomes a table. You can also query it by name, for example SELECT * FROM read_csv_auto('file.csv').
Can I connect to it from Java, Python or another program?
No. The playground is not a hosted database: there is no server, port or connection string. Java, Python, Node.js, Go, JDBC or ORM code cannot connect to it. Queries run only from the editor on this page.
Is my data uploaded?
No. The database runs inside your browser tab. Your queries and imported files never leave your device.
How large can my files be?
Files up to a few hundred megabytes can work, depending on your device's memory. Small files load fastest.
Is my data saved?
No. Reloading the page resets the database. The text in the editor is kept.
More playgrounds
PostgreSQL Playground · SQLite Playground · Mongo Query Playground · PostgreSQL Query Performance Lab · JSON Query (SQL on JSON) · All playgrounds
