Navicat for SQLite - your database editor & manager
Mac OS Developer Tools
***** Navicat Premium named “Best Database Administration Solution” by Database Trends and Applications Magazine *****
** Best-in-Class Database Management Tools **
Navicat for SQLite Enterprise Edition is a powerful database administration and development tool for SQLite. It comes with advanced features such as the Data Modeling Tool, Import/Export, Visual Query Builder, Database Migration, and Batch Job Scheduling. Create, organize, access, and share information securely and easily with an intuitive GUI and take advantage of the flexibility of Navicat Cloud to sync your connection settings, models, queries and virtual groups to the cloud so you can get real-time access to them anytime.
Navicat’s sophisticated features provide professional developers with the tools they need, but are designed to be easy to learn for users new to database servers. Navicat for SQLite is compatible with SQLite versions 2 and 3, and supports most of the latest SQLite objects.
- Visual Database Designer
The Data Modeling Tools allows you to create graphical representations of a relational database. The Reverse Engineer lets you create and edit database models from existing databases or create a model and generate a database to support it.
Navicat Data Modeling also allows you to compare and synchronize between Models and Databases and generate SQL/DDL scripts.
- Query-Building Tools
The Visual Builder allows you to build complicated queries without knowledge of SQL syntax. Quickly construct SQL statements in SQL Editor with the code/word completion feature. All it takes is a pick from the drop-down list.
- Data Import and Export
Navicat for SQLite provides a wide variety of file formats for inserting and extracting data to/from your database. Create new tables or update existing ones with formats including XLS, XML, CSV, TXT, and DBF.
- Data Manipulation Tools
Advanced Data Transfer brings a new level of reliability in data transfers between databases. Navicat’s synchronization tools help you centralize data and keep databases up-to-date so that each repository contains the same information.
- Navicat Cloud
Sync your connection settings, models, queries and virtual groups to the cloud so you can get real-time access to them anytime, anywhere. With Navicat Cloud Collaboration, you can create, organize and share files/projects with your coworkers from anywhere, on any device.
You can take control of your project -- adding members you choose, defining the role of each member, and get visibility into your team activities from the Activity Log to align your team for greater productivity.
Other useful features:
- ER Diagram View
- Database Backup and Restoration
- User Privilege Manager
- Form View
- Text/Hex/Image Viewer and Editor
- SQL Beautifier
- Connection coloring
- Virtual grouping
- Database Wide Search
- Object Filter
* For more detailed information, please visit
** For technical questions related to the Mac App Store, please visit http://wiki.navicat.com
Fixed the crash issue when running batch job
Added some common keyboard shortcuts to query editor
Some minor bug fixes and improvements.