Database Nodes

Database nodes let you interact with databases directly from your workflows. Query data, insert records, update fields, and delete rows, all without writing SQL by hand.

Available nodes

Supported databases

• PostgreSQL: full CRUD support
• MySQL: full CRUD support
• TinyTables: native integration with TinyCommand's data product

How it works

1. Set up a database connection in App Authorizations (host, port, credentials)
2. Add a database node to your canvas
3. Select the connection and table
4. Configure the operation (insert, query, update, delete)
5. Use variables to pass data from previous nodes

Common patterns

Log webhook data to a database

Webhook Trigger → Create Record (insert the payload into a table)

Enrich data from a database

Trigger → Read Record (look up customer by email) → Send Email (use the customer's name)

Sync two systems

Schedule Trigger → Read Record (source DB) → For Each → HTTP Request (push to external API)

Database types

TinyWorkflows supports two database engines plus TinyTables:

Setting up a database connection

Before using database nodes, set up a connection:

1. Go to Build → App Authorizations
2. Click + Add Connection
3. Choose PostgreSQL or MySQL
4. Enter: host, port, database name, username, password
5. For PostgreSQL, optionally select a schema (default: public)
6. Click Test Connection to verify
7. Click Save

The 3-tab pattern

All database nodes follow the same flow:

1. Initialise: choose a template (e.g., "Find by ID", "Insert User", "Delete Expired")
2. Configure: set connection, table, fields/conditions
3. Test: run against your real database and see the result