MS SQL Server MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MSSQL_PORT | No | Port number for the SQL Server connection | 1433 |
| MSSQL_USER | Yes | SQL Server authentication username (e.g. sa) | |
| MSSQL_SERVER | Yes | Localhost or Remote IP/Hostname of the MS SQL Server instance | |
| MSSQL_ENCRYPT | No | Whether to encrypt the connection (true/false) | true |
| MSSQL_DATABASE | No | Default database name to connect to | master |
| MSSQL_PASSWORD | Yes | SQL Server authentication password | |
| MSSQL_TRUST_SERVER_CERTIFICATE | No | Whether to trust the server certificate (true/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 |
|---|---|
| mssql_test_connectionB | Test connection to MS SQL Server and retrieve server version and metadata. |
| mssql_list_databasesC | List all online databases on the MS SQL Server. |
| mssql_list_tablesB | List all tables and views in a specified MS SQL database. |
| mssql_describe_tableA | Get table metadata including columns, data types, nullability, max length, and primary keys. |
| mssql_execute_queryA | Execute a T-SQL query (SELECT, INSERT, UPDATE, DELETE, EXEC) on the MS SQL database. |
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 5 tools
Each tool has a clearly distinct purpose: testing connectivity, listing databases, listing tables/views, describing schema, and executing arbitrary queries. There is no meaningful overlap between the metadata exploration tools and the general query execution tool.
All tools follow the same mssql_<verb>_<noun> pattern using snake_case. The names are predictable and make the action and target of each tool immediately clear.
Five tools is a well-scoped size for a database-focused MCP server. Each tool covers a distinct aspect of SQL Server interaction without unnecessary duplication or bloat.
The toolset covers the core database workflow: connection verification, database discovery, table discovery, schema inspection, and arbitrary query execution. The execute_query tool effectively fills gaps for any DML, DDL, or EXEC operations not explicitly wrapped.