AI Experience Enhancement (Make It “Wow”)

[dory-finn]

AI Experience Enhancement (Make It “Wow”)

Background

Dory already has AI capabilities, but the current experience feels like an add-on to SQL rather than a core feature.

Users may not immediately feel the value of AI.

Goal

Create a clear “wow moment” within the first interaction.

User types one sentence → Gets meaningful result instantly

Proposal

1. AI First Entry

• Show an input in empty state:
  • “Ask anything about your data”
• Encourage natural language instead of SQL

2. One-Click Result

After user asks:

• Generate SQL automatically
• Execute it
• Show results (table + chart if applicable)

3. Context-Aware AI

• Use schema (tables, columns) as context
• Prefer queries on existing data (especially demo data)

4. Suggested Prompts

Provide clickable examples:

• “Show error logs in the last 24 hours”
• “Top users by order amount”
• “Average response time by service”

5. Explain + Iterate

• Show generated SQL
• Allow user to refine:
  • “Filter only errors”
  • “Group by day”

Expected Outcome

• Users understand AI value instantly
• Less need to write SQL manually
• Strong differentiation from traditional SQL tools