mssql-mcp
by kevindump
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| HTTP_PORT | No | HTTP listen port | 3000 |
| MCP_TRANSPORT | No | Force stdio or http mode. If unset, auto-detects. | |
| DB_CONNECTIONS | Yes | JSON array of {name, host, port?, database, user, password} objects |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_databasesA | 列出此 MCP 服務已設定的所有資料庫連線名稱 |
| list_tablesA | 列出指定資料庫中所有的 TABLE 和 VIEW，包含欄位名稱、型別、是否可為 NULL |
| lookupA | 在指定的 TABLE 或 VIEW 中以關鍵字模糊搜尋（LIKE），最多回傳 100 筆 |
| query_sqlA | 執行自由 SELECT 語句查詢指定資料庫（僅允許 SELECT，禁止 INSERT/UPDATE/DELETE 等異動語法） |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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/kevindump/mssql-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server