DataraDB

Fix

• SSH tunnels to servers with several host keys — DataraDB no longer reports a trusted server's key as "changed" when the server offers more than one key type (for example Ed25519 and ECDSA). It now asks for the key type already in your known_hosts, as OpenSSH does, so hosts that work in DataraSSH or the terminal connect in DataraDB too.

New

• Report an Issue opens as a window over the app instead of a new tab.
• Licence devices are now listed by name and platform on your datara.studio account, so you can tell your machines apart.

Fix

• Database Sync works on every SQL database — Sync now runs correctly on MySQL, MariaDB, PostgreSQL, SQL Server, Oracle and SQLite, not just MySQL.
• Sync applies only the changes you tick — unticked differences are no longer applied.
• Safer data sync — a WHERE filter combined with "delete extra rows" no longer deletes target rows outside the filter, and failed statements are reported instead of counted as successes.
• Real transactions for sync — "Use transaction" now rolls back every change if any statement fails.
• Exact values when syncing data — dates keep their fractional seconds, and binary data and text containing backslashes copy correctly. The update count is now accurate.
• Framework migrations rebuilt — the migration generators for Laravel, Symfony (Doctrine), CodeIgniter, Yii, Django, Flask (Alembic), Rails, Prisma, TypeORM, Sequelize, Knex and EF Core now produce files that run on the current framework releases, keeping unique indexes, composite keys, defaults and cascade rules.
• Accurate table details — PostgreSQL column lengths, MySQL and PostgreSQL foreign-key cascade rules, SQL Server defaults, SQLite foreign-key names and Oracle schema selection are now read correctly.

New

• Ignore columns and compare-only columns in Sync's advanced options.
• Sync only offers target databases of the same type as the source.

DataraDB 1.0 is the first stable release. Thank you to everyone who tested the betas.

New

• Free and Pro editions — DataraDB is free to download and use with one saved connection. Pro ($30, one-time) unlocks unlimited connections, Schema Sync and Migrations, covers every 1.x release, and can be used on up to 2 machines.
• Licence activation — Enter your licence key in Settings → Licence. Pro keeps working offline for up to 30 days between checks, and you can deactivate a machine to move your licence.
• SSH tunnels for every database — Connect to PostgreSQL, MySQL, SQL Server, MongoDB and Redis through an SSH server, using a password or a key.
• SSH host key verification — DataraDB asks you to confirm a server's fingerprint the first time you connect, and warns you if it changes.
• 22 languages — The entire interface is now translated, including German, French, Spanish, Portuguese, Japanese, Korean, Chinese and more.

Fix

• Clearer tunnel errors — When the SSH server can't reach your database, DataraDB now says so and suggests the right host to use.
• Theme accents — Accent colours now apply correctly, and dark mode follows the app's theme setting instead of macOS.
• Excel export — Excel files are now written natively, which is faster and more reliable.

Maintenance

• Signed and notarised for macOS — Universal build for Apple silicon and Intel, notarised by Apple so it opens without warnings.
• Updated components — Svelte 5, Tailwind CSS 4, and the latest database drivers.

UI polish — titlebar background unified with app background, editor/results panels use consistent dark surface colour, sidebar header and tab bar heights match exactly

CRITICAL FIX: When a beta build expires or a newer version is available, the app now shows a clear banner explaining what happened and providing a direct download link. Previously this banner existed but was never displayed, meaning users would lose features with no explanation. If you are seeing this message, please update now.