n8n-nodes-azure-sqlInstall

Summary

Executes a SQL query against an Azure SQL Database using Entra ID authentication and returns the query results.

Inputs

• Item (required) — Input items are not used to build the query; each input item triggers an independent execution of the query.

Output shape

Item

If the query returns rows, each row is emitted as a separate item with its column values in the json field. If the query returns no rows, a single item is returned containing { json: { success: true, rowsAffected: number } }.

Examples

Example 1: Selecting rows from a table

Set Server to myserver.database.windows.net, Database to mydb, Query to SELECT id, name FROM users.