I created a library that can pragmatically insert data into a postgres database. This solves an itch where you need to test some part of your system that relies on a some set of tables, but you have to fulfill a set of constraints (fk, data type) that you dont care about. https://github.com/drewverlee/fk-gen Its possible, that if you have this issue, you might consider relaxing your database to be more of a datastore. Regardless, this problem tends to plague me at most shops. feedback and input welcome