Skip to content

AI Commands (ask, chat, models)

LEAI transforms your Oracle database catalog into an interactive knowledge base capable of answering complex engineering and business logic questions directly from your terminal.

1. leai ask <QUESTION>

Answers one-off natural language queries about database architecture, tables, procedures, and business rules with surgical context injection.

leai ask "What is the business rule inside CALC_TERMINATION and which tables does it query?" -p gemini

Parameters and Flags:

Parameter / Flag Type Default Description
QUESTION Argument Required Natural language question regarding database logic or schema.
-p, --provider TEXT Option From config AI provider (openai, gemini, claude, deepseek, ollama, etc.).
-m, --model TEXT Option From config Target model identifier.
-c, --config PATH Option leai.yml Path to leai.yml.
--seaweed Flag False Resolves metadata from remote S3 bucket.
--no-cache Flag False Operates in 100% remote mode without local files.

2. leai chat

Launches an advanced interactive terminal console styled with Catppuccin Mocha themes, persistent conversation history, dynamic contextual autocompletion, real-time reasoning streaming (reasoning tokens), and autonomous tool calling with live execution feedback.

# Terminal interactive copilot:
leai chat -p gemini -m gemini-2.0-flash

# Run with local model via Ollama:
leai chat -p ollama -m qwen2.5-coder:7b

# Launch and open Web Chat Studio directly in browser:
leai chat --web

Parameters and Flags:

Parameter / Flag Type Default Description
-p, --provider TEXT Option From config Active AI provider (gemini, openai, claude, ollama, etc.).
-m, --model TEXT Option From config Target AI model identifier.
-c, --config PATH Option leai.yml Path to configuration file.
-w, --web Flag False Launches Web Studio server and opens chat in browser.
--seaweed Flag False Resolves metadata from remote S3 storage.
--no-cache Flag False Runs purely in memory.

✨ Modern Terminal Features (TUI):

  • 🏷️ Smart Autocompletion with Prefixes:
  • Type @ to autocomplete Oracle catalog tables, packages, procedures, and views with type icons (📋 Table, 📦 Package, ⚙️ Procedure, 👁️ View, ⚡ Trigger, 🔢 Sequence, 🔗 Synonym).
  • Type # to reference business rules and domain definitions from the glossary (glossary.yml).
  • Type / to browse and autocomplete available slash commands.
  • 🧠 Real-time Reasoning Streaming (Reasoning Traces):
  • Native support for thinking models (e.g., DeepSeek-R1, Gemini 2.0 Flash Thinking, Qwen 2.5).
  • Displays a collapsible box with the model's live chain-of-thought prior to the final response.
  • Use /thoughts on or /thoughts off to toggle thought visibility.
  • ⚡ Visual Tool Execution Cards:
  • Displays animated spinners and real-time execution duration for each tool invoked during investigation rounds (⚡ search_database_objects (0.34s)).
  • 📊 Dynamic Bottom Status Toolbar:
  • Permanently shows the active provider, model, connected schema, thought streaming status (thoughts:on/off), and help shortcut (help:/?) at the bottom of the terminal.
  • ⌨️ Multiline Keybindings & Editing:
  • Enter: Sends prompt to the AI agent.
  • Alt+Enter or Ctrl+J: Inserts a newline for writing long SQL queries or multi-line instructions without triggering submission.
  • Ctrl+C or Ctrl+D: Cancels current input or exits session.

📋 In-Session Slash Commands:

Command Category Description
/tune [sql] Optimization Analyze & tune SQL queries identifying sargability issues, FTS, index ordering & anti-patterns.
/validate [sql] Validation Validate strict Oracle SQL/PL-SQL dialect compliance (detecting MySQL/PostgreSQL constructs).
/thoughts [on\|off] Reasoning Toggle real-time streaming display of AI reasoning/thinking trace.
/provider [name] AI Config Switch active AI provider with dynamic autocompletion.
/model <p> [m] AI Config Switch AI provider and model at runtime.
/models [p] AI Config List all available AI models returned by provider API.
/workflow <name> <obj> Workflows Execute autonomous pipelines (impact, refactor, reverse-procedure / reverse).
/agent <role> <task> Multi-Agent Execute specialized subagents (catalog, plsql, lineage, patch, doc).
/trace <obj> Lineage Perform inline dependency lineage & impact X-ray with Mermaid.
/copy [all\|code\|N] Clipboard Copy last AI response or specific code block directly to OS clipboard.
/doc [obj] Documentation Open interactive in-terminal YAML annotation & documentation editor.
/rule [list\|add\|del\|find] Glossary Manage global business rules, canonical domain filters & SeaweedFS sync.
/enrich [obj] AI Studio Auto-enrich business descriptions & rules with LLM.
/compile [obj] Pipeline Compile final Markdown docs in docs/ (supports single object).
/annotate [-W] Pipeline Synchronize YAML annotation stubs in annotations/ and/or SeaweedFS.
/extract [s\|d\|-W] Pipeline Connect to Oracle and extract fresh raw metadata snapshot.
/update [h\|d\|-W] Pipeline Fast incremental delta update for modified objects, annotations & S3.
/seaweed [status\|push\|pull\|sync] SeaweedFS Check SeaweedFS S3 status, push, pull, or bi-directional sync.
/serve [port\|stop] Web Studio Launch interactive Web Studio with in-browser editor & real-time sync.
/git [status\|pull\|sync] GitOps Check Git commit status, pull updates, or sync metadata with remote.
/tables Inspection List all tables with column counts and primary keys.
/schema [s] Inspection Show comprehensive overview of all catalog objects.
/changes [d] Inspection Inspect database objects modified in last N days (Default: 7).
/audit [last\|session\|export] Audit & Logs Inspect AI tool call trace, latency & session audit log.
/tools Audit & Logs Quick viewer for last turn's tool execution inputs/outputs.
/save [file.md] Session Export current conversation transcript to Markdown.
/doctor Diagnostics Run pre-flight health checks across Oracle, AI, Storage, Git, and directories.
/init Setup Initialize or update the leai.yml configuration file.
/clear Session Clear conversation memory and reset terminal screen.
/exit, /quit Session Exit LEAI interactive copilot.

3. leai models

Tests credentials, lists available models returned by provider APIs, and benchmarks roundtrip REST latency.

leai models -p gemini
leai models -p openai
Parameter / Flag Type Default Description
-p, --provider TEXT Option All Filters by specific provider.
-c, --config PATH Option leai.yml Path to leai.yml.