Free online SQL editors in 2026: 10 options compared

Most online SQL editors do one of two jobs: practicing queries on sample or hand-written tables, or running SQL on a file you already have. The table shows which is which.

DB Fiddle

DB Fiddle runs your queries on a server and lets you pick the engine version: MySQL 5.5 to 9, MariaDB, PostgreSQL 9.4 to 19 beta or SQLite 3.30 to 3.46. There is no file upload, so you build test data with CREATE TABLE and INSERT in the Schema SQL pane. It is free, and private fiddles need a PRO upgrade.

SQL Fiddle

SQL Fiddle is a free, ad-free playground for SQL Server, SQLite, PostgreSQL, MySQL, MariaDB, Oracle and Oracle PL/SQL, with queries run on its server. The editor works without an account, but its AI chat and query generator need a login.

OneCompiler

OneCompiler is a free online editor that runs code on its servers and covers 16 databases, including MySQL, PostgreSQL, SQL Server, Oracle, SQLite, DuckDB and ClickHouse. You pick a database, write a script with your own CREATE TABLE and INSERT statements, and run it.

W3Schools SQL Tryit

W3Schools SQL Tryit is built for learning, with fixed sample tables you can query straight away. It uses your browser's WebSQL where available and a server otherwise, and it has no way to load your own data.

sqlime

sqlime is a SQLite playground compiled to WebAssembly, so queries run in your browser with no server. It opens a SQLite database file from your computer or a URL, and can save queries and data as private GitHub gists you share by link. It is free and MIT-licensed.

SQLite Online

SQLite Online runs SQLite, DuckDB and PGlite (PostgreSQL compiled to WebAssembly) in your browser with no signup, and also offers MariaDB, PostgreSQL and SQL Server on its servers. You can import a CSV into a table, and it dropped its old 4 MB query limit in April 2024.

DuckDB Web Shell

The DuckDB Web Shell at shell.duckdb.org runs DuckDB-WASM as a terminal-style prompt in your browser. It queries files over HTTPS, and the .files add command opens a picker for local files. It is free and needs no account.

Datasette Lite

Datasette Lite runs Datasette and SQLite in your browser with WebAssembly. You load a CSV or Parquet file from a URL with ?csv= or ?parquet=, and the host must allow cross-origin requests (CORS). It is free and open source.

MotherDuck

MotherDuck is a cloud DuckDB service, so your tables stay in your account between sessions. In its web UI, the Add data button uploads a CSV, JSON or Parquet file. It has a free Lite plan, and Business starts at $250 per organization per month plus usage.

rows.page

rows.page runs DuckDB SQL in your browser on a CSV, TSV, JSON, JSONL or Parquet file you drop on the page, and nothing is uploaded unless you press Share. Text files open up to 1.5 GB per tab, Parquet is not held to that limit, and nested JSON fields become dot-path columns like "user.address.city". You type one statement that starts with SELECT, WITH or FROM against a table called data, so CREATE TABLE and joins across two files are out. It is free with no signup, and results show up to 1,000,000 rows.

SELECT
  "user.address.city" AS city,
  count(*) AS orders,
  median(price) AS median_price
FROM data
WHERE price > 20
GROUP BY ALL
HAVING count(*) >= 10
ORDER BY orders DESC

Where a query runs matters when your data is private. A server-based editor receives your SQL and any data inside it.

• In your browser: sqlime, SQLite Online (SQLite, DuckDB and PGlite), the DuckDB Web Shell, Datasette Lite, and rows.page until you press Share.
• On a server: DB Fiddle, SQL Fiddle, OneCompiler, the MariaDB, PostgreSQL and SQL Server engines in SQLite Online, and W3Schools SQL Tryit when WebSQL is not available.
• In the cloud with an account: MotherDuck, where uploaded files become stored tables.

• Testing a query on a specific MySQL, PostgreSQL or SQLite version: DB Fiddle.
• SQL Server or Oracle syntax: SQL Fiddle or OneCompiler.
• Learning SQL from scratch with ready-made tables: W3Schools SQL Tryit.
• A SQLite database file: sqlime.
• A CSV, JSON or Parquet file on your disk: rows.page, the DuckDB Web Shell, or SQLite Online for CSV.
• A file at a public URL: Datasette Lite, the DuckDB Web Shell or rows.page.
• Tables you want to keep and query again later: MotherDuck.