Skip to content
Open app Talk to sales
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.

Start building See the Microsoft SQL Server integration
Tools
7
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

  • 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

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.

Get your server URLTalk to sales

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 7 tools, including Find Rows, Insert Row, Insert Multiple 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.

Guides using Microsoft SQL Server

What Actually Transfers When You Migrate Off Automation Anywhere Automation Anywhere migrations require rebuilding bot logic and selectors from scratch. Use this guide to assess your process documentation for success.Step-by-Step Guide to Automating Tasks from Zendesk to Invoice Ninja Running a business is no small feat, you've got to keep your eyes on a ton of moving parts. 👀 One of the most rewarding, yet time-consuming aspects is customer service. You are on Zendesk, right? It's a lifesaver. But sometimes those support tickets can pile up and next thing

More developer tools apps on the same server

Browse all MCP apps
Supabase

Supabase

The open-source Firebase alternative

Developer Tools22 actions · 1 trigger
GitHub

GitHub

Developer platform that allows developers to create, store, manage and share their code

Developer Tools19 actions · 14 triggers
Cryptolens

Cryptolens

Cryptolens is a Software Licensing as a Service (SLaaS) platform that provides developers with tools to manage software licenses, protect against piracy, and analyze usage data.

Developer Tools5 actions · 1 trigger
Intruder

Intruder

Intruder is a powerful vulnerability management platform that helps businesses identify, assess, and remediate security risks across their digital assets. With its comprehensive scanning capabilities and user-friendly interface, Intruder enables organizations to stay ahead of potential threats and maintain a robust security posture.

Developer Tools6 actions
HashiCorp Vault

HashiCorp Vault

Securely manage secrets and sensitive data with HashiCorp Vault

Developer Tools5 actions
UptimeRobot

UptimeRobot

Monitor your websites, APIs, and servers. Get alerted when things go down.

Developer Tools5 actions