Skip to main content
Glama

MSSQL MCP Server

by NakiriYuuzu

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MSSQL_PORTNoMSSQL server port1433
MSSQL_USERYesYour MSSQL username
MSSQL_SERVERYesYour MSSQL server address
MSSQL_ENCRYPTNoWhether to use encryption for the connectiontrue
MSSQL_PASSWORDYesYour MSSQL password
MSSQL_TRUST_SERVER_CERTIFICATENoWhether to trust the server certificatefalse

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
connect-database

連接到 MSSQL 資料庫伺服器

list-databases

列出伺服器上的所有使用者資料庫

switch-database

切換到指定的資料庫

list-tables

列出目前資料庫中的所有資料表

describe-table

查看指定資料表的欄位結構

execute-query

執行 SQL 查詢語句

connection-status

檢查目前的資料庫連接狀態

disconnect

斷開資料庫連接

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