---
title: "SQL Playground - Run SQLite Queries Online | CanDoYa"
description: "Run SQL online in a private SQLite playground with sample data, instant result tables, CSV export, and no sign-up. Everything stays in your browser."
url: https://candoya.com/tools/sql-playground/
locale: en
type: browser-tool
---

# Free SQL Playground

Category: Developer

## 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.

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.

## How to use it

1. **Set up the database** - Keep the sample schema and rows, or replace the left editor with your own CREATE TABLE and INSERT statements.
2. **Write and run SQL** - Enter SQLite statements in the query editor, then choose Run query or press Ctrl or Cmd + Enter.
3. **Inspect 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.

## Expert note

The schema is reapplied only when you edit it or choose Apply schema. Until then, query statements share one in-memory database, so an UPDATE followed by a SELECT shows the change. Reapplying the schema deliberately returns you to the seed data, which makes experiments repeatable.

## Frequently asked questions

### 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.

## Related tools

- [SQLite Browser](https://candoya.com/tools/sqlite-browser/)
- [CSV Viewer](https://candoya.com/tools/csv-viewer/)
- [CSV Statistics](https://candoya.com/tools/csv-statistics/)
- [Pivot Table](https://candoya.com/tools/pivot-table/)

---

*Markdown edition of <https://candoya.com/tools/sql-playground/>, published for AI agents and other automated readers. Index of key pages: <https://candoya.com/llms.txt>.*