> ## Documentation Index
> Fetch the complete documentation index at: https://docs.korve.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Database advisor

> Review database performance, security, reliability, and cost findings with guarded remediation.

The production advisor scans a database and records findings with category, severity, evidence, and
a recommended action. History remains available after a finding is resolved or dismissed.

```bash theme={null}
korve advisor scan --database primary --data '{}'
korve advisor findings --database primary --severity critical
korve advisor preview --database primary <finding-id>
```

Where an automated fix is available, preview it first. Remediation requires explicit confirmation
and revalidates the finding and current authorization before applying the action.

```bash theme={null}
korve advisor remediate --database primary <finding-id> --yes
```

Findings are advice, not proof: inspect query plans and workload behavior before index or sizing
changes. See the [Advisor API](/api-reference/advisor).