Schema | MS SQL Server MCP Server

MS SQL Server MCP Server

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

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`	{}

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.

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/arsyadal/mssql-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server