General Settings

To successfully establish a new connection to a local or remote server, you must configure the primary login parameters within the General tab. If your Internet Service Provider (ISP) restricts direct access to the server, Navicat provides alternative routing solutions such as Secure Tunneling Protocol (SSH) or HTTP tunneling depending on the database.

Below are the configuration options available for each supported database system.

MySQL / MariaDB

Support SSL, SSH, and HTTP Tunneling.

Option	Description
Connection Name	Enter a friendly name to best describe your connection.
Add To	After you logged in Navicat Cloud or On-Prem Server, you can choose to save the connection to My Connections or a project.
Host	A host name where the database is situated or the IP address of the server.
Endpoint	The Endpoint for connecting to the Amazon Web Services instance.
Port	A TCP/IP port for connecting to the database server.
User Name	User name for connecting to the database server.
Password	Password for connecting to the database server.

Oracle

Support SSH Tunneling.

Option	Description
Connection Name	Enter a friendly name to best describe your connection.
Add To	After you logged in Navicat Cloud or On-Prem Server, you can choose to save the connection to My Connections or a project.
Connection Type	Basic - In Basic mode, it connects to Oracle through the Oracle Call Interface (OCI). TNS - In TNS mode, it connects to Oracle server using an alias entry from a tnsnames.ora file through the Oracle Call Interface (OCI).
Host	A host name where the database is situated or the IP address of the server.
Endpoint	The Endpoint for connecting to the Amazon Web Services instance.
Port	A TCP/IP port for connecting to the database server.
Service Name	Enter the Service Name or SID. Select the corresponding radio button.
Net Service Name	Enter the Net Service Name.
User Name	User name for connecting to the database server.
Password	Password for connecting to the database server.

Note: OCI is an application programming interface that allows an application developer to use a third-generation language's native procedure or function calls to access the Oracle database server and control all phases of SQL statement execution. OCI is a library of standard database access and retrieval functions in the form of a dynamic-link library. See also: OCI options

PostgreSQL

Support SSL, SSH, and HTTP Tunneling.

Option	Description
Connection Name	Enter a friendly name to best describe your connection.
Add To	After you logged in Navicat Cloud or On-Prem Server, you can choose to save the connection to My Connections or a project.
Host	A host name where the database is situated or the IP address of the server.
Endpoint	The Endpoint for connecting to the Amazon Web Services instance.
Port	A TCP/IP port for connecting to the database server.
Initial Database	Set the initial database which user connects when making connection.
User Name	User name for connecting to the database server.
Password	Password for connecting to the database server.

SQL Server

Support SSH Tunneling.

Option	Description
Connection Name	Enter a friendly name to best describe your connection.
Add To	After you logged in Navicat Cloud or On-Prem Server, you can choose to save the connection to My Connections or a project.
Host	A host name where the database is situated or the IP address of the server.
Endpoint	The Endpoint for connecting to the Amazon Web Services instance.
Initial Database	Set the initial database which user connects when making connection.
Authentication	SQL Server Authentication - Use login records to validate the connection. Windows Authentication - When a user connects through a Windows user account, SQL Server validates the account name and password using the Windows principal token in the operating system. Microsoft Entra - Password - Use an identity and password in Microsoft Entra ID to connect the server. Microsoft Entra - Integrated - Use Windows identity federated with Microsoft Entra ID to connect the server. Microsoft Entra - MFA - Use a user account with multifactor authentication (MFA) enabled to connect the server. Microsoft Entra - Managed Identity - Authenticate to the database in SQL Database or SQL Managed Instance with Microsoft Entra managed identities. Microsoft Entra - Service Principal - Authenticate to the database in SQL Database or SQL Managed Instance with Microsoft Entra service principals (Microsoft Entra applications).
User Name	User name for connecting to the database server.
Password	Password for connecting to the database server.

SQLite

Support HTTP Tunneling.

Option	Description
Connection Name	Enter a friendly name to best describe your connection.
Add To	After you logged in Navicat Cloud or On-Prem Server, you can choose to save the connection to My Connections or a project.
Type	Existing Database File - Connect to an existing database in the Database File. New SQLite 3 - Create a new SQLite 3 database in the Database File. New SQLite 2 - Create a new SQLite 2 database in the Database File.
Database File	Specify the initial database file. If the HTTP Tunnel is enabled, you need to enter an absolute file path of the database file in your web server.
User Name	User name for connecting to the database.
Password	Password for connecting to the database.

MongoDB

Support SSL and SSH Tunneling.

