AI Chat Assistant - Introduction

WhoDB's AI Chat Assistant revolutionizes database interaction by letting you use natural language instead of SQL. Ask questions in plain English, and the assistant generates accurate queries, executes them, and presents results in an intuitive format.

What is the AI Chat Assistant?

The AI Chat Assistant bridges the gap between human language and database queries. Instead of remembering SQL syntax, table names, or join conditions, you simply describe what you want to know.

Key Capabilities

How It Works

The AI Chat Assistant follows a simple workflow:

Who Should Use the AI Assistant?

Complete Beginners

Never written SQL before? The AI assistant is perfect for you:

• No SQL knowledge required
• Learn by seeing how questions translate to queries
• Explore databases without fear of making mistakes
• Get immediate results without syntax errors

Data Analysts

Speed up your analysis workflow:

• Generate complex aggregations in seconds
• Explore data relationships naturally
• Create ad-hoc reports without writing SQL
• Focus on insights, not query syntax

Developers

Accelerate development tasks:

• Quickly understand unfamiliar database schemas
• Test queries before implementing in code
• Debug data issues in development and production
• Prototype features without writing boilerplate SQL

Database Administrators

Simplify routine tasks:

• Run diagnostics with natural language commands
• Generate reports for stakeholders
• Validate data integrity
• Perform maintenance queries efficiently

Example Interactions

Simple Data Retrieval

You: "Show me all users"

Assistant: "Here are all the users in the database."

Result: Interactive table with all user records

---

You: "Find users created in the last week"

Assistant: [Generates and executes appropriate date filter query]

Result: Filtered user list with recent signups

Complex Analysis

You: "Count users by email domain"

Assistant: "Here's the user count by email domain."

Result: Aggregated data showing domain distribution

---

You: "Show average order value by month for the last year"

Assistant: [Generates query with date grouping and aggregation]

Result: Monthly revenue analysis table

Data Modification

You: "Delete user with id 5"

Assistant: [Generates the DELETE statement and shows an inline confirmation alert in the chat. You can view the SQL behind a toggle, then click Confirm or Cancel.]

You: [Click Confirm]

Result: "Action Executed - DELETE"

The same inline confirmation applies to all data modifications and schema changes (INSERT, UPDATE, DELETE, CREATE, ALTER, DROP).

Supported AI Providers

WhoDB supports multiple AI providers, giving you flexibility based on your needs:

Model lists are fetched live from each provider when you add it, so the available models always reflect your provider's current lineup.

Privacy and Security

Data Privacy Considerations

Security Features

• Confirmation Required: All data modifications and schema changes (INSERT, UPDATE, DELETE, CREATE, ALTER, DROP) require explicit confirmation
• Read-Only Mode: Can be configured with read-only database users
• Permission Aware: Respects your database user permissions

Getting Started

Ready to use the AI Chat Assistant? Follow these steps:

AI Assistant Features Overview

Core Features

• Natural Language Understanding: Ask questions conversationally
• Schema Awareness: Knows your tables, columns, and relationships
• SQL Generation: Creates optimized, database-specific queries
• Result Display: Interactive tables with full functionality
• Error Handling: Clear explanations when queries fail

Advanced Features

• Conversation Context: Follow-up questions build on previous queries
• Multi-Turn Dialogues: Complex analysis through iterative refinement
• SQL Code View: Toggle between results and generated SQL
• Scratchpad Integration: Move queries to Scratchpad for refinement
• Query History: Navigate through previous questions with keyboard shortcuts
• Chat Sessions: Keep multiple conversations in a chat history sidebar and switch between them

Data Operations

• SELECT Queries: Retrieve and analyze data
• Aggregations: COUNT, SUM, AVG, MIN, MAX automatically applied
• Filtering: WHERE conditions from natural language
• Sorting: ORDER BY inferred from context
• Joins: Multi-table queries generated correctly
• Data and Schema Modifications: INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP with confirmation

Use Case Examples

Comparison: Traditional SQL vs. AI Assistant

The AI assistant eliminates syntax memorization and reduces the time from question to insight.

Limitations

While powerful, the AI assistant has some limitations:

Best Practices

Key practices for effective AI assistant use:

1. Be Specific: Clear questions get better results
2. Provide Context: Mention table names when ambiguous
3. Verify SQL: Review generated queries for important operations
4. Use Confirmation: Take advantage of modification confirmations
5. Leverage Context: Build on previous questions in conversation
6. Move to Scratchpad: Save useful queries for reuse

Learn more best practices →

Next Steps