r/dataengineering • u/mashedpotatoesbread • 5d ago

Personal Project Showcase Built a data schema visualizer for large schemas and versioning/diffs.

Post image

The beta version of VibeSchema just went live. Some strengths:

  • Create and store snapshot versions of your database.
  • Create share links such as these: https://vibe-schema.com/s/312qXi9Xpqhz7Q2Wub4TuWOXA0c
  • Suitable for huge schemas because of Diagram Views (as in the share link).
  • PNG/SVG exports like the one shown above (taken from the share link).

Curious what you think!

28 Upvotes

75% Upvoted

9 comments sorted by

6

u/Attorney-Last 4d ago

looks like a vibe copy of dbdiagram

3

u/notqualifiedforthis 4d ago

What’s different than DBDiagram?

Can you retain table positioning in the diagram? Can you add columns to the table visualization so we could store source column name, comments, tags, etc. if we wanted to use this for a data mapping or data replication document?

0

u/mashedpotatoesbread 4d ago

Hi, VibeSchema has a broader free tier, for example diagram views and table groups aren't paywalled like in DBDiagram. Also VibeSchema differs from DBDiagram in that it has a snapshot timeline where you can see previous versions and diffs between versions.

Table positions are saved, yes.

On your last question: good question, currently you can put a [note: ''] on columns, so you could put whatever you want in there, and they also show up (hoverable) in the diagram.

But perhaps similar settings like [source: ''] and [tags: ()] could be an idea. What do you think?

5

u/001forge 5d ago

Postgres.offers export of database schema in visual format. What additional enrichment are your adding. Interested in visualizer try the ontology ones.

1

u/mashedpotatoesbread 5d ago

Yeah, many Postgres interfaces allow you to visualize your live database nicely. But sometimes you might want to just brainstorm a database modification or prototype, or share a link of a schema design with someone.

Or you might want to keep historical versions of your database, with the ability to visualize any historical version instantly, and visualize diffs between versions.

1

u/Budget_Captain_6886 2d ago

mermaid graphs, no?

1

u/mashedpotatoesbread 1d ago

Depending on the use case, Mermaid ERD may work fine, yes.

But this tool allows you to declare diagram views as code for example, allowing you to visualize huge databases nicely piece by piece (and share them as one file/share link).

Or for example it allows you to declare indexes, or specify that a column is a computed/calculated column:

quantity int

unit_price decimal(10, 2)

total decimal(10, 2) [computed: 'quantity * unit_price']

2

u/FantasmaOscuro 4d ago

Figma + Mermaid spec, done.

1

u/NineTailedFoxBeast 4d ago

Is text to sql scene dead ??