analyze_data_distribution

Analyze column data distribution patterns in SQL Server tables to assess data quality and identify trends, supporting informed decision-making and database optimization.

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