Extraction, Compilation & Lineage Commands

This section details the primary commands responsible for reverse engineering, impact analysis, and Markdown documentation generation in LEAI.

1. leai (or leai generate)

Executes the end-to-end pipeline: Oracle metadata extraction, business annotation synchronization, and final Markdown compilation.

leai
# or with specific flags:
leai -s HR -t tables -t packages --depth 2 --rag-json

Parameters and Flags:

2. leai extract

Connects to the Oracle database configured in dsn and extracts data dictionary catalog definitions into raw JSON files.

leai extract
# Incremental extraction of objects modified in the last 30 days:
leai extract --days 30

Parameters and Flags:

3. leai update

Performs surgical incremental updates: connects to Oracle, extracts only objects modified recently (in the last N hours or days), merges them into the consolidated catalog, synchronizes annotation stubs, and pushes the delta to SeaweedFS in seconds.

# Update objects modified in the last 4 hours and push delta to SeaweedFS:
leai update --hours 4 -W

# Update objects modified in the last day and recompile Markdown docs:
leai update -d 1 -W -C

[!IMPORTANT] Preservation of Comments & Glossary: leai update merges metadata with existing annotations (local and remote in SeaweedFS). All previously documented descriptions, business rules, and column comments are 100% preserved; only stubs for newly discovered columns are added. Furthermore, when SeaweedFS is active (-W), the global business glossary (annotations/glossary.yml) is automatically merged and synced to the central bucket.

Parameters and Flags:

[!TIP] In the interactive copilot session (leai chat), use /update [hours|days] [-W] [-C] (e.g. /update 4h -W) to refresh in-memory catalog data in real time!

4. leai annotate

Generates or synchronizes business annotation YAML files under ./annotations/<SCHEMA>.yml.

leai annotate

[!NOTE] This command is strictly non-destructive. It combines newly discovered technical schemas with existing annotations, guaranteeing that previously written human descriptions are never overwritten. When executed with --seaweed, it also synchronizes and merges the global glossary annotations/glossary.yml with central storage.

Parameters and Flags:

[!TIP] You can also run /annotate directly from an interactive copilot session (leai chat), with support for /annotate --seaweed (or -W) and /annotate --no-cache modifiers to synchronize stubs without leaving your terminal workflow.

5. leai doc <OBJECT>

Opens the interactive documentation editor right in your terminal for a specific object (table, view, package, etc.).

leai doc EMPLOYEES
leai doc PKG_BILLING

Allows developers and DBAs to update business descriptions and column notes with keyboard navigation, saving directly to local YAML and offering 1-click Markdown recompile. Can also be invoked inside the interactive chat via /doc <OBJECT>.

6. leai enrich

Invokes the configured LLM to inspect DDLs and PL/SQL code, drafting automated business descriptions for undocumented entities.

leai enrich
# Force regeneration for a specific object:
leai enrich -o CUSTOMERS_TB --overwrite -p gemini

Parameters and Flags:

7. leai compile

Merges ./raw/ snapshots with ./annotations/ notes to generate clean Markdown documents under docPath.

leai compile --depth 2 --rag-json

Parameters and Flags:

8. leai trace <OBJECT>

Executes multi-level lineage tracing and automated risk evaluation on any database entity.

leai trace CONTRACTS_TB --depth 3 --offline --output ./dossier.md

Parameters and Flags: