atlas-provider-sqlalchemy

What it is and what it does

atlas-provider-sqlalchemy is a bridge between SQLAlchemy ORM models and Atlas, a schema-as-code tool. It extracts your SQLAlchemy model definitions and converts them into a schema that Atlas can understand, then uses Atlas to plan and apply migrations automatically. Rather than writing SQL migration files by hand, you define your schema in Python using SQLAlchemy, and Atlas handles the diff, planning, and application to your database.

The package works by importing your models and generating DDL that Atlas consumes. It supports MySQL, MariaDB, PostgreSQL, SQLite, Microsoft SQL Server, and ClickHouse. You can use it standalone via a CLI command or as a Python script within your project. It integrates with Atlas's declarative and versioned migration workflows, plus Atlas's testing, linting, drift detection, and monitoring features.

Use it for:

• Define database schema entirely in Python using SQLAlchemy and automatically apply it to production without writing SQL migrations.
• Generate migration files automatically by comparing your current SQLAlchemy models to the live database schema.
• Detect schema drift in production and alert when the database diverges from your declared SQLAlchemy models.
• Run schema linting and testing as part of CI/CD to catch migration errors before they reach production.
• Extend SQLAlchemy with advanced database objects such as triggers, row-level security, and custom functions.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Connects SQLAlchemy models to Atlas to automatically generate and apply database schema migrations, eliminating manual migration writing.

Yes, if you use SQLAlchemy and want to eliminate manual migration writing. The package has low install friction and no known vulnerabilities. However, the aging maintenance status (243 days since last release) and unclear license terms warrant verification before adopting in production or commercial projects. Confirm the license and check the upstream repository for active support.

Install

atlas-provider-sqlalchemy on PyPI

pip install atlas-provider-sqlalchemy

uv add atlas-provider-sqlalchemy

poetry add atlas-provider-sqlalchemy

Installing atlas-provider-sqlalchemy

Before you install

Low install friction with a pure-Python wheel. Maintenance status is aging—last release was 243 days ago—so expect slower response to issues, though the package remains functional for current Python versions (3.9–3.14).

License in practice

License treatment is unclear; no SPDX identifier or raw license text is available in the metadata. Verify the actual license terms before adopting in a commercial or restricted-license context.

Quickstart

pip install atlas-provider-sqlalchemy

from atlas_provider_sqlalchemy.ddl import print_ddl
print_ddl("mysql", [])

Requires Atlas CLI installed separately (curl -sSf https://atlasgo.sh | sh on macOS/Linux); the provider runs within your project's Python environment and extracts schema from SQLAlchemy models.

Verify before relying

• Whether the unclear license status is a documentation gap or a genuine licensing issue that could affect use.
• Current state of the upstream repository and whether this provider is actively maintained.
• Whether ClickHouse support is fully tested or experimental.
• Actual license terms, given that the description excerpt references Apache License 2.0 but metadata shows no SPDX identifier.

Package facts

Evidence: atlas_provider_sqlalchemy-0.5.0-py3-none-any.whl

Tags

More Database packages