Supports MySQL Servers 3.21 or above
Support of Drizzle, OurDelta, Percona Server and MariaDB
Create / Drop Databases
Support all MySQL objects: tables, views, procedures/functions and events
Support all subobjects: fields, indices, foreign keys and triggers
Support of partitioning
Support of character set and unicode
Supports Oracle Servers 8.1 or above
Create/drop schemas
Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions
Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers
Managing directories, tablespaces, public database links and public synonyms
Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin
Support of physical attributes
Support of character set and unicode
Supports PostgreSQL Servers 7.3 or above
Create /drop databases and schemas
Support all PostgreSQL objects: tables, views and functions
Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers
Managing tablespace
Managing cast and languages
Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types
Support of character set and unicode
Supports SQLite 2 and 3
Attach/detach databases
Support all SQLite objects: tables and views
Support all subobjects: triggers and indices
Support to view master table
Support of character set and unicode
Multiple local/remote server connections
Support of Oracle Basic Connection
Support of Oracle TNS Connection
Support to connect a new or an existing SQLite database
Support encrypted SQLite file (wxSQLite3)
Connection to MySQL/Oracle/PostgreSQL Server through SSH
Connection to MySQL/PostgreSQL/SQLite Server through HTTP
Support SSL secure connection for MySQL and PostgreSQL 8.4 above
Export/Import connections settings
Customize selected MySQL/PostgreSQL databases to work with
Support on showing interactive and real-time debugging information
Ability to set simple and complex breakpoints
Stepping through a function, i.e. Step Into, Step Over and Step Out
Inspecting variables and expressions
Stack traces
Grid view
Form view
Text, Hex and BLOB viewer/editor
Oracle BFile viewer/editor
Copying and pasting selected records
Customize display formats
Incremental search, sorting and formatting table grid
Ability to show/hide Oracle and SQLite tables ROWID
Support of raw mode edit: apply MySQL/PostgreSQL/SQLite 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
Visual query/view builder to facilitate the process of building complicated queries
Ability to create parameter queries
Code completion for SQL editors
Code outline for Oracle functions/procedures/packages/types
SQL Code Beautifier
Multiple SQL editors with syntax highlighted feature
Multiple SQL editors with syntax highlighted feature
Copy SQL with quote
Word Wrap
Zoom In/Out for SQL editors
Enhanced find and replace options in SQL editors
Ability to preview SQL before execution
SQL console
Importing data from ODBC: MSSQL, Oracle etc
Importing data from MS Excel
Importing data from plain text file formats: TXT, CSV, XML etc
Importing data from other file formats: DBF etc
Exporting data to MS Excel
Exporting data to plain text file formats: TXT, CSV, XML etc
Exporting data to most popular formats: DBF etc
Data transfer (Same or cross server type)
Transferring data to SQL script as INSERT statement
Transferring data to a SQL file with designated SQL format and encoding
Data synchronization
Structure synchronization
Backing up/restoring database
Backing up database with chosen database objects
Restoring database with chosen database objects
Converting backup file into SQL script
Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization
Ability to run profiles from different servers in a single schedule job
Sending notification e-mail for schedule task
Ability to attach Export Wizard/Report result files in Batch Job notification email
Visual user manager to administer users, groups (roles) and privileges
Ability to duplicate MySQL user
Maintance database/schema objects
Server Monitor to view system variables and server status information
Objects search filter
Backing up database/schema/table to SQL script
Executing SQL script
Duplicate/empty/truncate tables
Create table/view shortcut on desktop
Ability to create Favorites list
Ability to set auto-save for Query, Function, etc
Print database/schema/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
Ability to copy Connection Information into Clipboard
Exporting data to MS Access
Exporting data to HTML
Compressing/Decompressing Backup files
Schedule report printing
Schedule to print report to files: PDF, Excel, HTML etc
Notification email supports SSL/TLS
Report Builder
Report Viewer
Importing data from MS Access
Support to return multi-resultsets