Enterprise Edition
Natural language queries require Aicser Enterprise Edition. See the Self-Hosting Guide to deploy EE, or use the cloud version at app.aicser.com.
Natural Language Queries
In Enterprise Edition, you can ask questions about your data in plain English. Aicser translates the question into SQL, executes it against your data source, and generates a chart.
How it works
- You type a question — for example: "Show me monthly sales by region for this year"
- Aicser sends the question and your database schema to Azure OpenAI
- The AI generates SQL based on your schema and question
- Aicser executes the SQL against your data source
- The result is used to generate a chart
The AI sees your schema (table names, column names, types) but not the data itself.
Writing effective questions
Questions work best when they are specific:
| Instead of | Try |
|---|---|
| "Show me sales" | "Show total sales by month for 2024" |
| "Revenue trends" | "Show monthly revenue for the last 12 months as a line chart" |
| "Compare regions" | "Compare total orders by region as a bar chart" |
You can specify time periods ("last quarter"), aggregations ("total", "average"), groupings ("by region"), and chart types ("as a pie chart").
AI model
EE uses Azure OpenAI. Configure the model in your environment — see AI Configuration.