Gen AI by UnifyApps provides generative AI capabilities within automation workflows.
Overview
Gen AI by UnifyApps provides generative AI capabilities within automation workflows. The node currently supports natural language to SQL conversion, enabling automations to translate plain-language user queries into executable SQL statements without requiring users to know database query syntax.
Gen AI by UnifyApps node configuration
Convert Text to SQL Statements
The Convert Text to SQL Statements action takes a natural language description of a data request and generates a valid SQL query against a described database schema, allowing non-technical users or conversational interfaces to query structured data.
Input Fields
Database Metadata — A description of the target database schema: table names, column names, data types, and relationships. The richer this description, the more accurate the generated SQL.
SQL Dialect — The SQL dialect to generate (e.g., PostgreSQL, MySQL, BigQuery). Ensures the output uses dialect-specific syntax.
User Prompt — The natural language question or request describing the data to retrieve (e.g., "Show me all orders placed in the last 30 days by customers in California").
Output
The action returns a generated SQL query string ready to pass to a database execution node (such as Analytics Execute SQL Query or a Custom HTTP Endpoint action against a database API).
Text-to-SQL input and output configuration
Use Case Example
A business intelligence automation allows non-technical analysts to query a sales database using plain English. The workflow receives a natural language question via a form submission trigger, passes the question along with the database schema to Gen AI Convert Text to SQL Statements, then pipes the resulting SQL into an Analytics Execute SQL Query node to retrieve and return the data.
Gen AI by UnifyApps details
Tip: Provide detailed Database Metadata including column descriptions and example values to improve SQL generation accuracy. Ambiguous schema descriptions lead to ambiguous queries.
Notes
Keep the following in mind when using Gen AI by UnifyApps:
Provide a clear, specific table and column schema when calling Convert Text to SQL; vague schema descriptions produce incorrect or incomplete SQL.
Review the generated SQL before executing it against a live database; natural language to SQL conversion can produce syntactically correct but semantically incorrect queries.
Use the Use Case Example section as a reference for how to structure the input fields; the expected format is not always obvious from the field labels alone.
Combine this node with an Analytics SQL node to generate and immediately execute a query based on natural language input.
Test generated SQL against a small, representative dataset before running it against full production tables.