Data Quality & Profiling

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

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

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

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

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

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

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...

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