configure-alembic-async-ddl

Community

Configure async SQLAlchemy Alembic migrations without conflicts.

Authorruskibeats
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill helps configure Alembic migrations for async SQLAlchemy applications, ensuring compatibility with async SQLAlchemy engines while using sync DDL connections.

Core Features & Use Cases

  • DDL Compatibility: Strips async driver suffix for DDL-compatible sync connections.
  • Target Metadata Wiring: Wiring target_metadata to the actual MetaData object.
  • NullPool for Migrations: Using NullPool for migration connections.
  • Online & Offline Modes: Supports both online and offline migration operations.
  • Verification: Includes verification steps to ensure correct DDL changes are detected.

Quick Start

To configure Alembic for async SQLAlchemy, first identify your MetaData object, then in env.py, strip the async driver suffix from the connection string. Wire the target_metadata to your MetaData object, and create a sync engine for online migrations using NullPool.

Dependency Matrix

Required Modules

psycopg2-binary

Components

scripts

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: configure-alembic-async-ddl
Download link: https://github.com/ruskibeats/t1d/archive/main.zip#configure-alembic-async-ddl

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.