analyze_data_distribution

Analyze column-level data distribution patterns in Microsoft SQL Server tables to assess data quality and identify trends. Specify table, schema, and optional column for targeted insights.

Instructions

Get data distribution patterns for columns to understand data quality and patterns

Input Schema

Name	Required	Description
`columnName`	No	Specific column to analyze (analyzes all if not provided)
`connectionName`	No	Named connection to use (e.g., 'production', 'staging')
`connectionString`	No	SQL Server connection string (uses default if not provided)
`sampleSize`	No	Sample size for analysis (default: 1000)
`schema`	No	Schema name (default: dbo)
`tableName`	Yes	Name of the table to analyze

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "columnName": {
      "description": "Specific column to analyze (analyzes all if not provided)",
      "type": "string"
    },
    "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"
    },
    "sampleSize": {
      "description": "Sample size for analysis (default: 1000)",
      "type": "number"
    },
    "schema": {
      "description": "Schema name (default: dbo)",
      "type": "string"
    },
    "tableName": {
      "description": "Name of the table to analyze",
      "type": "string"
    }
  },
  "required": [
    "tableName"
  ],
  "type": "object"
}

Microsoft SQL Server MCP Server (MSSQL)

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Microsoft SQL Server MCP Server (MSSQL)

Related Tools

MCP directory API