db_inspect
Inspect PostgreSQL and Odoo database schemas, list modules and tables, and compare before/after states to identify migration risks and promotion readiness.
Instructions
Introspect PostgreSQL & Odoo enterprise databases and compare schema states.
Actions:
'list': Enumerate allowlisted target databases and active disposable rehearsal copies.
'overview': Database size, largest tables, module counts, and problem indicators.
'modules': List installed Odoo modules with version, status, and code existence.
'table': Structure of one table: columns, data types, nullability, defaults, indexes.
'compare': Diff before vs after databases with risk findings and promotion verdict.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"action": "<action>"
},
"name": "db_inspect"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db | No | Database name (target or vmcp_ copy) | |
| after | No | Post-migration database for compare | |
| major | No | Major version filter (e.g. '17') | |
| state | No | Module state filter | |
| table | No | Table name for action='table' | |
| action | Yes | ||
| before | No | Pre-migration database for compare | |
| code_missing | No | Filter modules missing code | |
| exact_counts | No | Compute exact table row counts in compare |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||