Detects 7 common GP plan anti-patterns (broadcast of large table,
redistribute of large table, hot node, nested loop with large outer,
large sort, spill to disk, stale row estimates, planning-heavy queries)
and surfaces them as summary.warnings[] with severity + evidence.
Raw plan and raw summary metrics are preserved so the agent can verify
each warning against the underlying numbers.
MCP stdio server for Greenplum 6.x query plan evaluation:
- explain_sql / explain_dbt_model tools
- read-only session enforcement + statement_timeout
- dbt compile integration
- all settings via env vars (no hardcoded defaults)
