Related, something I wrote years ago:
https://pypi.org/project/quickpiggy/
From its README:
A makeshift PostgresSQL instance can be obtained quite easily:
pig = quickpiggy.Piggy(volatile=True, create_db='somedb')
conn = psycopg2.connect(pig.dsnstring())