Skip to content
Microsoft SQL Server logo

Microsoft SQL Server integration

Microsoft's relational database engine, on-premise or as Azure SQL

Actions
7
Triggers
1
Auth
Custom auth
License
MIT, open source
Updated
September 2026

About the Microsoft SQL Server integration

Add the Microsoft SQL Server piece to a flow, connect your account once, and the rest of the builder can read from it and write to it. Because the piece is open source you can run it on our cloud or self-host it, and combine Microsoft SQL Server with 760+ other apps in the same flow.

Triggers

Start a flow the moment something happens in Microsoft SQL Server

Each trigger below can start a flow on its own, either instantly or on a schedule.

  • New or Updated Row

    Fires when a row is added to, or changed in, a table

    4 fields

Actions

Everything Activepieces can do in Microsoft SQL Server

Drop any of these into a flow and fill in the fields. No code is required.

  • Find Rows

    Reads rows from a table

    8 fields

  • Insert Row

    Inserts a new row into a table and returns it

    2 fields

  • Insert Multiple Rows

    Inserts many rows into a table in a single transaction

    4 fields

  • Update Rows

    Updates every row whose search column matches a value

    4 fields

  • Delete Rows

    Deletes every row whose search column matches a value

    3 fields

  • Get Tables

    Returns a list of tables in the database

  • Run Query

    Runs a T-SQL statement and returns the rows it produced

    4 fields

Use Microsoft SQL Server in a flow

Connect Microsoft SQL Server once and every trigger and action above is yours to drop into the builder, alongside 760+ other apps. Free to start, on our cloud or your own servers.

Microsoft SQL Server, answered.

Yes. Activepieces is open source and free to start, and the Microsoft SQL Server piece is included on every plan, from the free cloud tier to any self-hosted deployment.

Add the Microsoft SQL Server piece to a flow, then authenticate with Custom auth. Once connected, its 1 trigger and 7 actions are available anywhere in the builder.

"New or Updated Row" can start a flow that runs "Find Rows", and you can chain Microsoft SQL Server together with any of 760+ other apps and AI steps in between.

Yes. Activepieces is fully self-hostable, so you can run the Microsoft SQL Server piece on your own infrastructure with your connections and your data staying in your environment.

Yes. Every piece you connect can be exposed over one Activepieces MCP server, so Claude, Cursor, Windsurf or any MCP client can call Microsoft SQL Server actions as tools.