ai_report
No security coverage
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"