I use Grafana for that. At the moment, we have developed entire internal products based on ClickHouse + Grafana.

There’s a community connector for metabase https://github.com/enqueue/metabase-clickhouse-driver

No, the results are embedded in a web app.