Dasha - performance dashboard

Dasha is an open source performance dashboard for PostgreSQL fleets. It connects to your clusters
with a read-only role, shows what the databases are doing right now, and explains what to do about
it. Nothing is installed on the database hosts: no agent, no extension beyond the ones you already
have.

One instance serves many clusters and all of their replicas. Because most PostgreSQL statistics are
per-instance and are *not* replicated, Dasha reads every host of a cluster and reasons over the
combined picture — an index that looks unused on the primary may be serving the entire read
workload on a standby.

---

## Features

* **Health Score** — a composite 0-100 score per instance across eight categories, with
prioritized recommendations and per-database drill-down. Optionally computed from
Prometheus/VictoriaMetrics time series instead of point-in-time SQL, with a trend and seasonal
baseline.
* **Query analysis** — top queries by execution time and WAL, running and blocked queries, and
`pg_stat_statements` snapshots that can be saved to a storage database, shared by URL, and
diffed against another snapshot or against live data.
* **Automatic snapshots** — a separate daemon captures query and lock-contention snapshots on
activity spikes or primary/replica role changes, so the evidence exists the next morning, when
someone asks what happened at 03:00.
* **Index analysis** — bloat, duplicates, invalid indexes, B-tree on arrays, plus a *may I drop
this index?* verdict that accounts for statistics resets, per-host counters and partitioned
indexes, instead of trusting `idx_scan = 0`.
* **Tables and maintenance** — size with TOAST breakdown, per-table describe, autovacuum and
wraparound thresholds computed with PostgreSQL's own formula, vacuum progress, and hot
tables/indexes derived from scheduled delta snapshots.
* **Locks, waits, connections** — lock trees, wait events grouped by type, connection states and
sources, active session details.
* **Access control** — three auth modes (open, static API keys, or OIDC with encrypted session
cookies), Casbin RBAC, personal access tokens and per-identity rate limiting.
* **MCP connector** — a read-only [MCP](https://modelcontextprotocol.io) server that exposes the
fleet diagnostics to AI assistants: 26 tools, 5 prompts, per-user token passthrough, and an
embedded knowledge base of the scoring rules.
The interface is available in English, Russian and German.

## Requirements

* **PostgreSQL 14 or newer** (tested on 14-18) for the monitored clusters, reachable with a role
holding `pg_monitor` and `CONNECT`.
* `pg_stat_statements` for query statistics; `pgstattuple` is optional.
* A separate PostgreSQL database if you want snapshots, hot-object history and personal access
tokens — everything else works without it.

## Documentation

* [README](https://github.com/dbulashev/dasha/blob/main/README.md) — configuration, deployment, Helm values.
* [Health Score scoring model](https://github.com/dbulashev/dasha/blob/main/README-health-score.md)
* [Changelog](https://github.com/dbulashev/dasha/blob/main/CHANGELOG.md)

## License

Dasha is licensed under the **GNU General Public License v3.0**; see
[LICENSE](https://github.com/dbulashev/dasha/blob/main/LICENSE).

Project page: [github.com/dbulashev/dasha](https://github.com/dbulashev/dasha)