DbEpoch 2.1.0

<div align="center">

<img src="./icon.png" alt="DbEpoch" width="120">

DbEpoch

Database migrations that ship.

A Flyway-style migration tool for PostgreSQL, SQL Server, MySQL, and SQLite.

<br>

Documentation · Report Bug · Request Feature

</div>

What is DbEpoch?

DbEpoch is a SQL-first database migration tool for .NET. You write plain .sql files, and DbEpoch tracks, validates, and applies them across environments — with built-in safety features for production use.

Why not Entity Framework migrations? EF migrations are tightly coupled to your application code and hard to control in production. DbEpoch keeps migrations as standalone SQL files that live in your repository, work with any language or framework, and give you full control over what runs and when.

Features

• SQL-first — Plain .sql files. No embedded DSL, no XML, no surprises.
• Multi-database — PostgreSQL, SQL Server, MySQL, and SQLite. Switch providers without changing your workflow.
• Safe by design — Distributed locks, approval gates, deployment windows, and audit trails.
• CI-friendly — Every command supports --json output and deterministic exit codes.
• Works offline — Validate, plan, and scaffold without a database connection.
• Checksum integrity — SHA-256 checksums detect when previously-applied scripts are edited in place.

Quick Start

# Install (no .NET required)
curl -fsSL https://github.com/AzimMahmud/DbEpoch/releases/latest/download/install.sh | bash

# Scaffold a project
DbEpoch new --name MyApp --provider postgresql

# Create a migration
DbEpoch create --name CreateUsersTable --type schema

# Validate & preview
DbEpoch validate
DbEpoch plan

# Deploy
DbEpoch migrate -c "Host=localhost;Database=myapp;Username=postgres"

Installation

No .NET SDK or runtime required — the binary is self-contained.

# Linux / macOS
curl -fsSL https://github.com/AzimMahmud/DbEpoch/releases/latest/download/install.sh | bash

# Windows (PowerShell)
powershell -c "iwr -Uri https://github.com/AzimMahmud/DbEpoch/releases/latest/download/install.ps1 | iex"

# .NET global tool (requires .NET 10 SDK)
dotnet tool install --global DbEpoch

Manual Download

Commands

Run DbEpoch <command> --help for command-specific options.

Configuration

DbEpoch uses a two-tier JSON configuration:

// Database/Config/migration.json
{
  "migration": {
    "database": {
      "provider": "postgresql",
      "connectionString": "${DB_CONNECTION_STRING}"
    },
    "scripts": {
      "path": "./Database/Migrations"
    },
    "execution": {
      "batchSize": 10,
      "stopOnFailure": true
    }
  }
}

Per-environment overrides in Database/Config/environments/<name>.json with ${VAR} expansion for secrets. See the Configuration Guide for details.

Supported Databases

Documentation

Full documentation is available at azimmahmud.github.io/DbEpoch.

Building from Source

git clone https://github.com/AzimMahmud/DbEpoch.git
cd DbEpoch
dotnet build DbEpoch.slnx
dotnet test DbEpoch.slnx --filter "Category!=Integration"

Requires the .NET 10 SDK.

Contributing

Contributions are welcome! Please see CONTRIBUTING.md for guidelines.

License

MIT