SQLite Browser

SQLite Client for Mac AI SQL Query Writing & File Explorer.

Open, browse, and edit local SQLite database files natively on macOS. Use natural language commands to build queries and run database changes offline.

Schema Explorer
logs
id PK
level text
message text
timestamp text
Natural Language Intent

Search for logs from yesterday containing keyword 'error' or 'failed'

POSTGRESQL EDITOR
-- Search for logs from yesterday containing keyword "error" or "failed"
SELECT id, level, message, datetime(timestamp, "localtime") AS local_time
FROM logs
WHERE timestamp >= date('now', '-1 day')
AND (message LIKE '%error%' OR message LIKE '%failed%')
ORDER BY timestamp DESC;
Verified SQL
Executed in 2ms • sqlite

Explore SQLite files at native Mac speeds

Double-click to open gigabyte-sized .sqlite files instantly, with zero Electron lag.

Instant SQLite Explorer

Double-click to open local `.sqlite`, `.db`, or `.sqlite3` files. Browse tables, columns, indexes, and edit cells with a fast spreadsheet view.

AI SQLite Assistant

Ask questions like "get all logs from last night containing errors" and get SQLite-compatible syntax (like SQLite's date modifiers) instantly.

Remote SQLite over SSH

Need to query a production SQLite file? Connect via TableAI's built-in SSH tunnel and query remote SQLite databases as if they were local.

100% Local Execution

Hook into local offline LLMs via Ollama to query sensitive SQLite data. Build a completely air-gapped database workflow where nothing leaves your Mac.

FAQ

Answers about TableAI\'s SQLite support.

DB Browser for SQLite is a classic, but its design is dated and lacks AI support. TableAI adds modern AI queries, SQL explanations, formatting, SSH tunneling, and a beautiful dark mode.

Yes! TableAI is built in native Swift and uses paginated loaders to open SQLite files containing gigabytes of database records instantly without crashing.

Yes, TableAI has unique support for querying remote SQLite files over SSH tunnels without needing manual SFTP transfers.

Privacy-First AI SQL Client

Let AI write the SQL. Try TableAI now.

Connect securely to PostgreSQL, MySQL, and SQLite. Generate complex queries and analyze performance, locally and privately.

Download on the Mac App Store
macOS 14.0+ Apple Silicon Native