Another cool trick - use ephemeral memory SQLite database during unit tests:

conn = sqlite3.connect(":memory:")

But also run against your prod-like database (Postgres/MySQL etc.) later in the CI pipe to catch idiosyncratic database problems.