Skip to content
Sign in Submit a tool
Open Report logo

Business intelligence

Open Report

Self-hosted open source reporting and dashboards with drag-and-drop, row-level security, and multi-database support

Open source alternative to Power BI and Looker Studio. Build interactive dashboards on your own infrastructure with drag-and-drop canvas, row-level security

Overview

Screenshot of the Open Report homepage

A look at openreport.io

Open Report is an open source reporting and data visualization platform that lets you build interactive dashboards on infrastructure you own. Connect your databases—PostgreSQL, MySQL, Google BigQuery, Azure SQL, DuckDB, or import CSV and Excel files—with a drag-and-drop canvas. The application queries your data locally; nothing leaves your servers.

Features include row-level security to control what each user sees, workspaces and team roles for collaboration, cross-filtering and drill-down interactions, multi-page reports, custom measures with SQL expressions, and 12+ visualization types including bar charts, line charts, pivot tables, gauges, and treemaps. Export reports to PDF, Excel, or PNG, and schedule recurring email delivery.

The self-hosted Community edition is free forever under the GNU AGPL-3.0 license with unlimited reports, users, and datasources. For those who prefer not to manage infrastructure, a managed Cloud option is available hosted on European infrastructure in France, with a free tier and paid plans offering higher file storage and more scheduled emails.

Built with React, Node.js, Express, and modern open source technologies, the entire codebase is readable, auditable, and forkable—ensuring no vendor lock-in and transparency.

Feature notes

  • Drag-and-drop canvas with multi-page layouts
  • Row-level security with glob patterns
  • Workspaces and team roles (Admin, Editor, Viewer)
  • Multi-database support (PostgreSQL, MySQL, Azure SQL, BigQuery, DuckDB)
  • Cross-filtering and drill-down interactions
  • Custom measures with SQL expression editor
  • 12+ visualization types including bar, line, pie, scatter, table, pivot, gauge, treemap
  • Scheduled email reports with configurable frequency
  • Export to PDF, PNG, Excel, or print
  • Theme customization with light/dark modes and color palettes

Pricing

Pricing model: Open source

Self-hosted Community: Free forever, unlimited reports, datasources, users, and all features. Cloud Free: €0/month with all Community features, 5 MB file uploads, 3 scheduled emails. Cloud Pro: €20/month with 200 MB file uploads, 20 scheduled emails. Cloud Enterprise: Custom pricing with 2 GB+ file

FAQ

Is Open Report really free?
Yes. The self-hosted Community edition is free forever under the GNU AGPL-3.0 with every feature, no user limit, and no expiring trial. The hosted Cloud is a separate optional service with a free tier and paid plans for those who prefer not to run a server.
How is it different from Power BI or Looker Studio?
You run it on your own infrastructure, and queries run locally against your databases without data leaving your servers. Pricing is not per seat, so adding readers costs nothing. The source code is readable and forkable, meaning the tool cannot be discontinued, re-priced, or feature-gated out from under you.
Which databases can it connect to?
PostgreSQL, MySQL, Google BigQuery, Azure SQL, and DuckDB. CSV and Excel files can be imported directly and are queried through DuckDB.
What do I need to self-host it?
Docker is required. A docker-compose.yml runs the published image as a single container on amd64 and arm64. A home server, NAS, or Raspberry Pi is sufficient. Alternatively, you can run it from source on a server with Node.js 22 or newer.
Can I use it at work or in a commercial product?
Yes. The AGPL-3.0 permits commercial use. The only obligation: if you modify Open Report and offer the modified version to others over a network, you must publish those modifications under the same license. Using it unmodified internally or with customers requires nothing of you.

Leave a review for Open Report

No reviews of Open Report yet. Run the first inspection.

Your rating

Reviews are free and are never paid for. Open the reviews

Reviews and notes · Change log · Share the profile · Maker of this product? Claim the profile · Report a fault

More on this profile

Open Report has a free listing. The owner can unlock the full profile with a paid launch for $5:

  • Founder story (locked)
  • Milestones (locked)
  • Demo video (locked)
  • Dofollow website link (locked)

Comparable tools

Help centre