Database Node

Query relational databases directly from your workflows.

Overview

The Database node allows you to connect to MySQL, PostgreSQL, or MongoDB databases and execute queries. It supports both simple visual query building and advanced raw SQL/query mode.

Don't need an external database? If you want to store and query data directly inside Ubex without setting up MySQL, PostgreSQL, or MongoDB, use Tables in My Data instead. Tables work as built-in database tables with full CRUD support via Query Data and Write Data nodes. See the My Data documentation for details.

Supported Databases

Configuration

Connection Settings

New Connection

SSH Tunnel (Optional)

Query Modes

Simple Mode

Build queries visually without writing SQL:

1. Select Table - Choose from available tables
2. Select Columns - Pick columns to return (or all)
3. Add Conditions - Filter with WHERE clauses
4. Order By - Sort results
5. Group By - Aggregate data
6. Limit/Offset - Pagination

Advanced Mode

Write raw SQL queries with full control:

SELECT u.name, COUNT(o.id) as order_count
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
WHERE u.created_at > '2024-01-01'
GROUP BY u.id
ORDER BY order_count DESC
LIMIT 10

Condition Operators

Using Variables

Use template variables in your queries:

SELECT * FROM users WHERE id = {{user_id}}

Or in conditions (Simple mode):

Column: status
Operator: =
Value: {{filter_status}}

Query Parameters

For advanced mode, use parameterized queries for security:

SELECT * FROM users WHERE email = $1 AND status = $2

Then map parameters:

• $1 → {{user_email}}
• $2 → {{status}}

Best Practices

• Save and reuse connections across workflows
• Use parameterized queries to prevent SQL injection
• Add appropriate indexes for frequently queried columns
• Use LIMIT to avoid returning too much data
• Test queries with small datasets first