Navicat Free MySQL GUI 8.1.18 lite

Navicat (MySQL Manager) version 8.x is a MySQL 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
   • Form 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
   • Support of foreign key data selection: locate the available values from the reference table
   • Filtering Records
   • 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
   • Ability to create parameter queries
   • Multiple SQL editors with syntax highlighted feature
   • Code completion for SQL editors
   • Ability to preview SQL before execution
   • SQL console
5. Diversified Import and Export Competence
   • Importing data from ODBC: MSSQL, Oracle etc
   • Importing data from MS Excel
   • Importing data from MS Access
   • Importing data from other file formats : TXT, CSV, XML, DBF etc
   • Exporting data to MS Excel
   • Exporting data to MS Access
   • Exporting data to HTML and PDF
   • Exporting data to most popular formats: TXT, CSV, XML, DBF etc
6. Other Data Manipulation Tools
   • Data transfer
   • Transfering data to SQL script as INSERT statement
   • Data synchronization
   • Structure synchronization
7. Backup/Restore
   • Backing up/restoring database
   • Restoring database with chosen database objects
   • Converting backup file into SQL script
   • Backing up database/table to SQL script
   • Executing SQL script
8. Schedule for Batch Job
   • Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization
   • Schedule report printing
   • Schedule to print report to files: PDF, Excel, HTML etc
   • Sending notification e-mail for schedule task
9. Server Security and Maintenance Services
   • Visual user manager to administer users and privileges
   • Ability to duplicate user
   • Analyzing, checking, optimizing and repairing tables
   • Server Monitor to view and change system variables, to view server status information
10. Report Management Tools
    • Report Builder
    • Report Viewer
11. Other Useful Features
    • Duplicate/empty/ truncate tables
    • Create table/view shortcut on desktop
    • Print database/table Structure
    • Support of docking/tab windows
    • Support of virtual grouping: provide logical organization over connections and objects
    • Ability to run profile from command line
    • Log files: keep track on the actions have been performed in Navicat

Enhancements:

1. Added keyboard interactive authentication for SSH.
2. Adjusted the AutoFill from picklist behavior for Grid View.
3. Bug Fixes:
   • Fixed export excel spreadsheet with datetime was set to 0.
   • Fixed wrongly treat empty string as null.
   • Fixed access violation when select BLOB/TEXT issue.
   • Disable KeepAliveTimer before executing SQL.

WareSeeker Editor