- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
Navicat for SQLite is available on three platforms - Microsoft Windows, Mac OS X and Linux. It allows users to connect to any local or remote SQLite database, and provides some practical database tools such as data model tools, data synchronization, import, export, backup and reports to assist in data management.
Function introduction
Secure connection
Navicat supports HTTP tunneling, giving you the flexibility to bypass Internet service providers that restrict direct database server connections. The HTTP channel connects to the server using the same protocol and port as the web server.
object designer
Create, modify and design all database objects such as tables, views, triggers and indexes using the professional object designer. No need to write complex SQL to create and edit objects, you will know what options you are using.
table viewer
Grid or form viewing
Use the grid to view added, modified, and deleted records. Browse grid views with datasheet-like features, such as sorting and hiding data groups, using our Assistant Editor: Notes, Hex, Images or more.
You can also use the form to view operation records. Clearly display the record's field names and their values, so you don't have to worry about misinterpreting the data.
Foreign key data selection
Use foreign key relationships to anchor referenced lookup tables in your database and automatically build drop-down lists. Without the need to constantly refer to a master table, you can streamline your workflow and increase efficiency.
SQL creation tool or editor
SQL creation tool
Visual SQL creation tools let you create and edit queries or views without worrying about syntax and correct command usage. Select the operations you want to perform on the table and it will write the SQL statements for you.
autocomplete code
Use our code completion feature to quickly create SQL statements in the SQL Editor. Whether you want to select a property of a database object or a SQL keyword, you just select it from the drop-down list.
Database designer
reverse engineering
Using Navicat's reverse engineering, you can create a database model from an existing database, visually visualize and edit your database structure or create a graphical model and generate a database from the model.
Forward engineering and script generation
The Sync to Database feature gives you full visibility into all database differences. Generate the necessary synchronization scripts to update the target database and make it identical to the model.
Exporting SQL gives you the opportunity to fully control the final SQL script, generate referential integrity rules, generate independent parts of the model, annotations, character sets, and more. It saves your working time.
it works
it works
it works