Advanced Settings

While basic login credentials get you connected, complex networks and strict security policies often require deeper customization. The Advanced tab provides granular control over timeouts, security, and driver configurations.

Note: The following options depend on the connection server type and sort in ascending order.

Option	Description
Auto connect	Open the connection at application startup automatically.
Cipher Name	Choose the encryption algorithm when connecting to an encrypted SQLite database.
Client Character Set	Choose the session client character set used in Navicat.
Client Driver Version	Choose the client driver used to connect the server. If the default driver does not work, you can change this setting to Legacy.
Compatibility	Enable the Compatibility tab for setting the compatibility mode for MySQL connection.
Connection Parameters	Enter advanced parameters that don't have an equivalent option exposed in any other tab, e.g. Trusted_Connection=yes;ApplicationIntent=ReadOnly;
Connection Timeout	Specify the amount of time to wait for a connection to be established before timing out.
Encoding	Choose a codepage for converting data to display in Navicat UI.
Encrypted	Enable this option and provide Password when connecting to an encrypted SQLite database.
Execution Timeout	Specify the amount of time to wait before execution of a task is completed on the server.
Initial Queries	Specify the initial query commands to be executed when connecting to the server.
Keepalive interval	Keep the connection with the server alive by pinging it. You can set the period between pings in the edit box.
Limit connection sessions	Specify the maximum number of concurrent connections that the server allows.
Native Client Driver	Choose the SQL Server Native Client used for the connection.
OS authentication	Use OS user login credentials to authenticate database users.
Read Timeout	Specify the amount of time to wait for more data from a connection before aborting the read.
Retryable Reads	Disable this option to specify "retryReads=false" in the connection string.
Retryable Writes	Disable this option to specify "retryWrites=false" in the connection string.
Role	Indicate that the database user is connecting with either the Default, SYSOPER or SYSDBA system privilege.
Server Selection Timeout	Specify the amount of time to block for server selection before throwing an exception.
Settings Location	When a new connection is being established, Navicat will create a subfolder under the Settings Location. Most files are stored within this subfolder.
Socket Timeout	Specify the amount of time to wait for an inactive socket before closing it.
Trust Server Certificate	Skip the step that validates the server certificate. The server certificate is automatically trusted.
Use compression	Use compression protocol. It is used if both client and server support zlib compression, and the client requests compression.
Use encryption	Use encryption for SQL Server connection.
Use named pipe, socket	Use socket file for localhost connection.
Write Timeout	Specify the amount of time to wait for a block to be written to a connection before aborting the write.

File in Settings Location

Additionally, Navicat saves your profiles locally in a dedicated Settings Location, so you can easily manage and back up your work.

File in Settings Location	Server Type	File Extension
Aggregation Pipeline	MongoDB	.nagg
Backup	MySQL, PostgreSQL, SQLite, MariaDB and Snowflake	.nb3
Backup	Redis	.nbr
Backup Profile	MySQL	.nbakmysql
	PostgreSQL	.nbakpgsql
	SQLite	.nbaksqlite
	SQL Server	.nbakmssql
	MariaDB	.nbakmariadb
	Redis	.nbakredis
	Snowflake	.nbaksnowflake
Collection Profile	MongoDB	.ntablep
Data Pump Export Profile	Oracle	.nbakora
Data View Profile	Redis	.ndvredis
ER Diagram File	MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and Snowflake	.nmodel
Export Materialized View Profile	Oracle	.nexpmora
	PostgreSQL	.nexpmpgsql
	Snowflake	.nexpmsnowflake
Export Query Result Profile	MySQL	.nexpqmysql
	Oracle	.nexpqora
	PostgreSQL	.nexpqpgsql
	SQLite	.nexpqsqlite
	SQL Server	.nexpqmssql
	MariaDB	.nexpqmariadb
	MongoDB	.nexpqmongodb
	Snowflake	.nexpqsnowflake
Export Table/Collection Profile	MySQL	.nexptmysql
	Oracle	.nexptora
	PostgreSQL	.nexptpgsql
	SQLite	.nexptsqlite
	SQL Server	.nexptmssql
	MariaDB	.nexptmariadb
	MongoDB	.nexptmongodb
	Snowflake	.nexptsnowflake
Export View Result Profile	MySQL	.nexpvmysql
	Oracle	.nexpvora
	PostgreSQL	.nexpvpgsql
	SQLite	.nexpvsqlite
	SQL Server	.nexpvmssql
	MariaDB	.nexpvmariadb
	MongoDB	.nexpvmongodb
	Snowflake	.nexpvsnowflake
Import Table/Collection Profile	MySQL	.nimpmysql
	Oracle	.nimpora
	PostgreSQL	.nimppgsql
	SQLite	.nimpsqlite
	SQL Server	.nimpmssql
	MariaDB	.nimpmariadb
	MongoDB	.nimpmongodb
	Snowflake	.nimpsnowflake
MapReduce	MongoDB	.mapreduce
Pub/Sub	Redis	.npsbredis
Pub/Sub Archive File	Redis	.nrpsbmlog
Query	MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and Snowflake	.sql
	MongoDB	.js
	Redis	.redis
Schema Analysis	MongoDB	.nsatmongodb
Table Profile	MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and Snowflake	.ntablep

Compatibility Settings

If your server is a variant of MySQL or has proxy middleware installed, you can enable compatibility mode and set the corresponding settings for the connection.

Option	Description
Force lower_case_table_names as	Set the value of the lower_case_table_name system variable.
Force sql_mode as	Set the value of the sql_mode system variable.
Force NDB cluster support as	Include or exclude the support for the NDBCLUSTER storage engine.
Force database listing method as	Use the SHOW DATABASES statement to retrieve the information for listing databases, or select the information from the INFORMATION_SCHEMA database.
Force view listing method as	Use the SHOW FULL TABLES statement to retrieve the information for listing tables, or select the information from the INFORMATION_SCHEMA database.