analyze_data_distribution

Analyze column data distribution patterns in SQL Server tables to identify data quality issues and 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"
}

MSSQL MCP Server

analyze_data_distribution

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from MSSQL MCP Server

Related Tools

MCP directory API