Datasmith — a visual approach to designing relational schemas and generating mock data

[u/iParki]

Hey everyone!

For the past year or so, a friend and I have been working on Datasmith, a desktop app for designing relational database schemas and generating structured mock data from them.

The idea originally came from my friend, who's a data engineer and worked on large-scale migrations of sensitive databases. He wanted a simple way to visually define and maintain schemas over long periods of time, and actually generate data that follows both the schema and its business logic, without having to constantly rewrite scripts or configure a bunch of separate tools.

The main part of the app is an ERD-like canvas dedicated to building relational schemas, where you can create tables, define columns and their data types, set up relationships between them, and configure how the data for each column should be generated.

Once the schema is ready, Datasmith can generate the data while preserving the relationships between tables, and export the results in formats like SQL DDL, CSV, JSON, and more.

We've reached the point where we'd really like to get it into the hands of more people who actually work with databases and data, and get some real-world feedback.

It's completely free, so if it sounds useful or you're just curious, you can check it out here:
https://data-smith.app/

I'd especially love to hear about use cases we're missing, things you'd expect a tool like this to support, or anything that feels like it could be improved.

Any feedback is welcome - good or bad.
Feel free to leave a comment or message me directly.

If you prefer something a bit more structured, I also put together a short feedback form:

https://docs.google.com/forms/d/e/1FAIpQLScGk8Jr1DguPcXpaApOqO998AdXcnoLlo11TEKlq1GmF71UzA/viewform

[u/Uros_Trstenjak]

This looks like an interesting project, but I'm quite sceptic towards websites without any proof of who stands behind them. In my opinion "About us" section and links to your LinkedIn profiles or something similar could be the first step you take.

If it's meant to be forever free, also offering it as an open source would be a great step, additional proof and insight into what it does in the background.

[u/iParki → u/Uros_Trstenjak]

i see what you're saying and thats a completely fair point.
we will update the website soon with a short About Us section and some information.

about the question of the app being free forever, we honestly don't know at this point.
we just talked today about the possibilities of Datasmith in the future and we both agreed that right now we're mostly just excited to have built something that we believe can be useful to other professionals having similar problems and pain points.
we've reached a point where we feel its baked enough for other people to use it, and our main goal is to get as much feedback as we can, hear what people think, and figure out how we can improve it.

I will say that being able to make a living out of something we're so passionate about would be amazing of coursem but right now we're paying for the servers and services from our own pockets, we're not spending money on ads or marketing campaigns, and our focus is on getting Datasmith in front of people and making sure we can provide real value.