How toufiqfarhan0/orvexa works
Orvexa is a PostgreSQL migration safety platform. Its principal workflow takes an operator’s SQL through deterministic analysis, isolated rehearsal, human approval, controlled execution, and post-execution verification. The graph also includes database inspection, MCP access, and the agent/briefing integration described in the README. Sampled excerpts establish several service responsibilities and wiring points; where implementation details were not sampled, the graph preserves documented capabilities without asserting uncertain calls.
Main entry points: migrations.route.ts Migration routes · migration-rehearsal-workflow.service.ts Rehearsal workflow · session.repository.interface.ts Session repository · app.ts HTTP application
Components 20
Operator interface
- Migration console
apps/web/src/pages/MigrationConsolePage.tsx - API client
apps/web/src/services/migration-api.service.ts - HTTP application
apps/server/src/app.ts - Migration routes
apps/server/src/routes/migrations.route.ts
Migration lifecycle
- Migration analysis
apps/server/src/services/migration-analysis.service.ts - Risk analyzer
apps/server/src/analyzer/services/migration-analyzer.service.ts - Rehearsal workflow
apps/server/src/rehearsal/services/migration-rehearsal-workflow.service.ts - Approval gate
apps/server/src/approval/services/approval.service.ts - Live execution
apps/server/src/execution/services/live-migration-execution.service.ts
Database safety
- Postgres inspection
apps/server/src/db/services/postgres-inspection.service.ts - Disposable PostgreSQL
apps/server/src/rehearsal/adapters/disposable-postgres.adapter.ts
Agent integrations
- Sandbox adapter
apps/server/src/sandbox/adapters/trueforge-sandbox.adapter.ts - MCP server
apps/server/src/mcp/schemasentry-mcp.server.ts - Gemini release brief
apps/server/src/trueforge/services/gemini-brief.service.ts
Session state
- Session service
apps/server/src/services/migration-session.service.ts - Session repository
apps/server/src/repositories/session.repository.interface.ts - In-memory sessions
apps/server/src/repositories/in-memory-session.repository.ts
Other components
- DBA / agent
- Target PostgreSQL
- TrueForge / Daytona
Connections 22
- DBA / agent → Migration console: submits SQL
- Migration console → API client: requests lifecycle
- API client → HTTP application: calls API
- HTTP application → Migration routes: mounts API
- Migration routes → Migration analysis: dispatches analysis
- Migration analysis → Risk analyzer: analyzes SQL
- Migration routes → Rehearsal workflow: dispatches rehearsal
- Rehearsal workflow → Sandbox adapter: checks capability
- Sandbox adapter → TrueForge / Daytona: dispatches sandbox
- Rehearsal workflow → Disposable PostgreSQL: provisions and inspects
- Rehearsal workflow → Postgres inspection: checks target unchanged
- Postgres inspection → Target PostgreSQL: reads catalog
- Migration routes → Approval gate: dispatches approval
- Migration routes → Live execution: dispatches execution
- Live execution → Target PostgreSQL: executes and verifies
- MCP server → Postgres inspection: inspects database
- HTTP application → MCP server: mounts MCP
- Session service → Session repository: loads and saves
- Session repository → In-memory sessions: implemented by
- Approval gate → Session repository: loads and saves
- Rehearsal workflow → Session repository: saves evidence
- Live execution → Session repository: loads and saves