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

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
Compare and explore
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.
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
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
- IdeaCrystalDR 26 · 1 community vote
- SellerviewDR 46 · 1 community vote
- Taleshape™DR 38 · 0 community votes
- GoRulesDR 43 · 0 community votes
