Changes and migrations · stop 1 of 10
schema_diff
Compares two schemas in the same database.
Works in read modeTool sets: dba · full
You might ask
“What's different between public and staging?”
Your assistant may call schema_diff to answer.
How it works
- Returns table, column, constraint and index differences. Changes nothing.
Parameters
sourceSchemastringrequired- Name of the schema to treat as the baseline, e.g. "public".
targetSchemastringrequired- Name of the schema to diff against the baseline, e.g. "staging".
What your assistant reads
The description nexql-mcp sends with the tool. It's how the assistant decides when to use it.
Compare two schemas in the current database (or sourceSchema vs targetSchema). Returns structured table/column/constraint/index diffs. Read-only — does not apply changes.