SQLite Viewer Online.
Open, query, explore.
Open .db, .sqlite and .sqlite3 files, inspect tables, and run SQLite queries directly in your browser. No installation, account, or file upload.
What are we exploring today?
SQLite databases · CSV files · SQL scripts
Open a local file .db .sqlite .sqlite3 .csv .sqlOne lab. A few useful tools.
From a raw file to the answer you came for.
SQL playground
Write, run, refine. Query your files with syntax highlighting and table-aware autocomplete.
Start queryingCSV to SQLite
Turn spreadsheets into tables. Import multiple CSVs, join your data, and export a database.
Work with CSVsERD generator
See how it all connects. Turn tables and foreign keys into a diagram you can explore.
Map your schemaVisual row editor
Insert, update and delete rows with explicit data types and SQLite constraint checks.
Edit your dataSQLite to Excel
Download tables and query results as Excel workbooks, preserving exact large integers.
Export a workbookSchema designer
Define tables, keys and relationships, then download SQL to review and run.
Design your schemaA database browser
that gets out of your way.
Inspect a database dump, check a CSV export, or experiment with a JOIN. SQLite Lab gives you a focused workspace without a database server.
How to open a .db fileBring a file, or borrow ours
Open a SQLite file, import a CSV, or load the included shop dataset.
Ask your data a question
Browse a table or run SQL. Explore your columns and relationships alongside the editor.
Keep what you find
Export query results, download your database, or reopen your locally saved workspace.
Your questions, answered.
A few details before you open that file.
Does my database leave my computer?
No. SQLite runs in your browser using WebAssembly. File contents, schemas, and SQL queries are not sent to a server. The workspace has no third-party analytics or advertising scripts.
Is this DB Browser for SQLite?
SQLite Lab is an independent browser-based tool. It is not the desktop application DB Browser for SQLite and is not affiliated with the SQLite project.
Can I open large SQLite databases and CSV files?
Imports are processed in chunks and result previews are bounded. Available memory and browser storage determine the practical limit. Large-file performance varies by device; there is no universal file-size guarantee.
Will my database still be here tomorrow?
Saved workspaces use private browser storage when available. Clearing site data removes them, and browsers can reclaim storage. Export a database to keep a backup. Temporary sessions disappear when closed.
Which browsers and files are supported?
Use a current Chrome, Edge, Firefox, or Safari browser. Open ordinary unencrypted SQLite databases, CSV files, or SQLite-compatible SQL scripts. Other formats with a .db extension and encrypted databases are not supported.
From a question to a working query.
Look up a function, practice on realistic datasets or understand how SQLite chooses an index.