Navicat Free MySQL GUI Lite 8.2.15

Navicat Free MySQL GUI Lite 8.2.15 is a powerful Database administration and development tool for MySQL. It 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. Code completion for SQL editors  
2. Support of virtual grouping: provide logical organization over objects
3. Sending notification e-mail for schedule task
4. Schedule to print report to files: PDF, Excel, HTML etc
5. Server Monitor to change system variables
6. Ability to duplicate user
7. Incremental search
8. Ability to set NULL and Empty String as default field value
9. Form view
10. Create table/view shortcut on desktop
11. Backup connection informations
12. Support of events
13. SQL console
14. Data synchronization
15. Structure synchronization
16. Restoring database with chosen database objects
17. Ability to create parameter queries
18. Support of foreign key data selection: locate the available values from the reference table
19. Truncate table
20. Support of triggers
21. Keep connection alive
22. Connection to MySQL Server through HTTP
23. Connection to MySQL Server through SSH public key authentication
24. Working with Windows Vista
25. Log files: keep track on the actions have been performed in Navicat
26. Importing data from ODBC: MSSQL, Oracle etc
27. Ability to set schedule on profiles
28. Schedule report printing
29. Schedule query execution
30. Print database/table Structure
31. Support of docking/tab windows
32. Text, Hex and BLOB viewer/editor
33. Formatting table grid
34. Support of stored procedures/functions
35. Support of views
36. Support of character set and unicode
37. Connection to MySQL Server through SSH
38. Support connection to all MySQL versions
39. Transfering data to SQL script as INSERT statement
40. Backing up database/table to SQL script
41. Executing SQL script
42. Multiple SQL editors with syntax highlighted feature
43. Support of raw mode edit: apply MySQL built-in function
44. Customize display formats
45. Set field to Empty String
46. Duplicate table
47. Empty table
48. Support of foreign keys
49. Support SSL secure connection
50. Analyzing, checking, optimizing and repairing tables
51. Server Monitor to view server status information and system variables
52. Visual user manager to administer users and privileges
53. Ability to run profile from command line
54. Report Builder/Viewer
55. Schedule backup file
56. Converting backup file into SQL script
57. Backing up/restoring database
58. Data transfer
59. Importing data from MS Excel and MS Access
60. Importing data from other file formats : TXT, CSV, XML, DBF etc
61. Exporting data to MS Excel and MS Access
62. Exporting data to most popular formats: TXT, CSV, HTML, XML, PDF, DBF etc
63. Visual SQL builder to facilitate the process of building complicated queries
64. Set field to NULL
65. Filtering and sorting records
66. Copying and pasting selected records
67. Ability to set number of records showing on each page
68. Grid view
69. Support of fields and indices
70. Support of tables
71. Customize selected databases to work with
72. Create / drop databases
73. Multiple local/remote MySQL server connections