MSSQL MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MSSQL_DANGER_MODE | No | Danger mode - allows most operations (use with caution!) | false |
| MSSQL_ALLOW_DELETE | No | Allow DELETE operations | false |
| MSSQL_ALLOW_INSERT | No | Allow INSERT operations | false |
| MSSQL_ALLOW_UPDATE | No | Allow UPDATE operations | false |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| connect-databaseC | 連接到 MSSQL 資料庫伺服器 |
| list-databasesB | 列出伺服器上的所有使用者資料庫 |
| switch-databaseC | 切換到指定的資料庫 |
| list-tablesB | 列出目前資料庫中的所有資料表 |
| describe-tableC | 查看指定資料表的欄位結構 |
| execute-queryC | 執行 SQL 查詢語句 |
| connection-statusB | 檢查目前的資料庫連接狀態 |
| disconnectB | 斷開資料庫連接 |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 8 tools
Each tool has a clearly distinct purpose with no ambiguity. Tools like connect-database, disconnect, and connection-status handle connection management separately from data operations like execute-query, list-tables, and describe-table. The separation between list-databases and list-tables is also well-defined, preventing misselection.
All tools follow a consistent verb_noun naming pattern with hyphens (e.g., connect-database, execute-query, list-tables). There are no deviations in style or convention, making the tool set predictable and easy to understand at a glance.
With 8 tools, the server is well-scoped for database operations. Each tool earns its place by covering essential functions like connection management, database navigation, and query execution without being overly complex or sparse. This count aligns well with typical MCP server ranges.
The tool set provides strong coverage for core MSSQL operations, including connection lifecycle, database listing, table exploration, and query execution. A minor gap exists in lacking explicit CRUD operations (e.g., insert, update, delete), but agents can work around this using execute-query for custom SQL, keeping the surface functional for most workflows.