Is my database file uploaded?

No. The file is read by the browser and loaded into SQLite running in this tab.

Which SQLite version is this?

The version bundled with sql.js 1.x, shown under the editor after the engine loads.

Can I save my changes?

Yes. Download database writes the current state as a SQLite file.

How do I list the tables?

Run SELECT name FROM sqlite_master WHERE type = 'table'; or use the table list beside the editor.

SQLite online playground

Run SQL against an in-memory SQLite database, or open a .sqlite file, without installing anything.

Runs in your browser. Your input is not uploaded.

SQLLoading engine…

Tables

No tables yet.

What it does

This is the real SQLite engine compiled to WebAssembly (sql.js). It runs in this tab with an in-memory database, so you can try a query, test a migration or open an existing .sqlite file without installing anything.

Opening a file reads it into memory. Changes stay in the tab until you download the database.

How to use it

Run the example, or open a .sqlite or .db file.
Write SQL and press Run (Ctrl+Enter). Multiple statements are allowed.
Export a result as CSV, or download the whole database.

Things to watch for

Everything is in memory. Reloading the page loses unsaved changes.
Very large databases (hundreds of MB) may not fit in browser memory.
This is SQLite. Functions and types from PostgreSQL or MySQL may not exist.

Questions

Is my database file uploaded?: No. The file is read by the browser and loaded into SQLite running in this tab.
Which SQLite version is this?: The version bundled with sql.js 1.x, shown under the editor after the engine loads.
Can I save my changes?: Yes. Download database writes the current state as a SQLite file.
How do I list the tables?: Run SELECT name FROM sqlite_master WHERE type = 'table'; or use the table list beside the editor.