PostgreSQL

pip install astapa

from astapa import Astapa

client = Astapa(
    api_url="http://localhost:8080",
    proxy_host="localhost",
    proxy_port=5433,
)

session = client.create_session(project_id="my-project")
session.connect(database="mydb", user="postgres", password="pass")

session.execute("UPDATE users SET status = 'active' WHERE id = 1")
print(session.diff())

session.propose()
session.approve()

with client.session(
    project_id="demo",
    database="mydb",
    user="postgres",
    password="pass",
) as session:
    session.execute("INSERT INTO orders (user_id, amount) VALUES (1, 99.99)")
    # auto-proposes on exit

import psycopg2

conn = psycopg2.connect(
    host="localhost",
    port=5433,
    database="mydb",
    user="postgres",
    password="pass",
    options=f"-c astapa_session={session.id}"
)