MSSQL MCP Server

connect-database

Establish secure connections to Microsoft SQL Server databases using the MCP interface. Provide server details, credentials, and encryption settings to enable database interactions and query execution.

Instructions

連接到 MSSQL 資料庫伺服器

Input Schema

Name	Required	Description
`database`	No	資料庫名稱 (可選)
`encrypt`	No	是否加密連接 (預設: true)
`password`	Yes	密碼
`port`	No	連接埠號 (預設: 1433)
`server`	Yes	MSSQL 伺服器位址
`trustServerCertificate`	No	是否信任伺服器憑證 (預設: false)
`user`	Yes	使用者名稱

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "database": {
      "description": "資料庫名稱 (可選)",
      "type": "string"
    },
    "encrypt": {
      "default": true,
      "description": "是否加密連接 (預設: true)",
      "type": "boolean"
    },
    "password": {
      "description": "密碼",
      "type": "string"
    },
    "port": {
      "default": 1433,
      "description": "連接埠號 (預設: 1433)",
      "type": "number"
    },
    "server": {
      "description": "MSSQL 伺服器位址",
      "type": "string"
    },
    "trustServerCertificate": {
      "default": false,
      "description": "是否信任伺服器憑證 (預設: false)",
      "type": "boolean"
    },
    "user": {
      "description": "使用者名稱",
      "type": "string"
    }
  },
  "required": [
    "server",
    "user",
    "password"
  ],
  "type": "object"
}

Install Server

HTTP connection URL

Other Tools from MSSQL MCP Server

Related Tools

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/NakiriYuuzu/Mssql-Mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server