Free Online SQLite 3 Playground
Current database engine: SQLite 3 (sqlite3)
This page runs SQLite 3.49 (3.49.1), the embedded database that stores everything in a single file and is built into browsers, phones and Python. SQLite uses flexible typing (a column has a type affinity rather than a strict type, unless the table is declared STRICT), supports CTEs and window functions, RIGHT and FULL OUTER JOIN (since 3.39) and has built-in JSON functions.
Use it to prototype a schema, test queries for a mobile or desktop app, or learn SQL without a server. For sample data, open SQLite 3 with preloaded tables.
NEW Now embed mode is available: put an interactive SQL editor on any web page with one script tag.
SQLize is a browser-based SQLite 3 SQL editor and query runner for fast testing, debugging, formatting, and sharing. It is useful for interview tasks, migration checks, analytics validation, and learning SQL in a real execution environment.
Developers, students and data analysts from more than 100 countries, most of all India, the United States, Russia, Brazil, Italy, Poland and Vietnam, use SQLize to run SQLite 3 queries online without installing a database server. A shareable link turns any query into a reproducible example for a colleague, a teacher or a question on Stack Overflow.