Navicat Free MySQL GUI Lite 8.2.14

Navicat Free MySQL GUI Lite 8.2.14 is regarded as a convenient and professional database management tool which can convert XML, CSV, MS Excel, MS Access, and popular data formats to MySQL databases, eliminating time-consuming data entry and the errors that accompany it.

Other useful major features include import and export wizard, Unicode support, HTTP/SSH Tunnel, batch job scheduling, data synchronization, data transfer, visual query builder, and visual report builder. Navicat features importing data from ODBC and batch job scheduling.

Major Features:

1. MySQL Objects Management
   • Support MySQL servers 3.21 or above
   • Create / drop databases  
   • Support all MySQL objects: tables, views, stored procedures/functions and events  
   • Support all subobjects: fields, indices, foreign keys and triggers  
   • Support of character set and unicode  
2. Connection Management and Navigation
   • Multiple local/remote MySQL server connections  
   • Connection to MySQL Server through SSH  
   • Connection to MySQL Server through HTTP  
   • Support SSL secure connection  
   • Keep connection alive  
   • Backup connection informations  
   • Customize selected databases to work with  
3. Data Viewer and Editor
   • Grid view    
   • Text, Hex and BLOB viewer/editor  
   • Copying and pasting selected records  
   • Customize display formats  
   • Incremental search, sorting and formatting table grid  
   • Support of raw mode edit: apply MySQL built-in function    
   • Ability to set number of records showing on each page  
4. SQL Processing
   • Visual query/view builder to facilitate the process of building complicated queries  
   • Multiple SQL editors with syntax highlighted feature  
   • Ability to preview SQL before execution  
   • Support to return multi-resultsets  
   • SQL console
5. Server Security and Maintenance Services
   • Visual user manager to administer users and privileges    
   • Analyzing, checking, optimizing and repairing tables
     
6. Backup/Restore
   • Backing up database/table to SQL script  
     
   • Executing SQL script
7. Other Useful Features
   • Duplicate/empty/ truncate tables  
   • Create table/view shortcut on desktop  
   • Support of docking/tab windows  
   • Ability to run profile from command line  
   • Log files: keep track on the actions have been performed in Navicat  
   • Ability to copy Connection Information into Clipboard