We are excited to announce the release of Atlas v0.26 🎊

It's been about a month since our last release, and we're excited to announce that Atlas v0.26 is now available! In this release we are happy to introduce a new feature that has been requested by many of you: support for Entity Framework Core. As part of our ever going effort to improve the quality and coverage of our documentation, we have published a set of guides on testing database schemas and migrations as well as a new GORM Portal.

Read the full announcement in our blogpost.

Quick installation

macOS + Linux:

curl -sSf https://atlasgo.sh | sh

Homebrew:

brew install ariga/tap/atlas

Docker:

docker pull arigaio/atlas

Windows

Download

Legal

The default binaries in this release are distributed released under Atlas EULA, and the community binaries are released under the Apache 2.0 license.

Full Changelog: v0.25.0...v0.26.0

We are excited to announce the release of Atlas v0.25 🎊

Thanks for joining us today for our v0.25 release announcement! In this version we are introducing a new feature that has been requested by many of you: support for Row-level Security Policies in PostgreSQL.

What are Row-level Security Policies?

Row-level security (RLS) in PostgreSQL allows tables to have policies that restrict which rows can be accessed or modified based on the user's role, enhancing the SQL-standard privilege system available through GRANT.

When enabled, all normal access to the table must comply with these policies, defaulting to a deny-all approach if no policies are set, ensuring that no rows are visible or modifiable. Policies can be specific to commands, roles, or both, providing fine-grained control over data access and modification.

policy "employee_policy" {
  on    = table.employees
  for   = SELECT
  to    = [PUBLIC]
  using = "(current_user = employee_role)"
}

Read the full announcement and in our blogpost: https://atlasgo.io/blog/2024/07/09/v025-row-level-security

Quick installation

macOS + Linux:

curl -sSf https://atlasgo.sh | sh

Homebrew:

brew install ariga/tap/atlas

Docker:

docker pull arigaio/atlas

Windows

Download

Legal

The default binaries in this release are distributed released under Atlas EULA, and the community binaries are released under the Apache 2.0 license.

Full Changelog: v0.24.0...v0.25.0

We are excited to announce the release of Atlas v0.24 🎊

We are back again with a new release of Atlas, v0.24. In this release we double down on the core principle that has been guiding us from the start: enabling developers to manage their database Schema as Code. The features we announce today may appear like a yet another cool addition to Atlas, but we're confident, that in a few years' time, they will be recognized as something foundational.

In this release we introduce:

• schema test - a new command (and framework) for testing your database schema using familiar software testing paradigms.
• migrate test - a new command for testing writing tests for you schema migrations.
• Enhanced editor support - we have added support for some long awaited features in our VSCode and JetBrains plugins: multi-file schemas, jump to definition, and support for much larger schemas.

test "migrate" "20240613061102" {
  # Migrate to version 20240613061046.
  migrate {
    to = "20240613061046"
  }
  # Insert some test data.
  exec {
    sql = "insert into users (name) values ('Ada Lovelace')"
  }
  # Migrate to version 20240613061102.
  migrate {
      to = "20240613061102"
  }
  # Verify the correctness of the data migration.
  exec {
    sql = "select first_name,last_name from users"
    output = "Ada, Lovelace"
  }
}

Read the full announcement and in our blogpost: https://atlasgo.io/blog/2024/06/13/atlas-v-0-24

Quick installation

macOS + Linux:

curl -sSf https://atlasgo.sh | sh

Homebrew:

brew install ariga/tap/atlas

Docker:

docker pull arigaio/atlas

Windows

Download

Legal

The default binaries in this release are distributed released under Atlas EULA, and the community binaries are released under the Apache 2.0 license.

Full Changelog: v0.23.0...v0.24.0

We are excited to announce the release of Atlas v0.23 🎊

It's been a few weeks since the release of v0.22 and we're excited to be back with the next version of Atlas, packed with some long awaited features and improvements.

• Redshift Support - Amazon Redshift, a fully managed, petabyte-scale data warehouse service in the cloud. Starting today, you can use Atlas to manage your Redshift Schema-as-Code.
• CircleCI Integration - Following some recent requests from our Enterprise customers, we have added a CircleCI orb to make it easier to integrate Atlas into your CircleCI pipelines.
• Kubernetes Operator Down Migrations - The Kubernetes Operator now detects when you are moving to a previous version and will attempt to apply a down migration if configured to do so.
• GORM View Support - We have added support for defining SQL Views in your GORM models.
• SQLAlchemy Provider Improvements - We have added support for defining models using SQLAlchemy Core Tables in the SQLAlchemy provider.
• ERD v2 - We have added a new navigation sidebar to the ERD to make it easier to navigate within large schemas.
• PostgreSQL Improvements - We have added support for PostgreSQL Event Triggers, Aggregate Functions, and Function Security.

