How to use
- Use the sample database or open your own file.
- Write a query and press Run (Ctrl+Enter).
- Export results or download the modified database.
Worked example
SELECT country, COUNT(*) FROM customers GROUP BY country ORDER BY 2 DESC; on the sample database lists customers per country.
Supported formats and limits
| Input | .sqlite / .db, CSV (imported as a table), SQL scripts |
|---|---|
| Output | Result grid, CSV, Modified .sqlite |
| Limits | Database files up to 1 GB are accepted; the whole database is kept in browser memory, so the practical size depends on your device. |
| Engine | sql.js (SQLite compiled to WebAssembly) in a Web Worker |
Limitations
- This is SQLite; some MySQL/PostgreSQL syntax differs.
- The first 1,000 rows of a result are shown; CSV export includes up to 200,000 rows.
Questions
Which SQL dialect is used?
SQLite, compiled to WebAssembly (sql.js) and run in a Web Worker. Most standard SELECT, JOIN, GROUP BY and window-function queries work; some MySQL or PostgreSQL syntax and functions differ.
How are CSV files imported?
Each CSV becomes a table. Column types are inferred as INTEGER, REAL or TEXT, empty cells become NULL, and values with leading zeros such as 00123 stay TEXT.
Are my changes saved?
Changes live in memory on this page. Download the modified database as a .sqlite file to keep them; your original file is not changed.
Privacy
Runs on your device. Files and text are processed in this browser tab and are not uploaded.
See the privacy policy for how toolsdocks handles data.