A consistent interface for maintenance operations on database engines not covered by SQLAlchemy.
Chooses opinionated drivers with both async + sync support, as well as support for Alembic.
exists
- Check if database existscreate
- Create a new databaseinit
- Create all tables in the given database, optionally dropping firstlist_tables
- List tables in the databaseis_blank_slate
- Check if database is either missing or exists but is emptyalembic
- Run any of the alembic commands on the given database
- SQLite (
aiosqlite
) - Postgres (
asyncpg
) - MS Sql (
pyodbc
andaioodbc
)