39 docs tagged with "declarative migrations"

Define Amazon Redshift roles, groups, users, and permissions as code. Atlas plans and applies the exact GRANT/REVOKE statements - no more manual grant drift on your cluster.

Learn how to integrate Atlas with Bitbucket Pipelines to automate declarative database schema migrations. This guide covers schema planning, approvals, and deployment across multiple databases.

Learn how to integrate Atlas with CircleCI to automate declarative database schema migrations. This guide covers schema planning, approvals, and deployment across multiple databases.

Learn how to integrate Atlas with GitLab CI/CD to automate and manage database schema migrations.

Define ClickHouse roles, users, and permissions as code. Atlas plans and applies changes automatically - no more manual GRANT/REVOKE drift.

Atlas supports templating inspection output using Go templates, similar to tools like kubectl and docker. This lets

Compare database schemas with Atlas schema diff command. Generate SQL migration plans between MySQL, PostgreSQL, SQLite, SQL Server, ClickHouse, and Redshift. Free visual ERD comparison tool.

Learn about Atlas's two workflows for managing database schemas - declarative (state-based migrations) and versioned migrations - and how to combine them for maximum flexibility

Learn how to set up a declarative migrations pipeline with Sequelize and Atlas on GitHub Actions. This guide covers prerequisites, Atlas project configuration, pushing schema to the Schema Registry, setting up GitHub Actions secrets, and creating workflows for planning and deploying changes.

Use the Atlas Terraform Provider for declarative database schema migrations to automatically plan and apply schema changes with Terraform.

Learn how to use Atlas for declarative schema migrations (sometimes called state-based migrations), enabling you to plan, review, and apply database schema migrations safely and automatically

Learn how to manage database schema migrations declaratively using the Atlas Kubernetes Operator. This guide covers providing schemas, credentials, safety policies, and using the Atlas Schema Registry for robust Kubernetes database automation.

A guide to declarative sqlc migrations with Atlas. Learn how to manage your database schema as code and automatically sync it to your database.

Learn how to implement environment promotion workflows for declarative schema migrations with Atlas. Read the schema version deployed in lower environments from the Atlas Registry and promote the exact same version to production using data sources and pre-execution checks.

Learn how to use Atlas to manage your MariaDB schema using HCL declarative schema migrations. This guide covers inspecting the database, planning changes, and applying them.

Learn how to use Atlas to manage your MySQL schema with HCL declarative migrations. This guide covers inspecting the database, planning changes, and applying them.

Learn how to use Atlas to manage your PostgreSQL schema with declarative migrations using HCL. This guide covers inspecting the database, planning changes, and applying them.

Learn how to use Atlas to manage your MariaDB schema with declarative migrations using SQL. This guide covers inspecting the database, planning changes, and applying them.

Learn how to use Atlas to manage your MySQL schema with declarative migrations using SQL. This guide covers inspecting the database, planning changes, and applying them.

Learn how to use Atlas to manage your PostgreSQL schema with declarative migrations using SQL. This guide covers inspecting the database, planning changes, and applying them.

Learn how to inspect existing database schemas and generate their HCL or SQL definitions using the `atlas schema inspect` command with various flags and options.

Define ClickHouse named collections as code. Atlas inspects, plans, and applies CREATE/ALTER/DROP NAMED COLLECTION statements automatically.

Define ClickHouse lookup tables and seed data as code. Atlas computes INSERT, ALTER UPDATE, and ALTER DELETE statements automatically.

Define lookup tables and seed data as code. Atlas computes INSERT, UPDATE, and DELETE statements automatically.

Define lookup tables, reference tables, configuration data, and seed data as code. Atlas computes INSERT, UPDATE, and DELETE statements automatically.

Define SQL Server lookup tables and seed data as code. Atlas computes INSERT, UPDATE, and DELETE statements automatically.

Define MySQL roles, users, and permissions as code. Atlas plans and applies changes automatically - no more manual GRANT/REVOKE drift.

Define Oracle roles, privileges, and grants as code. Atlas diffs the live database against your desired state and applies the exact GRANT/REVOKE changes - no more manual grant drift.

Define PostgreSQL roles, permissions, and row-level security policies as code. Atlas plans and applies changes automatically - no more manual GRANT/REVOKE drift.

Learn how to set up pre-approval flows for schema migrations using the Atlas Kubernetes Operator. This guide covers the steps to configure the Operator to plan schema changes, review them, and apply approved plans automatically.

When using the declarative workflow, users have the option to save migration plans to be reviewed and approved before

Manage lookup tables, reference data, configuration rows, and application settings as code. Atlas computes the INSERT, UPDATE, and DELETE statements needed to keep every environment in sync with the desired data state.

Set up your Atlas project: choose between versioned and declarative workflows, configure atlas.hcl, and organize your schema and migration directories.

Learn how to set up continuous integration and continuous deployment for your database schema migrations with Atlas. This guide covers CI (schema planning, pre-approval, ad-hoc approval, schema push) and CD (per-environment deployment) workflows for declarative migrations.

Set up your Atlas migration workflow: versioned migrations with baseline creation, or declarative state-based migrations. Includes importing from Flyway, Liquibase, and other tools.

Define SQL Server roles, users, permissions, and user-defined types as code. Atlas plans and applies changes automatically - no more manual GRANT/REVOKE drift.

Learn how to manage SQLite migrations and schemas using Atlas and declarative HCL. This step-by-step guide covers inspecting, editing, and applying schema changes for efficient SQLite schema management

Learn how to manage SQLite migrations and schemas using Atlas with declarative SQL. This step-by-step guide covers inspecting, editing, and applying schema changes for efficient SQLite schema management.

Learn how to test declarative schema migration plans in Atlas using `atlas schema plan test` to validate planned changes before applying.