Show HN: Visual Database Schema Designer (Angular 21 and .NET 10)

Posted by temakonkin 5 days ago

Counter6Comment4OpenOriginal

Hi HN, OP here.

I built this because I was frustrated with the current state of DB design tools. They are usually either heavy enterprise desktop apps (like DataGrip/Workbench) or simple drawing tools that don't export usable code.

I wanted a "VS Code-like" experience in the browser: dark mode, strict typing, and instant visual feedback.

The tech stack is quite aggressive: - Frontend: Angular 21 (Latest). I'm using Signals exclusively for the graph state management to handle 100+ nodes without layout thrashing. - Backend: .NET 10 for DDL generation and schema validation.

Current features: - Visual Table/Column editor. - Drag & drop relationships (1:N handling). - Exports to PostgreSQL DDL and Entity Framework Core.

It's an MVP, so I'm looking for feedback on the graph interaction and the UI feel.

Does the "IDE-like" layout work for you for this kind of task?

Comments

Comment by temakonkin 5 days ago

Hi HN, OP here.

I built this because I was frustrated with the current state of DB design tools. They are usually either heavy enterprise desktop apps (like DataGrip/Workbench) or simple drawing tools that don't export usable code.

I wanted a "VS Code-like" experience in the browser: dark mode, strict typing, and instant visual feedback.

The tech stack is quite aggressive: - Frontend: Angular 21 (Latest). I'm using Signals exclusively for the graph state management to handle 100+ nodes without layout thrashing. - Backend: .NET 10 for DDL generation and schema validation.

Current features: - Visual Table/Column editor. - Drag & drop relationships (1:N handling). - Exports to PostgreSQL DDL and Entity Framework Core.

It's an MVP, so I'm looking for feedback on the graph interaction and the UI feel.

Does the "IDE-like" layout work for you for this kind of task?

Comment by temakonkin 4 days ago

2025.01.20

I added user management to the design today, and UI mapping for changes in the database.

Comment by QuiCasseRien 5 days ago

very nice ! Does there is a setting to show the description in the canvas ? The idea is to print the whole schema, included description.

Thanks

Comment by temakonkin 5 days ago

of course, each object (instance, database, schemas, tables, columns) has a "description" field. If you add it, then when you hold the cursor over the object for a second, the description type will be displayed (this is useful if you need to document the database).

Comment by temakonkin 5 days ago

[dead]