Loadingโฆ
Loadingโฆ
Run SQL against a real SQLite database in your browser: a sample students and courses database, your own tables, or an uploaded .sqlite file.
Also covers: SQL query tester ยท Online SQLite ยท Practice SQL online ยท SQL editor
Tables
โฆ
A real SQLite database in your browser memory. Nothing is uploaded, and it resets when you leave the page unless you download it.
Students, courses, and enrollments are ready to query, or start empty, or open your own .sqlite or .db file.
Type SQL and press Run or Ctrl/โ + Enter. Several statements run in order, and each result set is shown as a table.
The tables panel lists every table and column. Download the database to keep your changes.
Yes: SQLite compiled to WebAssembly (sql.js), running entirely in your browser's memory. It supports joins, subqueries, window functions, CTEs, indexes, and transactions.
Core SQL (SELECT, JOIN, GROUP BY, INSERT, UPDATE) is the same. SQLite is more relaxed about column types and lacks some server features like users and stored procedures.
No. The database lives in memory and resets when you leave the page, unless you download it. Nothing is uploaded.
Data
Format, validate, and minify JSON in your browser. Paste it, upload a file, or load it from a URL. Errors show the exact line and column.
C# / .NET
Paste JSON and get C# model classes or records, ready for System.Text.Json or Newtonsoft.Json. Nested objects, arrays, nullable types, dates, and GUIDs are inferred for you.
TypeScript
Paste JSON and get TypeScript interfaces or type aliases, with nested objects named for you, optional and nullable fields detected from every array item, and union types.
SQL
Turn a JSON array into a CREATE TABLE with inferred column types and batched INSERT statements for PostgreSQL, MySQL, SQL Server, or SQLite.
SQL
Format and beautify SQL queries for SQL Server (T-SQL), PostgreSQL, MySQL, Oracle, and more. Set the indentation, keyword case, and layout, and get the exact line of any syntax error.
Data
Format, validate, and minify XML (config files, .csproj, SOAP, RSS) in your browser. Entities, CDATA, and mixed content are kept exactly as written, and errors show the line and column.