MSSQL MCP Server

connect-database

Connect to an MSSQL database server by providing server address, user credentials, and optional settings like encryption and database name to establish secure database interactions.

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