Show HN: Visual Database Schema Designer (Angular 21 and .NET 10)
6 points by temakonkin a day ago | 4 comments
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?

  • temakonkin a day 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?

  • QuiCasseRien a day 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

    • temakonkin a day 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).
  • temakonkin 6 hours ago |
    2025.01.20

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