Tools to generate data

[divyenduz]

We have a lot of schemas and some of them have data. We would love to use tools to generate fake data for all of them and keep it as data.sql next to the schema.sql file.

Call for community to help out with suggestions.

[thenonameguy]

I'm open to developing this feature for Postgres!

I already loaded some schemas from this repo into my data ingestion platform, that infers the correct SQL mutation ordering (INSERTs/UPDATEs needed to fill all columns).

Here is an example for Mastodon:

I'm considering a similar approach to: https://gitlab.com/geometalab/pgsynthdata
with some extra niceties, like considering CHECK constraints and removing some data type limitations.

Would you be interested in this?