analyze_data_distribution

Analyze data distribution patterns in SQL Server tables to assess data quality, identify trends, and optimize database performance without coding.

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