Automate Schema Migrations Safely
As a leader, you are accountable for the stability and integrity of your critical data systems, yet you face constant pressure to accelerate development. Database schema changes are often a major bottleneck and source of risk. Manual processes are slow and error-prone, while "schema drift" between the application and the database can lead to catastrophic production failures.
Voda answers your critical questions:
- "How do we stop our application code and database schema from silently drifting apart, causing production incidents?"
- "How can we automate our manual, ticket-based process for database schema updates without sacrificing safety and control?"
- "How do we ensure that a destructive change, like dropping a table, receives mandatory, human review before it ever reaches production?"
- "How do our auditors see a clear, version-controlled history of every database schema change that has ever been proposed and deployed?"
Key Business Values:
- Eliminate Schema Drift
- The application's ORM model becomes the single, verifiable source of truth for your database schema.
- Automate Schema Migrations Safely
- The tool automatically generates the precise SQL script needed to migrate the database and performs a built-in risk assessment on every change.
- Enforce Governance with Approval Gates
- The risk assessment allows you to build powerful, automated governance, halting pipelines for risky changes until a human provides approval.
- Create a Git-Based Audit Trail
- The tool commits the generated `migration.sql` and `risk-assessment.json` files back to the repository, creating a perfect, immutable, and auditable log of every change.
Embrace Your Existing ORM Workflow
Voda embraces your existing ORM workflow. You continue to define your schema using the tools you already know; the generator provides a powerful, governable engine to handle the migration. You don't need to learn any proprietary attributes or change how you code.
The ORM Fidelity Workflow
You don't need to learn any proprietary attributes. The tool reads the final model directly from your ORM's runtime or schema definition files.
GitOps for Database Changes:
- A developer modifies an ORM model and pushes the change in a Pull Request.
- The CI pipeline runs Voda in `generate` mode.
- The tool generates the precise SQL script and risk assessment and commits them to the developer's branch.
- The Pull Request now contains both the application code change and the exact, human-readable SQL migration artifacts for review.
A GitOps-Native, Deterministic Schema Engine
Voda is a containerized, environment-driven tool designed to bring safety and automation to database schema management. Its two-command design (`generate` and `execute`) provides a clear separation of concerns between CI and CD.
Execution Modes:
generate: The analysis and artifact creation mode. It inspects build artifacts, compares the ORM model to the live database, and generates `migration.sql` and `risk-assessment.json`. It does not modify the database.execute: The deployment-only mode. It takes a pre-generated `migration.sql` file, performs safety checks (like backups), and executes the script against the target database.serve-docs: Starts a lightweight web server to serve embedded tool documentation.
Licensing & Degraded Mode
If a valid license cannot be acquired, the `generate` command runs in Degraded Mode, performing only ORM model analysis and logging a summary to the console. The `execute` command requires a valid license and will fail if one cannot be acquired.
Auditing & Observability
The tool provides three layers of observability: Forensic Logging (`pipeline-log.json`), Signet Logging, and optional Firehose Artifact Logging to an external endpoint.