system-promptlisted

# System Prompt Editor — DBX Studio ## Prompt Locations There are **two** system prompts in this project: ### 1. Streaming Prompt (main, used in production) **File**: [apps/api/src/routes/ai-stream.ts](../../../apps/api/src/routes/ai-stream.ts) **Lines**: ~132–172 (with schema) and ~176–202 (without schema) **Variable**: `contextPrompt` (built inline, not a constant) ### 2. oRPC Provider Prompt (used in `callAnthropicWithTools`, `callOpenAIWithTools`) **File**: [apps/api/src/orpc/routers/ai/providersWithTools.ts](../../../apps/api/src/orpc/routers/ai/providersWithTools.ts) **Variable**: `SYSTEM_PROMPT_WITH_TOOLS` (top of file) ## Current Prompt Structure (Streaming) ``` You are a SQL assistant... ## Tools Available ← list 5 tools ## Response Style ← 5 rules: be direct, show results, use tools, minimal explanation, SQL format ## Examples ← 2-3 concrete input/output examples ## Context ← dynamic schema from generateSQLPrompt() Schema: "<schema>" ## User Query ← the actual user message ``` ## Prompt Design Rules for DBX Studio 1. **Results first** — answer the question before showing SQL 2. **Use tools always** — never guess schema or data 3. **Be concise** — this is a data tool, not a chatbot 4. **Show SQL only when asked** — use ```sql blocks with uppercase keywords 5. **Format numbers clearly** — "**1,247 orders**" not "1247" ## When Editing the Prompt - Keep the `## Tools Available` section in sync with actual tools in `tools.ts`