SQLite SQL Playground
Run SQLite 3.49.1 SQL or inspect a local database file in your browser. Query a sample or open a file without uploading it.
Run SQLite statements in a temporary database inside your browser. Choose an example, edit the SQL, and run it to see result tables. The sample includes employees and departments; you can change its schema and data freely, then restore the sample at any time. You can also open a local .sqlite, .sqlite3, or .db file up to 25 MiB. Examples cover SQLite printf() and format() formatting, JSON and JSONB values, when to use SQLite JSONB, window functions, and timediff().
This playground runs SQLite SQL only. It does not connect to a server or emulate MySQL, PostgreSQL, or SQL Server. The database exists in memory for this page and is cleared when you reload it. SQL text, schemas, and result rows stay in the browser and are not sent to SQLiz.
Loading the local SQLite playground. It requires JavaScript and a browser with WebAssembly support.
Run SQLite SQL
Use this temporary sample database, create your own tables, or open a local SQLite file. The selected file is read into browser memory; it is not uploaded. Close applications using the database first. A WAL sidecar file is not imported, so checkpoint and close WAL databases before selecting the main database file.
Multiple SQL statements are allowed. Result tables show up to 200 rows each. Errors are displayed here and do not change the database beyond statements that completed before the error.
Starting SQLite…
When Google Analytics is enabled, SQLiz records whether a run succeeded, how many result sets it returned, and whether a local file was opened or exported. It does not record SQL text, file names, file sizes, database contents, result values, or errors.
The browser engine is sql.js 1.14.2, which embeds SQLite 3.49.1. The active SQLite version is also shown when the playground starts. Functions added in later SQLite releases may be unavailable here; for example, jsonb_each() requires SQLite 3.51.0 or later. SQL.js is MIT-licensed, and SQLite is public domain. The engine runs locally in your browser and is loaded only on this page.