Azure SQL

Learn how to use the Azure SQL node to query your Azure SQL database with natural language or SQL, including required inputs, configurations, and output details.

What is Azure SQL?

Azure SQL is a workflow node that allows you to query an Azure SQL database using either plain English or SQL queries. This node is ideal for retrieving, analyzing, and interacting with your database data directly within your workflow, making data access seamless and user-friendly.

---

How to use it?

To use the Azure SQL node, you must provide two required inputs:

1. Schema: Describe your database schema, including tables, columns, and data types.

2. Query: Enter your question or request in plain English or as a SQL statement.

The node will process your input, convert plain English queries to SQL if needed, execute the query, and return the results.

---

Example of Usage

Suppose you have a table called Sales with columns CustomerName, OrderAmount, and OrderDate.

• Schema (Required):

  TABLE Sales (
    CustomerName TEXT,
    OrderAmount REAL,
    OrderDate DATE
  );

• Query (Required):

  What is the total order amount for 2024?

  or

  SELECT SUM(OrderAmount) FROM Sales WHERE YEAR(OrderDate) = 2024;

Outputs:

• Query (Required): The SQL query that was executed (e.g., SELECT SUM(OrderAmount) FROM Sales WHERE YEAR(OrderDate) = 2024;)

• Results (Required): The results of the query (e.g., {"SUM(OrderAmount)": 150000})

---

Available Actions

• Query an Azure SQL database

  • Inputs:

    • Schema (Required): The structure of your database (tables, columns, types, etc.).

    • Query (Required): Your question in plain English or a SQL statement.

  • Configurations: None required beyond the schema and query.

  • Outputs:

    • Query (Required): The SQL query that was executed.

    • Results (Required): The results returned from the database.