# SQLite Online - Open a .db / .sqlite File and Run SQL

> Free online SQLite browser: inspect tables, row counts and indexes, run real SQL in a genuine SQLite engine, export CSV / JSON or download the new .sqlite.

- URL: https://qilingtools.com/en/sqlite
- Category: Developer Tools (https://qilingtools.com/en/dev)
- Tags: [Converters](https://qilingtools.com/en/tags/convert), [Developer](https://qilingtools.com/en/tags/dev)
- Last updated: 2026-10-26
- Price: Free, no sign-up
- Privacy: Runs locally in the browser; files are never uploaded

You have a .db file and want to see what is inside. Installing DB Browser is heavy, and uploading it to a website is worse — it may hold chat logs, accounts or a production export. This page runs the official SQLite compiled to wasm: the whole database opens in memory, tables, views, indexes and row counts are right there, SQL is plain SQL, and you can download the modified database afterwards. The file on your disk is never written to.

## How to use

1. Choose a .db / .sqlite / .sqlite3 file, or click Load sample database
2. Click a table name on the left to insert a query, or write your own SQL
3. Press Ctrl/Cmd + Enter to run, then export the result as CSV or JSON
4. If you ran writes, use Download .sqlite to keep the modified copy

## Features

- Real SQLite 3.54: window functions, recursive CTEs, JSON functions, RETURNING and STRICT tables all work
- Tables, views, indexes and triggers are listed, and one click inserts a query
- Several statements at once, including INSERT / UPDATE / CREATE
- Export results as CSV / JSON, or the whole database as .sql (the same format as sqlite3 .dump)
- BLOBs show as a byte count in the table and export as hex instead of mojibake

## FAQ

### Is my database uploaded?

No. The SQLite engine is a 670 KB wasm file that runs in your browser; the database is read into memory with FileReader and no request carries the data anywhere. The page keeps working offline.

### If I change data, does the file on disk change?

No. A browser cannot write local files, so writes apply to the in-memory copy. The page says the database was modified, and Download .sqlite gives you a new file while the original stays as a backup.

### How large a database can it open?

The whole file is read into memory, so a few hundred MB is comfortable and beyond that the tab may run out (the page warns you first). For very large databases, export the tables you need into a smaller one with the sqlite3 command line.

### Which SQL is missing?

The default sql.js build has no FTS5 full-text index, no R-Tree and no math functions (sqrt, pow …), so those report no such module / no such function; FTS4 is included. An FTS5 virtual table is flagged as unsupported, and ordinary tables in the same database still work.

### My .db will not open

Check whether the file starts with "SQLite format 3". The .db extension is used by many databases — Access, Realm and LevelDB files have nothing to do with SQLite and cannot be opened here.

### How is this different from SQL on CSV?

That tool reads CSV / JSON text with an SQL engine written for this site, which suits exported files. This one reads real SQLite databases with real SQLite, so the syntax matches your production database.

## Related tools

- [JSON Formatter](https://qilingtools.com/en/json): Free online JSON formatter: beautify or minify, validate with the exact line and column of any error, browse a collapsible tree, sort keys and escape strings.
- [Base64 Encode/Decode](https://qilingtools.com/en/base64): Free online Base64 encoder and decoder: UTF-8 safe, optional URL-safe variant, convert text to Base64 and back in real time. Processed locally, never uploaded.
- [URL Encode/Decode](https://qilingtools.com/en/url-encode): Free online URL encoder and decoder with encodeURIComponent and encodeURI modes. Escapes Chinese, spaces and special characters. Real-time and local, no upload.
- [JWT Decoder](https://qilingtools.com/en/jwt): Free online JWT decoder: decode the header and payload of a JSON Web Token, show expiry and issued-at times, all locally without uploading the token.
- [Timestamp Converter](https://qilingtools.com/en/timestamp): Free online Unix timestamp converter: convert timestamps and dates, auto-detect seconds or milliseconds, and show local, UTC, ISO 8601 and relative time.
- [Hash / Checksum](https://qilingtools.com/en/hash): Free online hash calculator: SHA-1, SHA-256, SHA-384 and SHA-512 of text or any file through the browser crypto API. Files never leave your device.
- [UUID Generator](https://qilingtools.com/en/uuid): Free online UUID generator: create RFC 4122 UUID v4 in bulk with a cryptographic RNG. Options for uppercase, no hyphens and braces, with one-click copy.
- [Base Converter](https://qilingtools.com/en/base-convert): Free online number base converter: convert between binary, octal, decimal, hexadecimal and any base 2–36. Uses BigInt for huge integers, computed locally.