DbClone

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