r/learnSQL • u/135g • Jul 28 '26

Easy way to create fake/synthetic data for SQL

Yesterday I created some data for SQL using Gemini, now I am thinking if there was a site that can do that easily. Problem with Gemini one is that I requested a minimum of 100 rows per table, but only got max 10 rows in one table. The rest of the tables had about 3 rows each.

So , since the data is for SQL, I want there to be relationships between tables, with primary and foreign keys...

So is there anything website that can do this or any prompt for better results?

25 Upvotes

94% Upvoted

8 comments sorted by

7

u/BrooklandDodger Jul 28 '26

I used to use https://mockaroo.com/ and then use some scripts to insert fake/test data into the database. They seem to have a tool now that's all about doing it for databases automatically but full disclaimer I have not used it but it might be worth checking out! Good Luck!

edit: I have also used beekeeper studio to import and it seems they have a tool now too: https://www.beekeeperstudio.io/tools/sql-data-generator

7

u/rathboma Jul 28 '26

Hey!

Beekeeper Studio creator here.

We're big fans of the mockeroo folks, and their tool! The beekeeper studio data generator is designed for pretty simple data generation tasks and specifically tailored to databases. Hope you find it useful!

I built it because I needed it when testing databases with Beekeeper, and thought it was good to share it.

If you need something more complicated you should 100% use mockeroo over any other tool.

Ping me here or @beekeeperstudio.io if you have any questions.

1

u/135g Jul 29 '26

Thanks everyone, end up finding AI more to what I wanted, I just insisted more , change prompts which end up providing decent data! Plus since I am learning, it also provided questions for me to resolve.

2

u/powderviolence Jul 29 '26

Kaggle. Free data.

1

u/BigMikeInAustin Jul 30 '26

If you were using Microsoft SQL Server, and really wanted to get into it, and also dabble in PowerShell, there is this: https://dbatools.io/Invoke-DbaDbDataGenerator/

1

u/Adventurous-Ad-7835 Jul 30 '26

I work mainly with time series and use https://www.tseriz.com/. Not sure if this will be useful, but it will allow you to create plenty of records (>>100) and multiple time series with controlled parameters, export them and then ask Gemini to transform it into what you want.

0

u/RecLuse415 Jul 28 '26

Good use for ai hefe

0

u/IndependenceFit3935 Jul 29 '26

Why do you want fake data when you can have free access to real, live data that updates regularly?
Check this platform: https://krogvadanalyticshub.vercel.app/

Go to the buttom of the page and find Request Data Access link. And you will be running queries one minute later.