SQLite Viewer

No. Your database file never leaves your device. It is opened locally in your browser and queried right there on your computer. Your data, your queries, and your results are never sent anywhere or stored outside this page.

Standard SQLite 3 databases with any of the common extensions: .sqlite, .db, .sqlite3, .db3, .s3db, and .sl3. The file format is the same regardless of extension - SQLite 3's binary format. Files exported by Android, iOS, Firefox, Chrome, Electron apps, Python sqlite3, and any other SQLite-based application all work.

Yes, 200 MB. Larger files would slow down or crash the page on lower-end devices, so the 200 MB limit keeps performance reasonable across phones, tablets, and desktops. If you need to inspect a larger database, narrow it to a smaller subset on the source machine first and export that.

Any valid SQLite SQL works: SELECT with JOIN, WHERE, GROUP BY, ORDER BY, HAVING, LIMIT, OFFSET, subqueries, CTEs (WITH), aggregate functions (COUNT, SUM, AVG, MIN, MAX), window functions, and even INSERT, UPDATE, DELETE, CREATE, DROP, and ALTER. Modifying queries only change the working copy inside this page - your original file on disk is never touched.

Press Ctrl+Enter (or Cmd+Enter on Mac) inside the SQL Query textarea to run the current query without reaching for the Run Query button. The cursor can be anywhere inside the textarea.

Run SELECT name FROM sqlite_master WHERE type='table' to list every table, or SELECT sql FROM sqlite_master WHERE type='table' to see the full CREATE TABLE statements. For a single table's columns, run PRAGMA table_info('your_table_name').

Your uploaded database file and the selected table are saved automatically, so after a refresh the database is reloaded and the same table is selected. The text in the SQL Query box, however, is reset to the default SELECT * FROM "table_name" - if you typed a custom query (a JOIN, a WHERE clause, an aggregate), copy it somewhere first if you want to keep it. Click Clear All to wipe the stored database immediately.

The Output table preview is capped at 500 rows so a SELECT * against a large table does not freeze the page rendering tens of thousands of rows. The full result is still available - Copy Results copies every row as TSV to your clipboard, and Export CSV downloads every row as a .csv file.

It depends on whether the page has been refreshed. In a fresh session, Export CSV writes whatever queries you have run so far in this session, each prefixed with === table_name === as a section header. After a page refresh, the tool re-reads every table in the database in the background to restore your work, so Export CSV in that case will dump every table in the database. Click Clear All first if you want a clean slate.

Every query you would write against a normal SQLite database works the same way here - including SELECT, JOIN, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET, subqueries, CTEs (WITH), window functions, and aggregate functions like COUNT, SUM, AVG, MIN, MAX.

The Upload picker and drag-and-drop both accept .sqlite, .db, .sqlite3, .db3, .s3db, and .sl3. They are all the same SQLite 3 file format - the different extensions just reflect conventions used by Android, iOS, Firefox, Chrome, desktop apps, and various other tools.

Databases up to 200 MB are supported. Larger files would slow down or crash the page on lower-end devices, so the 200 MB cap keeps the experience snappy on phones, tablets, and desktops alike.

Every table in the loaded database is rendered as a clickable chip below the toolbar. Click a chip to load that table - the SQL Query box is auto-filled with SELECT * FROM "table_name" so you can edit it (add WHERE, change LIMIT) before running.

The SQL Query textarea accepts any SQL you type. Run Query and Ctrl+Enter both execute exactly what is in the textarea, not a hardcoded query - so you have full freedom to write whatever you need.

Press Ctrl+Enter (Cmd+Enter on Mac) anywhere inside the SQL Query box to run the current query without reaching for the mouse. Ideal for fast iteration.

INSERT, UPDATE, DELETE, CREATE, DROP, and ALTER all work - they only change the working copy inside this page. Your original file on disk is never touched. Use Export CSV after modifying if you want to save the new data.

The Output table preview is limited to the first 500 rows even when your query returns more, so a SELECT * against a million-row table does not freeze the page. Copy Results and Export CSV always operate on the full untruncated result.

When the preview is capped, an inline notice next to the Output heading shows the full row and column count of your query result so you always know what is really in the buffer.

Click Copy Results to copy every row of the current query as tab-separated values to your clipboard. Paste directly into Excel, Google Sheets, Numbers, or any spreadsheet - tabs become columns automatically.

Click Export CSV to download every table you have queried in this session as a single .csv file, with each table prefixed by a === table_name === section header. The filename is derived from your original database file name.

Drag a SQLite database file from your file explorer (Windows Explorer, macOS Finder, Linux file manager) directly onto the input area. The drop zone highlights while you hover so you know it is going to land in the right place.

Your uploaded database file and the selected table are saved automatically, so a page refresh reloads the same database and re-selects the same table. The SQL Query box is reset to the default SELECT * FROM "table_name" on restore - any custom query you typed is not kept, so copy it elsewhere first if you want to keep it. Only Clear All removes the stored database.

NULL values in query results are rendered as italic gray NULL text so you can distinguish them at a glance from empty strings, zero, or the literal text "NULL" stored in a column.