describe_table

Retrieve schema details for a specific table in Microsoft SQL Server, including column names, data types, and constraints. Use this tool to efficiently analyze table structures without writing SQL queries.

Instructions

Get detailed schema information for a specific table including columns, data types, and constraints

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)
`tableName`	Yes	Name of the table to describe

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"
    },
    "tableName": {
      "description": "Name of the table to describe",
      "type": "string"
    }
  },
  "required": [
    "tableName"
  ],
  "type": "object"
}

Microsoft SQL Server MCP Server (MSSQL)

describe_table

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Microsoft SQL Server MCP Server (MSSQL)

Related Tools

MCP directory API