SQLite is a self-contained relational database with dynamic typing and broad SQL support. It is widely used for embedded, mobile, desktop, and local application data.
Use this playground to practise SQLite syntax, test schemas, joins, CTEs, window functions, constraints, and transactions without installing the SQLite CLI.
This page sends your script to a hosted, network-isolated SQLite 3.51.2 runtime. Every Run executes the whole editor contents against a fresh database, then discards its database state and files. It does not run the database in your browser and it never connects to your own database.
Available output: HTML result tables, text messages, CSV, and native JSON. The schema panel shows a bounded catalogue captured after successful execution. Large output may be truncated, and package installation, remote network access, persistent storage, and external database connections are not supported.
Build a SQLite script in the editor with syntax highlighting and editor assistance.
Run the complete script against a fresh isolated database sandbox.
Review rows, messages, errors, and execution time in the results panel.
Your draft stays in this browser, and Share creates a separate snapshot link.
CREATE TABLE users (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL
);
INSERT INTO users VALUES (1, 'Ada'), (2, 'Linus');
SELECT * FROM users ORDER BY id;The editor uses Monaco, the engine behind VS Code, with language-aware editing tools and familiar keyboard controls.
Write your query in the editor, then click Run (or press Ctrl/Cmd + Enter) to execute it.
Results appear instantly in the output panel below, along with any errors and how long the query took.
Nothing to install and no account to create — queries run in a hosted, isolated database sandbox.
Smart autocomplete and syntax highlighting for your query language
Real-time error underlines, bracket matching, and code folding
Multi-cursor editing plus find & replace (Ctrl/Cmd + F)
One-click formatting to tidy up long queries
Copy to clipboard and download your script
Built on Monaco — the same editor that powers VS Code
Run the whole editor script and see its native results
Output shows returned rows, messages, errors, and execution time
Start from a clean database every run, so experiments never clash
Switch between light and dark themes
Adjust font size and other editor settings
Toggle side-by-side or top/bottom layouts
Enter distraction-free fullscreen mode
Generate a shareable link to your exact query in one click — no login needed
Your work autosaves to your browser, so you can pick up where you left off
Copy your query to the clipboard or download it as a file
Run query: Ctrl/Cmd + Enter
Find & replace: Ctrl/Cmd + F
Open the full shortcut list from the keyboard icon in the toolbar