query

query

Execute SQL queries on Microsoft SQL Server databases by providing connection details or a connection string. Manage database interactions and retrieve results directly.

Instructions

Execute a SQL query on a MSSQL database

Input Schema

Name	Required	Description
`connectionString`	No	Full connection string (alternative to individual parameters)
`database`	No	Database name (default: master)
`encrypt`	No	Enable encryption (default: false)
`host`	No	Database server hostname
`password`	No	Database password
`port`	No	Database server port (default: 1433)
`query`	Yes	SQL query to execute
`trustServerCertificate`	No	Trust server certificate (default: true)
`username`	No	Database username

Input Schema (JSON Schema)

{
  "oneOf": [
    {
      "required": [
        "connectionString"
      ]
    },
    {
      "required": [
        "host",
        "username",
        "password"
      ]
    }
  ],
  "properties": {
    "connectionString": {
      "description": "Full connection string (alternative to individual parameters)",
      "type": "string"
    },
    "database": {
      "description": "Database name (default: master)",
      "type": "string"
    },
    "encrypt": {
      "description": "Enable encryption (default: false)",
      "type": "boolean"
    },
    "host": {
      "description": "Database server hostname",
      "type": "string"
    },
    "password": {
      "description": "Database password",
      "type": "string"
    },
    "port": {
      "description": "Database server port (default: 1433)",
      "type": "number"
    },
    "query": {
      "description": "SQL query to execute",
      "type": "string"
    },
    "trustServerCertificate": {
      "description": "Trust server certificate (default: true)",
      "type": "boolean"
    },
    "username": {
      "description": "Database username",
      "type": "string"
    }
  },
  "required": [
    "query"
  ],
  "type": "object"
}

MSSQL MCP Server

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from MSSQL MCP Server

Related Tools

MCP directory API