How It Works Under the Hood
Choose an SQLite file or start with a sample. The left panel lists tables with row counts and columns. Click a table to query it, edit the SQL, and press Run or Ctrl+Enter. Results show in a table you can export as CSV. If you change data, download the edited database.
Step-by-Step Instructions
Open a database file.
Pick a table or write SQL.
Run, then export CSV or download the database.
Key Features & Performance
- Table and column browser
- SQL editor
- CSV export of results
- Download edited database
- Runs in your browser
Methodology, Formulas & Technical Standards
The real SQLite engine, compiled to WebAssembly (sql.js), opens the file in memory. Nothing is written back to your original file.
Worked Examples & Edge Cases
SELECT * FROM orders LIMIT 100
100 rows
Export CSV
Limitations, Scope & Accuracy Notes
- • Large databases are held in memory; very big files (hundreds of MB) may not open.
- • Changes live in memory only until you download the database.
- • Only the first 1,000 rows of a result are shown; use LIMIT or a filter for more.
- • Encrypted databases (SQLCipher) are not supported.
Local Browser Processing & Privacy
Traditional web converters upload your documents, snippets, or media files to remote servers. SQLite File Explorer & Query Runner runs inside your browser tab:
Your input text and files are processed locally without uploading payloads to a processing server.
Microdeck does not log or store the files or inputs you paste into tool workspaces (normal static hosting/CDN requests still load page assets).
Working outputs stay in your browser tab and are released when you reset the tool or close the tab.
Frequently Asked Questions
Will my original file change?
No. The file is copied into memory. Download the edited database to keep changes.
Is anything uploaded?
No. Your database file or diagram text stays in your browser. Only the open-source library itself is downloaded the first time you use the tool.
Explore Related Micro-Tools
SQL Formatter & Query Beautifier
Pretty-print or minify SQL queries across PostgreSQL, MySQL, SQLite, T-SQL & BigQuery dialects
JSON to SQL Schema Generator
Create a CREATE TABLE statement from JSON
Instant CSV to JSON & Table Converter
Fast reactive CSV to JSON parser with zero ads and zero reloads