Navicat for MySQL 8.1.15

Navicat for MySQL 8.1.15 is designed as a powerful MySQL Database Server administration and development tool. It works with any MySQL Database Server from version 3.21 or above, and supports most of the latest MySQL features including Trigger, Stored Procedure, Function, Event, View, and Manage User, etc.

Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to MySQL.

With Navicat well-designed Graphical User Interface (GUI), Navicat for MySQL lets you quickly and easily create, organize, access and share information in a secure and easy way, taking MySQL administration.

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 information
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

Enhancements:

• Enhanced support of new MySQL server versions
• Support of Table Partitioning
• Support of Show Profile and Status in Query
• Support of multi-result set in Query and Stored Procedure
• Ability to attach Export Wizard/Report result files in a Batch Job notification email
• Support of SQL Preview for all object design forms
• More table properties can be adjusted in Table design form
• Support of Preview and Explain in View Design Form

Requirements:

• Microsoft Windows 2000, XP, Vista or 2003
• Pentium II processor or above
• 64 megabytes (MB) of RAM
• Hard-disk space vary depending on installation. Full installation requires 10 MB of available hard-disk space