Zap / Database explorer

Your data.
Within reach.

A desktop database client for PostgreSQL, MySQL, and SQLite. Browse schema and records, run SQL, and stage data edits in a tabbed workspace.

Capabilities

How it works.

Connect to a database server or open an existing SQLite file from the desktop app.

Open tables in independent tabs with Data, Structure, and Indexes views.

Paginate, filter, and sort records; select which columns appear.
Views and materialized views are grouped separately and open read-only. The backend also rejects edits to them.
Rename tables and add fields from Structure where supported by the driver and database permissions.

Write SQL with syntax highlighting and context-aware completion.

Completion suggests tables, columns, and keywords; column metadata is loaded for tables referenced by the query.
Save queries per connection and reopen them in their own tabs.
Query editors preserve local drafts while you move between workspace tabs.

Edit cells locally and review pending changes before saving them to the database.

Save or revert pending edits explicitly.
Moving between pages, filters, or sort orders stages the active cell before navigation.
Workspace-level discard prompts protect unsaved work when leaving the connection.

Inspect related records without replacing the table you are working in.

Open a referenced row from a foreign-key cell with its relation icon or Ctrl/Command-click.
Follow additional references in a side panel with a back stack.
Open the referenced row in its own filtered table tab.

Jump between schema objects and queries, or move table definitions and data using SQL files.

Go To searches tables, views, and saved queries in the current connection, including word-start abbreviations.
The recent-tab switcher previews cached table pages and query drafts without making database requests.
Import SQL from the sidebar menu. Export one table or a selection, with rows or structure only.

Technical reference

Application: Tauri desktop shell, React and TypeScript UI, Rust backend.
Database access: Native desktop runtime; the browser development preview does not perform real database operations.
Appearance: Light and dark themes, five accent colours, persisted sidebar width and window size.

Use Ctrl on Linux and Windows; ⌘ on macOS unless shown otherwise.

Schema edits depend on the selected database driver and your database permissions.
Views and materialized views are read-only in the workspace.
Published macOS builds are not Developer ID signed or notarized and may require approval in macOS security settings.

A different light