TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Show HN: Private, text to entity-relationship diagram tool

262 点作者 npack将近 2 年前

34 条评论

shizcakes将近 2 年前
We&#x27;ve been using <a href="https:&#x2F;&#x2F;dbdiagram.io&#x2F;" rel="nofollow">https:&#x2F;&#x2F;dbdiagram.io&#x2F;</a>, which also has an open-source markup language: <a href="https:&#x2F;&#x2F;github.com&#x2F;holistics&#x2F;dbml">https:&#x2F;&#x2F;github.com&#x2F;holistics&#x2F;dbml</a>
评论 #36245358 未加载
评论 #36249921 未加载
评论 #36245222 未加载
评论 #36245469 未加载
评论 #36245163 未加载
sbuttgereit将近 2 年前
From what I can tell, a lot of these tools seem OK for capturing relatively simple database designs, but at least &quot;look&quot; fairly inadequate for more robust needs. This makes sense if you&#x27;re trying to use a GUI for creating a database: there&#x27;s going to be limits to how much you can accomplish easily with that approach so being robust for smaller databases works out.<p>Most of the time I want an ERD tool it&#x27;s to capture a database that I&#x27;ve already built for documentation purposes, or to document a database that someone else has built and that I need to come to terms with.<p>For this I use SchemaSpy (<a href="https:&#x2F;&#x2F;schemaspy.org&#x2F;" rel="nofollow">https:&#x2F;&#x2F;schemaspy.org&#x2F;</a>). I let it reverse engineer the database, build the diagrams, etc. I like the way it organizes what it captures and that it will do things like capture in-database object comments and put them in sensible places; for example, this lets me use the PostgreSQL COMMENT ON * commands to add contextually relevant documentation in the DDL and this tool will do the right thing when I generate database documentation.
评论 #36249637 未加载
mih将近 2 年前
The issue I have with a lot of these tools is they work fine when depicting relationships between tables in the same schema (talking mainly about PostgreSQL databases), but few support showing relationships between tables across different schemas.<p>Also, when the number of tables grows large, few have layouts arranged in an optimal way. I use D2 (<a href="https:&#x2F;&#x2F;d2lang.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;d2lang.com&#x2F;</a>) to create ERDs. However, of the free layout engines available in D2, Dagre (<a href="https:&#x2F;&#x2F;github.com&#x2F;dagrejs&#x2F;dagre">https:&#x2F;&#x2F;github.com&#x2F;dagrejs&#x2F;dagre</a>) and ELK (<a href="https:&#x2F;&#x2F;github.com&#x2F;eclipse&#x2F;elk">https:&#x2F;&#x2F;github.com&#x2F;eclipse&#x2F;elk</a>) both don&#x27;t have optimal placement of layouts for a sufficiently complicated database.
graypegg将近 2 年前
Jetbrains has their own mermaid plugin they started working on recently, and honestly, I’ve found mermaid to be really all I need.<p><a href="https:&#x2F;&#x2F;plugins.jetbrains.com&#x2F;plugin&#x2F;20146-mermaid&#x2F;reviews" rel="nofollow">https:&#x2F;&#x2F;plugins.jetbrains.com&#x2F;plugin&#x2F;20146-mermaid&#x2F;reviews</a>
评论 #36249630 未加载
ElFitz将近 2 年前
Oh! I thought this was something about describing a data model in plain text and having an LLM generate the entity-relationship diagram tool.<p>I’ve done this with GPT4, asking it to output Mermaid relationship diagrams. And it’s usually impressively good (never went beyond ~10 entities). I also had it update and fix the result using natural language feedback.<p>I sometimes had to touch up a few things &quot;by hand&quot;, but I really wouldn’t bother doing it from scratch myself anymore.<p>Even the failures are interesting, as they often result from an unclear description, or issues in my own understanding of the domain or model.
评论 #36252205 未加载
smusamashah将近 2 年前
I am somewhat maintaining a list of text to diagram tools at <a href="https:&#x2F;&#x2F;xosh.org&#x2F;text-to-diagram&#x2F;" rel="nofollow">https:&#x2F;&#x2F;xosh.org&#x2F;text-to-diagram&#x2F;</a> (will add this one too)<p>These are two other dedicated tools I have on the list<p><a href="https:&#x2F;&#x2F;app.quickdatabasediagrams.com&#x2F;#&#x2F;" rel="nofollow">https:&#x2F;&#x2F;app.quickdatabasediagrams.com&#x2F;#&#x2F;</a><p><a href="https:&#x2F;&#x2F;dbdiagram.io&#x2F;d" rel="nofollow">https:&#x2F;&#x2F;dbdiagram.io&#x2F;d</a>
评论 #36248787 未加载
评论 #36248351 未加载
saadatq将近 2 年前
I love that this is trending on HN. LLMs be damned. We still have lots of “simple” problems to be solved, like how to effectively write and share an ERD.
评论 #36250605 未加载
kapv89将近 2 年前
Great ! I am also excited to share ERDTOOL built in this space - <a href="https:&#x2F;&#x2F;erdtool.com" rel="nofollow">https:&#x2F;&#x2F;erdtool.com</a> ... - Multiplayer entity-relationship-diagramming tool - think Figma of ERDs - Supports Postgresql and MySQL (mysql part is new homepage hasn&#x27;t been updated to reflect that) Building it solo. I hope this will also interest the tech community
capitanazo77将近 2 年前
Created this python script to export mysql to this format. Used chatgpt so expect weird code.<p>it works! but dies a little with many tables :-)<p>code: <a href="https:&#x2F;&#x2F;paste.rs&#x2F;1ZHp7.py3" rel="nofollow">https:&#x2F;&#x2F;paste.rs&#x2F;1ZHp7.py3</a><p>screenshot: <a href="https:&#x2F;&#x2F;i.imgur.com&#x2F;4D2hEWc.png" rel="nofollow">https:&#x2F;&#x2F;i.imgur.com&#x2F;4D2hEWc.png</a>
评论 #36251267 未加载
flarg将近 2 年前
I just today discovered that draw.io auto converts Mermaid to editable shapes in draw.io. The best of both worlds!
laowantong将近 2 年前
My own tool adopts a mixed approach to the layout problem : diagram-as-text, but the line breaks and the order of the boxes (entities and relations) are used as position hints. The resulting layout is constrained to an invisible grid corresponding to a left-to-right and top-to-down reading of the source.<p>Moreover, since there are relatively few possible grid positions, automatically rearranging the layout becomes an assignment problem, which can be solved by a simple b&amp;b algorithm.<p>Obviously, this wouldn&#x27;t scale, but this is just a teaching tool that I use to present small ERDs to my students.<p>You may test it at <a href="https:&#x2F;&#x2F;mocodo.net" rel="nofollow">https:&#x2F;&#x2F;mocodo.net</a>. Click the turning arrows symbol to draw the diagram and the shuffle symbol to rearrange it randomly.<p>Warning: French-flavored ERD, aka Merise MCD.
manishsharan将近 2 年前
I am using ChatGPT to generate PlantUML Entity Diagrams. I have a separate chat just for this purpose. It can generate the PlantUML and Spring JPA Java code for all my entities. If I need a change , I ask it to update the model and generate updated diagram and code. It also generate Liquibase xml changeset. Moreover, it can also generate my GraphQL schema .. and update it when I change the data model.<p>This is the friggin&#x27; holy grail of all diagramming and modeling tools. And it is available and working now. Everything else is just too primitive !
otto_ortega将近 2 年前
Cool tool. My favorite tool for text to model &#x2F; model to SQL is: <a href="https:&#x2F;&#x2F;app.quickdatabasediagrams.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;app.quickdatabasediagrams.com&#x2F;</a>
评论 #36246009 未加载
评论 #36249913 未加载
hackish将近 2 年前
Thanks! I was writing a FastAPI&#x2F;SQLAlchemy+SQLModel&#x2F;Rocketry app this week and dreaded documenting my model relationships. That said, I see a few SQLAlchemy extensions and Pydantic→Mermaid projects that can probably be used in my case, and that was the route I was initially planning on going down despite none of them being aesthetically pleasing.<p>Many of these online tools reasonably rely on human input to place tables&#x2F;nodes. Do any of these recommended tools do a decent job of smartly laying out the final diagram?
评论 #36245433 未加载
text2db将近 2 年前
Something similar made by me (text2db) long time ago, cannot maintained it, but if someone wants to continue, code is available on github<p><a href="https:&#x2F;&#x2F;stackblitz.com&#x2F;edit&#x2F;web-platform-hxc9oz?file=index.html" rel="nofollow">https:&#x2F;&#x2F;stackblitz.com&#x2F;edit&#x2F;web-platform-hxc9oz?file=index.h...</a><p><a href="https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?v=8hYtZ38wuz4">https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?v=8hYtZ38wuz4</a>
评论 #36254182 未加载
评论 #36264988 未加载
d4rkp4ttern将近 2 年前
Ah, diagrams from text. Every few months I look into producing slides, and look for something that saves me from having to use a mouse-intensive tool like PowerPoint or KeyNote, preferably using Markdown. There are plenty of tools to make markdown slides — slidev, Marp (esp w VSCode extension), HackMD, etc. But for diagrams I haven’t converged on a good workflow. Maybe mermaid is worth spending time with.
digitalsanctum将近 2 年前
I love tools like this (text to diagram) and tend to use mermaid for most things. I also really like draw.io which includes a gui and has integration with GitHub to save diagrams directly to a source repo.<p>Is there a solution that has direct, bi-directional integration with Postgres&#x2F;MySQL. For example, execute DDL from the diagram or point to an existing db and output the diagram text?
评论 #36247528 未加载
评论 #36245582 未加载
rjbwork将近 2 年前
Since this thread is likely to attract good answers to this...<p>Are there any Terraform-like declarative tools for your schemas that will do a diff and generate a change script?<p>I&#x27;ve seen liquibase and it&#x27;s just a series of migrations which I think is pretty gross.<p>I really like MS&#x27;s SSDT tools, but the DACPAC workflow is pretty heavy to operationalize, though doable.
评论 #36246268 未加载
davidktr将近 2 年前
This looks fantastic, exactly what I needed last time I worked with DBs and could not find. Hope to be using it soon.
Kwpolska将近 2 年前
1. Why not just use SQL?<p>2. You should really work on error handling. I went to &#x2F;app and tried changing the name of the CustomerID column, and nothing happened. I tried changing something else and it didn’t work either. It should tell me that the other table is mentioning a non-existent column and the input is invalid.
评论 #36249783 未加载
sexydev将近 2 年前
I use ERDLab<p>Check it out at <a href="https:&#x2F;&#x2F;app.erdlab.io&#x2F;designer&#x2F;new" rel="nofollow">https:&#x2F;&#x2F;app.erdlab.io&#x2F;designer&#x2F;new</a><p>Has a lot more cool features for better visual representation like color tagging and search.<p>I also like the ability to create tables&#x2F;notes using the canvas even though it has DDL support.
jrm4将近 2 年前
When I see things like this, now my immediate question is always: what&#x27;s the underlying model? Is this like a generally open and free thing, with maybe a little bit of monetization to keep the lights on? Then that&#x27;s great.<p>But, if this is looking to be a big moneymaker? eh, nah.
评论 #36246360 未加载
vegarab将近 2 年前
I&#x27;m not too familiar with ER-diagrams -- how does this compare to Mermaid? <a href="https:&#x2F;&#x2F;mermaid.js.org&#x2F;syntax&#x2F;entityRelationshipDiagram.html" rel="nofollow">https:&#x2F;&#x2F;mermaid.js.org&#x2F;syntax&#x2F;entityRelationshipDiagram.html</a>
评论 #36244506 未加载
kholdstayr将近 2 年前
Is it possible to resize a table in the diagram? I work on a database that has a column name of &quot;order_module_order_num&quot; and if you try putting that in the text doesn&#x27;t fit. The text runs into the data type.
评论 #36249843 未加载
verelo将近 2 年前
Love it, is there any way to make it a little more fuzzy. Ie pk works but &quot;primary key&quot; doesnt, uint works, but &quot;integer unsigned&quot; doesnt?<p>Great idea for helping teams communicate.
评论 #36244534 未加载
mattdocumatt将近 2 年前
I’m a tech writer and love the idea of “drawing” diagram using the markup. Definitively will try to use it by my another docs project. Thank you.
allanrbo将近 2 年前
did you consider letting the input be just sql ddl rather than yet another layer of ddl?
评论 #36249875 未加载
mfru将近 2 年前
for lighter usage, i am using Database Designer on Android.<p>it is surprisingly easy to use and most of my ideas never come up when i&#x27;m on my pc anyway.
fallingmeat将近 2 年前
neato! anyone interested in a collab on a more generic natural language graph making tool (think GoJS powered by LLM to make SysML diagrams etc). Demo of api here, I cant do front end, it is a weakness…<p><a href="https:&#x2F;&#x2F;grapher.baselines.cloud&#x2F;" rel="nofollow">https:&#x2F;&#x2F;grapher.baselines.cloud&#x2F;</a><p>hit me up on linkedin: &#x2F;in&#x2F;thenatefisher
评论 #36245395 未加载
tessbi将近 2 年前
Very cool!
Cypher将近 2 年前
why no dark modeeee ahh
penciltwirler将近 2 年前
just use dbdiagram.io
yieldcrv将近 2 年前
lpt: ask chatgpt or other sufficient LLMs for catchy domain name variations. I specifically ask for &quot;in web 2.0 style&quot;.<p>I crank out short catchy brand names and domain names at far greater efficacy now, steers my thoughts really well if I’m not outright taking the first suggestion verbatim
shinkim0914将近 2 年前
&gt; Generate DDL directly generate SQL statements to create your database tables.<p>Looks like it&#x27;s capable of turning a diagram to SQL too? That&#x27;s neat!<p>For those that are interested in an GPT-powered tool, we have a project that can generate diagrams from code of any language or natural language: <a href="https:&#x2F;&#x2F;eraser.io&#x2F;diagramgpt" rel="nofollow">https:&#x2F;&#x2F;eraser.io&#x2F;diagramgpt</a>