Docs/App Integrations/Database

Database

App Integrations

Database Node

Overview

Supports the following operations: PostgreSQL, MySQL, Microsoft SQL Server, Snowflake, Google BigQuery, INSERT (Create), SELECT (Read), UPDATE (Update), DELETE (Delete), Run SQL Query.

Configuration

Property	Type	Default	Description
`dbType`	`string`	—	Database type (postgresql, mysql, mssql, etc.)
`operation`	`string`	—	Action to execute
`connectionString`	`string`	—	Database connection string or DSN
`tableName`	`string`	—	Target database table name
`columns`	`string`	—	Columns to select or insert
`orderBy`	`string`	—	Field to order results by
`limit`	`string`	—	Maximum number of results to return
`query`	`string`	—	Search or database query string

Output Variables

Reference these variables in downstream nodes using the {{node.field}} syntax.

{{database.rows}}

anyOutput field: rows

{{database.row_count}}

anyOutput field: row_count

{{database.affected}}

anyOutput field: affected

Examples

Basic Usage

Example configuration:

{
  "dbType": "value",
  "operation": "value",
  "connectionString": "value",
  "tableName": "value",
  "columns": "value",
  "orderBy": "value",
  "limit": "value",
  "query": "value"
}

Tips & Best Practices

•Ensure all required fields are configured.
•Check the output variables to see available data.
•Verify your connection credentials are configured in Settings > Integrations.

Try Database in Your Workflow

Create a free account and start building AI-powered workflows with the Database node.

Open Workflow Editor