Search tools

Search for a command to run...

SQL Playground (SQLite Online)

Practice and run SQL in your browser on a real SQLite database — sample shop data included, joins, CTEs and window functions, import CSV/Excel as tables, open .db files and export results.

How to use

  1. 1Pick an example query or write your own against the sample tables (customers, products, orders, order_items).
  2. 2Run with Ctrl+Enter; results show as tables you can download as CSV.
  3. 3Import a CSV or Excel file as a new table, or open your own .db/.sqlite file.

Frequently asked questions

Which SQL dialect is this?

SQLite 3 — standard SELECT/INSERT/UPDATE/DELETE, JOINs, CTEs (WITH), window functions, JSON functions and more.

Is my database uploaded?

No. SQLite runs in your browser via WebAssembly; files you open never leave your device.

Are changes saved?

The database lives in memory. Use Download database to keep a copy of your changes.