SQL Server integrations

Connect SQL Server to any other app, or use it from your AI client over MCP. Connect directly to a Microsoft SQL Server database and run SQL statements from your automations.

Connects with an API keymicrosoft.com

4 triggers 7 actions

What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it.

Build solutions, not workarounds.

What do you want to automate with SQL Server?

Ask the assistant

Connect your AI client

Give your AI client this address.

https://mcp.apiant.ai

Any client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser.

Set it up in your client

Claude Code

Run this in the directory you want to work in.

claude mcp add --transport http -s project apiant-ai https://mcp.apiant.ai

Start Claude Code there, approve the server, and sign in in the browser page it opens.

Claude Code guide

Claude, web and desktop

Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first.

Setup guide

Cursor

Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser.

Setup guide

Zed

Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server.

Setup guide

Codex and the ChatGPT desktop app

Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in.

Setup guide

Any other MCP client

Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection.

Setup guide

Popular

SQL Server with the apps people pair it with most

Pair it

Connect SQL Server with another app

What your agent can do with SQL Server

Triggers and actions 4 triggers · 7 actions

Trigger
New or Updated Row
Triggers when a new row is added or modified.
Trigger
New or Updated Row (Custom Query)
Fires for each new or changed row returned by a SELECT statement you write against the connected SQL Server database.
Trigger
New Row
Triggers when you add a new row.
Trigger
New Table
Fires when a new table appears in the connected SQL Server database.
Action
Add Row
Add one row to a table on the connected SQL Server database.
Action
Delete Row
Delete the rows in a table whose chosen column equals a value.
Action
Find Row
Find the first row in a table whose chosen column matches a value.
Action
Find Rows via Custom Query
Runs a SELECT statement you write against the connected SQL Server database and returns every row it matches.
Action
Find Row via Custom Query
Runs a SELECT statement you write against the connected SQL Server database and returns the first row it matches.
Action
Run Custom Statement
Runs a statement you write against the connected SQL Server database that changes data rather than returning rows, and reports how many rows it changed.
Action
Update Row
Change column values on every row of a table whose chosen column matches a value.

Related apps

What our customers say

Questions

SQL Server, answered

Is there a SQL Server MCP server?

APIANT's MCP server at https://mcp.apiant.ai works with SQL Server. Add that address to any AI client that takes a remote MCP server, sign in once in your browser, and your client can build, test and run automations that use SQL Server. Nothing to install.

What can start an automation from SQL Server?

Any of SQL Server's 4 triggers in the catalog, including New or Updated Row, New or Updated Row (Custom Query), New Row and New Table. Describe the moment in plain language and your agent picks the right one.

What can your agent do in SQL Server?

Any of SQL Server's 7 actions, including Update Row, Add Row, Find Row and Find Rows via Custom Query. Your agent maps the data both ways and tests every scenario before it ships.

Which apps can SQL Server connect to?

Any app in the catalog; the list on this page pairs SQL Server with each of them. If the other app is missing, point your agent at its API documentation and it builds the connector.

What happens when something fails?

Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships.

Is there a free plan?

Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.