Skip to main content

SQL Server Node

What it does​

Executes Microsoft SQL Server queries/statements via SQL Server credentials for lookup, transformation, or persistence steps.

Inputs/config​

  • SQL Server credential reference.
  • Query/statement text and parameters.
  • Optional command timeout and execution options.

Outputs/branches​

  • Uses matched_output.
  • success on successful execution.
  • error on SQL/connection/login failures.

Example usage snippet​

{
  "id": "n_sqlserver",
  "type": "sqlserver_node",
  "config": {
    "query": "select top 1 * from Accounts where AccountId = @id",
    "params": { "id": "{{input.accountId}}" }
  }
}

Common pitfalls​

  • Mixing SQL dialect syntax from other databases.
  • Not parameterizing values and increasing injection risk.
  • Ignoring collation/case-sensitivity differences across environments.