Migrondi.Core 2.0.0

There is a newer version of this package available.
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
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Migrondi.Core" Version="2.0.0" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Migrondi.Core" Version="2.0.0" />
                    
Directory.Packages.props
<PackageReference Include="Migrondi.Core" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Migrondi.Core --version 2.0.0
                    
#r "nuget: Migrondi.Core, 2.0.0"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package Migrondi.Core@2.0.0
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Migrondi.Core&version=2.0.0
                    
Install as a Cake Addin
#tool nuget:?package=Migrondi.Core&version=2.0.0
                    
Install as a Cake Tool

.NET Core NuGet Version NuGet Version NuGet Version

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 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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

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
Loading failed

### 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.