SQLite Client

Native SQLite browser for macOS

TablePro opens any .sqlite, .db, or .sqlite3 file on your Mac. No server process needed. Drag a file onto the app or use File > Open. You get instant access to all tables, views, and indexes. The SQL editor supports SQLite-specific syntax and the data grid lets you edit, insert, and delete rows without writing SQL. Works with Core Data databases, iOS app databases, and any SQLite file.

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 and drop .db, .sqlite, .sqlite3 files. Or use File > Open. Browse all tables and views instantly. No configuration needed.

Inline Data Editing

Click any cell to edit. Insert new rows. Delete rows. Review pending changes before saving. Supports BLOB preview and NULL handling.

SQL Editor

Tree-sitter highlighting for SQLite dialect. Autocomplete for your tables and columns. Full query history with search.

Table Structure

View and modify columns, indexes, and triggers. See CREATE TABLE statements. Add or drop columns.

Export & Import

Export tables or query results to CSV, JSON, SQL, or XLSX. Import data from CSV files with column mapping.

Multiple Files

Open multiple SQLite databases in separate tabs. Switch between them instantly. Compare data across files.

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 .sqlite, .db, .sqlite3 files by drag and drop
Browse tables, views, indexes, and triggers
Edit data inline with undo/redo
Run SQL queries with syntax highlighting
View table structure and CREATE statements
Export to CSV, JSON, SQL, XLSX
Import from CSV with error handling
Works with Core Data and iOS app databases

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)

Try TablePro for free.

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

Download for Mac Setup guide