Cómo 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.
También se busca como: run sql online, sql online, sqlite online, sql editor online, practice sql, sql sandbox, online sql compiler.
Herramientas que combinan con: 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.
Preguntas frecuentes
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.
¿Puedo instalar SQL Playground como aplicación web y utilizarla sin conexión?
Sí. SQL Playground es una aplicación web instalable (PWA): se instala desde el navegador, no se descarga desde una tienda de aplicaciones. Haz clic en «Instalar aplicación» en la parte superior de esta página en Chrome o Edge (Windows, macOS, Linux, ChromeOS) o, en Android, utiliza «Compartir» → «Añadir a la pantalla de inicio» en iPhone y iPad, o «Archivo» → «Añadir al Dock» en Safari 17+ en un Mac. A continuación, se abrirá en su propia ventana con su propio icono y, como se ejecuta íntegramente en tu navegador, seguirá funcionando sin conexión. Firefox en el ordenador de sobremesa no permite instalar aplicaciones web. Cómo funciona la instalación.