Maybe use pglite (which wraps postgres-wasm)? Readme indicates it can run in-memory.

Doesn't solve your testing-data question, but it'll save you from spinning up a new DB.

https://github.com/electric-sql/pglite/

https://github.com/electric-sql/postgres-wasm