YUNIQL favicon

YUNIQL
Schema Versioning and Database Migration Engine with Plain SQL

YUNIQL
Free

Home: https://yuniql.io

Social:
Visit YUNIQL

What is YUNIQL?

YUNIQL offers a streamlined approach to database versioning and migration, leveraging plain SQL scripts for complete control over schema changes without the need for proprietary markup or runtime dependencies. The tool is natively built on .NET Core and runs as a standalone executable, ensuring easy deployment across environments without additional installations.

Compatible with various cloud and on-premise platforms, YUNIQL supports bulk CSV data imports, rich CLI commands, and integration with CI/CD pipelines through Azure DevOps. It is extensible to different RDBMS, already supporting PostgreSQL, MySQL, MariaDB, and provides preview support for Snowflake and Redshift, making it suitable for modern, cloud-ready database workflows.

Features

  • Plain SQL Scripting: Executes database migrations using normal SQL files organized in directories.
  • Bulk CSV Import: Imports master and lookup data directly from CSV files.
  • .NET Core Native: Runs as a self-contained executable without external dependencies.
  • Cloud Platform Support: Tested compatibility with Azure SQL, Amazon RDS, Google Cloud SQL, and preview support for Redshift and Snowflake.
  • CI/CD Integration: Provides Azure Pipelines tasks, Docker images, and command-line interface for DevOps workflows.
  • Open Source: Free for personal and commercial use under Apache License 2.0.
  • Extensible Platform: Supports PostgreSQL, MySQL, MariaDB, and can be extended to other RDBMS.

Use Cases

  • Managing version control for database schemas in software projects.
  • Automating SQL-based database migrations as part of CI/CD pipelines.
  • Bulk importing seed, master, or lookup data into databases during schema updates.
  • Integrating database versioning with Azure DevOps via Azure Pipelines tasks.
  • Deploying database changes to multiple cloud database platforms.
  • Standardizing cross-environment schema upgrades for distributed development teams.

FAQs

  • What database platforms does YUNIQL support?
    YUNIQL supports PostgreSQL, MySQL, MariaDB, and has preview support for Redshift and Snowflake, with tests conducted on Azure SQL, Amazon RDS, and Google Cloud SQL.
  • Does YUNIQL require the .NET CLR or other runtime dependencies?
    No, YUNIQL is released as a self-contained .NET Core application that runs as a standalone executable, requiring no external runtime installations.
  • Is YUNIQL free for commercial use?
    Yes, YUNIQL is absolutely free for both personal and commercial use under the Apache License version 2.0.

Related Queries

Helpful for people in the following professions

YUNIQL Uptime Monitor

Average Uptime

100%

Average Response Time

104.53 ms

Last 30 Days

View all

Related Tools:

View all Alternatives

Blogs:

  • Best AI Tools For Startups

    Best AI Tools For Startups

    we've compiled a straightforward list of user-friendly AI tools designed to give startups a boost. Discover practical solutions to streamline everyday tasks, enhance productivity, and gain valuable insights without the need for a tech expert. Learn where and how these tools can be applied in your startup journey, from automating repetitive tasks to unlocking powerful data analysis. Join us as we explore the features that make these AI tools accessible and beneficial for startups in various industries. Elevate your business with technology that works for you!

Didn't find tool you were looking for?

Be as detailed as possible for better results