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 |
Capabilities
Features and capabilities supported by this server
| 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 | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/dhipskind253/mssql-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server