Microsoft SQL Server Integration

Authentication

SQL Server Connection

Connect using SQL Server host, port, database, username, and password

Required Credentials

Field	Description	Required	Format
Host	SQL Server hostname or IP address	Yes	`myserver.database.windows.net`
Port	SQL Server port number	Yes	`1433`
Username	SQL Server login username	Yes	`-`
Password	SQL Server login password	Yes	`-`
Database	Name of the database to connect to	Yes	`-`
Encrypt	Whether to encrypt the connection (true/false). Use true for Azure SQL.	No	`true`
Trust Server Certificate	Whether to trust self-signed certificates (true/false). Use true for local dev.	No	`false`

Available Actions

execute_raw_query — Execute a raw SQL query against the database and return results

Parameters

string

required

The SQL query to execute

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "recordset": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Recordset",
      "type": "array"
    },
    "rows_affected": {
      "items": {
        "type": "integer"
      },
      "title": "Rows Affected",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "ExecuteRawQueryOutput",
  "type": "object"
}

execute_query — Execute a parameterized SQL query with named inputs

Parameters

string

required

The SQL query to execute, using @name placeholders for parameters

object

Key-value mapping of parameter names to values for the query placeholders

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "recordset": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Recordset",
      "type": "array"
    },
    "rows_affected": {
      "items": {
        "type": "integer"
      },
      "title": "Rows Affected",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "ExecuteQueryOutput",
  "type": "object"
}

insert_row — Insert a new row into a specified table

Parameters

string

required

Name of the table to insert into

object

required

JSON object mapping column names to values for the new row

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "rows_affected": {
      "items": {
        "type": "integer"
      },
      "title": "Rows Affected",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "InsertRowOutput",
  "type": "object"
}

list_table_options — List all available base tables in the database

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "tables": {
      "items": {
        "type": "string"
      },
      "title": "Tables",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "ListTableOptionsOutput",
  "type": "object"
}

Limits & Quotas

No API rate limits apply; performance depends on the SQL Server instance capacity and network latency.

Connection timeout defaults to pymssql’s default (dependent on server responsiveness).

Query execution is wrapped in asyncio.to_thread so it does not block the event loop.

Error model: connection failures, query syntax errors, and timeouts are caught and returned as success=False + error rather than raising.

Using

Providers

Building

Tools

Microsoft SQL Server Integration for AI Agents & Workflows

Overview

Authentication

SQL Server Connection

Required Credentials

Available Actions

Parameters

Response

Parameters

Response

Parameters

Response

Response

Limits & Quotas

MySQL

PostgreSQL

Snowflake

Links

​Overview

​Authentication

​SQL Server Connection

​Required Credentials

​Available Actions

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Response

​Limits & Quotas

​Related integrations

MySQL

PostgreSQL

Snowflake

​Links

Overview

Authentication

SQL Server Connection

Required Credentials

Available Actions

Parameters

Response

Parameters

Response

Parameters

Response

Response

Limits & Quotas

Related integrations

Links