Atlas: Manage your database schema as code

[amotl]

About

Atlas is a language-agnostic tool for managing and migrating database schemas using modern DevOps principles.

Details

Atlas offers two workflows.

• Declarative: Similar to Terraform, Atlas compares the current state of the database to the desired state, as defined in an HCL, SQL, or ORM schema. Based on this comparison, it generates and executes a migration plan to transition the database to its desired state.

• Versioned: Unlike other tools, Atlas automatically plans schema migrations for you. Users can describe their desired database schema in HCL, SQL, or their chosen ORM, and by utilizing Atlas, they can plan, lint, and apply the necessary migrations to the database.

Features

• Schema management: The atlas schema command offers various options for inspecting, diffing, comparing, and modifying
  database schemas.
• Versioned migration: The atlas migrate command provides a state-of-the-art experience for planning, linting, and
  applying migrations.
• Terraform support: Managing database changes as part of a Terraform deployment workflow.
• [SQL], [HCL] and [ORM] support: Atlas enables users to define their desired database schema using [HCL], [SQL], or their chosen [ORM].
• Multi-tenancy: Atlas includes built-in support for multi-tenant database schemas.
• Cloud integration: Atlas integrates with standard cloud services and provides an easy way to read secrets from cloud
  providers such as AWS Secrets Manager and GCP Secret Manager.

Resources

• https://atlasgo.io/
• https://github.com/ariga/atlas
• https://github.com/ariga/atlas-showcase
• https://atlasgo.io/integrations/github-actions
• SQLAlchemy Migrations: Goodbye, Alembic. Hello, Atlas