execute_query

Run SQL SELECT queries on Microsoft SQL Server databases to retrieve up to 20 rows, using a connection string or named connection. Simplifies database exploration for AI assistants and tools.

Instructions

Execute a custom SQL SELECT query with automatic limit (top 20 rows)

Input Schema

Name	Required	Description
`connectionName`	No	Named connection to use (e.g., 'production', 'staging')
`connectionString`	No	SQL Server connection string (uses default if not provided)
`query`	Yes	SQL SELECT query to execute

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "connectionName": {
      "description": "Named connection to use (e.g., 'production', 'staging')",
      "type": "string"
    },
    "connectionString": {
      "description": "SQL Server connection string (uses default if not provided)",
      "type": "string"
    },
    "query": {
      "description": "SQL SELECT query to execute",
      "type": "string"
    }
  },
  "required": [
    "query"
  ],
  "type": "object"
}

Microsoft SQL Server MCP Server (MSSQL)

execute_query

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Microsoft SQL Server MCP Server (MSSQL)

Related Tools

MCP directory API