superset

Apache Superset does that. Connect it to your database, write SQL or use the visual query builder, and create shareable dashboards.

It handles most common databases (Postgres, MySQL, BigQuery, Snowflake, ClickHouse) and the chart library is extensive. Apache project, used by Airbnb, Lyft, and others in production.

The catch: self-hosting Superset is where it gets real. Versioning is a beast. It is very easy to fall out of compliance with updates before you realize it. The Docker setup works but keeping it maintained takes genuine ops effort. And the learning curve for non-technical users is steeper than paid alternatives like Metabase or Looker.