---
id: atlas-provider-sqlalchemy
version: "0.5.0"
license: unclear
license_treatment: unclear
maintenance: aging
---

# atlas-provider-sqlalchemy — Load sqlalchemy models into an Atlas project.

License: unclear · Maintenance: aging · Downloads: 165.0K/mo

## 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 above — 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

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

- License: not declared (unclear)
- Python support: supports_current
- Install friction: low
- Maintenance: aging
- Downloads: 165.0K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sqlalchemy schema migration, database schema as code, atlas sqlalchemy provider, automatic migration generation, declarative database migrations, schema drift detection, sqlalchemy ddl extraction, schema-migration, sqlalchemy-integration, infrastructure-as-code

[View on SkillFed](https://skillfed.io/packages/atlas-provider-sqlalchemy) · [View on PyPI](https://pypi.org/project/atlas-provider-sqlalchemy/)