| name | live_database_ingest |
| description | Capture semantic-layer and knowledge updates from a live database schema snapshot. |
| callers | ["memory_agent"] |
Live Database Ingest
Use this skill when the ingest work unit contains raw files under
raw-sources/<connectionId>/live-database/<syncId>/.
Workflow
- Read the table JSON file listed in the work unit.
- Read
connection.json to understand the snapshot metadata.
- Read
foreign-keys.json when the table has a foreign key or when joins are
needed for the semantic-layer source.
- Create or update one semantic-layer source for the table with
sl_write_source.
- Use the physical table name from the raw JSON as the source
table field.
- Preserve database comments as
descriptions.db on tables and columns.
- Add joins only when the foreign key index names both sides.
- Write wiki pages only for durable business meaning that is present in table
or column comments.
- Run
sl_validate for the table source before the work unit completes.
Sample values come from the scan record; do not invent values not present in
relationship-profile.json.
Identifier Verification Protocol
Before writing a wiki page or SL source on any topic:
discover_data({query: "<topic>"}) - see what wikis, SL sources, and raw
tables already exist. Prefer updating existing pages over creating new ones.
Before emitting any schema.table or into a wiki body,
SL source, frontmatter, , or :