Read the full announcement and in our blogpost: https://atlasgo.io/blog/2024/05/21/atlas-v-0-23

Quick installation

macOS + Linux:

curl -sSf https://atlasgo.sh | sh

Homebrew:

brew install ariga/tap/atlas

Docker:

docker pull arigaio/atlas

Windows

Download

Legal

The default binaries in this release are distributed released under Atlas EULA, and the community binaries are released under the Apache 2.0 license.

Full Changelog: v0.22.0...v0.23.0

We are excited to announce the release of Atlas v0.22 🎊

We're happy to share with you v0.22, which includes very exciting improvements for Atlas. Here's what's new:

• RENAME Detection - Prior to version v0.22, Atlas interpreted schema renames as DROP and ADD commands. This version includes a rename detector that identifies such operations and interactively asks the user for feedback before generating the changes.
• Preventing Table Locks - Eight new checks have been added to the migrate lint to detect table locks in various modes, which can be avoided during the PR stage. Note, these checks are available for Atlas Cloud users only 🚀
• Added support for PostgreSQL UNIQUE and EXCLUDE constraints.
• PostgreSQL composite types can now be managed as part of your schema.
• Added support for sequence objects in Microsoft SQL Server.

Quick installation

macOS + Linux:

curl -sSf https://atlasgo.sh | sh

Homebrew:

brew install ariga/tap/atlas

Docker:

docker pull arigaio/atlas

Windows

Download

Legal

The default binaries in this release are distributed released under Atlas EULA, and the community binaries are released under the Apache 2.0 license. If you would like to build Atlas from source follow the instructions here.

Full Changelog: v0.21.0...v0.22.0

We are excited to announce the release of Atlas v0.21 🎊

It's been only two weeks since our last version and today I'm happy to share with you v0.21, which includes very exciting feature for Atlas: migrate down.

The new atlas migrate down command allows reverting applied migrations. Unlike the traditional approach, where down files are "pre-planned", Atlas computes a migration plan based on the current state of the database. Atlas reverts previously applied migrations and executes them until the desired version is reached, regardless of the state of the latest applied migration — whether it succeeded, failed, or was partially applied and left the database in an unknown version.

Read the full announcement and in our blogpost: https://atlasgo.io/blog/2024/04/01/migrate-down

Quick installation

macOS + Linux:

curl -sSf https://atlasgo.sh | sh

Homebrew:

brew install ariga/tap/atlas

Docker:

docker pull arigaio/atlas

Windows

Download

Legal

The default binaries in this release are distributed released under Atlas EULA, and the community binaries are released under the Apache 2.0 license. If you would like to build Atlas from source follow the instructions here.

Full Changelog: v0.20.0...v0.21.0

We are excited to announce the release of Atlas v0.20 🎊

It's been a few weeks since our last version announcement and today I'm happy to share with you v0.20, which includes very exciting improvements for Atlas. Here's what's new:

• Support for PostgreSQL Extensions - Atlas now supports installing and managing PostgreSQL extensions.
• Django ORM Integration - Atlas now supports Django! Django is a popular ORM for Python. Developers using either ORM can now use Atlas to automatically plan schema migrations for them, based on the desired state of their schema instead of crafting them by hand.
• SQL Server is out of Beta - SQL Server is officially out of Beta! Along with this official support, we have included some new features:
  • User-Defined Types support for SQL Server - Atlas now supports two User-Defined Types: alias types and table types.
  • Azure Active Directory (AAD) Authentication for SQL Server - Connect to your SQL Server database using AAD Authentication.
• Dashboards in the Cloud - The dashboard (previously the 'Projects' page) got a whole new look in Atlas Cloud. Now you can view the state of your projects and environments at a glance.

Read the full announcement on our blog: https://atlasgo.io/blog/2024/03/18/atlas-v-0-20

Quick installation

macOS + Linux:

curl -sSf https://atlasgo.sh | sh

Homebrew:

brew install ariga/tap/atlas

Docker:

docker pull arigaio/atlas

Windows

Download

Legal

The default binaries in this release are distributed released under Atlas EULA, and the community binaries are released under the Apache 2.0 license. If you would like to build Atlas from source follow the instructions here.

Full Changelog: v0.19.0...v0.20.0

We are excited to announce the release of Atlas v0.19.0 🎊

