Learn or test SQL without installing a database. A real SQLite engine runs in your browser with ready-made customers and orders tables, so you can try SELECT, JOIN, GROUP BY, INSERT and more and see the results as tables. You can also open your own .sqlite or .db file, change it and download it again.
loading toolHow to use the SQL playground
- Tap one of the example queries, or type your own SQL.
- Press Run (or Ctrl + Enter) to see the results as tables.
- Open your own .sqlite file to explore it, and download the database when you are done.
Good to know
- Press Reset sample data to start again after deleting rows.
- Separate several statements with ; and all their results are shown.
Questions
Which SQL does it understand?
SQLite’s SQL, which covers almost everything taught in SQL courses: joins, GROUP BY, subqueries, CTEs (WITH), window functions, views and triggers.
Are my changes saved?
Changes stay while the page is open. Press Download database to keep them as a .sqlite file.
Is my database file uploaded?
No. It is opened inside your browser with sql.js (SQLite compiled to WebAssembly) and never leaves your device.
Is my data private?
Yes. Everything happens inside your own browser: nothing you type or choose is uploaded to us or anyone else.
Is it free?
Completely free, with no sign-up, no watermark and no limit on how many times you use it. Light ads keep the site running.
