Migrondi.Core
2.0.0
See the version list below for details.
dotnet add package Migrondi.Core --version 2.0.0
NuGet\Install-Package Migrondi.Core -Version 2.0.0
<PackageReference Include="Migrondi.Core" Version="2.0.0" />
<PackageVersion Include="Migrondi.Core" Version="2.0.0" />
<PackageReference Include="Migrondi.Core" />
paket add Migrondi.Core --version 2.0.0
#r "nuget: Migrondi.Core, 2.0.0"
#:package Migrondi.Core@2.0.0
#addin nuget:?package=Migrondi.Core&version=2.0.0
#tool nuget:?package=Migrondi.Core&version=2.0.0
Migrondi
Migrondi is a SQL migrations tool: write versioned .sql files and it tracks which ones a database has applied, then applies pending migrations or rolls applied ones back.
It supports SQLite, SQL Server, PostgreSQL, and MySQL. The CLI runs on Windows, Linux, and macOS (x64 and arm64). The desktop app, Migrondi UI, runs on Windows x64, Linux x64, and macOS arm64, the platforms Goo supports.
Install
.NET tools
The CLI installs as migrondi; the desktop app and its HTTP MCP host install as migrondiui. Migrondi UI needs the .NET 10 runtime; the CLI targets .NET 8, 9, and 10.
dotnet tool install --global Migrondi
dotnet tool install --global MigrondiUI
Run a tool without installing it:
dnx Migrondi -- list
dnx MigrondiUI -- --http 8080
Windows: Scoop
scoop install https://github.com/AngelMunoz/Migrondi/releases/latest/download/migrondi.json
scoop install https://github.com/AngelMunoz/Migrondi/releases/latest/download/migrondi-ui.json
These addresses serve the newest stable release manifest. Scoop checks the SHA-256 before installing, and scoop update adopts each new release.
Linux: Flatpak
flatpak install --user --bundle https://github.com/AngelMunoz/Migrondi/releases/latest/download/migrondiui-linux-x64.flatpak
The bundle installs Migrondi UI and its launcher. Flatpak offers to install the freedesktop runtime from Flathub. Install the bundle from a new release to update the app.
Binary archives
Download the archive for your platform from the releases page. Each release also carries a .sha256 file for its archives.
| App | Platforms | Archive |
|---|---|---|
| CLI | win-x64, win-arm64, linux-x64, linux-arm64, osx-x64, osx-arm64 |
migrondi-<version>-<rid>.zip |
| Migrondi UI | win-x64, linux-x64, osx-arm64 |
migrondiui-<version>-<rid>.zip |
The archives are self-contained: they need no .NET installation. Extract the archive and add its folder to PATH (the CLI) or start the app from it (the UI).
Migrondi UI keeps its database and virtual project files in your local application data folder, so an app or tool update does not replace them.
Migrondi UI needs Vulkan 1.3. On Linux it also needs a native Wayland session; X11 and XWayland are not supported.
Quick usage reference
Usage:
Migrondi [command] [options]
Options:
--version Show version information
-?, -h, --help Show help and usage information
Commands:
init, setup <path> Creates a migrondi.json file where the command is invoked or the path provided
create, new <name> Creates a new SQL migration file in the configured migrations directory
apply, up <amount> Applies pending migrations
down, rollback <amount> Rolls applied migrations back
list, show Reads migration files and the database to show the current state
show-state, status <name> Checks whether a migration is applied or pending
mcp Runs an MCP server over stdio for the project in the current directory or --config
Build
dotnet restore
dotnet build Migrondi.slnx
dotnet test Migrondi.slnx
Publish a self-contained folder for a platform:
dotnet publish src/Migrondi/Migrondi.fsproj -c Release -r <RID> --self-contained true -o dist
dotnet publish src/Migrondi.UI/Migrondi.UI.fsproj -c Release -r <RID> --self-contained true -o dist
The release workflow (.github/workflows/release.yml) packs the .NET tools, builds the archives, and publishes the release. See CONTRIBUTING.md for the release checklist.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
-
net10.0
- FSharp.UMX (>= 1.1.0)
- FsToolkit.ErrorHandling (>= 5.2.0)
- IcedTasks (>= 0.11.9)
- Microsoft.Data.SqlClient (>= 7.1.1)
- Microsoft.Data.Sqlite (>= 10.0.14)
- Microsoft.Extensions.Logging (>= 10.0.14)
- Microsoft.Extensions.Logging.Console (>= 10.0.14)
- MySql.Data (>= 26.10.0)
- Npgsql (>= 10.0.3)
- SQLitePCLRaw.bundle_e_sqlite3 (>= 3.0.5)
- System.Security.Cryptography.Pkcs (>= 10.0.14)
- Thoth.Json.Net (>= 12.0.0)
NuGet packages (1)
Showing the top 1 NuGet packages that depend on Migrondi.Core:
| Package | Downloads |
|---|---|
|
Migrondi.Mcp
This is the core library for the Migrondi CLI, you can use this library to run the same functionality of Migrondi as part of your source code or to write an abstraction for different kind of tools. |
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 2.0.1 | 60 | 11/16/2026 |
| 2.0.0 | 59 | 11/16/2026 |
| 1.3.0 | 215 | 6/27/2026 |
| 1.3.0-beta-001 | 151 | 6/27/2026 |
| 1.2.0 | 594 | 2/11/2026 |
| 1.1.0 | 152 | 2/11/2026 |
| 1.0.1 | 174 | 2/10/2026 |
| 1.0.0-rc-002 | 397 | 6/17/2025 |
| 1.0.0-beta-014 | 266 | 5/26/2025 |
| 1.0.0-beta-013 | 441 | 5/12/2025 |
| 1.0.0-beta-012 | 312 | 5/12/2025 |
| 1.0.0-beta-011 | 285 | 10/31/2024 |
| 1.0.0-beta-010 | 278 | 2/18/2024 |
| 1.0.0-beta-009 | 226 | 2/17/2024 |
| 1.0.0-beta-008 | 265 | 2/8/2024 |
| 1.0.0-beta-007 | 234 | 2/8/2024 |
| 1.0.0-beta-006 | 280 | 10/11/2023 |
| 1.0.0-beta-005 | 189 | 10/4/2023 |
### Added
- **Migrondi:** The `mcp` server's tools are now stateless — every tool accepts a `configPath` argument to target any project from one registration (send `null` to use the startup binding), and two new tools join the surface: `init_project` creates a project in a directory (never deleting files) and `update_project_config` rewrites `migrondi.json` fields in place. `create_migration` also accepts `manualTransaction` for statements that cannot run inside a transaction.
- **Migrondi:** New `mcp` command serves one project over stdio as an MCP server, so agents and harnesses can drive migrations as tools (`get_project`, `list_migrations`, dry runs, `create_migration`, `run_migrations`, `run_rollback`) instead of shell commands. `--config` selects the project, anchors its directory as the project root, and layers `MIGRONDI_*` variables and the config override flags on top; `--readonly` serves only the read tools. All server logs go to stderr, keeping stdout clean for strict MCP clients.
- **Migrondi:** `new` accepts `--up`/`--down` inline SQL and `--up-file`/`--down-file` to read a section from a file (or stdin with `-`), so a migration can be created with its content in one call instead of creating an empty file and editing it afterwards.
- **Migrondi:** `list` accepts `--pending`/`--applied`, `--limit`/`--last`, `--search <text>`, and `--show-path`/`--show-content` to filter and inspect migrations without scanning the migrations folder by hand.
- **Migrondi:** `up` and `down` accept `--to <name>` to apply up to, or roll back to, a named migration (name, filename, or timestamp) instead of counting migrations; the positional amount stays optional and cannot be combined with `--to`.
- **Project:** Added `migrondi-cli` and `migrondi-library` agent skills under `.agents/skills`, covering CLI usage for agents and `Migrondi.Core` embedding patterns such as custom migration sources.
- **Migrondi.UI:** The desktop app ships on the Goo rendering stack: projects list and management, virtual projects, migration apply/rollback/dry-run with step counts, a highlighted migration view with pending-migration editing, Navs routing, an OS-following dark/light theme, and an HTTP MCP host mode. The shell, project list, new-project flow, and project screen share one design system (palette tiers, button hierarchy, chips, page headers): runs are the only primary actions and ask before applying or rolling back, previews and step limits sit beside them, and each screen names its single next step.
- **MigrondiUI:** The desktop app also ships as the `migrondiui` .NET tool: `dotnet tool install --global MigrondiUI` installs it, and `dnx MigrondiUI` runs it without an install.
- **MigrondiUI:** Linux releases include a Flatpak bundle (`io.github.angelmunoz.migrondi.ui`) built from the same self-contained archive, so `flatpak install --bundle` installs the app and its launcher.
- **Migrondi:** Linux releases include a separate Flatpak bundle (`io.github.angelmunoz.migrondi`) built from the CLI archive, so `flatpak install --bundle` installs the `migrondi` command on its own.
- **Project:** Windows installs use Scoop manifests published with each release (`migrondi.json`, `migrondi-ui.json`), so `scoop install` and `scoop update` fetch and verify the archives.
### Changed
- **Migrondi:** **Breaking:** Binary releases are self-contained folders inside zip archives, not single-file executables, and no AOT build is used. Extract the archive and run `Migrondi` or `Migrondi.UI`.
- **Migrondi.Core, Migrondi.Mcp:** **Breaking:** the libraries target `net10.0` only; `net8.0` support is gone, so consuming applications must upgrade to .NET 10 or later.
- **Migrondi, MigrondiUI:** **Breaking:** the CLI and the desktop app target `net10.0` and `net11.0`; the `net8.0` and `net9.0` targets are gone. Tool installs need .NET 10 or later, and the release archives bundle the .NET 11 runtime.
- **CI:** Releases publish to NuGet with trusted publishing and take the version from `CHANGELOG.md`. The run packs `Migrondi`, `MigrondiUI`, `Migrondi.Core`, and `Migrondi.Mcp`, and publishes CLI archives for six RIDs and UI archives for Windows x64, Linux x64, and macOS arm64.
- **MigrondiUI:** The app database and virtual project files now live in the user's local application data folder instead of next to the executable. An existing database moves on first start, and app or tool updates no longer replace the data.
- **Migrondi.Mcp:** **Breaking (behavioral):** the multi-project `get_project` tool no longer returns database connection strings (local project config and virtual project detail); report hosts must never expose them.
- **Migrondi:** **Breaking (behavioral):** the MCP server re-reads the project config on every tool call, so config edits and `init_project` take effect on the next call without restarting the server, and `get_project` reflects the per-call project. Tool calls that omit optional arguments must now send them as explicit `null` (the schemas list them as required-but-nullable).
- **Migrondi.Mcp:** The shared MCP layer now reports full tool annotations (`idempotentHint` on read tools, `openWorldHint: false` everywhere), the real package version in the `initialize` response instead of a hardcoded value, and serves HTTP statelessly — no session store, localhost-only `Origin` acceptance, and no redundant `Mcp-Session-Id` headers.
- **Migrondi.Mcp:** MCP clients see the real parameter names (`amount`, `projectId`, ...) in tool schemas again instead of `delegateArg0`, which made those arguments impossible to pass; send `null` for an omitted "all migrations" value (e.g. `{"amount": null}`).
- **Project:** Migrated all projects to central package management via `src/Directory.Packages.props`, removing per-project package versions and consolidating dependency versions in one place.
- **Project:** Switched to the Microsoft Testing Platform (`global.json`) and bumped test-related packages to their latest stable versions.
- **MigrondiUI:** Upgraded from Avalonia 11 to Avalonia 12 and updated UI code to match the new API surface (`Watermark` → `PlaceholderText`, `IBinding` → `BindingBase`, nullable `TextBox.Text` handling, and `JsonElement` deserialization).
- **MigrondiUI:** Updated Avalonia-related dependencies (AvaloniaEdit, TextMate, SukiUI, NXUI) to their Avalonia 12-compatible versions.
- **Migrondi.Tests:** Migrated to `MSTest.Sdk/4.2.3`.
- **MigrondiUI.Tests:** Migrated to the Microsoft Testing Platform with the xUnit v3 runner, targeting `net10.0` only.
- **Project:** Updated all package dependencies to their latest stable versions, including Avalonia 12.1.6, ModelContextProtocol 2.4.0, MSTest 4.5.2, Serilog 4.4.0, and the database drivers, and updated the local Fantomas and FsDocs tools.
- **Project:** Moved the MCP tooling into a new shared `Migrondi.Mcp` project that holds the tool definitions, service contracts, result encoders, and both transports. MigrondiUI now keeps only the host code that builds its project collection and starts the server, so the CLI can host the same MCP tools against a single project in a later phase.
### Removed
- **Project:** The `migrondi_install.sh` and `migrondi_install.ps1` install scripts and `build.fsx` are gone. Install with the .NET tools, Scoop, or a release archive; build with `dotnet build`.
- **MigrondiUI:** The Avalonia app is replaced by `Migrondi.UI`. `--stdio` for the GUI is gone — the `migrondi` CLI serves stdio.
### Fixed
- **Migrondi:** The CLI now flushes its logger on exit, so log-then-exit errors (such as a rejected MCP transport) always reach stderr instead of being lost when the process ends before the console logger drains.
- **MigrondiUI:** MCP mode (`--stdio`/`--http`) no longer writes log lines to stdout; all logs go to stderr, so MCP clients receive only protocol messages.
- **Migrondi.Mcp:** Every tool that reports a migration (`list_migrations`, both dry runs, `run_migrations`, `run_rollback`, `get_migration`) now reports the same real file name (e.g. `1794436380501_add_users.sql`). Previously these results recomposed the timestamp onto the decoded name — which already carries it for standard-written files — producing doubled names like `1794436380501_1794436380501_add_users` that match no file on disk and broke handing identifiers to the CLI (`status`, `--to`). For virtual projects the file name also lacked the `.sql` suffix.
- **Migrondi.Mcp:** The `create_migration` tool result now reports the migration's name (e.g. `add_users`) and its real file name (e.g. `1794436380501_add_users.sql`). Previously the file name was reported as the name and the timestamp was recomposed onto it, producing a doubled file name like `1794436380501_1794436380501_add_users.sql`; for virtual projects the file name also lacked the `.sql` suffix.
- **Migrondi:** `status` now returns a non-zero exit code when no migration matches the given name, instead of reporting `NotFound` with a success exit code.
- **Project:** Addressed the high-severity `SQLitePCLRaw.lib.e_sqlite3` vulnerability (GHSA-2m69-gcr7-jv3q) by overriding `SQLitePCLRaw.bundle_e_sqlite3` to `3.0.5` in central package management.
- **Project:** Addressed the high-severity `System.Security.Cryptography.Pkcs` vulnerabilities (GHSA-846f-f764-76mx, GHSA-2fmv-rv2c-59x7) that Microsoft.Data.SqlClient pulled in, by overriding that package to `10.0.14` in central package management. No project reports a vulnerable package now.
- **Migrondi.UI:** Local migration save, delete, and lookup now resolve the configured migrations directory and locate files by decoded content (falling back to the filename), instead of globbing the project root by name — pending local migrations always save instead of reporting `NotFound`. Saving a timestamped file also normalizes its `NAME` to the friendly name.
- **MigrondiUI:** Virtual project migrations no longer show doubled timestamps (e.g. `1695829818636_CreateUsersTable_1695829818636.sql`). New migrations, imports, and exports store the friendly name and compose the filename once.