Drupal is a registered trademark of Dries Buytaert
cms 2.1.3 Update released for Drupal core (2.1.3)! drupal 10.5.11 Update released for Drupal core (10.5.11)! drupal 11.3.11 Update released for Drupal core (11.3.11)! drupal 11.2.13 Update released for Drupal core (11.2.13)! drupal 10.6.10 Update released for Drupal core (10.6.10)! cms 2.1.2 Update released for Drupal core (2.1.2)! drupal 11.1.10 Update released for Drupal core (11.1.10)! drupal 10.5.10 Update released for Drupal core (10.5.10)! drupal 10.4.10 Update released for Drupal core (10.4.10)! drupal 11.2.12 Update released for Drupal core (11.2.12)! drupal 11.3.10 Update released for Drupal core (11.3.10)! drupal 10.6.9 Update released for Drupal core (10.6.9)! drupal 10.6.8 Update released for Drupal core (10.6.8)! drupal 11.3.9 Update released for Drupal core (11.3.9)! drupal 11.3.8 Update released for Drupal core (11.3.8)! drupal 11.3.7 Update released for Drupal core (11.3.7)! drupal 11.2.11 Update released for Drupal core (11.2.11)! drupal 10.6.7 Update released for Drupal core (10.6.7)! drupal 10.5.9 Update released for Drupal core (10.5.9)! cms 2.1.1 Update released for Drupal core (2.1.1)!

ai_report

No security coverage
View on drupal.org

AI Report

Query your Drupal database using natural language - no SQL knowledge required!

Warning: This is a work in progress!

How it works

  1. Ask a question in plain English (e.g., "Show me all articles created this month")
  2. The AI generates and executes the SQL query for you
  3. 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

  1. Enable the module: drush en ai_report -y
  2. Assign permissions at: People → Permissions
    • Access AI Reports: For users who will generate reports
    • Administer AI Reports: For administrators only
  3. Configure at: Configuration → AI → AI Report
  4. 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"

Activity

Total releases
1
First release
Dec 2025
Latest release
5 months ago
Release cadence
Stability
0% stable

Releases

Version Type Release date
1.0.x-dev Dev Dec 3, 2025