Database Connections
Connect your existing databases to qomplement. Browse schemas, run queries, and push extracted data directly to your tables.
Supported databases
| Database | Type |
|---|---|
| PostgreSQL | Relational |
| MySQL | Relational |
| Microsoft SQL Server | Relational |
| SQLite | Relational |
| Oracle | Relational |
| MongoDB | Document |
| Snowflake | Cloud Data Warehouse |
| Google BigQuery | Cloud Data Warehouse |
| Amazon Redshift | Cloud Data Warehouse |
Adding a connection
- Click Clouds in the left sidebar
- Click Add Connection
- Fill in the connection details:
| Field | Description |
|---|---|
| Name | A friendly name for this connection (e.g., "Production CRM") |
| Type | Select your database type |
| Host | Server address (e.g., db.example.com) |
| Port | Database port (defaults are pre-filled per type) |
| Database | Database name |
| Username | Your database username |
| Password | Your database password |
| SSL | Toggle to enable SSL encryption |
- Click Test Connection to verify connectivity
- Click Save to store the connection
Testing connections
After saving, click Test at any time to verify the connection is still working. You'll see:
- Connected (with timestamp) — connection successful
- Failed (with error) — check your credentials or network settings
Connection security
- Credentials are encrypted at rest
- Connections use SSL when enabled
- Database credentials are never exposed in the UI after saving
- Only organization members can access saved connections
Editing and deleting
- Edit — update credentials without recreating the connection
- Delete — permanently remove a connection
Using connections in workflows
Once connected, your databases appear as nodes in the Workflow Builder:
- Source Database — read rows from a connected database
- Target Database — write extracted data to a connected database
- Execute Query — run custom SQL against a connection
Troubleshooting
| Issue | Solution |
|---|---|
| Connection timeout | Check if your database allows external connections (firewall, security groups) |
| Authentication failed | Verify username/password, check if the user has remote access permissions |
| SSL required | Toggle SSL on if your database requires encrypted connections |
| Database not found | Verify the database name is correct and the user has access to it |