Skip to content

Compare environments

Identify schema drift, missed table changes and dependencies that could affect a synchronisation or migration window. Guide-derived workflow; compare with the current six-tool MCP surface.

This is an operational workflow, not an additional callable MCP tool. See the six current tools.

Operator question

Which source and target differences need review before a sync?

The guide calls for comparing objects and reviewing schema drift, stored procedures and dependencies before cutover.

Context a call would need

  • Two named environments
  • Selected schemas or tables
  • Comparison scope and capture time

Evidence to return

  • Objects compared and differences found
  • Dependencies requiring investigation
  • A reproducible comparison record

Safety and availability

The current generate_table_migration tool compares supplied tables and returns destination migration SQL for review. It is not a general environment comparison tool and does not apply changes.

SQL table synchronisation guide