mcp-mssqlserver
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MSSQL_HOST | Yes | SQL Server host or IP | localhost |
| MSSQL_PORT | No | SQL Server TCP port | 1433 |
| MSSQL_USER | Yes | SQL login user | |
| MSSQL_ENCRYPT | No | Enables encrypted connection | false |
| MSSQL_DATABASE | Yes | Default database | |
| MSSQL_PASSWORD | Yes | SQL login password | |
| MSSQL_TRUST_SERVER_CERTIFICATE | No | Trusts server certificate when encryption is enabled | true |
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 |
|---|---|
| execute_queryA | Executa uma query SQL no SQL Server e retorna os resultados. Use para SELECT, INSERT, UPDATE e DELETE. |
| list_tablesA | Lista todas as tabelas do banco de dados atual, opcionalmente filtrando por schema. |
| describe_tableB | Retorna a estrutura de uma tabela: colunas, tipos de dados, nulabilidade e valores padrão. |
| list_databasesA | Lista todos os bancos de dados disponíveis no servidor SQL Server. |
| get_table_indexesB | Lista os índices de uma tabela, incluindo colunas e tipo de índice. |
| get_foreign_keysC | Lista as chaves estrangeiras de uma tabela e suas referências. |
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 6 tools
Each tool has a clearly distinct purpose: describing table structure, executing arbitrary queries, listing foreign keys, indexes, databases, and tables. No overlap or ambiguity.
All tool names follow a consistent verb_noun pattern using snake_case (e.g., describe_table, get_foreign_keys, list_databases), making them predictable and easy to understand.
With 6 tools, the set is well-scoped for a SQL Server utility server, covering essential introspection and query execution without being overly numerous or sparse.
The tools cover core database introspection (list databases, tables, describe table, get indexes/foreign keys) and query execution. Missing advanced features like schema management or stored procedure execution, but these are minor gaps for typical usage.