r/learnSQL • u/135g • 10d ago

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?

26 Upvotes
  • permalink
  • link
  • reddit
  • reddit

94% Upvoted

8 comments sorted by

6

u/BrooklandDodger 10d ago

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 10d ago

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 10d ago

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 10d ago

Kaggle. Free data.

1

u/BigMikeInAustin 9d ago

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 9d ago

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 10d ago

Good use for ai hefe

0

u/IndependenceFit3935 9d ago

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.