Skip to content
Microsoft SQL Server logo

Microsoft SQL Server MCP server

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

Microsoft SQL Server is not a separate install. One Activepieces MCP server exposes it alongside 760+ other apps, behind a single URL.

Tools
6
Works with
Any MCP client
Auth
Custom auth
License
MIT, open source
Updated
September 2026

About the Microsoft SQL Server MCP server

Connect Microsoft SQL Server once in Activepieces and every action it ships becomes a tool your assistant can call, behind the same server URL as the rest of your apps. Your agent reaches Microsoft SQL Server and 760+ other apps over a single connection, on our cloud or a self-hosted install.

Tools

Microsoft SQL Server tools your AI can run

Once connected, your assistant can call any of these Microsoft SQL Server actions by asking in plain language.

  • Find Rows

    Reads rows from a table

    8 fields

  • Insert Row

    Inserts a new row into a table and returns it

    2 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

Triggers

Microsoft SQL Server events your agent can watch

These start a run the moment something happens in Microsoft SQL Server, so work gets picked up on its own.

  • New or Updated Row

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

    4 fields

Give your assistant Microsoft SQL Server

Connect Microsoft SQL Server once and every tool above is callable from Claude, Cursor or any MCP client, behind the same server URL as 760+ other apps. Free to start.

Microsoft SQL Server MCP, answered.

No. That is the point of it. One Activepieces server exposes Microsoft SQL Server alongside every other piece you connect, so your client keeps a single connection.

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

Connect Microsoft SQL Server in Activepieces, enable the server under Settings → MCP Server, then paste your server URL into your client config. It authenticates over OAuth on first use.

It can call 6 tools, including Find Rows, Insert Row, Update Rows, and chain them with steps in other apps inside the same run.

Connections use OAuth2 with limited scopes and are stored under 256-bit encryption, with no API to read them back, so an agent gets scoped access rather than your keys.