Data Quality & Profiling

Analyze NULL value distribution across columns. Shows which columns have high NULL percentages and identifies data quality issues.

Find columns with enum-like behavior (limited distinct values) and show value frequencies. Useful for understanding categorical data and identifying c...

Profile a column's data distribution: min, max, avg, median, distinct count, null percentage, and most frequent values. Replaces writing multiple anal...

Generate comprehensive data quality report including duplicates, NULLs, constraint violations, and referential integrity. One-stop analysis for data q...

Validate that all constraints (CHECK, NOT NULL, UNIQUE, FOREIGN KEY) are satisfied. Finds rows that violate constraints.

Get compact, token-efficient database schema description optimized for AI text-to-SQL. Returns tables with columns, types, relationships, and sample v...

Find orphaned foreign key references - rows that reference non-existent parent rows. Critical for data integrity validation.

Find duplicate rows based on specified columns. Returns groups of duplicates with counts. Essential for data quality audits and cleanup.

Detect statistical outliers in numeric columns using IQR (Interquartile Range) or z-score methods. Useful for data quality analysis and anomaly detect...