Desktop app for Mac, Windows & Linux

SQLite GUI Client

Name: 1bench SQLite GUI Client
Author: 1bench

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

Your Data Stays Yours

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

100% Local

Your credentials and data never leave your machine. No cloud sync, no account required.

Zero Telemetry

No usage tracking, no query logging, no analytics. What you do in 1bench stays in 1bench.

Direct Connection

1bench connects straight to your database. No proxy servers, no middleware in between.

Built for SQLite

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.

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.

Browse, Edit & Manage

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

File Overview

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

Create Tables

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

SQLite over SSH

Open .db files on remote servers without copying them down. Browse and edit just like a local file — changes push back through the tunnel.

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