SQLite Playground Online

Run SQL queries against a local SQLite database, inspect its schema and export results or the database. Free sqlite playground online, with no installation or account.

Tool capabilities

Input: application/vnd.sqlite3 · text/sql
Output: application/vnd.sqlite3 · CSV

How to use SQLite Playground

Practice SQL online or inspect a SQLite file in a local database playground. A sample table is included so you can run SELECT, INSERT, UPDATE and DELETE statements immediately.

Run the sample SQL or open an unencrypted SQLite 3 database from your device.
Write a query, run it and inspect the result tables and database schema.
Download query results as CSV or save the current database as a SQLite file.

SQLite Playground · Example

Input

SELECT name, category FROM tools ORDER BY name;

Output

CSV Editor | Data
JSON Editor | Developer
Unix Timestamp Converter | Date & time

Run against the included sample tools table. User databases are processed locally.

Usage notes

The SQLite WebAssembly engine runs in a disposable worker. A cancelled or failed query does not replace the last completed database snapshot.

Databases are limited to 20 MiB. Results stop at 1,000 rows per statement; narrow your query with WHERE and LIMIT when working with large tables.

The workspace starts fresh when you leave. Download the database to keep changes. Explicit transaction controls, attached databases and VACUUM are not supported.

SQLite Playground