Skip to content

Evidence Metadata Migrations

Jump to bottom
Huzefaaa2 edited this page May 17, 2026 · 3 revisions

Evidence Metadata Migrations

CAVRA supports SQLite-backed evidence metadata search for self-hosted pilots.

Migration:

migrations/sqlite/001_evidence_metadata.sql
migrations/sqlite/002_approval_router.sql

Apply:

cavra evidence migrate --sqlite .cavra/evidence/metadata.db

The CLI records applied migration filenames in schema_migrations, so deployment automation can run the command repeatedly.

Run API:

CAVRA_EVIDENCE_METADATA_DB=.cavra/evidence/metadata.db uvicorn cavra.api:app --reload

Search filters: session_id, signer, min_blocked, has_approvals, limit, and offset.

CAVRA Field Compass
Before the agent acts, CAVRA asks: who is acting, what will change, what policy applies, and what evidence will prove it?
Start Build Operate Assure
Quick Start CLI Enterprise Guide AISPM
Reader Paths Policy Syntax Deployments Evidence
Community GUI Troubleshooting Conclusion
Textbook home: Before the Agent Acts | Development archive: development and testing artifacts | Source repository: github.com/Huzefaaa2/cavra

CAVRA Textbook

Chapters

  1. Foreword And Reader Paths
  2. Why CAVRA Exists
  3. Runtime Authority Model
  4. Architecture
  5. Editions
  6. Install And Deploy
  7. Community Guide
  8. Enterprise Guide
  9. CLI Reference
  10. GUI And Sandbox
  11. AISPM Guide
  12. Policy And Evidence
  13. Operations And Integrations
  14. Labs And Use Cases
  15. Appendices And FAQ
  16. Policy Language Reference
  17. Troubleshooting Playbook
  18. Conclusion

Practical Paths

Clone this wiki locally