Databases

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 triggers7 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

You'll sign in before anything runs. What you typed comes with you.

Connect your AI client

Give your AI client this address.

https://mcp.apiant.ai

One connection does both: ask your client to act in an app once, or have it build an automation that keeps running. 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 (opens in a new tab)
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 (opens in a new tab)
Cursor

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

Setup guide (opens in a new tab)
Zed

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

Setup guide (opens in a new tab)
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 (opens in a new tab)
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 (opens in a new tab)

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

More in Databases

Reviews

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 and sign in once in your browser. Your client can then run SQL Server actions on demand, or have APIANT 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.

Can I use SQL Server directly from Claude, ChatGPT or Cursor?

Yes. Connect your AI client to APIANT once and it works with SQL Server two ways. Ask it to do something in SQL Server once and it runs that action on the spot. Ask for an automation and your agent builds it, tests every scenario and keeps it running on its own. A one-off action uses your plan's tasks the same way an automation step does.

Do I need to write code against the SQL Server API?

No. APIANT connects to the SQL Server API for you, with your SQL Server API key. Describe what you want in plain language and your agent builds it on the SQL Server triggers and actions in the catalog. If you need an endpoint that is not there yet, your agent reads the SQL Server API documentation and adds it.

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.