You can also create parameter queries, interrogate stored procedures or events and generate INSERT statements.

The data editor features syntax highlighting, code completion and formatting, multi-cell editing, incremental searching, filtering and data display options.ĭatabase tables can be organized and relationships can be easily managed, while SQL queries are created using the visual SQL builder.

Its compatibility range includes MySQL Server 3.21 or above, Drizzle, OurDelta, Percona Server and MariaDB.Īside from basic database administration functions such as data entry, table editing and creation or user management, it comes with importing and exporting capabilities, an integrated report generator, batch job scheduling, SSH and HTTP tunnel support, data and structure backup and synchronization tools and much more. While it is mainly intended for professional users, the applications is intuitive enough to help users who are new to MySQL or MariaDB to get accustomed with it from the first interaction. It sports a comprehensive data editor, SQL processing capabilities and data modeling and manipulation tools, enabling you to connect to multiple local or remote MySQL databases simultaneously. Navicat for MySQL aims to provide you with a database administration platform comprising a rich feature set that can meet the requirements of most demanding users.