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.
An SQLite browser for the file in front of you
SQLite Lab is an online SQLite viewer and editor for ordinary, unencrypted database files. Open a .db, .sqlite or .sqlite3 file to inspect its tables, columns and indexes. You can browse rows, filter a table, and write a query when you need a more precise answer. The SQLite engine runs in a browser worker, so your file contents and SQL are processed on your device rather than uploaded to an application server. If you do not have a database yet, load the included sample or start with an empty workspace.
Move from browsing to a useful result
The SQL playground lets you run a selection or a complete script, inspect several result sets, and return to recent queries. The schema explorer shows what is in the database beside the editor. When tables declare foreign keys, the ER diagramhelps you follow their relationships. If your starting point is a spreadsheet export, useCSV to SQLite to preview columns, choose types, and query several imported tables together.
Keep a copy of what matters
Download a complete SQLite database when you need a portable backup, or export a table or query as CSV, JSON, Excel or PDF. The grid is a bounded preview; use the complete export controls for all matching rows within each format's limits. Saved browser workspaces can be cleared or evicted, so keep a downloaded backup of important data. SQLite Lab does not open encrypted SQLCipher files or connect to a remote MySQL or PostgreSQL server.
Privacy, files and storage
Practical details to know before opening a database.
Does my database leave my computer?
SQLite and file operations run locally in your browser. SQLite Lab does not upload your database or queries to an application server.
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.
Frequently asked questions
Clear answers to common questions about this topic.
Why do people use SQLite?
SQLite removes the need to run a separate database server. An application can open a database file, use SQL and transactions, and ship with a small embedded engine. That makes it useful for local software, mobile apps, prototypes, tests, caches and many websites with modest write concurrency.
What are the common uses of SQLite?
Common uses include application settings, offline-first mobile data, desktop application records, embedded devices, local analytics and test fixtures. SQLite is also a practical interchange format when one file needs to carry tables, indexes and data. It is less suited to a central database receiving many simultaneous writes from separate servers.
What are the main uses of SQLite?
SQLite is often the durable local store inside an app: it keeps structured data close to the code that reads it. Developers also use it for small services, browser or desktop tools, prototypes and portable datasets. Choose it when a single-file, serverless relational database fits your write and sharing needs.
Does SQLite have a GUI?
SQLite itself is a database library, not a graphical interface. You can use its command-line shell, or open a database with a GUI such as SQLite Lab or a desktop database browser. A GUI helps inspect tables and run queries; the database format and SQL engine remain SQLite.
Is there a GUI for SQLite?
Yes. Independent graphical tools can browse tables, edit SQL and visualize results for SQLite files. SQLite Lab runs in the browser and keeps opened files and queries on your device; desktop tools are another option if you prefer an installed application. Check a tool’s import, export and privacy behavior before using sensitive data.