Open Source Google Looker Studio Alternatives

Redash exists so the one person who writes SQL is not a bottleneck for everybody else. SQL users explore, query and visualize data from any connected source, and their work turns into dashboards and shareable URLs that colleagues without technical training can read and act on.

Everything happens in the browser. A query editor with a schema browser and auto-complete handles both SQL and NoSQL sources, visualizations are assembled by drag and drop and combined into a single dashboard, and every action available in the interface is exposed through a REST API as well.

Beyond writing queries, the parts teams lean on are operational.

• Scheduled refreshes: Charts and dashboards update automatically at intervals you define.
• Alerts: Conditions on query results fire the moment the underlying data changes.
• Sharing: Visualizations travel with their queries, so reports and the SQL behind them can be peer reviewed.
• Data sources: More than 35 connectors span warehouses, relational databases, NoSQL stores and plain files.
• Extensibility: The data source API accepts new connectors when a system is not covered yet.

That built-in list runs from Athena, BigQuery, Redshift, Snowflake and Databricks through PostgreSQL, MySQL, SQL Server and Oracle to Elasticsearch, MongoDB, Prometheus, Google Sheets, CSV files and shell scripts. Setup documentation covers running your own instance, including ready-made AWS and Google Compute images.

Chartbrew is an open source web application that connects directly to databases and APIs and builds charts from what it finds there. It removes the export-to-spreadsheet detour that usually sits between a live data source and a chart anyone actually looks at.

Work happens in a chart builder backed by a query and request editor, so a SQL statement or an HTTP request becomes a visualization without leaving the app. Dashboards are editable, charts can be embedded elsewhere, and team capabilities let more than one person work on the same project.

Running it yourself involves a short list of requirements.

• Prerequisites: Node.js 22 or newer, MySQL 5 or PostgreSQL 12.5, and Redis 6.
• Local setup: clone the repository, run the setup script, fill in the environment variables, then start client and server in separate terminals.
• Docker: an image is built on every release and configured entirely through environment variables.
• Encryption key: a 32 byte AES key has to be generated and supplied before the application will start.
• Queue dashboard: the BullMQ admin view is behind HTTP basic auth, with a username and password you set yourself.

A one-click droplet on the DigitalOcean marketplace handles deployment for anyone who would rather not assemble the pieces, and a hosted Chartbrew service is available too. The documentation site carries the quickstart, the environment variable reference and the current list of supported data sources, which grows faster than any README could track.

Frappe Framework made building custom apps easy and getting information back out of them hard, and Insights was written to close that gap. It is a fully open source business intelligence tool aimed at making analysis and reporting reachable for people who do not write SQL, not only for the ones who do.

Queries are built step by step through an interface that lets you select tables, add joins, apply filters and perform calculations. Underneath, Ibis composes the SQL through a dataframe API, Frappe UI supplies the Vue-based interface, eCharts draws the results, and the Frappe Framework carries the full stack.

The tool comes down to a handful of pieces.

• Multiple sources: data from several databases, files and spreadsheets lands in one place so interconnected data can be analyzed together.
• Query builder: a step-by-step interface builds queries without any SQL knowledge.
• Visualizations: results render as charts, with the best chart for a given result set suggested automatically.
• Dashboards: a drag-and-drop layout, with filters that apply across every chart on it.
• Database support: MySQL, PostgreSQL, DuckDB and BigQuery today, with more integrations planned.

Production setup runs an easy install script that deploys a Docker stack for a given site name and domain, after which server scripts are enabled with one bench command and the admin password is written to a local file. Development uses Docker Compose with an init script. Frappe Cloud offers managed hosting for teams who would rather not operate it, and a live demo is available before committing to either path.