Option	Description
Connection Name	Enter a friendly name to best describe your connection.
Add To	After you logged in Navicat Cloud or On-Prem Server, you can choose to save the connection to My Connections or a project.
Type	The type of your MongoDB server: Standalone, Shard Cluster or Replica Set.
SRV Record	Check this option to connect the server using an SRV Record.
Host	A host name where the database is situated or the IP address of the server.
Endpoint	The Endpoint for connecting to the Amazon Web Services instance.
Port	A TCP/IP port for connecting to the database server.
Member	Add or remove the members of replica set or the instances of sharded cluster to the connection.
Read Preference	Choose the replica set read preference for this connection.
Replica Set	The name of the replica set.
Authentication	None - No authentication. Password - Specify the Authentication Database name associated with the User Name and Password. LDAP - Specify the User Name and Password. Kerberos - Set the Kerberos Service Name and the user Principal. X.509 - x.509 certificate authentication.

Use MongoDB URI

You can also use a MongoDB URI to connect your MongoDB server. Simply click the URI button and paste the URI. Navicat will automatically fill out the options in the General, SSL and SSH tabs.

Redis

Support SSL and SSH Tunneling.

Option	Description
Connection Name	Enter a friendly name to best describe your connection.
Add To	After you logged in Navicat Cloud or On-Prem Server, you can choose to save the connection to My Connections or a project.
Type	The type of your Redis server: Standalone, Cluster or Sentinel.
Role	The role of your Redis instance: Master or Replica.
Host	A host name where the database is situated or the IP address of the server.
Port	A TCP/IP port for connecting to the database server.
Authentication	None - No authentication. Password - Enter the Password if the Redis server is password protected via the requirepass option. Username & Password - Enter the User Name and Password if Redis ACLs are used.
Sentinel Host	The IP address of the Sentinel instance.
Sentinel Port	A TCP/IP port for connecting to the Sentinel instance.
Sentinel Authentication	None - No authentication. Password - Enter the Sentinel Password for the Sentinel instance. Username & Password - Enter the Sentinel User Name and Sentinel Password for the Sentinel instance.
Group Name	The group of Redis instances composed of a master and one or more slaves.
Group Authentication	None - No authentication. Password - Enter the Group Password for the group. Username & Password - Enter the Group User Name and Group Password for the group.

Sentinels Settings

If you are connecting to a Redis Sentinel architecture, you can provide additional configuration options within the Sentinel tab to ensure high availability.

To enhance redundancy and failover capabilities, you can enable the Use extra sentinels option. This allows you to easily specify additional Sentinel nodes to associate with your connection.

Sentinel SSL

If your Redis Sentinels are configured to use SSL/TLS for secure, encrypted communication, you can manage these strict security options within the Sentinel SSL tab.

First, enable the Use SSL option to instruct Navicat to communicate over a secure channel.

To provide authentication details, enable Use authentication and fill in the required information:

Option	Description
Client Key	The SSL key file in PEM format to use for establishing a secure connection.
Client Key Password	The password of the key file.
Allow any server SSL certificates	Check this option if your Redis server allows any server SSL certificates.
CA Certificate	The path to a file in PEM format that contains a list of trusted SSL certificate authorities.
Server Name Indication	The Server Name Indication (SNI) value used when establishing the SSL connection to the Redis server.

Snowflake

Option	Description
Connection Name	Enter a friendly name to best describe your connection.
Add To	After you logged in Navicat Cloud or On-Prem Server, you can choose to save the connection to My Connections or a project.
Configuration Method	Choose the configuration method of the database server. Either using user credentials (Default), data source names (DSN), Native SSO or Browser-Based SSO.
Host	A host name where the database is situated or the IP address of the server.
Warehouse	The warehouse to use once connected.
Role	The default access control role to use.
Port	A TCP/IP port for connecting to the database server.
User Name	User name for connecting to the database server.
Password	Password for connecting to the database server.
Use MFA passcode	Check this option if your user account has multi-factor authentication (MFA) enabled.
Data Source	Choose the data source you have set.
Native SSO URL	The Okta URL endpoint for your Okta account.

GaussDB

Support SSL and SSH Tunneling.

Option	Description
Connection Name	Enter a friendly name to best describe your connection.
Add To	After you logged in Navicat Cloud or On-Prem Server, you can choose to save the connection to My Connections or a project.
Type	The type of your GaussDB server: Single Host or Multiple Hosts.
Host / Hosts	A host name where the database is situated or the IP address of the server.
Port	A TCP/IP port for connecting to the database server.
Host Type Preference	The type of the host to be connected.
Initial Database	Set the initial database which user connects when making connection.
User Name	User name for connecting to the database server.
Password	Password for connecting to the database server.

Dameng

Support SSH Tunneling.

Option	Description
Connection Name	Enter a friendly name to best describe your connection.
Add To	After you logged in Navicat Cloud or On-Prem Server, you can choose to save the connection to My Connections or a project.
Configuration Method	Choose the configuration method of the database server. Either using user credentials (Default) or data source names (DSN).
Host	A host name where the database is situated or the IP address of the server.
Port	A TCP/IP port for connecting to the database server.
User Name	User name for connecting to the database server.
Password	Password for connecting to the database server.
Data Source	Choose the data source you have set.