db_sync_knowledge
Copy database annotations from one connection to another, syncing only tables and columns present in the target schema. Reports skipped tables and warnings for missing columns.
Instructions
Copy annotations from one connection's knowledge store to another.
Typical use: after confirming that staging and prod share the same schema,
sync all the semantic knowledge you've built up in staging to prod.
Only syncs tables and columns that exist in the target schema cache —
tables missing from target are reported in 'skipped', columns in 'warnings'.
Args:
from_connection: Source connection (e.g. "orders.staging").
to_connection: Target connection (e.g. "orders.prod").
tables: Optional list of specific table FQNs to sync. Defaults to all.
Returns:
{synced: [...], skipped: [{table, reason}], warnings: [{table, column, reason}]}
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| from_connection | Yes | ||
| to_connection | Yes | ||
| tables | No |