SQLite Viewer Online – Open & View SQLite Databases
Drop the database. Explore every table instantly.
Open SQLite, DB and SQLite3 files directly in your browser, browse tables, inspect schemas, run SQL queries and export results as CSV.
Drop your SQLite database here
Browse tables, schemas and rows without installing database software or uploading your file.
SQLite · DB · SQLite3 · Browser onlyReading your SQLite file...
Loading tables and database metadata.
Choose a table from the left to inspect its rows.
SQL
Query console
Run read-only SQL queries against this database.
+
Open a SQLite database and inspect its tables without setting up database software
A SQLite database can contain many tables, thousands of records and a schema that is difficult to understand with an ordinary text or file viewer.
The SQLite viewer above opens supported SQLite, SQLite3, DB and DB3 files directly in the browser. Browse database tables, inspect column definitions, move through rows, run read-focused SQL queries and export a complete table as CSV.
This database viewer is part of Xplore File Manager, where browser-based utilities are designed to help you inspect the contents and structure of unfamiliar files before choosing a larger desktop workflow.
How to open and view a SQLite database online
Load the original database, choose a table, inspect its schema and records, then query or export the data you need.
Choose the SQLite database from your device
Click Choose database file or drop the database onto the workspace. The picker is configured for common extensions including .sqlite, .sqlite3, .db and .db3.
The current viewer limits database files to 250 MB because larger databases can require more browser memory than is practical.
Select a database table from the sidebar
After the database opens, the viewer reads the user-table list
from SQLite metadata and displays it in the sidebar. SQLite
internal tables beginning with sqlite_ are excluded
from that normal table list.
If the database contains many tables, use Find table to filter the sidebar by table name.
Inspect the table schema and browse its rows
Selecting a table reveals its total row count and column count. The Table Schema section shows detected column names and types and indicates properties such as Primary key and Not null where SQLite reports them.
Table data is loaded in pages of 100 rows, so you can move forward and backward instead of rendering the entire table at once.
Run a read-focused SQL query when table browsing is not enough
Open the Query console and enter SQL when you need a more specific view of the database.
The viewer blocks common write commands including INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, REPLACE, VACUUM, ATTACH, DETACH and REINDEX. Query results are displayed in a table, with up to the first 500 returned rows rendered in the result panel.
SELECT id, name, email
FROM users
WHERE active = 1
LIMIT 100;
Export the selected SQLite table as CSV
When the active table contains the data you need, click Export CSV. The viewer reads that complete table and creates a comma-separated CSV using the column names as the header row.
Text containing commas, quotation marks or line breaks is quoted
appropriately for CSV output. SQLite NULL values become empty
CSV fields, while binary BLOB values are represented as
[BLOB].
What is a SQLite database?
SQLite is a relational database system that can store tables, columns, rows, indexes and other database structures inside a self-contained database file.
Unlike a CSV file, which represents one flat table as text, one SQLite database can contain several related tables with different schemas and data types.
Inspect the columns before trying to understand the records
A schema explains what a table is built from. That context can be more useful than looking at raw values with no idea what each field represents.
Identify the field
See the actual name used by the selected table for each column.
Inspect declared type
Review the type string reported by SQLite for that column.
Find key columns
Primary-key information is highlighted when SQLite reports it.
Check null rules
Columns marked with a NOT NULL constraint are identified in the schema cards.
SELECT name, total
FROM orders
WHERE total > 100
LIMIT 50;
Use SQL when you need more than the first page of a table
Browsing a table is ideal for quick inspection. A query becomes more useful when you want selected columns, filtering, ordering, aggregation or another read operation supported by the database.
The console is intentionally viewer-oriented. Common commands that obviously modify database structure or data are blocked before execution.
NULL and binary BLOB values are shown differently from ordinary text
A database cell does not always contain readable text or a number. SQLite can contain NULL values and binary data as well.
In the table viewer, NULL is labelled clearly instead of being confused with an ordinary empty string. Binary Uint8Array values are represented with a BLOB label and their byte size in the table view.
SQLite and CSV both store data, but their structures are not interchangeable
| Feature | SQLite | CSV |
|---|---|---|
| Tables | Can contain multiple tables | Usually one flat dataset |
| Schema | Columns and database metadata | Header row and text fields |
| SQL queries | Supported by the database engine | Not native to the file |
| Binary values | Can store BLOB data | Primarily textual fields |
| Typical use | Application and structured database storage | Portable tabular data exchange |
The database is loaded into the browser workspace
SQLite parsing, table queries, schema inspection and CSV creation are performed from the database loaded in the browser. Browsing tables or running the viewer workflow does not overwrite the original database file stored on your device.
Questions about opening SQLite databases online
How can I open a SQLite database online?
Choose the database in the viewer above. Once SQLite can open the file, its user tables appear in the table browser.
Which SQLite file extensions can I select?
The file picker is configured for common SQLite database extensions including .sqlite, .sqlite3, .db and .db3.
Can I view SQLite tables and rows?
Yes. Choose a table from the sidebar and its rows are displayed in pages of up to 100 records.
Can I view a SQLite table schema?
Yes. The viewer uses SQLite table metadata to display column names, declared types and available Primary Key and Not Null information.
Can I search for a SQLite table?
Yes. The Find table field filters the table sidebar by name.
Can I run SQL queries online?
Yes. The query console executes SQL against the database loaded into the viewer. It is intended for inspection and blocks a list of common write operations.
Are UPDATE and DELETE queries allowed?
No. Common modifying statements including UPDATE, DELETE, INSERT, DROP, ALTER and CREATE are among the operations explicitly blocked by the current viewer.
How many SQL query result rows are displayed?
The current result renderer shows up to the first 500 rows from a returned result set in the query-result table.
Can I convert a SQLite table to CSV?
Yes. Select a table and use Export CSV to download that complete table as a CSV file.
What happens to SQLite BLOB values in CSV export?
Binary values are represented as [BLOB] in the exported CSV rather than attempting to embed the binary bytes directly into a text CSV.
What is the maximum database size?
The current browser viewer rejects database files larger than 250 MB because very large databases may exceed browser memory.
Open your SQLite file and inspect the data table by table
Browse records, inspect the schema, run read-focused SQL and export a table when you need the data elsewhere.