Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development. It is a single application that allows you to connect to MySQL and MariaDB databases simultaneously. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. This all-inclusive frontend provides an intuitive and powerful graphical interface for database management, development, and maintenance.
Main Screen
Intuitive and well-designed GUI simplifies your database administration and development.
Object Designer
Manage all the database objects with smart object designer.
Data Manipulation
Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.
Modeling
Visualize and edit your databases using a sophisticated database design and modeling tool.
Charts
Turn your database data into visuals to have clear insights in data through charts and graphs.
Data Synchronization
Compare and sync data between databases/schemas with a detailed analytical process.
Structure Synchronization
Deliver a full picture of database differences, and generate script to update the destination database.
Code Completion
Construct SQL statements in the SQL Editor by picking the suggestions from the drop-down list.
Code Snippet
Insert a snippet into the SQL Editor for faster and error-free SQL writing.
Automation
Create and schedule a batch job for your daily tasks, and get notification e-mails upon tasks completion.
Navicat Cloud
Store your files in cloud to start collaboration with your team members.
Features
Seamless Data Migration
Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across databases. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.
Diversified Manipulation Tool
Use Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables, views, or query results to formats like Excel, Access, CSV and more. Add, modify, and delete records with our spreadsheet-like Grid View together with an array of data editing tools to facilitate your edits. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.
Easy SQL Editing
Visual SQL Builder will help you create, edit and run SQL statements without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding.
Intelligent Database Designer
Create, modify and manage all database objects using our professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.
Data Visualization Tool
Our Charts feature lets you create visual representations of large data sets and help you to gain deeper insights from your data. Explore and unearth patterns, trends and relations between data, and create effective visual outputs to present your findings in dashboard for sharing.
Increase your Productivity
Our powerful local backup/restore solution guides you through the backup process and reduces the potential for errors. Set an automation for repeatable deployment process like database backup and script execution at a specific time or day. No matter where you are, you can always get the job done.
Make Collaboration Easy
Synchronize your connection settings, models, queries and virtual groups to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Learn more >
Advanced Secure Connection
Establish secure connections through SSH Tunneling and SSL ensure every connection is secure, stable, and reliable. Support different authentication methods of database servers such as PAM authentication. Navicat provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.
Cross-platform licensing is now available. Whether you’re operating on Windows, macOS, or Linux, you can purchase once and select a platform to activate and later on transfer your license.
Dark Mode
Set dark theme to protect your eyes from the traditionally blinding whiteness of computer. No behavior changes with how pages look when you are in dark mode.
Main Screen
Intuitive and well-designed GUI simplifies your database administration and development.
Object Designer
Manage all the database objects with smart object designer.
Data Manipulation
Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.
Modeling
Visualize and edit your databases using a sophisticated database design and modeling tool.
Charts
Turn your database data into visuals to have clear insights in data through charts and graphs.
Data Synchronization
Compare and sync data between databases/schemas with a detailed analytical process.
Structure Synchronization
Deliver a full picture of database differences, and generate script to update the destination database.
Code Completion
Construct SQL statements in the SQL Editor by picking the suggestions from the drop-down list.
Code Snippet
Insert a snippet into the SQL Editor for faster and error-free SQL writing.
Automation
Create and schedule a batch job for your daily tasks, and get notification e-mails upon tasks completion.
Navicat Cloud
Store your files in cloud to start collaboration with your team members.
Features
Seamless Data Migration
Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across databases. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.
Diversified Manipulation Tool
Use Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables, views, or query results to formats like Excel, Access, CSV and more. Add, modify, and delete records with our spreadsheet-like Grid View together with an array of data editing tools to facilitate your edits. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.
Easy SQL Editing
Visual SQL Builder will help you create, edit and run SQL statements without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding.
Intelligent Database Designer
Create, modify and manage all database objects using our professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.
Data Visualization Tool
Our Charts feature lets you create visual representations of large data sets and help you to gain deeper insights from your data. Explore and unearth patterns, trends and relations between data, and create effective visual outputs to present your findings in dashboard for sharing.
Increase your Productivity
Our powerful local backup/restore solution guides you through the backup process and reduces the potential for errors. Set an automation for repeatable deployment process like database backup and script execution at a specific time or day. No matter where you are, you can always get the job done.
Make Collaboration Easy
Synchronize your connection settings, models, queries and virtual groups to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Learn more >
Advanced Secure Connection
Establish secure connections through SSH Tunneling and SSL ensure every connection is secure, stable, and reliable. Support different authentication methods of database servers such as PAM authentication. Navicat provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.
Cross-platform licensing is now available. Whether you’re operating on Windows, macOS, or Linux, you can purchase once and select a platform to activate and later on transfer your license.
Dark Mode
Set dark theme to protect your eyes from the traditionally blinding whiteness of computer. No behavior changes with how pages look when you are in dark mode.
Main Screen
Intuitive and well-designed GUI simplifies your database administration and development.
Object Designer
Manage all the database objects with smart object designer.
Data Manipulation
Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.
Modeling
Visualize and edit your databases using a sophisticated database design and modeling tool.
Charts
Turn your database data into visuals to have clear insights in data through charts and graphs.
Data Synchronization
Compare and sync data between databases/schemas with a detailed analytical process.
Structure Synchronization
Deliver a full picture of database differences, and generate script to update the destination database.
Code Completion
Construct SQL statements in the SQL Editor by picking the suggestions from the drop-down list.
Code Snippet
Insert a snippet into the SQL Editor for faster and error-free SQL writing.
Automation
Create and schedule a batch job for your daily tasks, and get notification e-mails upon tasks completion.
Navicat Cloud
Store your files in cloud to start collaboration with your team members.
Features
Seamless Data Migration
Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across databases. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.
Diversified Manipulation Tool
Use Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables, views, or query results to formats like Excel, Access, CSV and more. Add, modify, and delete records with our spreadsheet-like Grid View together with an array of data editing tools to facilitate your edits. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.
Easy SQL Editing
Visual SQL Builder will help you create, edit and run SQL statements without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding.
Intelligent Database Designer
Create, modify and manage all database objects using our professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.
Data Visualization Tool
Our Charts feature lets you create visual representations of large data sets and help you to gain deeper insights from your data. Explore and unearth patterns, trends and relations between data, and create effective visual outputs to present your findings in dashboard for sharing.
Increase your Productivity
Our powerful local backup/restore solution guides you through the backup process and reduces the potential for errors. Set an automation for repeatable deployment process like database backup and script execution at a specific time or day. No matter where you are, you can always get the job done.
Make Collaboration Easy
Synchronize your connection settings, models, queries and virtual groups to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Learn more >
Advanced Secure Connection
Establish secure connections through SSH Tunneling and SSL ensure every connection is secure, stable, and reliable. Support different authentication methods of database servers such as PAM authentication. Navicat provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.
Cross-platform licensing is now available. Whether you’re operating on Windows, macOS, or Linux, you can purchase once and select a platform to activate and later on transfer your license.
Dark Mode
Set dark theme to protect your eyes from the traditionally blinding whiteness of computer. No behavior changes with how pages look when you are in dark mode.
System Requirements |
||
Windows Microsoft Windows 7, Windows 8, Windows 8.1, Windows 10, Windows 11, Server 2012, Server 2016, Server 2019, Server 2022 |
macOS Mac OS X 10.11 El Capitan, macOS 10.12 Sierra, macOS 10.13 High Sierra, macOS 10.14 Mojave, macOS 10.15 Catalina |
Linux Debian 9 or later, Ubuntu 16.04 or later, CentOS 7 or later, Fedora 26 or later, Linux Mint 18 or later |
Navicat Cloud
Navicat provides users with our Navicat Cloud service. Sync your connection settings and queries to the cloud so you can get real-time queries and connections anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Learn more ›
Secure Connection
Navicat allows you to establish secure SSH sessions through SSH Tunneling, ensuring strong authentication and secure encryption between two hosts. The authentication method can use a password or a public/private key pair. Navicat also comes with HTTP Tunneling, allowing you to bypass ISP restrictions on direct database server connections.
Object Designer
Create, modify, and design database objects using professional object designers, available for all database objects such as Tables, Views, Functions/Procedures, and Events. Without the need to write complex SQL to create and edit objects, you’ll know exactly what you are working on.
Table Viewer
Grid View
Add, modify, and delete records using Grid View. Navigate the Grid View with spreadsheet-like features, such as sorting and searching, or use our assistant editors like memos, images, and more.
Foreign Key Data Selection
Use foreign key relationships in your database to anchor referenced lookup tables and automatically create dropdown lists. Without the need to constantly reference a master table, you can optimize your workflow and productivity.
SQL Builder/Editor
SQL Builder
SQL Builder allows you to create and edit queries/views without having to worry about syntax and proper usage of commands. Just choose the operation you would like to perform on the tables, and it will write the SQL statements for you.
Code Completion
Quickly construct SQL statements in the SQL Editor with our code completion feature. Whether you want to select properties of database objects or SQL keywords, all it takes is a pick from the suggestion list.
Useful Tools
Tree/Object Filter
Use the Tree/Object Filter to narrow the list of displayed database objects. Simply type in the text and only objects that start with the specified string are shown.
Compatibility: Requires iOS 7.0 or later. Compatible with iPhone, iPad, and iPod touch.
This app is optimised for iPhone 5, iPhone 5C, iPhone 5S, iPhone 6, iPhone 6 Plus, iPhone 6S, iPhone 6S Plus, iPhone SE, iPhone 7, iPhone 7 Plus, iPhone 8, iPhone 8 Plus, iPhone X, iPhone XR, iPhone XS, and iPhone XS Max.
(Other products are coming soon.)
