Como usar: SQL Playground
- Wait a moment for SQLite to load — sample tables
customers,products,ordersandorder_itemsare created for you. - Write SQL in the editor or click an example, then press Run or Ctrl+Enter.
- Import your own CSV as a table, or open an existing
.sqlitefile. - Export the last result as CSV, or download the whole database.
A real database, not a simulator
The playground runs SQLite 3 compiled to WebAssembly (sql.js), so you get a genuine SQL engine: joins, subqueries, common table expressions, window functions, JSON functions, views, triggers, transactions and indexes. Everything happens in your browser’s memory; nothing is sent to a server, and closing the tab discards the data unless you download the database.
Sample schema
| Table | Columns |
|---|---|
customers | id, name, email, country, created_at |
products | id, name, category, price |
orders | id, customer_id, status, created_at |
order_items | order_id, product_id, quantity, unit_price |
SQLite vs MySQL and PostgreSQL
- Types are flexible: a column declared
INTEGERcan hold text. UseSTRICTtables to enforce types. - Dates are stored as text or numbers; use
date(),datetime()andstrftime(). RIGHTandFULL OUTER JOINare supported in recent versions;ILIKEis not —LIKEis case-insensitive for ASCII.
Check dialect-specific syntax with the SQL validator, tidy queries with the SQL formatter and turn spreadsheets into INSERT statements with CSV to SQL.
Também pesquisado como: run sql online, sql online, sqlite online, sql editor online, practice sql, sql sandbox, online sql compiler.
Ferramentas que combinam com: SQL Playground
- CREATE TABLE Generator — Design a table column by column — types, primary key, NOT NULL, UNIQUE, auto-increment and defaults — and get the correct CREATE TABLE syntax for your database.
- SQL to JSON, CSV & Excel — Paste a SQL dump or a few INSERT statements and get the rows back as JSON, CSV or an Excel workbook with one sheet per table.
- Excel to JSON — Open an .xlsx workbook or paste cells straight from Excel or Google Sheets and get clean JSON.
- JSON to Excel — Turn a JSON array into a real Excel workbook.
Perguntas frequentes
Which SQL dialect does the playground use?
SQLite 3. Most standard SQL works unchanged; vendor-specific features of MySQL, PostgreSQL or SQL Server (stored procedures,
ILIKE, SERIAL) do not.Is my data private?
Yes. The database lives in your browser’s memory. Imported CSV and .sqlite files are never uploaded.
How big can my data be?
It is limited by your device’s memory. Tens of megabytes and hundreds of thousands of rows work fine on a typical laptop.
Can I keep my database?
Click Download database to save a .sqlite file, and Open .sqlite file to continue later. It also opens in DB Browser for SQLite, DBeaver and the sqlite3 CLI.
Posso instalar o SQL Playground como um aplicativo da web e usá-lo offline?
Sim. O SQL Playground é um aplicativo da web instalável (PWA) — instalado a partir do seu navegador, não baixado de uma loja de aplicativos. Clique em “Instalar aplicativo” na parte superior desta página no Chrome ou no Edge (Windows, macOS, Linux, ChromeOS) ou, no Android, use “Compartilhar” → “Adicionar à tela inicial” no iPhone e no iPad, ou “Arquivo” → “Adicionar ao Dock” no Safari 17+ em um Mac. Em seguida, ela se abre em uma janela própria com seu próprio ícone e, como é executada inteiramente no seu navegador, continua funcionando offline. O Firefox no desktop não permite a instalação de aplicativos da web. Como funciona a instalação.