mcp-server-mssql
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| LOG_LEVEL | No | Logging level (optional) | info |
| MSSQL_HOST | Yes | The MSSQL server host | |
| MSSQL_PORT | No | The MSSQL server port (default 1433) | 1433 |
| MSSQL_USER | Yes | The MSSQL user | |
| MSSQL_DRIVER | No | The ODBC driver name (optional) | |
| MSSQL_ENCRYPT | No | Whether to encrypt connection (optional, default true) | true |
| MSSQL_DATABASE | Yes | The MSSQL database name | |
| MSSQL_PASSWORD | Yes | The MSSQL password | |
| MSSQL_TRUST_SERVER_CERTIFICATE | No | Whether to trust server certificate (optional, default false) | 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
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_tablesC | Lists all tables in the database |
| get_table_schemaB | Gets the schema of a specific table |
| read_table_rowsB | Reads rows from a table with optional filtering and pagination |
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 3 tools
Each tool has a clearly distinct purpose: listing tables, getting schema, and reading rows. There is no ambiguity between them.
All tool names follow a consistent verb_noun snake_case pattern: list_tables, get_table_schema, read_table_rows.
With 3 tools, the server is slightly underpopulated but still reasonable for a focused read-only database schema and data access tool.
The server lacks essential database operations such as writing, updating, deleting rows, or running arbitrary SQL queries, making it incomplete for typical use cases.