3.0 KiB
ThothII operating workflow
ThothII guides every question through eight phases. The model proposes the work, the reviewer makes decisions at gates, and the system records persistent artifacts and decisions.
flowchart LR
Q["Question"] --> F1["F1 Clarification"]
F1 --> F2["F2 Memory"]
F2 --> F3["F3 Rewriting"]
F3 --> F4["F4 Evidence"]
F4 --> F5["F5 Schema"]
F5 --> F6["F6 CTE plan"]
F6 --> F7["F7 SQL"]
F7 --> F8["F8 Promotion"]
F8 --> DONE["Finalized session"]
Workflow principles
- The model proposes; the reviewer approves, corrects, or rejects.
- The session ledger records every material decision.
- Persisted state is the source of truth.
- A phase advances only when its artifacts and gates are complete.
- Resume rebuilds context from persisted artifacts, not from the conversation.
F1: clarification
The system identifies the ambiguity most likely to change the meaning of the question and presents one decision at a time. Mutually exclusive interpretations use a single choice; multiple valid answers use a multiple choice.
F2: Memory
The system proposes Memory items that fit the question. Selected items enter the current session context; unselected items remain available for future questions.
F3: rewriting
The system rewrites the question explicitly using the approved clarifications. The reviewer checks the resulting question and its assumptions before continuing.
F4: Evidence
The system retrieves Evidence from the active corpus and presents citations and provenance. The reviewer decides which items apply to the question.
F5: schema
Tables, columns, relationships, and filters are linked to the approved meaning of the question. The summary closes the phase when the question, assumptions, and DWH elements are consistent.
F6: CTE plan
The query is broken into named CTEs with a purpose, dependencies, tables, filters, and output columns. The reviewer sees each step before the system produces the final SQL.
F7: final SQL
The system produces sql_final.sql, checks it against the approved plan, and presents the artifact
to the reviewer. A correction can reopen the CTE plan without discarding decisions that remain valid.
F8: Memory promotion
At the end of the session, the system proposes reusable Memory cards, including the approved solved question. The reviewer selects and edits the additions or updates to retain in the workspace's Memory archive, or declines them all. The session is then finalized.
Available gates
| Gate | Use |
|---|---|
| Single choice | Only one interpretation can be valid |
| Multiple choice | Several items can be valid at the same time |
| Artifact confirmation | Approval of a document or phase result |
| Phase confirmation | Explicitly closes a phase |
Resume and reopening
A resumed session returns to its last incomplete phase. Reopening invalidates only the decisions and artifacts that depend on the changed point; the rest of the work remains valid.