Schema | mssql-mcp

mssql-mcp

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

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.

Features and capabilities supported by this server

Protocol revision2025-11-25

Capability	Details
`tools`	{ "listChanged": true }

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 `aws sso login` to recover from an expired session, or after the secret has been rotated.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

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