Skip to content

Microsoft SQL#

The Microsoft SQL node allows you to automate work in Microsoft SQL, and integrate Microsoft SQL with other applications. n8n has built-in support for a wide range of Microsoft SQL features, including executing SQL queries, and inserting rows into the database.

On this page, you'll find a list of operations the Microsoft SQL node supports and links to more resources.

Credentials

Refer to Microsoft SQL credentials for guidance on setting up authentication.

Examples and templates

For usage examples and templates to help you get started, take a look at n8n's Microsoft SQL integrations list.

Basic Operations#

  • Execute an SQL query
  • Insert rows in database
  • Update rows in database
  • Delete rows in database

Example Usage#

This workflow allows you to execute an SQL query in Microsoft SQL. You can also find the workflow on the website. This example usage workflow would use the following two nodes. - Start - Microsoft SQL

The final workflow should look like the following image.

A workflow with the Microsoft SQL node

1. Start node#

The start node exists by default when you create a new workflow.

2. Microsoft SQL node#

  1. First of all, you'll have to enter credentials for the Microsoft SQL node. You can find out how to do that here.
  2. Select 'Execute Query' from the Operation dropdown list.
  3. Enter your SQL query in the Query field.
  4. Click on Execute Node to run the workflow.