mssql-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| AWS_REGION | Yes | AWS region the secret is in (e.g. us-east-1). Also picked up by the AWS SDK as its default region. | |
| SECRET_NAME | Yes | The Secrets Manager secret name (no ARN suffix needed). | |
| AWS_ACCOUNT_ID | Yes | The AWS account where the secret lives. Combined with name + region into a full ARN. | |
| TRUST_SERVER_CERTIFICATE | No | Skip TLS cert validation to the SQL Server. Accepts true/false/1/0/yes/no. Set true only if you understand why. | 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 | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_schemasA | List user-defined schemas in the configured database. |
| list_tablesB | List tables, optionally filtered by schema. |
| describe_tableA | Return columns, data types, nullability, identity, primary key, and defaults for a table. |
| list_indexesB | List indexes on a table, one row per (index, column). |
| list_foreign_keysC | List foreign keys originating from a table. |
| list_viewsC | List views, optionally filtered by schema. |
| get_view_definitionC | Return the SQL definition of a view. |
| list_proceduresB | List stored procedures, optionally filtered by schema. |
| get_procedure_definitionA | Return the SQL definition of a stored procedure. (Definitions are read-only — this server cannot EXEC procedures.) |
| sample_rowsA | Return up to N rows from a table (SELECT TOP N *). Default 10, max 100. |
| run_selectA | Run a single SELECT or WITH (CTE) statement. DML/DDL/EXEC are rejected before reaching the server. Results are capped at max_rows (default 100, hard max 1000). |
| refresh_secretA | Re-fetch the database credentials from AWS Secrets Manager and reconnect. Call this after running |
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 12 tools
Each tool has a clearly distinct purpose: listing metadata (tables, views, schemas, procedures, indexes, foreign keys), retrieving definitions, running SELECT queries, sampling rows, and refreshing credentials. No two tools can be confused.
All tool names follow a consistent verb_noun pattern in snake_case, e.g., 'describe_table', 'list_procedures', 'run_select'. There are no deviations or mixed conventions.
12 tools is appropriate for a database exploration and querying server. The set covers all common operations without being excessive or sparse.
The tool surface is nearly complete for read-only database interaction: metadata listing, definition retrieval, SELECT querying, and sampling. Minor gaps include absence of database-level listing or system views, but the core use case is well-covered.