MSSQL MCP Server

MIT License

Overview InspectNew Schema Related Servers Reviews Score

get_relationships

Identify foreign key relationships between tables in a SQL Server database using connection strings or named connections. Simplify database schema analysis and management with this tool.

Instructions

Get foreign key relationships between tables in the database

Input Schema

Name	Required	Description
`connectionName`	No	Named connection to use (e.g., 'production', 'staging')
`connectionString`	No	SQL Server connection string (uses default if not provided)
`schema`	No	Schema name (default: dbo)

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"
    },
    "schema": {
      "description": "Schema name (default: dbo)",
      "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/c0h1b4/mssql-mcp-server'

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