A free, open-source schema versioning and database migration engine built with .NET Core, using plain SQL scripts.
Yuniql is a free, open-source database migration and schema versioning engine built with .NET Core. It allows developers to manage database changes using plain SQL scripts, bulk import CSV data, and integrate migrations into CI/CD pipelines across multiple database platforms.
Developers and DevOps engineers working with .NET ecosystems who need a lightweight, script-based migration tool for SQL Server, PostgreSQL, MySQL, and other supported databases.
Yuniql stands out by using plain SQL without a proprietary DSL, supporting a wide range of databases, and offering seamless integration with CI/CD tools like Azure DevOps and Docker, all with zero runtime dependencies.
Free and open source schema versioning and database migration made natively with .NET/6. NEW THIS MAY 2022! v1.3.15 released!
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Uses straightforward SQL script files for migrations, avoiding proprietary DSLs, which keeps the learning curve low for developers familiar with SQL, as emphasized in the Key Features.
Supports SQL Server, PostgreSQL, MySQL, MariaDB, Snowflake, Redshift, and Oracle, with platform-specific build statuses detailed in the README table, enabling cross-database compatibility.
Provides Azure DevOps pipeline tasks, Docker container execution, and .NET Core library integration, facilitating automated deployments in modern development workflows, as shown in the working examples.
Allows importing master data directly from CSV files during migrations, useful for data seeding, with advanced use cases documented on the project website.
Oracle support is marked as preview, and databases like SAP Hana, Azure Synapse, and Amazon Aurora are in analysis or ideation phases, limiting production readiness for some platforms.
Focuses on forward migrations without native rollback commands, requiring manual SQL scripts or custom workflows for reverting changes, which can increase operational risk.
Built natively with .NET Core, so extending functionality or debugging issues may demand .NET expertise, despite cross-platform operation via Docker and CLI.