Show HN: Database-replicator – Replicate any DB to PostgreSQL

3 points

6 months ago

Repo: https://github.com/serenorg/database-replicator

Open-source CLI (Rust, Apache 2.0) that replicates SQLite, MySQL, MongoDB, or PostgreSQL to any PostgreSQL target. Selective table filtering, continuous sync for PG→PG, checkpointing for interrupted transfers.

    cargo install database-replicator
    
    database-replicator init \
      --source "mysql://readonly@prod:3306/db" \
      --target "postgresql://admin@replica:5432/db" \
      --include-tables "orders,products"

Backstory: We're building SerenDB, a Neon-PostgreSQL fork with native micropayments for AI agent data access. Our early users kept saying, "We're not migrating our production database for LLMs." Fair point. So we built this replicator instead—keep your existing infra, create a filtered replica for AI queries, drop it when you're done.

- We have an opinion about the future that we are sharing with everyone

1. The future web is agentic as publishers get fed up with training LLMs and not receiving compensation

2. The agentic web will be agents directly querying databases instead of websites.

3. Your data in your database/datalake shouldn't migrate, but replicate, where agents will pay the most for it. "If you want my data, make me an offer I can't refuse!"

Works with any PostgreSQL target, not just ours. PRs welcome, especially for commercial database connectors (Oracle, SQL Server, etc.).