Actions

Workflow Actions

Actions are what workflows do when their conditions are met. AI for Database supports several built-in actions and a generic webhook for custom integrations.

Send Email

Send an email to one or more recipients. The email body supports Markdown and can include data from query results.

Configuration:

• To -- email addresses (comma-separated) or a dynamic value from a query column
• Subject -- plain text with {{variable}} support
• Body -- Markdown with {{variable}} support and a {{results_table}} helper that renders query results as an HTML table
• Attachments -- optionally attach query results as a CSV file

Example subject: "Alert: {{row_count}} overdue invoices found"

Post to Slack

Send a message to a Slack channel. Requires the Slack integration to be configured in Settings > Integrations.

Configuration:

• Channel -- select from your Slack workspace's channels
• Message -- Markdown text with variable support
• Include table -- attach query results as a formatted Slack table
• Thread -- optionally post as a thread reply to a previous message

Call Webhook

Send an HTTP request to any URL. This is the most flexible action and can integrate with thousands of tools.

Configuration:

• URL -- the endpoint to call
• Method -- GET, POST, PUT, PATCH, or DELETE
• Headers -- custom headers (e.g., Authorization)
• Body -- JSON template with variable support

Example body:

{
  "text": "{{row_count}} new signups today",
  "data": {{results_json}}
}

Run Query

Execute an additional SQL query as an action. This is useful for writing to log tables, updating status fields, or calling stored procedures.

Action Chaining

You can add multiple actions to a single workflow. Actions execute in order and each one has access to the results of all previous steps. If an action fails, subsequent actions are skipped by default (configurable).