1bench, modern SQLite GUI client

SQLiteSQLite GUI client

Browse tables, run SQL, and edit data inline. Local .db files or remote via SSH. Connect to SQLite on localhost, self-hosted, or cloud (remote servers via SSH).

Apple Silicon. Also available for 7-day free trial · No credit card required
SQLite GUI Client - 1bench

Your data stays yours

1bench runs entirely on your machine. Nothing is ever sent to us.

100% Local

Credentials and data never leave your machine.

Zero Telemetry

No usage tracking, no query logging, no analytics.

Direct Connection

Straight to your database, nothing in between.

Built for SQLite

1

Just Open a File

No server, no setup. Open any .db, .sqlite, or .sqlite3 file from Finder or Explorer. Double-click a database file and 1bench opens it instantly.

2

Visual Query Builder

Build SQL visually with column pickers, filters, sort, limit. See the generated SQL and run with one click, or switch to the raw editor for full control.

3

Browse, Edit & Manage

Browse table data with pagination and sorting. Edit cells inline, insert rows visually, manage tables. Schema view shows types, defaults, constraints.

4

File Overview

Instant file health on connect: SQLite version, page size and count, file size, journal mode (WAL / DELETE), encoding, FK enforcement. PRAGMAs surfaced.

5

Create Tables

Visual wizard for tables with columns, primary keys, foreign keys, indexes, and check constraints. Live SQL preview shows exactly what will run.

6

SQLite over SSH with Sync

Open .db files on remote servers over SSH. Bidirectional sync detects remote changes automatically and warns on conflicts before overwriting local edits.

10x your SQLite productivity

Stop switching between CLI and code. Manage everything visually.

SQL Query Execution

Write and run SQL queries with full syntax highlighting and autocomplete. View results in a sortable table.

Inline Data Editing

Click any cell to edit its value directly in the table. Changes are saved back to the database instantly.

Row Insertion

Insert new rows through a visual form right from the table view. Fill in values per column and commit them.

Table Operations

Truncate or drop tables from the interface. Built-in confirmation dialogs prevent accidental data loss.

Read-Only Mode

Open databases in read-only mode to safely prevent any accidental writes to your production databases.

SSH Tunnel Support

Access remote .db files securely over SSH. Browse, query, and edit remote SQLite databases from your desk.

:memory: Database

Spin up in-memory SQLite databases instantly for quick prototyping, testing queries, or experimenting safely.

Sorting & Pagination

Sort by any column with a single click and paginate through large tables without loading everything at once.

Export & Import

Export full tables or filtered query results as CSV or JSON files. Import data back from external files.

Bidirectional Sync

Push local edits to remote or pull remote changes. Auto-detects conflicts and warns before overwriting.

Query History

Browse and re-run your full history of previously executed SQL queries. Find and repeat any past query fast.

Multiple Tabs

Open multiple databases and queries side by side in parallel using tabbed navigation across workspaces.

Keyboard Shortcuts

Navigate between tables, execute queries, and switch tabs entirely from the keyboard using quick shortcuts.

Dark & Light Mode

Choose between polished dark and light themes to keep your workspace comfortable during late-night sessions.

Open from Finder / Explorer

Double-click any .db file to open it directly in 1bench. Native file association on macOS, Windows, Linux.

Not just SQLite

One tool for all your databases. No more juggling apps.

PostgreSQLPostgreSQLRedisRedisElasticsearchElasticsearchClickHouseClickHouseCockroachDBCockroachDBSupabaseSupabaseTimescaleDBTimescaleDBQdrantQdrantTypesenseTypesenseMongoDBMongoDBMySQLMySQLMariaDBMariaDBDuckDBDuckDBMilvusMilvusYugabyteDBYugabyteDBNeonNeonValkeyValkeyDragonflyDragonflyOpenSearchOpenSearchMeilisearchMeilisearchWeaviateWeaviateChromaChromaTursoTursoEloqKVEloqKVTiDBTiDB

Don't see yours? Request it →

Frequently asked questions

Does SQLite have a GUI?
SQLite is a C library and command-line tool. It has no built-in graphical interface. For a visual experience you install a third-party SQLite viewer or GUI like 1bench, which opens .db files directly and replaces the sqlite3 CLI for browsing, querying, and editing.
How do I open a .db or .sqlite file on Mac, Windows, or Linux?
Install a native SQLite viewer like 1bench and double-click the file. It opens directly from Finder or Explorer without any CLI or server setup. 1bench handles .db, .sqlite, and .sqlite3 extensions on all three operating systems, plus drag-and-drop from anywhere on disk.
How do I safely browse a production SQLite database?
Use a SQLite viewer that supports read-only mode so writes are blocked at the connection level. You can inspect rows, run queries, and audit schema without any risk of accidental UPDATE or DELETE. 1bench has a read-only toggle on every connection, ideal for reading production files without touching them.
Can I open a remote SQLite database over SSH?
SQLite is file-based, so there's no wire protocol for remote access like you'd have with PostgreSQL or MySQL. 1bench works around this by pulling .db files over SSH into a local workspace, so you can view, edit, and sync changes back without manual SCP transfers.
What is the difference between the sqlite3 CLI and a SQLite viewer?
sqlite3 is a terminal tool that runs SQL against a .db file and prints text results. A SQLite viewer and editor like 1bench adds a visual table browser, inline row editing, a schema inspector, and a read-only mode for safely inspecting production files, so you work with SQLite the way you would with any relational GUI.

Ready to manage SQLite visually?

1bench connects to SQLite Cloud and self-hosted instances. Start your 7-day free trial today.

View Pricing

1bench is not affiliated with or endorsed by Hipp, Wyrick & Company, Inc.. SQLite is a trademark of Hipp, Wyrick & Company, Inc..