Skip to main content
Glama

Microsoft SQL Server MCP Server (MSSQL)

test_connection

Verify database connectivity and retrieve basic server details for Microsoft SQL Server using a connection string or named connection, ensuring seamless integration with AI assistants and IDEs.

Instructions

Test the database connection and return basic server information

Input Schema

NameRequiredDescriptionDefault
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
connectionStringNoSQL Server connection string (uses default if not provided)

Input Schema (JSON Schema)

{ "$schema": "http://json-schema.org/draft-07/schema#", "additionalProperties": false, "properties": { "connectionName": { "description": "Named connection to use (e.g., 'production', 'staging')", "type": "string" }, "connectionString": { "description": "SQL Server connection string (uses default if not provided)", "type": "string" } }, "type": "object" }

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

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