Skip to content


The PostgreSQL driver depends on psycopg2 and can be installed with:

pip install "sayn[postgresql]"

The PostgreSQL connector looks for the following parameters in the credentials settings:

Parameter Description Default
host Host name or public IP of the server Required
port Connection port 5432
user User name used to connect Required
password Password for that user Required
dbname Database in use upon connection Required

Other parameters specified will be passed to sqlalchemy.create_engine when creating the engine.


    type: postgresql
    port: 5432
    user: pg_user
    password: 'Pas$w0rd' #use quotes to avoid conflict with special characters
    dbname: models

Check the sqlalchemy psycopg2 dialect for extra parameters.