alembic.ini – Configuration file for Alembic


A generic, single database configuration.


path to migration scripts

script_location = alembic

template used to generate migration files file_template = %%(rev)s_%%(slug)s


max length of characters to apply to the “slug” field

#truncate_slug_length = 40

set to ‘true’ to run the environment during the ‘revision’ command, regardless of autogenerate revision_environment = false


set to ‘true’ to allow .pyc and .pyo files without a source .py file to be detected as revisions in the versions/ directory sourceless = false


version location specification; this defaults to alembic/versions. When using multiple version directories, initial revisions must be specified with –version-path version_locations = %(here)s/bar %(here)s/bat alembic/versions


the output encoding used when revision files are written from output_encoding = utf-8

#sqlalchemy.url = sqlite:///book_webapp.sqlite
sqlalchemy.url = postgres://

Logging configuration

keys = root,sqlalchemy,alembic

keys = console

keys = generic

level = WARN
handlers = console
qualname =

level = WARN
handlers =
qualname = sqlalchemy.engine

level = INFO
handlers =
qualname = alembic

class = StreamHandler
args = (sys.stderr,)
level = NOTSET
formatter = generic

format = %(levelname)-5.5s [%(name)s] %(message)s
datefmt = %H:%M:%S