SQL Server MCP connector

Updated 10 September 2026

SQL Server is Microsoft's relational database management system for storing and managing structured business data. The SQL Server MCP connector allows AI agents to execute SQL queries, statements, and stored procedures against a database instance to retrieve and manipulate data. It also supports returning single scalar values from queries, making it well suited for both data lookups and broader database operations within a workflow.

Authentication type

• API Key - Requires a static API key to be configured before the agent can connect to the service.

Uses

Use the SQL Server MCP connector to perform the following actions:

• Update customer records in bulk across SQL Server tables
• Retrieve open orders, invoices, or inventory levels on demand
• Count records matching specific business conditions instantly
• Delete outdated or duplicate rows from SQL Server tables
• Insert new leads, transactions, or logs into SQL Server
• Check account balances or totals for reporting needs
• Sync workflow results by writing data back to SQL Server
• Audit table changes by querying row counts and statuses

Example prompts

Use the following example prompts to invoke SQL Server MCP connector tools from your AI assistant or Boomi Connect workflow:

• Show me all open invoices from last month in SQL Server.
• Update the shipping status for order 4521 in SQL Server.
• How many customers signed up this week in SQL Server?
• Delete the test records from the staging table in SQL Server.
• Add a new employee record to the SQL Server database.
• What is the total revenue for Q3 stored in SQL Server?
• List all products with inventory below 10 units in SQL Server.
• Count how many support tickets are still open in SQL Server.
• Insert a new customer entry into the SQL Server sales table.
• Get the average order value from SQL Server for this month.

SQL Server MCP connector tools

The SQL Server MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.

Tool	Description
sqlserver_sqlserverexecutenonquery_invoke	Execute a non-query SQL statement that returns the number of rows affected
sqlserver_sqlserverexecutequery_invoke	Returns zero or more rows from a SQL query
sqlserver_sqlserverexecutescalar_invoke	Returns a single value from a SQL query e.g.