Use cases

manage your database schema as code

Get Started

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

Viktor Farcic, DevOps Toolkit

“Atlas is a great tool for managing databases, there you go, I said it!”

Used by

4000+ projects

Trusted by engineers at

Why Atlas

Database Schemas as Code

Define database schemas in declarative code. Use HCL, SQL or any ORM or language.

Supports all popular ORMs, such as GORM, Sequelize, Django, SQLAlchemy, Hibernate, and more.

Test your schemas and migrations using the Atlas testing framework.

Getting Started

ATLAS

HCL

SQL

table"users"{

schema=schema.main

column"id"{

null=false

type=int

}

column"first_name"{

null=true

type=varchar

}

column"last_name"{

null=true

type=varchar

}

primary_key{

columns=[column.id]

}

table"orders"{

schema=schema.main

column"id"{

null=false

type=int

}

column"name"{

null=true

type=varchar

}

column"user_id"{

null=false

type=int

}

column"product_id"{

null=false

type=int

}

primary_key{

columns=[column.id]

}

foreign_key"product_id"{

columns=[column.product_id]

ref_columns=[column.products.column.id]

on_update=NO_ACTION

on_delete=NO_ACTION

}

foreign_key"user_id"{

columns=[column.user_id]

ref_columns=[table.users.column.id]

on_update=NO_ACTION

on_delete=NO_ACTION

}

table"products"{

schema=schema.main

column"id"{

null=false

type=int

}

column"name"{

null=true

type=varchar

}

column"description"{

null=false

type=int

}

column"quantity"{

null=false

type=int

}

primary_key{

columns=[column.id]

}

schema"main"{

}

Automatic Migration Planning

Define the desired state of your schema, and let Atlas automatically plan the SQL migrations. Like Terraform, but for databases.

Standardize schema changes using policies, regardless of the database or the ORM used.

Works with existing schema migration tools like Flyway, Liquibase, or migrate.

Planning Quick start

Verify Migration Safety in CI

Prevent destructive and backward-incompatible changes, or schema migrations that might fail or lock the database before they reach production.

Automate and customize reviews and approvals using policies.

GitHub Action Quick start

GitLab CI Quick start

CI RUN

#85485452

ISSUES FOUND

Repo

ariga/demo

Branch

new-t

Commit

c725c63

Pull Request

https://github.com/ariga/atlas

Summary

SQL Change

ERD

Migration Integrity check

Detect New Migration Files

Analyze Schema Changes

2 reports were found in analysis

Blocking column changes detected

Changing column "c1" from "smallint" to "integer" alters storage

size from 2 to 4 bytes and requires a rewrite of the table (PG301)

Concurrent index violations detected

Adding a PRIMARY KEY on "users" not concurrently acquires an

ACCESS EXCLUSIVE lock, blocking all access to the table (PG104)

Deploy to production with modern tooling

Atlas seamlessly integrates with modern deployment tools like Kubernetes and Terraform to make it easy to deploy your database migrations to production as part of your existing CD process.

Terraform Quick start

ArgoCD Quick start

Full visibility and control on your databases

Gain full visibility into the databases in your development and production environments with detailed logs and troubleshooting capabilities.

Prevent schema drift in production by detecting manual and accidental changes to your database.

Atlas Cloud Quick start

CI RUN

#85485452

ISSUES FOUND

Branch

Main

Commit

92b0a8c

Updated at

a minute ago

Last trigger

https://github.com/atlasclo..

Commits

92b0a8c

Less than a minute ago

c39524cd

6 minutes ago

10ca8fa

10 minutes ago

9a2dd9

20 minutes ago

ERD

Why Atlas

Schema as Code
Generated migrations
CI for schema changes
Deploy to production
Production control

Get Started

Database Schemas as Code

Define database schemas in declarative code. Use HCL, SQL or any ORM or language.

Supports all popular ORMs, such as GORM, Sequelize, Django, SQLAlchemy, Hibernate, and more.

Test your schemas and migrations using the Atlas testing framework.

Getting Started

ATLAS

HCL

SQL

table"users"{

schema=schema.main

column"id"{

null=false

type=int

}

column"first_name"{

null=true

type=varchar

}

column"last_name"{

null=true

type=varchar

}

primary_key{

columns=[column.id]

}

table"orders"{

schema=schema.main

column"id"{

null=false

type=int

}

column"name"{

null=true

type=varchar

}

column"user_id"{

null=false

type=int

}

column"product_id"{

null=false

type=int

}

primary_key{

columns=[column.id]

}

foreign_key"product_id"{

columns=[column.product_id]

ref_columns=[column.products.column.id]

on_update=NO_ACTION

on_delete=NO_ACTION

}

foreign_key"user_id"{

columns=[column.user_id]

ref_columns=[table.users.column.id]

on_update=NO_ACTION

on_delete=NO_ACTION

}

table"products"{

schema=schema.main

column"id"{

null=false

type=int

}

column"name"{

null=true

type=varchar

}

column"description"{

null=false

type=int

}

column"quantity"{

null=false

type=int

}

primary_key{

columns=[column.id]

}

schema"main"{

}

Automatic Migration Planning

Define the desired state of your schema, and let Atlas automatically plan the SQL migrations. Like Terraform, but for databases.

Standardize schema changes using policies, regardless of the database or the ORM used.

Works with existing schema migration tools like Flyway, Liquibase, or migrate.

Planning Quick start

Verify Migration Safety in CI

Prevent destructive and backward-incompatible changes, or schema migrations that might fail or lock the database before they reach production.

Automate and customize reviews and approvals using policies.

GitHub Action Quick start

GitLab CI Quick start

CI RUN

#85485452

ISSUES FOUND

Repo

ariga/demo

Branch

new-t

Commit

c725c63

Pull Request

https://github.com/ariga/atlas

Summary

SQL Change

ERD

Migration Integrity check

Detect New Migration Files

Analyze Schema Changes

2 reports were found in analysis

Blocking column changes detected

Changing column "c1" from "smallint" to "integer" alters storage

size from 2 to 4 bytes and requires a rewrite of the table (PG301)

Concurrent index violations detected

Adding a PRIMARY KEY on "users" not concurrently acquires an

ACCESS EXCLUSIVE lock, blocking all access to the table (PG104)

Deploy to production with modern tooling

Atlas seamlessly integrates with modern deployment tools like Kubernetes and Terraform to make it easy to deploy your database migrations to production as part of your existing CD process.

Terraform Quick start

ArgoCD Quick start