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.
Download
Pick the file for your OS — arm64 dmg for Apple Silicon, x64 dmg for Intel Macs.
See all on GitHub ReleasesWindows
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.appFirst 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
| Engine | Status |
|---|---|
| MySQL / MariaDB | Service DB → dev DB sync supported. |
| PostgreSQL | Coming soon. |
Keyboard shortcuts
| Key | Action |
|---|---|
⌘/Ctrl+Enter | Start sync |
1 / 2 / 3 | Select sync mode |
Enter | Test connection (form) |
Esc | Clear search · rollback in confirm |
How to use
MySQL/PostgreSQL dev DB sync — schema+data, incremental.