bbdump
A desktop application for managing PostgreSQL databases —
backups, restores, scheduling, encryption, data browsing, and more.
Website · Download · Report a bug
Features
Project & Database Management
Organize your databases into color-coded projects. Add local or external connections, duplicate databases across servers, and manage everything from a single view.
Backup & Restore
Manual and scheduled backups using pg_dump/pg_restore. Supports custom format, plain SQL, compression, and AES-256-GCM encryption.
Database Viewer
Browse tables, inspect data, search across columns, and inspect row details.
Schema Visualizer
Interactive graph of your database schema — tables, columns, and foreign key relationships rendered with Vue Flow.
SQL Builder
Visual query builder with SELECT, FROM, WHERE, JOIN, and LIMIT clauses. Build queries visually or switch to raw SQL mode.
Proxy Server
Built-in TCP proxy per project to route local connections to any configured database. Switch targets instantly without changing your app config.
Scheduled Tasks
Visual cron editor with presets and per-database controls. Automate backups, vacuum, reindex, and health checks.
Logs
Real-time application logs with level and database filtering. Track every backup, restore, and operation.
MCP Server (Claude Desktop)
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.
System Tray
Quick access to your projects and databases from the menu bar. Trigger backups and monitor status without opening the full app.
Installation
Quick Install
curl -fsSL https://poups.dev/bbdump.sh | bash
Detects your platform, downloads the latest release, installs PostgreSQL if needed, and sets everything up. See full installation docs for options.
From Release
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.app
From Source
git clone https://github.com/poup-s/bbdump.git
cd bbdump
npm install
npm run dev
Prerequisites: Node.js 18+, PostgreSQL client tools (pg_dump in PATH).
Demo Database
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.sh
See bbdump-demo/README.md for details.
Building
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)
Configuration
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
Security
- 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
Contributing
Contributions are welcome. Please open an issue first to discuss what you'd like to change.
License
MIT — Copyright (c) 2024-2026 Poups
Top comments (1)
I like this tool, i use also with the MCP Claude Desktop.