Ambry

A cross-platform, open-source database client built with Butter, React, and Mantine.

Supports PostgreSQL, MySQL/MariaDB, and SQLite via Bun's built-in drivers.

Install

macOS — Homebrew (recommended). Homebrew strips the quarantine attribute on install, so the app launches without a "damaged" prompt.

brew install --cask wess/packages/ambry

First time installing from this tap:

brew tap wess/packages
brew install --cask ambry

macOS — direct download. Grab Ambry.dmg from the latest release, mount it, and drag Ambry into Applications.

If macOS shows "Ambry is damaged and can't be opened", the release wasn't notarized for that build — remove the quarantine flag once and re-open:

xattr -dr com.apple.quarantine /Applications/Ambry.app

Notarized releases (CI builds with Apple Developer credentials configured) skip this step entirely.

Quick Start (development)

bun install
bun run dev

Features

• Connection management — SSL/TLS, SSH tunneling, URL parsing, groups, tags, safe mode, startup commands, health monitoring
• SQL editor — CodeMirror 6 with autocomplete, 17 snippets, Vim mode, formatting, multi-tab, multi-statement, find/replace
• Data grid — inline editing, column resize/visibility, filtering (18 operators), sorting, pagination, FK navigation, change tracking with SQL preview
• Cell inspector — detail sidebar for wide tables with per-field copy
• Schema tools — structure viewer, data profiling (null %, distribution), schema comparison with ALTER migration generation
• ER diagram — auto-generated SVG relationship diagram with draggable nodes and zoom
• Charts — bar, line, pie visualizations from query results (zero deps)
• Import/Export — CSV, JSON, SQL with native file dialogs, clipboard paste, drag-and-drop .sql
• Mock data — type-aware generation (names, emails, dates, UUIDs, etc.)
• Macros — record, replay, manage, export/import action sequences
• Command palette (Cmd+P) — quick jump to tables, queries, actions
• Settings — theme (light/dark/system), editor config, grid config, persisted to disk
• Plugin system — install/manage database drivers, export formats, and themes
• Full light and dark theme support across all components

Documentation

• Features & TODO — full feature list with completion status
• Specification — project spec and tech stack
• Architecture — codebase structure and data flow
• Configuration — butter.yaml, app settings, connection settings
• Keyboard Shortcuts — all shortcuts and SQL snippets

Tech Stack

Layer	Technology
Runtime	Butter 1.0 (Bun + native webview)
Frontend	React 19, Mantine 8, Tanstack Router, Tanstack Query
Editor	CodeMirror 6, sql-formatter, @replit/codemirror-vim
Icons	Lucide React
DB Drivers	Bun built-in (postgres, sqlite, mysql)

Stats

• 78 source files
• 3.80MB frontend bundle
• 58.78KB host bundle

License

MIT