db_detect_drift
Audit database annotations against live schema. Identify orphaned annotations and undocumented tables to maintain schema coverage.
Instructions
Audit saved annotations against the live database schema (read-only).
Surfaces drift after the schema evolves:
- orphaned annotations — a table or column you annotated that no longer
exists in the DB. Remove with db_forget, or db_deprecate if pending.
- undocumented tables — live tables with no annotation yet (coverage gaps).
Changes nothing — purely a report. Run after schema changes, or periodically.
Args:
connection: Connection name. Defaults to first defined.
Returns:
{connection, orphaned_tables, orphaned_columns, undocumented_tables,
undocumented_truncated, summary}
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection | No |