Phoenix Lens is a mountable SQL notebook for Phoenix apps. Point it at your Ecto Repo, save questions, pin dashboards, and mask PII/PHI. Not Metabase. A PgHero-shaped tool you mount at /lens so you stop giving a sidecar dashboard a god-mode DB user. Optional DuckDB joins, MCP endpoint for agents, email/webhook alerts, and extra TOTP/passkey lock. Open source. Free. Just use it if you need it. GitHub: https://github.com/oivoodoo/phoenix_lens Hex: https://hex.pm/packages/phoenix_lens

Phoenix Lens is a mountable SQL notebook for Phoenix apps. Point it at your Ecto Repo, save questions, pin dashboards, and mask PII/PHI in every output (grid, CSV, embeds, audit). Not Metabase. A PgHero-shaped tool you mount at /lens so you stop giving a sidecar dashboard a god-mode DB user. Optional DuckDB for cross-source joins, MCP endpoint for agents, email/webhook alerts, and an extra TOTP/passkey lock. Open source. Free. Just use it if you need it. GitHub: https://github.com/oivoodoo/phoe... Hex: https://hex.pm/packages/phoenix_... built Phoenix Lens to give Phoenix teams a safer, self-hosted way to explore production data without granting a sidecar dashboard a god-mode database user. It keeps SQL notebooks, dashboards, and privacy controls close to the Phoenix app.

Phoenix Lens

Mountable SQL notebook for Phoenix with PII masking

Mountable SQL notebook for Phoenix with PII masking