Feature Compatability
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 Free Plan of Atlas, which you can use for free by creating an Atlas account. The Free Plan has some limitations, but those pertain mostly to the number of projects you can use in Atlas Cloud.
Free Plan
The Free Plan is available to all Atlas users. Create your Atlas Free Plan account by running the following command and following the instructions on the screen:
atlas login
Feature Availability
This document compares the CLI features available to users who are logged in to Atlas Cloud and those who are not.
CLI Features
| Feature | Availability |
|---|---|
| Database Inspection | Open |
| Schema Diffing | Open |
| Versioned Migrations | Open |
| Declarative Migrations | Open |
| Migration Linting | Open |
| Migration Checkpoints | Requires Login |
| Schema Visualization | Requires Login |
| Interactive Migrations | Requires Login |
Schema Visualization as well as Interactive Migrations are features that require connectivity to the cloud and hence are not available in the open-source version of Atlas.
Database Support
All common open-source RDBMS are supported in all versions of Atlas. In addition, Atlas also supports SQL Server and ClickHouse in the Free Plan of Atlas Cloud.
| Driver | Availability |
|---|---|
| MySQL | Open |
| PostgreSQL | Open |
| MariaDB | Open |
| SQLite | Open |
| LibSQL | Open |
| SQL Server | Requires Login |
| ClickHouse | Requires Login (Beta) |
Database Features
Most common database features are supported in all versions of Atlas. More advanced features are available by running atlas login.
| Feature | Availability |
|---|---|
| Tables and Columns | Open |
| Indexes | Open |
| Foreign Keys | Open |
| Constraints | Open |
| Partitions | Open |
| Views | Requires Login |
| Materialized Views | Requires Login |
| Stored Procedures | Requires Login |
| Functions | Requires Login |
| Triggers | Requires Login |
| Sequences (Postgres) | Requires Login |
| Composite Types (Postgres) | Requires Login |
| Domain Types (Postgres) | Requires Login |
| Extensions (Postgres) | Requires Login |
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 Dir | Open |
| Template Dir | Open |
| AWS RDS Token | Open |
| GCP CloudSQL Token | Open |
| Composite Schema | Requires Login |