Database Guides

All common open-source relational database management systems are supported in all versions of Atlas. The Pro Plan also includes support for ClickHouse, SQL Server, Redshift, Aurora DSQL, CockroachDB, YugabyteDB, Oracle, Spanner, Snowflake, Databricks, and Azure Fabric. Choose your database to get started.

For more details on the specific features supported by our RDBMS drivers, take a look at our docs.

PostgreSQL

Getting Started with PostgreSQL

Learn how to set up and use Atlas with your PostgreSQL database

Serial Type Columns

Understanding serial type columns in PostgreSQL with Atlas

Partial Indexes

Implementing partial indexes in PostgreSQL with Atlas

Included Columns

Working with covering indexes in PostgreSQL

Index Operator Classes

Understanding index operator classes in PostgreSQL

Optimal Data Alignment (PG110)

Achieving optimal data alignment in PostgreSQL with Atlas

Descending Indexes

Implementing descending indexes in PostgreSQL with Atlas

Functional Indexes

Creating functional indexes in PostgreSQL with Atlas

Unlogged Tables

Creating and managing unlogged tables in PostgreSQL with Atlas

Security as Code (Declarative)

Define roles, permissions, and row-level security as code

Security as Code (Versioned)

Manage security changes as versioned migration files

Default Privileges

Manage PostgreSQL's implicit PUBLIC grants and ALTER DEFAULT PRIVILEGES

Seed & Lookup Data

Define lookup tables, reference tables, and seed data as code

Supabase Projects

Manage a Supabase project's tables, RLS policies, and Data API grants as code

Testing Schemas with pgTAP

Use pgTAP assertion functions in your Atlas schema tests

Schema Tests with Template Databases

Run every schema test group on a fresh clone of the dev database

PostgreSQL Lineage Graph

Trace column-level data lineage across tables and views of your PostgreSQL database

HCL Syntax with PostgreSQL

Represent your PostgreSQL schema using HCL

MySQL and MariaDB

Getting Started with MySQL

Learn how to set up and use Atlas with your MySQL database

Descending Indexes

Working with descending indexes in MySQL with Atlas

Functional Indexes

Working with functional indexes in MySQL with Atlas

Prefix Indexes

Working with prefix indexes in MySQL with Atlas

CHECK Constraint

Working with CHECK constraints in MySQL with Atlas

Generated Columns

Working with generated columns in MySQL with Atlas

MySQL RDS with Terraform

Managing MySQL schemas on RDS with Terraform

Inline REFERENCES clauses (MY102)

Detecting inline REFERENCES clauses for MySQL

Dropping non-virtual columns (DS103)

Detecting dropping non-virtual columns for MySQL databases with Atlas's linting capabilities

Dropping foreign key constraints

Detecting dropping foreign keys in MySQL databases, using Atlas's linting capabilities

Security as Code (Declarative)

Define roles, permissions, and grants as code for MySQL

Security as Code (Versioned)

Manage MySQL security changes as versioned migration files

Seed & Lookup Data

Define lookup tables, reference tables, and seed data as code

MySQL Lineage Graph

Trace column-level data lineage across tables and views of your MySQL database

HCL Syntax with MySQL

Represent your MySQL schema using HCL

SQLite

Partial Indexes

Implementing partial indexes in SQLite with Atlas

Descending Indexes

Creating descending indexes in SQLite with Atlas

Functional Indexes

Creating functional indexes in SQLite with Atlas

Working with Turso

Working with Turso in SQLite with Atlas

HCL Syntax with SQLite

Represent your SQLite schema using HCL

ClickHouse

Getting Started with ClickHouse

Manage ClickHouse schemas as code, declaratively or with versioned migrations

Cluster Mode

How Atlas manages schema changes in ClickHouse cluster mode

Managing ClickHouse Cloud

Managing ClickHouse Cloud databases using Atlas

Managing Session Settings

Managing ClickHouse settings with Atlas

Security as Code (Declarative)

Define roles and grants as code for ClickHouse

Security as Code (Versioned)

Manage ClickHouse security changes as versioned migration files

Seed & Lookup Data

Define lookup tables, reference tables, and seed data as code

Named Collections

Manage ClickHouse named collections

WASM Modules & UDFs

Manage WASM Modules and WASM UDFs with Atlas

ClickHouse Lineage Graph

Trace column-level data lineage across tables and views of your ClickHouse database

Schema Management for dbt

Manage the databases, source tables, lookup data, and grants a dbt project runs on

ClickHouse and dbt

Sort order on source tables, schema-scope grants for dbt, and dimension data as code

HCL Syntax with ClickHouse

Represent your ClickHouse schema using HCL

SQL Server

Getting Started with SQL Server

Learn how to set up and use Atlas with your SQL Server database

Security as Code (Declarative)

Define roles and permissions as code for SQL Server

Security as Code (Versioned)

Manage SQL Server security changes as versioned migration files

Seed & Lookup Data

Define lookup tables, reference tables, and seed data as code

HCL Syntax with SQL Server

Represent your SQL Server schema using HCL

Redshift

Getting Started with Redshift

Learn how to set up and use Atlas with your Redshift database

Redshift Lineage Graph

Trace column-level data lineage across tables and views of your Redshift database

Security as Code (Declarative)

Manage Redshift roles, groups, users, and GRANTs as the desired state

Security as Code (Versioned)

Track Redshift role, group, user, and GRANT changes as versioned migrations

HCL Syntax with Redshift

Represent your Redshift schema using HCL

Aurora DSQL

Getting Started with Aurora DSQL

Learn how to set up and use Atlas with AWS Aurora DSQL

CockroachDB

Getting Started with CockroachDB

Learn how to set up and use Atlas with your CockroachDB database

Azure HorizonDB

Getting Started with HorizonDB

Learn how to set up and use Atlas with your HorizonDB database

YugabyteDB

Getting Started with YugabyteDB

Learn how to set up and use Atlas with YugabyteDB YSQL

Distributed Schemas (Declarative)

Declare YugabyteDB colocation, tablet pre-splitting, and index sharding as code

Distributed Schemas (Versioned)

Manage YugabyteDB colocation, tablet pre-splitting, and index sharding through versioned migrations

Atlas for Oracle Database

Getting Started with Atlas for Oracle Database

Learn how to set up and use Atlas with your Oracle database

Security as Code (Declarative)

Define account roles, database roles, and object grants as code

Security as Code (Versioned)

Manage Oracle security changes as versioned migration files

Spanner

Getting Started with Spanner

Learn how to set up and use Atlas with your Spanner database

Protobuf Column Types

Managing protobuf column types with Atlas and Spanner

Snowflake

Getting Started with Snowflake

Learn how to set up and use Atlas with your Snowflake database

Security as Code (Declarative)

Define account roles, database roles, and object grants as code

Snowflake Lineage Graph

Trace column-level data lineage across tables and views of your Snowflake database

Databricks

Getting Started with Databricks

Learn how to set up and use Atlas with your Databricks database

Azure Fabric

Getting Started with Azure Fabric

Learn how to manage Azure Fabric Data Warehouse schemas with Atlas