Free SQL Playground

Runs entirely in your browser - no upload, no sign-up.

Example ready - run the query to start SQLite.

Schema and sample data

Rebuilds the local database when applied

CREATE TABLE departments (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  budget INTEGER NOT NULL
);

CREATE TABLE employees (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  department_id INTEGER NOT NULL,
  salary INTEGER NOT NULL,
  hired_on TEXT NOT NULL,
  FOREIGN KEY (department_id) REFERENCES departments(id)
);

INSERT INTO departments VALUES
  (1, 'Engineering', 600000),
  (2, 'Design', 240000),
  (3, 'Operations', 320000);

INSERT INTO employees VALUES
  (1, 'Amina', 1, 98000, '2022-04-18'),
  (2, 'Diego', 2, 84000, '2023-01-09'),
  (3, 'Mei', 1, 112000, '2021-08-30'),
  (4, 'Noah', 3, 76000, '2024-02-12'),
  (5, 'Priya', 2, 91000, '2022-11-03');

SQL query

Press Ctrl or Cmd + Enter to run

SELECT
  d.name AS department,
  COUNT(e.id) AS people,
  ROUND(AVG(e.salary)) AS average_salary
FROM departments AS d
LEFT JOIN employees AS e ON e.department_id = d.id
GROUP BY d.id, d.name
ORDER BY average_salary DESC;

Query results

Your result table will appear hereRun the sample query or replace it with your own SQLite statement.

Share this tool

What is an SQL playground?

An SQL playground is a browser-based editor where you can create tables, add sample data, and run SQL queries without installing a database. This playground uses SQLite compiled to WebAssembly, so SELECTs, JOINs, aggregates, CTEs, and data changes run locally on your device and return results immediately.

How to use

1Set up the database. Keep the sample schema and rows, or replace the left editor with your own CREATE TABLE and INSERT statements.
2Write and run SQL. Enter SQLite statements in the query editor, then choose Run query or press Ctrl or Cmd + Enter.
3Inspect or export. Review each result set in the table, then copy or download the active result as CSV.

Who it's for

Students and interview candidates practicing SELECT, JOIN, GROUP BY, subqueries, and common table expressions against ready-made data.
Developers and analysts checking SQLite syntax or reducing a query to a small reproducible example before changing a real database.
Teachers and technical writers creating compact SQL examples whose schema, seed rows, query, and output can be inspected together.

The left editor defines a fresh SQLite database with CREATE TABLE and INSERT statements. The right editor works against that database for the rest of your session, so you can test a query, change rows, and query again. Editing the schema rebuilds the database on the next run.

The engine and your work stay in this browser tab. There is no connection string, account, or server-side database, which makes the playground useful for private snippets and quick experiments.

FAQ

Is my SQL or data uploaded anywhere?

No. The SQLite WebAssembly engine loads into your browser and runs the schema, queries, and result formatting on your device. CanDoYa does not send the SQL you type or the rows it creates to a database server.

Is the SQL playground free?

Yes. You can run queries, reset the sample database, copy result tables, and download CSV files without an account or payment. The database lives in memory for the current browser tab.

What SQL dialect does this playground support?

It uses SQLite syntax. Standard SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, JOIN, GROUP BY, window functions, subqueries, and common table expressions work, but vendor-specific PostgreSQL, MySQL, Oracle, and SQL Server features may not.

Can I run more than one SQL statement?

Yes. Separate statements with semicolons. If several statements return tables, the result selector lets you inspect each result set. Statements that only change data report the affected row count and leave the database ready for another query.

How large can the in-browser database be?

The practical limit depends on your browser and device memory because sql.js keeps the full database in memory. The playground is designed for learning, examples, and small test datasets, not multi-gigabyte production databases.

Does the database persist after I close the tab?

No. The working database is temporary and resets when the page closes or reloads. Download any result you need as CSV, and keep important schema or query text in your own file before leaving.