ReportBurster v13: Meet Your AI Crew

ReportBurster was born as a report distribution and automation engine. That's our pedigree — splitting, routing, personalizing, and delivering documents at scale. It's what we do best, and it's still the core of everything we build.

Our users have always told us the same thing: "It was so easy to automate and email our reports — just a few configurations and it was done."

That simplicity is still there. It always will be.

But now we're aiming bigger. What if you could surface real-time business KPIs on a live dashboard your customers actually use? What if setting up a complete invoicing workflow — sending bills through a custom web portal, accepting payments, tracking delivery stats in real time — could feel almost as simple as emailing payslips? That's the goal. We give you the tools, and the AI Crew walks you through the rest.

That's the thinking behind ReportBurster v13: you can't build the best report automation solution without giving you a great all-around data and business intelligence platform. Report generation, self-service portals, embeddable analytics, OLAP engines — when all of these come together in one coherent system, it becomes possible to fully automate the complete data-to-delivery pipeline.

No SaaS lock-in. No glue code between five different tools. No manual handoffs. Just a single workflow from raw data to the right document in the right inbox.

It All Starts With the Data

Your databases. Your data sources. The schemas, relationships, and business logic hiding inside them. Truly understanding that data — what it means, how it connects, where the value lives — is equivalent to knowing exactly which document flows to automate, when to trigger them, and how to deliver them.

That understanding is hard to get on your own. It takes time, context, and expertise across multiple domains.

That's why v13 gives you a team to work with. Enter the AI Crew.

The AI Crew — The Oracles of Ancient Greece

v13 ships with a council of domain-expert AI agents — each one has deep knowledge on a specific area of the platform:

• Athena — ReportBurster Guru & Data Strategist. Work with her to explore your schema, tackle queries together, co-design reports, or plan a data warehouse architecture. She leads the crew.
• Hephaestus — Backend & Automation specialist. Pair with him on ETL pipelines, job scheduling, and cron workflows — he guides you through the plumbing so you stay in control of your data flows.
• Hermes — Portal advisor & Web specialist. Collaborate with him on self-service document portals, admin panels, and analytics dashboards — he empowers you to build the interfaces your users actually need.

Not the kind of AI where you ask a question, get an answer, and start all over next time. They're (almost) teammates. Athena, Hephaestus and Hermes all remember your projects, learn about you and your preferences, and get sharper with every conversation. The more you work with them, the more personalized and useful they become. Chat with them from the built-in web app, or connect through your favorite desktop and mobile chat clients.

No other reporting tool has anything like this.

Chat2DB — Understand Your Data Through Conversation

The best way to understand something is to have a conversation with it. Chat2DB lets you do exactly that with your databases.

Connect to PostgreSQL, MySQL, SQL Server, Oracle, SQLite, DuckDB, ClickHouse, and more — then start chatting. Every question you ask deepens your understanding of the data, and that understanding is what turns a vague automation idea into a precise, well-designed workflow.

Athena recognizes your database, identifies the schema, and is ready to pair with you. Want to understand the structure? Ask for an entity-relationship diagram and explore it together.

Now ask a business question: "Show me our top 3 customers."

Athena helps you craft the SQL, runs it against your database, and walks you through the results — with row counts, execution times, and syntax-highlighted query blocks you can review, tweak, and reuse.

Want a visualization? Just ask. "Show me a pie chart for those top three."

Follow-up questions work naturally. Refine queries, request different chart types, drill deeper into the data — all inside the same conversation thread. No context switching. No copying SQL between tools.

Ready to level up? Work with Athena to build a pivot table over your OLAP data warehouse:

This is what "AI-powered data exploration" should actually feel like.

OLAP Analytics — From Thousands to Billions of Rows

v12 gave you embeddable charts and dashboards. v13 gives you the engines to power them at any scale.

Two new OLAP engines:

• DuckDB — Fast in-process analytics. Runs server-side, aggregates locally, sends only results to the browser. Ideal for datasets up to ~10 million rows. Perfect for instant pivot tables and charts without any external infrastructure.

• ClickHouse — Columnar OLAP built for billions of rows. When your data outgrows DuckDB, ClickHouse handles real-time analytics at enterprise scale. Launch it from the Starter Packs UI alongside a CDC (Change Data Capture) sink connector that automatically replicates data from your OLTP databases into ClickHouse in real time.

The Complete ETL Pipeline

Raw transactional data is useful. Properly modeled analytical data is powerful.

v13 integrates dbt Core with the dbt-clickhouse adapter to transform the raw OLTP data replicated into ClickHouse into a proper star schema — staging views, dimension tables, fact tables, and analytical views.

A sample Northwind dbt project is included out of the box:

• Staging views for raw source tables
• Dimension tables: dim_customer, dim_product, dim_employee, dim_time
• Fact table: fact_sales
• Analytical views: vw_sales_detail, vw_monthly_sales

Run it with a single command: docker compose run dbt-transform run

CDC handles Extract + Load. dbt handles Transform. That's a complete, self-hosted data warehouse — no Snowflake invoice, no Databricks subscription, no SaaS middleman.

Your Data Stays Yours

This hasn't changed and never will.

AI works with schema metadata — table names, column names, relationships. Your actual data rows never leave your systems. Athena generates SQL; your database engine executes it. The two never interact directly.

The code is open source. Have your security team read every line.

Try v13

Download ReportBurster and have it running in five minutes:

• QuickStart Guide — zero to first report
• AI Crew Documentation — meet the oracles
• Data Exploration — chat with your databases
• BI Analytics — OLAP engines and embeddable dashboards