Ai report
No security coverage
Ai ecosystem
AI Report allows you to query your Drupal database using natural language questions, which are then translated into SQL queries by an AI to display your data in tables. This module helps non-technical users access and understand their site's data without needing to write SQL.
AI Report
Query your Drupal database using natural language - no SQL knowledge required!
Warning: This is a work in progress!
How it works
- Ask a question in plain English (e.g., "Show me all articles created this month")
- The AI generates and executes the SQL query for you
- View your data in a formatted table
👇 See it in action below 👇
Features
- Natural language to SQL query generation
- AJAX-powered real-time results
- Security-first: Only SELECT queries allowed
- Configurable AI models and prompts
- Database structure and content type awareness
- Debug mode to view generated SQL and AI responses
Requirements
- Drupal 9, 10, or 11
- AI module
- Configured AI provider (OpenAI, Anthropic, etc.)
Quick Start
- Enable the module:
drush en ai_report -y - Assign permissions at: People → Permissions
- Access AI Reports: For users who will generate reports
- Administer AI Reports: For administrators only
- Configure at: Configuration → AI → AI Report
- Use at: Reports → AI Report
Example Questions
- "Show me the 10 most recent users"
- "List all published articles with their authors"
- "Find all content updated this week"
- "Count how many nodes of each type exist"