Reporting AI
Natural language to SQL reporting module enabling conversational data queries, saved reports, and database schema browsing.
Features
- Chat Interface - Conversational AI assistant for generating reports via natural language with session management
- Natural Language Queries - Ask questions in plain English, get data-driven answers
- Saved Reports - Save frequently used queries as reports for quick re-execution
- Run Reports - Re-run saved reports to get updated data
- Query History - Browse previous queries and their results
- Schema Browser - Explore the database schema to understand available data
Requirements
| Requirement | Details |
|---|---|
| Dependencies | AICore |
| PHP Version | 8.2+ |
| AI Provider | At least one AI provider configured in AI Core |
Installation
Enable via Admin Panel
- Log in as administrator
- Navigate to Settings > Addons
- Find Reporting AI and click Enable
Enable via Command Line
php artisan module:enable ReportingAI
php artisan migrate
note
AI Core must be installed and enabled with at least one AI provider configured before enabling this module.
Usage
Dashboard
Access Reporting AI at /reporting-ai/. The dashboard provides an overview of recent queries and saved reports.
Chat Interface
Access the chat at /reporting-ai/chat. Features include:
- New Session - Create a new reporting-focused chat session
- Send Messages - Ask data questions in natural language and receive AI-generated results
- Session History - Load messages from previous sessions
- Delete Session - Remove chat sessions
Queries
Browse your query history at /reporting-ai/queries to review past questions and results.
Saved Reports
Manage saved reports at /reporting-ai/saved-reports:
- Save Report - Save a useful query as a named report
- Run Report - Re-execute a saved report to get fresh data
- Delete Report - Remove saved reports that are no longer needed
Schema Browser
Explore the database schema at /reporting-ai/schema-browser to understand what tables and fields are available for querying. This helps you formulate better questions for the AI.
Safety Features
- Read-Only Queries - Only SELECT statements are generated
- Query Validation - AI-generated SQL is validated before execution
Notes
- The AI generates SQL queries from natural language and executes them against your database
- Complex queries may require multiple iterations to refine
- All queries are logged for audit purposes
- The schema browser helps users understand what data is available for reporting
Changelog: View version history