SQLite

A free viewer that opens a database file in your browser, guides to the parts of SQLite that surprise people, and honest comparisons with the free desktop clients.

Free tool

Runs SQLite itself in your browser. Nothing is installed and nothing is uploaded.

SQLite viewerFree

Open a .sqlite, .db or .sqlite3 file, browse tables, read the schema, run SELECT queries, and export to CSV. Read-only by design.

Guides

The two questions people hit most often when SQLite does not behave like the database they came from.

SHOW TABLES in SQLite

SHOW TABLES and DESCRIBE are MySQL and do not exist here. The real equivalents: .tables, .schema, sqlite_master, and PRAGMA table_info, including the ones that work from application code.

JSON in SQLite

There is no JSON column type. How storage actually works, the difference between -> and ->>, validating with json_valid, indexing with expression indexes, and what JSONB changed in 3.45.

The app

FluentDB is the paid, native macOS client. It edits, and it speaks more than SQLite.

SQLite browser and editor for Mac

A native Mac app for SQLite with an AI co-pilot, inline row editing, and support for ChaCha20 and SQLCipher encrypted files.

Comparisons

Both of these are free and genuinely good. The pages say so, and say when they are the better pick.

DB Browser for SQLite alternative

Free, open source, cross-platform, with a visual table designer. Where FluentDB differs, and where DB4S wins.

SQLiteStudio alternative

SQLiteStudio was renamed Letos in 2026. What changed, and an honest comparison.

Stop wrestling
with your database.

One database client, one payment, yours forever.

Download for Mac

If FluentDB has not replaced your current client within 14 days, we refund you. No questions asked.