Desktop app for Mac, Windows & Linux

SQLiteSQLite GUI Client

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

7-day free trial · No sign-up required
SQLite GUI Client - 1bench
1

Just Open a File

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

2

Visual Query Builder

Build SQL queries visually with column pickers, filters, sort, and limit controls. See the generated SQL and run it 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, and manage tables — all without writing SQL. Schema view shows column types, defaults, and constraints.

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.

Favorites

Pin your most-used tables, saved queries, and database connections for instant access from the sidebar.

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.

Frequently Asked Questions

Does SQLite have a GUI?
SQLite doesn't come with a built-in GUI — it's a C library and command-line tool. However, several third-party GUI clients exist. 1bench is a modern SQLite GUI for Mac, Windows, and Linux that lets you browse tables, run SQL queries, and edit data inline. Other options include DB Browser for SQLite (free, open source) and SQLiteStudio (free).
Is there a free SQLite GUI for Mac, Windows, and Linux?
Yes. 1bench offers a free 7-day trial and runs natively on Mac (Apple Silicon and Intel), Windows, and Linux. DB Browser for SQLite is completely free and open source. SQLiteStudio is another free cross-platform option. All three support opening local .db files and running SQL queries.
Can a SQLite GUI connect to a remote database?
SQLite databases are single files, so there's no server to connect to directly. However, 1bench supports SSH tunneling to download and sync remote .db files from servers, making it easy to browse and edit SQLite databases hosted on remote machines without manual file transfers.
How do I safely browse a production SQLite database?
1bench offers a read-only mode that prevents any writes to your database — ideal for inspecting production data without risk of accidental changes. Toggle it on from the sidebar, and all write operations (editing, inserting, deleting) are disabled until you turn it off.
Can I edit SQLite data without writing SQL?
Yes. 1bench supports inline editing — click any cell to modify its value, insert new rows through a visual form, and delete rows from the context menu. You can also use the visual query builder to filter and sort data without writing SQL. For advanced needs, the raw SQL editor is always available.

Not Just SQLite

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

PostgreSQLPostgreSQLRedisRedisElasticsearchElasticsearchClickHouseClickHouseCockroachDBCockroachDB
YugabyteDBYugabyteDB
TimescaleDBTimescaleDB
NeonNeon
SupabaseSupabaseAmazon RedshiftAmazon Redshift
GreenplumGreenplum
ValkeyValkeyDragonflyDragonflyOpenSearchOpenSearchMongoDBMongoDBMySQLMySQLMariaDBMariaDBDuckDBDuckDBSQL ServerSQL ServerCassandraCassandraNeo4jNeo4jQdrantQdrantTypesenseTypesenseMilvusMilvus

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..