bbdump: Modern PostgreSQL Manager

Poups — Wed, 01 Apr 2026 11:53:12 +0000

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.

DEV Community: Poups