AI Query Assistant
The AI Query Assistant lets you describe what data you need in plain English, and it generates the SQL query for you.
Getting Started
- Click Data Bridge → New Query → AI Assistant
- Select your database connection
- Type your question in natural language
- Review the generated SQL
- Click Run Query
Example Prompts
| You Say | AI Generates |
|---|---|
| "Show all customers in California" | SELECT * FROM customers WHERE state = 'CA' |
| "Orders over $1000 from last month" | SELECT * FROM orders WHERE total > 1000 AND order_date >= DATEADD(month, -1, GETDATE()) |
| "Top 10 products by sales" | SELECT TOP 10 product_name, SUM(quantity) as total_sold FROM order_items GROUP BY product_name ORDER BY total_sold DESC |
Supported AI Providers
- Claude (Anthropic): Best overall accuracy and SQL quality
- GPT-4 (OpenAI): Excellent for complex queries
- Azure OpenAI: For enterprise environments with Azure requirements
Configuring AI
- Click Data Bridge → Settings → AI Configuration
- Select your preferred AI provider
- Enter your API key (stored securely in Windows Credential Manager)
- Click Test Connection
Privacy: Only your table/column names are sent to the AI provider to generate accurate queries. Your actual data is never transmitted.
Tips for Better Results
- Be specific: "orders from January 2024" vs "recent orders"
- Use column names when you know them
- Specify output format: "show customer name and total spend"