Integrations
Database Connectors
Connect directly to relational and NoSQL databases in your workflows.
Supported Databases
| Database | Operations |
|---|---|
| PostgreSQL | Query, Insert, Update, Delete, Execute |
| MySQL / MariaDB | Query, Insert, Update, Delete, Execute |
| Microsoft SQL Server | Query, Execute Stored Procedure |
| SQLite | Query, Execute |
| MongoDB | Find, Insert, Update, Delete, Aggregate |
| Redis | Get, Set, Delete, Publish, Subscribe |
Setting Up a Database Credential
- Go to Settings → Credentials → Add → PostgreSQL (or your DB type)
- Enter:
- Host, Port, Database name - Username and Password - SSL mode (recommended: require for production)
- Click Test Connection to verify
- Save
Writing Safe Queries
Always use parameterised queries to prevent SQL injection:
-- ✅ Safe — parameterised
SELECT * FROM users WHERE email = $1 AND tenant_id = $2
-- ❌ Never do this — string interpolation
SELECT * FROM users WHERE email = '{{ $json.email }}'Map parameters in the Query Parameters field:
["{{ $json.email }}", "{{ $env.TENANT_ID }}"]Handling Large Result Sets
For queries returning thousands of rows, enable Streaming Mode to process results in batches and avoid memory issues.
Transactions
Wrap multiple operations in a transaction using the Execute Query node:
BEGIN;
UPDATE accounts SET balance = balance - $1 WHERE id = $2;
UPDATE accounts SET balance = balance + $1 WHERE id = $3;
COMMIT;