DbClone is a free, open-source desktop application that copies PostgreSQL databases including schema, data, and extension-aware DDL generation. Unlike pgAdmin or pg_dump, DbClone is purpose-built for migrating databases off managed platforms (Supabase, Aiven, Neon) where standard tools fail due to extension-owned objects, managed schemas, and search_path issues.
Key capabilities:
Four copy modes: Full (fresh clone), Resume (pick up interrupted copies), Update (sync changed tables), and Backup (timestamped copy to a new database)
Extension-aware: detects objects owned by extensions via pg_depend and skips them automatically
Platform detection: auto-identifies Supabase, Aiven, Neon, and vanilla PostgreSQL from the hostname and applies the correct settings
Dependency-ordered DDL with topological sort and cycle detection
Built-in database comparison: structural diff of tables, indexes, views, functions, sequences, triggers, enums, and domains — exportable as HTML, Markdown, JSON, or plain text
Real-time progress with per-table status, ETA, and error isolation (one table failing doesn't stop the rest)
Post-copy validation: row count, checksum, or full content verification plus object count checks
Connection manager with color-coding, import/export, and optional AES-256 encryption
Auto-update from GitHub Releases
No .NET runtime installation required — ships self-contained
DbClone runs on Windows 10/11 (x64) and works with any PostgreSQL version supported by Npgsq