DBSyn 1.0

Overview

DBSyn is a native macOS application designed to provide a modern alternative to MySQL Workbench.

This release candidate brings together SQL development, database administration, schema design, connection management and Laravel development utilities in a unified interface.

New Features

Database Connections

• Manage multiple MySQL server connections.
• Switch between saved connections.
• SSH tunnel support for remote servers.
• Experimental native MySQL TLS connectivity.
• Secure password storage using macOS Keychain.
• Connection testing and saved connection preferences.

SQL Editor

• Execute SQL queries and scripts.
• Browse query results.
• SQL syntax highlighting and formatting.
• Query history and execution information.
• Export query results.
• Edit supported query-result rows.
• Review generated SQL before applying changes.

Schema Designer

• Visual database schema diagrams.
• Table and relationship inspection.
• Customisable diagram appearance.
• Schema search and filtering.
• Inline editing of supported column properties.
• Generate ALTER TABLE statements.
• Review and copy generated SQL.
• Reload schema metadata to verify modifications.

MySQL Administration

• Server status and monitoring.
• MySQL user and account management.
• Create and modify user accounts.
• Account locking and password changes.
• Account resource limits.
• Global and schema-level privilege management.
• Privilege selection using checkboxes.
• Server configuration inspection.
• Server error log inspection with copyable details.

Laravel Development

• Generate Laravel migrations from existing MySQL tables.
• Generate migration filenames using Laravel conventions.
• Configure migration output directories.
• Generate Laravel-compatible bcrypt password hashes.
• Insert generated password hashes into supported table rows.

Improvements

• Improved connection-switching architecture.
• Reduced main-thread blocking during disconnection.
• Added safeguards against stale asynchronous responses.
• Improved SSH tunnel startup detection.
• Added defensive MySQL packet-size validation.
• Improved schema modification verification.
• Added protection against unsupported column modifications.
• Improved preservation of column comments.
• Expanded automated regression tests.
• Consolidated application settings.