It has been three weeks since our last version announcement, and today I'm happy to share with you v0.19, which includes some very exciting improvements for Atlas. Here's what's new:

• Pre-migration Checks: Before executing schema changes, you can now add pre-migration checks that will be verified to help avoid risky migrations.
• Schema Docs: Atlas lets you manage your database schema as code. One of the things we love most about code, is that because of its formal structure, it's possible to automatically generate documentation from it. With this release, we're introducing a new feature that lets you generate code-grade documentation for your database schema.
• SQL Server Trigger Support: Atlas now supports managing triggers in SQL Server.
• ClickHouse Materialized Views Support: Atlas now supports managing materialized views in ClickHouse.

Read the full announcement on our blog: https://atlasgo.io/blog/2024/02/02/atlas-v-0-19

Quick installation

macOS + Linux:

curl -sSf https://atlasgo.sh | sh

Homebrew:

brew install ariga/tap/atlas

Docker:

docker pull arigaio/atlas

Windows

Download

Legal

The default binaries in this release are distributed released under Atlas EULA, and the community binaries are released under the Apache 2.0 license. If you would like to build Atlas from source follow the instructions here.

Full Changelog: v0.18.0...v0.19.0

New Contributors

• @haoxins made their first contribution in #2443
• @eric made their first contribution in #2499

Full Changelog: v0.18.0...v0.19.0

We are excited to announce the release of Atlas v0.18.0 🎊

It's been only a bit over a week since our last release, but we have some exciting new features we couldn't wait to share with you:

• Drift Detection - A common source of database trouble is that the schema in your database doesn't match the schema in your code. This can happen for a variety of reasons, including manual changes to the database, or changes made by other tools. Today, we are happy to announce the availability of a new feature that lets you automatically detect these drifts, and alerts you when they happen.
• SQLAlchemy Support - SQLAlchemy is a popular Python ORM. Developers using SQLAlchemy can use Atlas to automatically plan schema migrations for them, based on the desired state of their schema instead of crafting them by hand.
• Composite Schemas - The newly added composite_schema data source lets you combine multiple schemas into one, which is useful for managing schemas that are loaded from multiple sources or to describe applications that span multiple database schemas.
• VSCode ERDs - We've added a new feature to our VSCode extension that lets you visualize your database schema as an ERD diagram.

Read the full announcement on our blog: https://atlasgo.io/blog/2024/01/09/atlas-v0-18

Quick installation

macOS + Linux:

curl -sSf https://atlasgo.sh | sh

Homebrew:

brew install ariga/tap/atlas

Docker:

docker pull arigaio/atlas

Windows

Download

Legal

The default binaries in this release are distributed released under Atlas EULA, and the community binaries are released under the Apache 2.0 license. If you would like to build Atlas from source follow the instructions here.

Full Changelog: v0.17.0...v0.18.0

What's Changed

• cmd/atlas/internal/sqlparse/myparse: move oss parser to ent by @a8m in #2415
• cmd/atlas/internal: fix quotation in migrate diff example by @ronenlu in #2402
• cmd/atlas/internal/sqlparse: rename myparse.Parser to FileParser by @a8m in #2416
• sql/internal/sqlx: changes planer compares schema by name by @a8m in #2417
• doc/md: add sqlalchemy provider guide by @ronenlu in #2411
• sql/internal/specutil: marshal unquoted literals for text-based types by @a8m in #2419
• cmd/atlas: initialize the cmd context by @rotemtam in #2422
• schemahcl: allow using references in the for_each meta argument by @a8m in #2423
• cmd/atlas: report env loaded by @rotemtam in #2424

Full Changelog: v0.17.0...v0.18.0

We are excited to announce the release of Atlas v0.17.0 🎊

It's been only a bit over a week since our last release, but we have some exciting new features we couldn't wait to share with you:

• Trigger Support - Atlas now supports managing triggers on MySQL, PostgreSQL, MariaDB, and SQLite databases.
• Improved ERDs - You can now visualize your schema's SQL views, as well as create filters to select the specific database objects you wish to see.

Read the full announcement on our blog: https://atlasgo.io/blog/2024/01/01/atlas-v-0-17

Quick installation

macOS + Linux:

curl -sSf https://atlasgo.sh | sh

Homebrew:

brew install ariga/tap/atlas

Docker:

docker pull arigaio/atlas

Windows

Download

Legal

The default binaries in this release are distributed released under Atlas EULA, and the community binaries are released under the Apache 2.0 license. If you would like to build Atlas from source follow the instructions here.

What's Changed

Full Changelog: v0.16.0...v0.17.0