SQLite Client

The SQLite GUI Client for Mac.

A fast, native SQLite GUI client for Mac. Open any .db, .sqlite, or .sqlite3 file. Browse tables, edit rows, run queries with autocomplete. Streams million-row tables without loading them all in memory. Free and open source.

Download for Mac Read the docs

TablePro connected to a SQLite database showing the data grid and SQL editor

Features

Built for SQLite.

Open Any SQLite File

Drag a .db file onto the app, or pick it from File > Open. Read-only or read-write, your call.

Inline Cell Editing

Edit any cell. Add and delete rows. Type-aware editor for INTEGER, REAL, TEXT, BLOB, and NULL.

Schema-Aware Autocomplete

Suggests tables, columns, aliases, and SQLite functions. Picks up the schema instantly.

Streaming Result Sets

Million-row tables open in 200 ms. Scroll without lag. Export streams to disk.

FTS5 Search

Run full-text searches across FTS5 virtual tables. View ranked snippets in the result grid.

AI SQL Assistant

Ask in English, get SQL. Explain queries. Optimize index usage.

Data Grid

Browse and edit data.

Sort, filter, and edit SQLite data in a spreadsheet-like grid. Click any cell to edit. Insert and delete rows. Review changes before saving.

TablePro data grid showing SQLite table rows with inline editing

SQL Editor

Write queries faster.

Tree-sitter syntax highlighting, schema-aware autocomplete, multi-tab, Vim mode, and full-text query history. AI assistant can write, explain, or optimize your SQL.

TablePro SQL editor with SQLite query and autocomplete

Capabilities

What you can do.

Open .db, .sqlite, .sqlite3, and FTS5 files
Browse tables, views, indexes, and triggers
Edit cells with type-aware widgets
Run queries in tabs, view EXPLAIN QUERY PLAN
Export to CSV, JSON, SQL dump, or XLSX
Import from CSV with type inference
Read encrypted SQLite files (with key)
Safe mode for read-only browsing

Connect

Get connected in seconds.

# Open in TablePro
File > Open > select your .db file

# Or drag and drop onto the app icon

# Common locations:
~/Library/Application Support/*/databases.sqlite
~/Documents/*.db

Supported versions

SQLite 3.x (any version)

Connection types

Local file (.sqlite, .db, .sqlite3)

How to

Connect to SQLite in four steps.

1
Install TablePro
brew install --cask tablepro, or grab the DMG from tablepro.app/download.
2
Open a SQLite file
File > Open, or drag the .db file onto the app icon.
3
Browse and edit
Tables show up in the sidebar. Click any to view rows. Edit cells inline.
4
Run queries
Cmd+T opens a query tab. Type, hit Cmd+Return to run.

FAQ

Common SQLite questions.

Does it support encrypted SQLite?

Yes. SEE and SQLCipher both. Provide the key when opening the file.

Can I work on huge databases?

Yes. The data grid streams rows. We test against 10 GB SQLite files routinely.

Is it actually free?

Yes. AGPLv3 open source. No paywall, no nag screen.

Does it work for FTS5 tables?

Yes. Run MATCH queries; results include ranking and snippets.

Can I open multiple databases at once?

Yes. Each DB opens in its own tab. Cmd+Tab between them.

Try TablePro for free.

Free and open-source. macOS 14+. Apple Silicon and Intel.

Download for Mac Setup guide