Skip to main content
Glama

Microsoft SQL Server MCP Server (MSSQL)

list_constraints

Retrieve and filter all database constraints (check, unique, foreign key, primary key, default) across tables using a SQL Server connection. Specify schema and constraint type for targeted results.

Instructions

List all constraints (check, unique, foreign key, etc.) across tables in the database

Input Schema

NameRequiredDescriptionDefault
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
connectionStringNoSQL Server connection string (uses default if not provided)
constraintTypeNoFilter by constraint type (default: ALL)
schemaNoSchema 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" }, "constraintType": { "description": "Filter by constraint type (default: ALL)", "enum": [ "ALL", "CHECK", "UNIQUE", "FOREIGN_KEY", "PRIMARY_KEY", "DEFAULT" ], "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/dperussina/mssql-mcp-server'

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