jeecgboot/jimureport
Jimureport
JimuReport is an open-source reporting and dashboard engine designed to be embedded directly into Spring Boot applications. Its core identity centers on generating data reports and full-screen dashboards from natural language descriptions, eliminating the need for manual design. The platform also provides a conversational query interface that translates plain-language questions into database queries, returning results as tables and charts without requiring SQL knowledge.
What distinguishes JimuReport is its integration of AI skills that can be installed with a single command, enabling report and dashboard generation from a sentence or even a screenshot. These skills work with any OpenAI-compatible large language model, including local instances like Ollama. Beyond AI generation, the platform offers a drag-and-drop, Excel-like web designer for building complex reports with cell properties, grouping, and formulas, alongside a grid-based dashboard layout system for creating interactive data visualizations with 28 chart types, map components, and drill-down capabilities.
The platform connects to over 30 database types and imports data from Excel, CSV, and JSON files, allowing reports and dashboards to pull from multiple sources within a single view. It supports role-based access control, data tenant isolation, and token-based authentication through extension hooks that integrate with the host application's security system. Reports can be exported to Excel, PDF, Word, or image formats, and dashboards automatically adapt for mobile display.
JimuReport is distributed as a Java library that integrates into existing Spring Boot 2 or 3 projects through a single Maven or Gradle dependency, with configuration options for LLM connections, file storage backends, and query parameter defaults.
Features
- Natural Language Report Generations - Generates data reports and dashboards from natural language descriptions without manual design.
- Full-Screen Dashboard Generations - Creates full-screen dark-themed data dashboards from a single natural-language description.
- Charts and Visualization - Offers 28+ chart types including bar, line, pie, scatter, radar, map, and gauge charts configurable via drag-and-drop.
- Dashboard Layouts - Offers a drag-and-drop canvas with 28+ chart types, map components, and a grid-based layout for creating real-time data visualizations.
- Report Designers - Provides an Excel-like web designer where users drag and drop fields and components to build reports with live preview.
- Conversational Query Interfaces - Translates natural language questions into database queries using a configured semantic data domain and business terminology.
- Conversational Data Analysis Tools - Answers plain-language questions about data with tables, charts, and insights without writing SQL.
- Dynamic Data Source Connectors - Queries over 30 database types and imports Excel, CSV, and JSON files to populate reports and dashboards.
- Multi-Source Data Aggregation - Integrates with relational databases, NoSQL stores, big data engines, and file-based datasets for cross-source queries.
- Multi-Source Data Integration - Supports over 30 data source types including SQL, NoSQL, CSV, and cloud databases.
- Data Visualization Charts - Creates charts and graphs from SQL or API data sources, supporting 28 chart types for data analysis.
- Natural Language Querying - Accepts plain-language questions, translates them into database queries, and returns results as tables and charts.
- Report Configuration Compilations - Translates plain-language descriptions into structured report configurations using an AI model and a semantic data domain.
- Data Visualization Dashboards - Provides a drag-and-drop canvas for assembling professional data dashboards without coding.
- Database Connectivity - Connects to over 30 relational, NoSQL, and cloud databases for data source configuration.
- Federated Data Query Engines - Queries over 30 database types and imports Excel, CSV, and JSON files through a unified connection manager.
- Multi-Database Connections - Connects to dozens of relational, NoSQL, and cloud databases including MySQL, Oracle, PostgreSQL, and MongoDB.
- AI Skill-Triggered Report Generations - Generates reports, dashboards, or card-style dashboards from natural-language commands or screenshots via AI skills.
- Report Data Set Managers - Connects to SQL, API, JavaBean, JSON, and shared data sources to supply data for reports.
- Natural Language Dashboard Assemblers - Generates full-screen data dashboards from a single natural-language description, handling layout and data binding automatically.
- Data Injection Filters - Injects the logged-in user's account code into SQL queries to restrict report data per user.
- Spring Boot Integrations - Embeds the reporting engine into an existing Spring Boot 2 or 3 application by adding a single Maven or Gradle dependency.
- Embeddable Engines - Integrates into existing Spring Boot applications as a dependency for self-hosted reporting capabilities.
- Natural Language Builders - Creates full-screen data dashboards from a single sentence, handling layout, charts, and data binding automatically.
- Excel-Like Report Designers - Provides a web-based WYSIWYG editor with cell properties, merged cells, and multi-sheet support for report layout.
- Interactive Dashboards - Builds full-screen data dashboards with drag-and-drop layout, auto-generated components, and live data binding.
- Dashboard - Positions dashboard components on a 24-column grid or fixed canvas with pixel-level control for full-screen displays.
- Report Designers - Supports grouped, cross-tabulated, and detailed reports with subtotals, totals, conditional queries, and expressions.
- Dashboard Builders - Provides a Word-like web designer where users freely drag and arrange components to create custom, visually rich data dashboards.
- Report Generation Skill Installations - Installs AI-powered skills that enable natural-language report and dashboard generation from a single command.
- Semantic Data Domain Assistants - Binds a semantic data domain to a chat interface and publishes it for end users.
- OpenAI-Compatible Backend Configurators - Configures the AI assistant to use any large language model that exposes an OpenAI-compatible API, including local Ollama instances.
- Screenshot-Based Report Recreations - Rebuilds reports by recognizing table structure, fields, and styles from provided images or screenshots.
- Report Generation Skill Installations - Installs a Claude Code skill that creates a full-screen data dashboard from a single sentence.
- Geographic Map Visualizations - Displays geographic data using scatter, flow, bar, heat, and region map components for location-based analysis.
- Token and Permission Hooks - Integrates with host system authentication and authorization through extension interfaces for login, roles, and data access.
- Spreadsheet Report Exports - Exports completed reports and dashboards as Excel, PDF, Word, or image files for distribution.
- Precision Report Printers - Supports custom print templates with margins, orientation, headers, footers, and overlay printing.
- Report Configuration Generations - Generates complete report configurations by interpreting plain-English descriptions of desired layout and data.
- Report Generations - Produces data reports, charts, or detail tables from plain-language descriptions without manual design.
- Live Data Source Connectors - Configures multiple data sources for a dashboard and keeps displayed data synchronized in real time.
- Chat-Based Dashboard Modifications - Modifies existing dashboards through natural-language change requests via an API without manual editing.
- Grid-Based Prompt Dashboards - Assembles light-themed dashboards with card-style widgets on a 24-column grid from plain-language requests.
- Database Connection Managers - Registers and tests connections to multiple database types, storing credentials with AES encryption.
- Data Tenant Isolators - Separates data per tenant so each tenant sees only its own records, preventing cross-tenant data leaks.
- File-Based Data Import - Loads data from Excel, CSV, and JSON files as a data source for report generation.
- Semantic Data Domain Configurations - Defines a bounded analytical scope by registering tables, field roles, joins, and query themes for AI.
- Report Drill-Down Navigators - Lets users click a chart element to reveal a more detailed breakdown of that data point.
- Hierarchical Row Grouping - Arranges rows into hierarchical groups based on a chosen field and computes subtotals for each group.
- Dashboard Iteration Commands - Modifies an existing dashboard's layout, chart type, axis labels, or style by describing the change in natural language.
- Multi-Chart Type Libraries - Offers a library of chart types including bar, line, pie, radar, and map for representing different data patterns.
- Request Token Validators - Validates a token on each request to control login access and enforce role or permission checks.
- Role-Based Access Controls - Manages user authentication, token validation, and data-level permissions to secure report access by role.
- Data Access Permission Configurators - Controls data access through role-based permissions, row-level filters, column masking, and sensitive-word blocking.
- Terminology Definitions - Links colloquial terms and synonyms to precise metric definitions for accurate natural language queries.
- Report Generation Skill Plugins - Installs natural-language report generation capabilities as modular plugins that interface with OpenAI-compatible LLMs.
- Automatic Layout Arrangements - Uses a 24-column grid system to place cards, charts, and tables in optimal widths and rows based on component type.
- Dashboard Data Filters - Places a form with date, dropdown, and text inputs above the dashboard to refresh all linked components when submitted.
- Mobile Adaptations - Automatically adapts reports and dashboards for mobile device display without separate development.
- Chart Embedding - Includes 28 chart types such as bar, line, pie, radar, and map that can be placed directly into report cells.
- Property Editors - Sets cell coordinates, dimensions, content type, padding, grouping, hyperlinks, and calculation behavior in a single interface.
- Dashboard Layouts - Positions components by exact pixel coordinates on a fixed 1920×1080 canvas and applies a dark theme with decorative borders and accents.
- Dashboard Component Linking - Connects a chart, map, or form to other components so clicking one automatically refreshes the others with related data.
- Responsive Dashboards - Renders dashboards as web pages that adapt to different screen sizes and devices without rework.
- Multi-Source Combiners - Combines fields from separate datasets into a single report by linking them on a common key.
- Printable - Supports print-specific layouts including background printing and overlay printing for forms and labels.
- Report Layout Configurators - Configures report-level settings including background images, overlay printing, borders, and export options.
- Template Data Binding - Links report cells to data sources using field variables, system variables, and aggregate functions.
