ModaDbSynker — DB Sync Tool

MySQL/PostgreSQL dev DB sync — schema+data, incremental.

A Windows·macOS sync tool that mirrors a production MySQL·MariaDB into a dev DB.

It only reads the production DB and only writes to the dev DB. Pick tables and a sync mode, run it, and you can roll back the dev DB until you commit.

Full schema+data sync, data-only fill, and integer-PK incremental sync. Windows installer and portable exe, macOS Intel/Apple Silicon dmg — auto-updates via GitHub Releases.

Version 1.0.6Windows · macOSFree

Download

Pick the file for your OS — arm64 dmg for Apple Silicon, x64 dmg for Intel Macs.

See all on GitHub Releases

Windows

Windows Installer

64-bit Setup · 81 MB · Standard install

modaDbSynker-1.0.6-win-x64-setup.exe

Download

Windows Portable

Portable exe · 80 MB

modaDbSynker-1.0.6-win-x64-portable.exe

Download

macOS

macOS Apple Silicon

M1 · M2 · M3 · M4 · 99 MB · Recent Macs

modaDbSynker-1.0.6-mac-arm64.dmg

Download

macOS Intel

Intel Mac · 106 MB

modaDbSynker-1.0.6-mac-x64.dmg

Download

First launch on macOS

modaDbSynker isn't on the Mac App Store and isn't Apple-notarized, so Gatekeeper may block it as an "unidentified developer" or "damaged" app on first launch.

Control-click → Open → Open

If it still won't open, in Terminal:

xattr -cr /Applications/modaDbSynker.app

First launch on Windows

The build isn't code-signed, so SmartScreen may show a warning.

More info → Run anyway

Key features

Connection

  • Service DB is read-only; writes go to dev DB only.
  • Connect via Host, Port, User, Password & Database — sync starts only after the test passes.
  • Same host·port·database pairs are not synced.

Projects

  • Save service/dev DB connections per project.
  • Create, rename & delete supported.
  • Passwords are encrypted in the OS keychain.

Tables

  • Load table list from the service DB.
  • Pick sync targets via search, select-all & clear.
  • Shows progress log & row progress.

Sync mode

  • Full schema+data sync — rebuilds dev tables with service structure & data.
  • Data-only full sync — keeps structure, fills with service data.
  • Auto incremental — only adds rows above the max integer PK.

Safety

  • Choose commit or rollback right after sync.
  • Auto-rolls back dev DB if no choice in 3 min.
  • Auto-updates via GitHub Releases.

Supported formats

EngineStatus
MySQL / MariaDBService DB → dev DB sync supported.
PostgreSQLComing soon.

Keyboard shortcuts

KeyAction
⌘/Ctrl+EnterStart sync
1 / 2 / 3Select sync mode
EnterTest connection (form)
EscClear search · rollback in confirm

How to use

MySQL/PostgreSQL dev DB sync — schema+data, incremental.

db sync

Related tools