conceptual/logical/physical models. • Support various database systems: MySQL, MariaDB, Oracle, PostgreSQL, SQLite and SQL Server (including cloud databases like Amazon RDS, Amazon Redshift, Alibaba Cloud Release 2, 12c Release 1, 12c Release 2, 18c, 19c, 21c, 23c • PostgreSQL - 7.3, 7.4, 8.0, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, 9.2, 9.3, 9.4, 9.5, 9.6, 10.0, 11.0, 12.0, 13.0, 14.0, 15.0 • SQLite 3 • Redshift optional. Limit Specify the number of records to be displayed. Note: Available only for MySQL, PostgreSQL, SQLite and MariaDB. Add Expressions/Subqueries You can add an expression or a subquery to

conceptual/logical/physical models. • Support various database systems: MySQL, MariaDB, Oracle, PostgreSQL, SQLite and SQL Server (including cloud databases like Amazon RDS, Amazon Redshift, Alibaba Cloud Release 2, 12c Release 1, 12c Release 2, 18c, 19c, 21c, 23c • PostgreSQL - 7.3, 7.4, 8.0, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, 9.2, 9.3, 9.4, 9.5, 9.6, 10.0, 11.0, 12.0, 13.0, 14.0, 15.0 • SQLite 3 • Redshift optional. Limit Specify the number of records to be displayed. Note: Available only for MySQL, PostgreSQL, SQLite and MariaDB. Add Expressions/Subqueries You can add an expression or a subquery to

Procedures / Functions 58 Packages 59 Recycle Bin 60 Other Objects 61 Maintain Objects 61 PostgreSQL 64 Databases & Schemas 64 Tables 64 Views 65 Materialized Views 66 Procedures / in Non-Essentials Edition) 157 5 About Debugger 157 Oracle PL/SQL Debugger 157 PostgreSQL PL/pgSQL Debugger 158 Chapter 10 - Pub/Sub (Available only in Non-Essentials Edition) 161 Job (Step 2) 262 Chapter 15 - Backup & Restore 264 About Backup & Restore 264 MySQL / PostgreSQL / SQLite / MariaDB (Available only in Non-Essentials Edition) 264 About Built-in Backup & Restore

Procedures / Functions 57 Packages 58 Recycle Bin 59 Other Objects 60 Maintain Objects 60 PostgreSQL 62 Databases & Schemas 62 Tables 63 Views 64 Materialized Views 64 Procedures / in Non-Essentials Edition) 156 5 About Debugger 156 Oracle PL/SQL Debugger 156 PostgreSQL PL/pgSQL Debugger 157 Chapter 10 - Pub/Sub (Available only in Non-Essentials Edition) 160 Job (Step 2) 261 Chapter 15 - Backup & Restore 263 About Backup & Restore 263 MySQL / PostgreSQL / SQLite / MariaDB (Available only in Non-Essentials Edition) 263 About Built-in Backup & Restore

Procedures / Functions 57 Packages 58 Recycle Bin 59 Other Objects 60 Maintain Objects 60 PostgreSQL 62 Databases & Schemas 62 Tables 63 Views 64 Materialized Views 64 Procedures / in Non-Essentials Edition) 153 5 About Debugger 153 Oracle PL/SQL Debugger 153 PostgreSQL PL/pgSQL Debugger 154 Chapter 10 – Pub/Sub (Available only in Non-Essentials Edition) 156 Job (Step 2) 267 Chapter 15 - Backup & Restore 268 About Backup & Restore 268 MySQL / PostgreSQL / SQLite / MariaDB (Available only in Non-Essentials Edition) 268 About Built-in Backup & Restore

Supported On-Premises Databases • MySQL 3.23 or later, Drizzle, OurDelta, Percona Server • PostgreSQL 7.3 or later • Oracle 8i or later • SQLite 2 and 3 5 • SQL Server 2000 or later Amazon Redshift • Amazon Aurora for MySQL • Amazon Aurora for PostgreSQL • Amazon RDS for MySQL • Amazon RDS for PostgreSQL • Amazon RDS for Oracle • Amazon RDS for SQL Server • Amazon Amazon RDS for MariaDB Google Cloud • Google Cloud SQL for MySQL • Google Cloud SQL for PostgreSQL • Google Cloud SQL for SQL Server Oracle Cloud • Oracle Database Cloud Service • Oracle

Supported On-Premises Databases • MySQL 3.23 or later, Drizzle, OurDelta, Percona Server • PostgreSQL 7.3 or later • Oracle 8i or later • SQLite 2 and 3 5 • SQL Server 2000 or later Amazon Redshift • Amazon Aurora for MySQL • Amazon Aurora for PostgreSQL • Amazon RDS for MySQL • Amazon RDS for PostgreSQL • Amazon RDS for Oracle • Amazon RDS for SQL Server • Amazon Amazon RDS for MariaDB Google Cloud • Google Cloud SQL for MySQL • Google Cloud SQL for PostgreSQL • Google Cloud SQL for SQL Server Oracle Cloud • Oracle Database Cloud Service • Oracle

Supported On-Premises Databases • MySQL 3.23 or later, Drizzle, OurDelta, Percona Server • PostgreSQL 7.3 or later • Oracle 8i or later • SQLite 2 and 3 5 • SQL Server 2000 or later Amazon Redshift • Amazon Aurora for MySQL • Amazon Aurora for PostgreSQL • Amazon RDS for MySQL • Amazon RDS for PostgreSQL • Amazon RDS for Oracle • Amazon RDS for SQL Server • Amazon Amazon RDS for MariaDB Google Cloud • Google Cloud SQL for MySQL • Google Cloud SQL for PostgreSQL • Google Cloud SQL for SQL Server Oracle Cloud • Oracle Database Cloud Service • Oracle

Supported Repository Databases 13 • MySQL 5.1.73 or later • MariaDB 10.0 or later • PostgreSQL 9.5.1 or later • SQL Server 2012 or later • Amazon RDS Instance Offline Installation all user information and Navicat objects. It can be either a MySQL database, MariaDB database, PostgreSQL database, SQL Server database or Amazon RDS instance. We do not recommend setting the repository existing database or a new database created by Navicat On-Prem Server. Schema Name [SQL Server / PostgreSQL] The name of the schema. Domain [SQL Server] The domain name of the database server. 19