Read time: ~5 minutes · Series: Analyst getting started · Previous: Why it can't stay in chat · Next: Plan → Execute → Report
The one-line distinction
| Mode | When | Deliverables | Status bar |
|---|---|---|---|
| Quick Analysis | No focused project; quick exploration, one-off validation | Conversation + SQL tabs (optional export) | Quick Analysis |
| Project Analysis | A project is focused; you need Plan review and a formal Report | Plan + SQL + Report | Project Focused / Planning / Executing |
Both share the same IDE, the same tables, and the same Agent—the difference is whether you have a "plan contract + Execute gate + Report delivery."
Quick Analysis: what it's for
Good for:
- "What values does this table's
statushave?" - "Try last 30 days of GMV, and check the NULL ratio while you're at it"
- "Write me a PIVOT—I'll check whether the syntax is right"
- Analysis still diverging, metrics not yet settled
You'll see: the Agent creating SQL tabs, running queries, and explaining results in the conversation. You can watch every step in real time (if you chose foreground-related behavior).
You won't have: the Approve & Execute button in the Plan toolbar—because you haven't yet entered the "approved formal analysis plan" flow.
Common pitfall: asking in Quick "make me a full funnel report for the weekly meeting" while expecting the Execute / Report flow. You should create a project and focus it, or choose Project Analysis when the Agent confirms the mode with you.
Project Analysis: when it enters automatically
Any one of the following conditions enters project mode:
- A project is focused (the eye icon on the project row in the sidebar turns green)—the Agent no longer asks Quick or Project
- When nothing is focused, you chose Project Analysis for a "data analysis request"
- Complexity rises during a Quick session, and the Agent may suggest upgrading to a project
The full path: take the question → explore → draft Plan → you annotate and revise → you press Execute → the Agent runs SQL step by step → produces a Report.
When nothing is focused: the Agent asks first
If you haven't focused a project but make a data-analysis-type request (e.g., "analyze the retention trend," "find the reasons for order drop-off"), the Agent asks first:
- Quick Analysis — query directly in the IDE and give results in the conversation
- Project Analysis — create a project, write a Plan, you review, then Execute, and finally a Report
When it won't ask about the mode: pure SQL syntax, feature explanations, explaining an error message—the Agent answers directly.
Choosing Quick doesn't mean "low-grade"; choosing Project doesn't mean "it must be slow." What you're choosing is whether to lock the metrics and delivery into project files.
Execution modes
Quick Analysis (no project)
After choosing Quick Analysis, the Agent asks once more how to run it (pick one of three):
| Mode | Experience |
|---|---|
| Foreground automatic analysis | Watch the Agent create SQL tabs in real time |
| Background agent analysis | Queries run in the background, results mainly in the conversation; doesn't touch the editor |
| Hybrid mode | Mostly background, switching to foreground for key steps |
Plan Executing (inside a project)
After a Plan enters Executing, the Agent reads the Plan first, then asks once more how to run it (pick one of two; separate from Quick's background option):
| Mode | Experience |
|---|---|
| Foreground automatic analysis | Core steps and Pipeline stages all create SQL tabs |
| Hybrid mode | Non-Pipeline steps mostly use run_query in the conversation; Pipeline stages still create SQL tabs |
This only affects how it runs after Execute; it does not replace the rule that "Execute must be pressed by you." If you press Continue after an interruption, it won't re-ask the execution mode.
Decision table (analyst edition)
| Your situation | Recommendation |
|---|---|
| Need a number within 5 minutes, metrics still being tried | Quick |
| Due at the weekly meeting, metrics will be questioned | Focus a project → Project |
| Already wrote 5 SQL queries in Quick and realize you need a Report | Create and focus a project, move the logic into the Plan if needed |
| Just asking about DuckDB syntax | Ask directly, no need to create a project |