PostgreSQL performance dashboard for analyzing database cluster health, identifying problems, and providing optimization recommendations.
Query Analysis · Index Analysis · Table Analysis · Foreign Key Analysis · Maintenance & Vacuum · Connections & Locks · I/O · Progress Tracking · Settings Analysis · Schema Checks · Health Score · Log Search (Yandex Cloud) · Authentication & Authorization · Infrastructure · User Preferences · Auto-snapshots · MCP connector
The full list with details: doc/en/features.md.
Create dasha.yaml (searched in ., $HOME/.dasha/, /etc/dasha/):
clusters:
- name: production
username: monitoring_user
password: secret
port: 5432
databases:
- myapp
hosts:
- pg-master.example.com
- pg-replica-1.example.comRun with the pre-built images:
cd deploy/compose
# Edit dasha.yaml with your cluster settings
docker compose up -d
# Open http://localhost:3000Everything else — service discovery, log search, schema checks, authentication, snapshot storage — is optional and documented in Configuration.
To see Dasha against a live workload, make demo-lab starts several PostgreSQL clusters with
streaming replication, an OIDC provider and a load generator: Demo Lab.
| Document | Contents |
|---|---|
| Features | Full capability list by domain |
| Architecture | Components, data flows, technology stack |
| Configuration | dasha.yaml, service discovery, log search, schema checks |
| Authentication | none / token / OIDC modes, RBAC, personal access tokens |
| Snapshots | Snapshot storage and the auto-snapshot daemon |
| Deployment | Docker Compose, images, Helm chart |
| MCP connector | dasha-mcp — read-only diagnostics for AI assistants |
| Development | Local run, demo lab, project layout, code generation, CI/CD |
| Health Score model | Formula, weights, all rules and thresholds |
Russian translation: doc/ru/ — except the Health Score model, which keeps its own root-level file, README-health-score.ru.md.
See CHANGELOG.md for release notes.
The SQL behind Schema Checks is derived from db_verifier
(MIT, © 2024 Nikonov — licence text in the project's LICENSE file), a set of structural checks for
PostgreSQL. Per-template attribution: backend/internal/query/README.md.
The lock tree query comes from postgres_dba
(BSD 3-Clause, © 2017 Nikolay Samokhvalov) — sql/l2_lock_trees.sql, adapted to run as a single
statement without psql version branches. Licence text:
backend/internal/query/LICENSE-postgres_dba.
Index bloat estimation descends from pgsql-bloat-estimation
(BSD-style — the PostgreSQL licence, © 2015-2019 Jehan-Guillaume (ioguix) de Rorthais; licence text in the
project's LICENSE file).