A desktop application for managing PostgreSQL databases —
backups, restores, scheduling, encryption, data browsing, and more.
Website · Download · Report a bug
Organize your databases into color-coded projects. Add local or external connections, duplicate databases across servers, and manage everything from a single view.
Manual and scheduled backups using pg_dump/pg_restore. Supports custom format, plain SQL, compression, and AES-256-GCM encryption.
Browse tables, inspect data, search across columns, and inspect row details.
Click any row to open the detail panel. Edit fields inline — modified values are highlighted, save or discard with one click.
Interactive graph of your database schema — tables, columns, and foreign key relationships rendered with Vue Flow.
Visual query builder with SELECT, FROM, WHERE, JOIN, and LIMIT clauses. Build queries visually or switch to raw SQL mode.
Built-in TCP proxy per project to route local connections to any configured database. Switch targets instantly without changing your app config.
Visual cron editor with presets and per-database controls. Automate backups, vacuum, reindex, and health checks.
Real-time application logs with level and database filtering. Track every backup, restore, and operation.
bbdump includes a built-in PostgreSQL MCP server that connects Claude to your databases. Install it in one click from Settings — Claude can then explore schemas, read data, run queries, and execute mutations with confirmation prompts. 31 tools exposed including schema inspection, full-text search, query explain, and more.
Quick access to your projects and databases from the menu bar. Trigger backups and monitor status without opening the full app.
curl -fsSL https://raw.githubusercontent.com/poup-s/bbdump/main/install.sh | bashDetects your platform, downloads the latest release, installs PostgreSQL if needed, and sets everything up. See full installation docs for options.
Download the latest release from GitHub Releases:
| Platform | File |
|---|---|
| macOS (Apple Silicon) | bbdump-*-arm64.dmg |
| macOS (Intel) | bbdump-*.dmg |
| Linux | bbdump-*.AppImage or bbdump-*.deb |
macOS note: The app is not code-signed. On first launch, right-click the app and select "Open", then confirm. Alternatively:
xattr -cr /Applications/bbdump.appgit clone https://github.com/poup-s/bbdump.git
cd bbdump
npm install
npm run devPrerequisites: Node.js 18+, PostgreSQL client tools (pg_dump in PATH).
Want to try bbdump right away? A demo script creates a PostgreSQL database with 36 000+ French towns and registers it in bbdump automatically:
./bbdump-demo/bbdump-demo.shSee bbdump-demo/README.md for details.
npm run build # Compile TypeScript + Vite
npm run dist # Build + package for current platform
npm run dist:mac # macOS (DMG)
npm run dist:linux # Linux (AppImage + deb)All user data is stored in ~/.bbdump/:
| File | Description |
|---|---|
config.json |
Database connections and app settings |
logs/app.log |
Application logs |
.encryption.key |
AES-256 key (auto-generated, mode 600) |
Databases can be configured through the UI or by pasting a PostgreSQL connection URL:
postgresql://user:password@host:port/database
- AES-256-GCM encryption for passwords and backup files
- Encryption key auto-generated on first launch with restricted permissions
- Electron context isolation enabled
- Export/import encryption keys for multi-machine setups
Contributions are welcome. Please open an issue first to discuss what you'd like to change.
MIT — Copyright (c) 2024-2026 Poups