Welcome to Jetbase 🚀

Jetbase is a simple, lightweight database migration tool for Python projects.

Jetbase helps you manage database migrations in a simple, version-controlled way. Whether you're adding a new table, modifying columns, or need to undo a change, Jetbase makes it super easy!

Created and maintained by Jaz 🛠️

Key Features ✨

📦 Simple Setup — Get started with just one command
⬆️ Easy Upgrades — Apply pending migrations with confidence
⬇️ Safe Rollbacks — Made a mistake? No problem, roll it back!
📊 Clear Status — Always know which migrations have been applied and which are pending
🔒 Migration Locking — Prevents conflicts when multiple processes try to migrate
✅ Checksum Validation — Detects if migration files have been modified
🔄 Repeatable Migrations — Support for migrations that run on every upgrade

📚 Full Documentation

Quick Start 🏃‍♂️

Installation

Using pip:

pip install jetbase

Using uv:

uv add jetbase

Note for Snowflake, Databricks, and ClickHouse Users:
To use Jetbase with Snowflake, Databricks, or ClickHouse, install the appropriate extras:
pip install "jetbase[snowflake]"
pip install "jetbase[databricks]"
pip install "jetbase[clickhouse]"

Initialize Your Project

jetbase init
cd jetbase

This creates a jetbase/ directory with:

A migrations/ folder for your SQL files
An env.py configuration file

Configure Your Database

Edit jetbase/env.py with your database connection string (currently support for PostgreSQL, SQLite, Snowflake, Databricks, MySQL, ClickHouse):

PostgreSQL example:

sqlalchemy_url = "postgresql+psycopg2://user:password@localhost:5432/mydb"

SQLite example:

sqlalchemy_url = "sqlite:///mydb.db"

Create Your First Migration

jetbase new "create users table" -v 1

This creates a new SQL file called V1__create_users_table.sql.

Tip:
You can also create migrations manually by adding SQL files in the jetbase/migrations directory, using the V<version>__<description>.sql naming convention (e.g., V1__add_users_table.sql, V2.4__add_users_table.sql).

Write Your Migration

Open the newly created file and add your SQL:

-- upgrade
CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(255) UNIQUE NOT NULL
);

CREATE TABLE items (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100) NOT NULL
);

-- rollback
DROP TABLE items;
DROP TABLE users;

Apply the Migration

jetbase upgrade

That's it! Your database is now up to date. 🎉

Note:
Jetbase uses SQLAlchemy under the hood to manage database connections.
For any database other than SQLite, you must install the appropriate Python database driver.
For example, to use Jetbase with PostgreSQL:

pip install psycopg2

You can also use another compatible driver if you prefer (such as asyncpg, pg8000, etc.).

Supported Databases

Jetbase currently supports:

✅ PostgreSQL
✅ SQLite
✅ Snowflake
✅ Databricks
✅ MySQL
✅ ClickHouse

Need Help?

Open an issue on GitHub!

Metadata

Release files for jetbase 0.18.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for jetbase 0.18.1
File	Size	Uploaded
jetbase-0.18.1.tar.gz	186.3 kB	Aug 6, 2026	Details

Built distribution (wheel)

Table of built distributions (wheels) for jetbase 0.18.1
File	Interpreter	ABI	Platform	Reset
jetbase-0.18.1-py3-none-any.whl 57.4 kB Aug 6, 2026	Python 3	none	any	Details

Total release size: 243.7 kB

Release files / jetbase-0.18.1.tar.gz

Download URL	jetbase-0.18.1.tar.gz
Size	186.3 kB
Tags	Source
SHA-256 checksum How to use checksums	`cbd05f227cf6d0e43c7f76a82119172610146750be913cbd8cba7ea8c9a8e250`
BLAKE2b-256 checksum How to use checksums	`c6e6db8bc5699c53cd1a198622b5dfb72b7d33132f195630a00ac8a2507622fb`
Upload date	Aug 6, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/jetbase-hq/jetbase
Publishing commit: github.com/jetbase-hq/jetbase/tree/bf1892d6f6b98611e085111bffe508e6329349b5

Workflow

Publishing configuration: github.com/jetbase-hq/jetbase/blob/bf1892d6f6b98611e085111bffe508e6329349b5/.github/workflows/publish.yml
Publishing logs: github.com/jetbase-hq/jetbase/actions/runs/31067640679/attempts/1

Artifact

Subject: jetbase-0.18.1.tar.gz
SHA-256 checksum: cbd05f227cf6d0e43c7f76a82119172610146750be913cbd8cba7ea8c9a8e250 Verifying attestations

Release files / jetbase-0.18.1-py3-none-any.whl

Download URL	jetbase-0.18.1-py3-none-any.whl
Size	57.4 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`3086bc2b57e7e6a5f3a858b3eb0d926620bcf9a137296982d466c395d7bd8b3e`
BLAKE2b-256 checksum How to use checksums	`7cbb2517b0c8feadacd57e51339a038d8ff70103e9ee809956d9a203e8cb2289`
Upload date	Aug 6, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/jetbase-hq/jetbase
Publishing commit: github.com/jetbase-hq/jetbase/tree/bf1892d6f6b98611e085111bffe508e6329349b5

Workflow

Publishing configuration: github.com/jetbase-hq/jetbase/blob/bf1892d6f6b98611e085111bffe508e6329349b5/.github/workflows/publish.yml
Publishing logs: github.com/jetbase-hq/jetbase/actions/runs/31067640679/attempts/1

Artifact

Subject: jetbase-0.18.1-py3-none-any.whl
SHA-256 checksum: 3086bc2b57e7e6a5f3a858b3eb0d926620bcf9a137296982d466c395d7bd8b3e Verifying attestations