Schema Optimizer

Purpose

Analyzes the schema for quality issues and suggests improvements. Identifies unused fields, misconfigured merge operations, missing mappings, identity resolution gaps, and PII exposure risks. Read-only analysis with actionable recommendations.

Environment

Requires authenticated API access. See ../references/auth.md for credential resolution.

Inputs

• Table (default: user)
• Optional focus area: unused-fields, coverage, identity, merge-ops, mappings, pii, or all

Analysis Flow

Run all checks (or a specific focus area), then present a unified report.

Step 1: Gather Data

Fetch the three core datasets in parallel: