SQL Server MCP connector

Microsoft SQL Server is a relational database management system used to store and manage structured business data. The SQL Server MCP connector allows AI agents to execute SQL statements, run queries, and retrieve scalar values directly against a target database. It also supports data manipulation and analysis tasks, enabling agents to integrate live database operations into broader automated workflows.

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 directly in SQL Server without writing code
• Retrieve sales data instantly to answer business questions
• Count open orders or overdue invoices in real time
• Insert new leads or transactions into SQL Server tables
• Delete outdated records to keep databases clean and accurate
• Calculate totals, averages, or counts across large datasets
• Pull inventory levels from SQL Server for stock reporting
• Automate routine database updates within larger workflows

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 status of order 4521 to shipped in SQL Server.
• How many customers signed up this week in SQL Server?
• Delete the test records from the staging table in SQL Server.
• What is the total revenue for Q3 in SQL Server?
• Add a new employee record to SQL Server.
• Count how many products are out of stock in SQL Server.
• List all overdue accounts from SQL Server.
• Change the price of item SKU-1023 in SQL Server.
• What is the average order value this month in SQL Server?

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.