dbwarden 0.2.2

Database migration system for Python/SQLAlchemy projects

DBWarden

A database migration system for Python/SQLAlchemy projects.

---

Installation

pip install dbwarden

Configuration

⚠️ Warning

This is an experimental package. Your fuckups are not mine to fix. You have been warned.

Even though this is an experimental package, I added lots of failsafes to protect the connected DB as to avoid issues.

Create warden.toml in your project:

database_type = "sqlite"
sqlalchemy_url = "sqlite:///./development.db"

ClickHouse example:

database_type = "clickhouse"
sqlalchemy_url = "clickhousedb+connect://user:password@localhost:8123/analytics"

Basic Commands

Command	Description
dbwarden init	Initialize migrations directory
dbwarden make-migrations "name"	Generate SQL from SQLAlchemy models
dbwarden migrate	Apply pending migrations
dbwarden migrate --verbose	Apply with detailed logging
dbwarden rollback	Revert the last migration
dbwarden history	Show migration history
dbwarden status	Show current status
dbwarden config	Show current configuration
dbwarden check-db	Inspect DB schema
dbwarden diff	Show models vs DB differences

SQLAlchemy Models

DBWarden automatically detects models in models/:

# models/user.py
from sqlalchemy import Column, Integer, String
from sqlalchemy.orm import declarative_base

Base = declarative_base()

class User(Base):
    __tablename__ = "users"
    id = Column(Integer, primary_key=True)
    name = Column(String(100))
    email = Column(String(255), unique=True)

Complete Example

# 1. Initialize
dbwarden init

# 2. Create models in models/

# 3. Generate migration from models
dbwarden make-migrations "create users table"

# 4. Apply
dbwarden migrate --verbose

# 5. View history
dbwarden history

# 6. Check configuration
dbwarden config

Supported Databases

• PostgreSQL
• SQLite
• MySQL
• ClickHouse

Docs

For more information, see DBWarden Docs or DBWarden DeepWiki page

License

This Project is Licensed under the MIT License. See LICENSE