Feature Compatibility
Atlas is Open-Core
Atlas is an open-core project. The core engine is open-source and available on GitHub under the Apache 2.0 license. Open-source features cover the core functionality of Atlas, including database inspection, diffing, migration planning and execution, and more. For the basic and common use cases, the open-source version of Atlas is more than enough.
In addition, Atlas also offers a number of advanced features that are only available in proprietary versions. The vast majority of these features are available in the Pro Plan of Atlas, which you can use for free by creating an Atlas account.
Pro Plan
We provide a free 30-day trial for new users, after which a license is required to continue using Atlas Pro.
Users can upgrade to the Pro Plan for $9/seat per month.
To learn more about our plans and pricing, visit the Atlas Pricing Page.
Create your Atlas Pro account by running the command below and following the instructions on the screen:
atlas login
Feature Availability
The following sections clarify which features are available to users who use the open-source version of Atlas and which are exclusively available to those on the Atlas Pro Plan.
CLI Features
| Feature | Availability |
|---|---|
| Database Inspection | Open |
| Schema Diffing | Open |
| Versioned Migrations | Open |
| Declarative Migrations | Open |
| Migration Linting | Partially Open (Full version in Pro) |
| Custom Schema Rules | Pro |
| Pre-migration checks | Pro |
| Migration Checkpoints | Pro |
| Schema Visualization | Pro |
| Interactive Migrations | Pro |
| Testing Framework | Pro |
Database Support
All common open-source RDBMS are supported in all versions of Atlas. In addition, Atlas supports SQL Server, ClickHouse and Redshift in the Pro Plan.
| Driver | Availability |
|---|---|
| PostgreSQL | Open |
| MySQL | Open |
| MariaDB | Open |
| SQLite | Open |
| CockroachDB | Open |
| TiDB | Open |
| LibSQL | Open |
| SQL Server | Pro |
| ClickHouse | Pro |
| Redshift | Pro |
Database Features
Most common database features are supported in all versions of Atlas. More advanced features are available to users of the Pro Plan.
- PostgreSQL
- MySQL
- MariaDB
- SQLite
- SQL Server
- ClickHouse
- Redshift
The following features are supported by the PostgreSQL driver in all versions of Atlas:
- Tables and columns
- Indexes
- Check, unique, and exclusion constraints
- Foreign keys constraints
- Enum types
- Comments
Some features are only available in the Pro Plan. For example:
- Partitions
- Views
- Materialized views
- Stored procedures
- Functions
- Sequences
- Extensions
- Row-level security/policies
- Composite types
- Domain types
- Foreign servers
- Triggers, constraint triggers and event triggers
- And more. For the full list, see the PostgreSQL driver documentation.
The following features are supported by the MySQL driver in all versions of Atlas:
- Tables and columns
- Indexes
- Foreign keys
- Check and unique constraints
- Comments
Some features are only available in the Pro Plan. For example:
- Partitions
- Views
- Full-text search index
- Triggers
- Stored procedures
- Functions
- And more. For the full list, see the MySQL driver documentation.
The following features are supported by the MariaDB driver in all versions of Atlas:
- Tables and columns
- Indexes
- Foreign keys
- Check and unique constraints
- Comments
Some features are only available in the Pro Plan. For example:
- Partitions
- Views
- Temporal tables
- Triggers
- Stored procedures
- Functions
- And more. For the full list, see the MariaDB driver documentation.
The following features are supported by the SQLite driver in all versions of Atlas:
- Tables and columns
- Indexes
- Foreign keys
- Constraints
Some features are only available in the Pro Plan. For example:
- Views
- Triggers
- And more. For the full list, see the SQLite driver documentation.
The SQL Server driver is only available to Atlas users with the Pro Plan. It supports the following features:
- Tables and columns
- Indexes
- Foreign keys
- Constraints
- Comments
- Views
- Materialized views
- Stored procedures
- Functions
- Triggers
- Sequences
- Alias types
- Table types
- Full-text search indexes
- Temporal tables
- And more. For the full list, see the SQL Server driver documentation.
The ClickHouse driver is only available to Atlas users with the Pro Plan. It supports the following features:
- Tables and columns
- Indexes
- Comments
- Views
- Materialized views
- And more. For the full list, see the ClickHouse driver documentation.
The Redshift driver is only available to Atlas users with the Pro Plan. It supports the following features:
- Tables and columns
- Indexes
- Foreign keys
- Constraints
- Comments
- Partitions
- Views
- Materialized views
- And more. For the full list, see the Redshift driver documentation.
Data Sources
Data sources are a powerful feature of Atlas that allows you to load data from external sources into your Atlas Project.
| Data Source | Availability |
|---|---|
| SQL | Open |
| External | Open |
| Runtimevar | Open |
| HCL Schema | Open |
| External Schema | Open |
| Remote Directory | Open |
| Template Directory | Open |
| AWS RDS Token | Open |
| GCP CloudSQL Token | Open |
| Composite Schema | Pro |
Linting rules
Migration and schema linting help teams automate the verification of schema changes, ensuring they are safe and won't introduce any issues. Atlas' open plan includes a basic set of linting rules, while the Pro Plan provides a more advanced suite for deeper validation.
| Linting Rule | Availability |
|---|---|
| Backward incompatible changes | Open |
| Destructive changes | Open |
| Data-dependent changes | Open |
| MySQL and MariaDB checks | Open |
| SQLite specific checks | Open |
| Naming conventions | Open |
| Concurrent index changes | Pro |
| PostgreSQL table-locking | Pro |
| Linear history protection | Pro |
| Custom linting rules | Pro |
For more a detailed breakdown on linting rules, visit the Migration Linting page.