Run SQL queries against an in-browser SQLite database. Paste your schema, seed data, and query — instant results.
Updated
Loading SQL Runner…
Loading SQL Runner…
The ByteKiln SQL Runner uses sql.js — a WebAssembly build of SQLite — served from ByteKiln itself, with no third-party CDN. The engine is fetched once on first load; after that your schema and queries run in the page, not on a server.
sql.js creates a transient SQLite database in your browser's memory. You define the schema using standard DDL (CREATE TABLE, INSERT) in the left panel, then run SELECT or other queries in the right panel.
Each SELECT statement produces a result set displayed as a table with column headers, row data, and a row count. NULL values are displayed as NULL in a muted color. BLOB columns show <blob> as a placeholder.
After loading a schema, the table explorer in the status bar shows each table name and column count. Hovering a table badge displays the column names and types as a tooltip.
Short answers for the things developers usually ask before trusting a tool.
SQLite syntax. This covers most standard SQL including CREATE TABLE, SELECT, JOIN, GROUP BY, subqueries, CTEs (WITH), triggers, and views. MySQL or PostgreSQL-specific syntax may or may not work depending on the SQLite version bundled.
No. The SQLite database exists only in your browser's memory tab. Closing or refreshing the page destroys it. Your schema, data and queries are not sent to a server; the only network fetch is the SQLite engine itself, from ByteKiln, on first load.
Click "Reload DB" to re-execute the Schema panel, which drops the old in-memory database and creates a fresh one. This is useful after experimenting with INSERT, UPDATE, or DELETE statements.
Yes. The schema panel supports any number of CREATE TABLE, INSERT, and other DDL/DML statements. The query panel also supports multiple SELECT statements separated by semicolons — each produces its own result set.
The SQLite engine is a ~650 KB WebAssembly file, downloaded from ByteKiln itself the first time you open the tool. After that the browser caches it, so later loads are near-instant. If it cannot be downloaded (for example, offline or blocked by a content blocker), the tool shows an error and "Reload DB" retries.
Useful follow-ups when one conversion usually turns into three more.
Format raw SQL with dialect support for SQL Server, MySQL, PostgreSQL, SQLite, and more.
Generate CREATE TABLE scaffolding from JSON objects with nested structures and arrays.
Generate CREATE TABLE statements from C# classes for SQL Server, MySQL, and PostgreSQL.
Write and execute GraphQL queries against a schema with mock data — no server needed.
Want the background and worked examples? There's a longer write-up.
Read the SQL Runner guide