Native Database Connections

Supported Databases

Connect supports a wide range of native database systems, allowing you to connect to both relational and NoSQL databases.

MySQL / MariaDB

Connect to MySQL or MariaDB databases with the following configuration:

• Host - Database server hostname or IP address
• Port - Default: 3306
• Database - Name of the database to connect to
• Username - Database user with appropriate permissions
• Password - User password
• SSL Mode - Optional SSL/TLS configuration

PostgreSQL

Connect to PostgreSQL databases with these settings:

• Host - Database server hostname or IP address
• Port - Default: 5432
• Database - Database name
• Schema - Optional schema name (default: public)
• Username - Database user
• Password - User password
• SSL Mode - disable, allow, prefer, require, verify-ca, verify-full

Microsoft SQL Server

Connect to SQL Server instances:

• Host - Server hostname or IP address
• Port - Default: 1433
• Database - Database name
• Authentication - SQL Server or Windows Authentication
• Username - SQL Server login
• Password - Login password
• Encrypt - Enable connection encryption
• Trust Server Certificate - Skip certificate validation

Oracle Database

Connect to Oracle Database instances:

• Host - Oracle server hostname
• Port - Default: 1521
• Service Name - Oracle service name or SID
• Username - Oracle user
• Password - User password

MongoDB

Connect to MongoDB instances or clusters:

• Connection String - Full MongoDB URI or individual settings
• Host - MongoDB server hostname
• Port - Default: 27017
• Database - Database name
• Username - MongoDB user
• Password - User password
• Auth Database - Authentication database (default: admin)