# DBDiagram: A Relational Database Diagram Design Tool **URL:** \ **Category:** Resources\ **Tags:** utility\ **Created:** [May 12, 2021, 7:43pm UTC](https://the.fmsoup.org/t/dbdiagram-a-relational-database-diagram-design-tool/2106 "2021-05-12T19:43:03Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![rivet](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/rivet/32/1727_2.png) [@rivet](https://the.fmsoup.org/u/rivet)\ **Post date:** [May 12, 2021, 7:43pm UTC](https://the.fmsoup.org/t/dbdiagram-a-relational-database-diagram-design-tool/2106/1 "2021-05-12T19:43:03Z")
Here is a nice app, I stumbled on the other day — [dbdiagram.io](https://dbdiagram.io/home) ![dbdiagram-demo.0791273](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/c/ce8b07d6611c66273dfc03e004c826ce81addf53.gif) ---
**Author:** ![planteg](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/planteg/32/627_2.png) [@planteg](https://the.fmsoup.org/u/planteg)\ **Post date:** [May 12, 2021, 8:40pm UTC](https://the.fmsoup.org/t/dbdiagram-a-relational-database-diagram-design-tool/2106/2 "2021-05-12T20:40:22Z")
Thanks for that, looks interesting ! ---
**Author:** ![jwilling](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/jwilling/32/256_2.png) [@jwilling](https://the.fmsoup.org/u/jwilling)\ **Post date:** [May 12, 2021, 10:04pm UTC](https://the.fmsoup.org/t/dbdiagram-a-relational-database-diagram-design-tool/2106/3 "2021-05-12T22:04:50Z")
Can I get the name of the coffee (or drug) the developer in that gif is using? ---
**Author:** ![OliverBarrett](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OliverBarrett](https://the.fmsoup.org/u/OliverBarrett)\ **Post date:** [May 13, 2021, 11:06am UTC](https://the.fmsoup.org/t/dbdiagram-a-relational-database-diagram-design-tool/2106/4 "2021-05-13T11:06:17Z")
There is also SQL Editor ($79) that works with all databases, including FileMaker. If you choose FileMaker it will FORWARD and REVERSE engineer your FileMaker database. That means it will create (forward) or read into its model (reverse) an existing database so you can modify and then forward engineer it again. You can also design a brand new database and then forward that new database to FileMaker. [https://www.malcolmhardie.com/sqleditor/](https://www.malcolmhardie.com/sqleditor/) For my money, this is the SQL tool to get. It also creates FileMaker DDR. * * * Here's an example. I have a database called "EmailWebHook.FMP12" that I'm using to capture email data using Zapier (and the free fmgateway connector). For clarity, this is a good example since it only has a single table. Here are the steps: 1. Install the free FileMaker JDBC driver into the directory SQL Editor mentions when you go to "Preferences\>Database\>Installed Drivers" and you click "Open Driver Directory". (you only do this setup one time) 2. Create a setup item for your FMP database (remember to enable JDBC in your FMP12 database). ![image](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/6/6f001efeabb1af1d661063f2c420a5f0458d336a.png) Now you have an active setup item for that database whenever you need to work with it (read update schema and save...). Note, I used localhost since the FileMaker database was, well, local. But this **connection could also be to FMS** using that URL. 1. Now, just click the File \> Import From Database ![image](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/d/dd98e7eddf675e4d3ec6b3e4c65ee9fe0566b040.jpeg) Notice that after selecting your database, you see that the (in this case) one table is open. Clicking on a field gives you a dialog so you can change any of the field definitions. You can also add new fields, tables, or whatever, and then forward engineer it to save those database changes back to Filemaker. ![image](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/a/a56c5672748836e5e4b6fce0d4c0ed23b77e0046.jpeg) SQL Editor also works with any other database like MySQL, SQL Server, Oracle, .... so it's a real gem. ---
**Author:** ![harvest](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/harvest/32/231_2.png) [@harvest](https://the.fmsoup.org/u/harvest)\ **Post date:** [May 13, 2021, 2:39pm UTC](https://the.fmsoup.org/t/dbdiagram-a-relational-database-diagram-design-tool/2106/5 "2021-05-13T14:39:58Z")
2.a open the database, you want to import 🙂 ---
**Author:** ![OliverBarrett](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OliverBarrett](https://the.fmsoup.org/u/OliverBarrett)\ **Post date:** [May 13, 2021, 3:11pm UTC](https://the.fmsoup.org/t/dbdiagram-a-relational-database-diagram-design-tool/2106/6 "2021-05-13T15:11:29Z")
Isn't that what I noted in step 3 after you configure the connection? ---
**Author:** ![harvest](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/harvest/32/231_2.png) [@harvest](https://the.fmsoup.org/u/harvest)\ **Post date:** [May 13, 2021, 3:53pm UTC](https://the.fmsoup.org/t/dbdiagram-a-relational-database-diagram-design-tool/2106/7 "2021-05-13T15:53:15Z")
didn't get it as I ran into 802 errors but doesn't matter, it's easy to figure out, thank you for the link and showing how easy it is to read table and field definitions from FM files... used to write some scripts to get this sql-code but this is way faster ---
**Author:** ![OliverBarrett](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OliverBarrett](https://the.fmsoup.org/u/OliverBarrett)\ **Post date:** [May 13, 2021, 4:37pm UTC](https://the.fmsoup.org/t/dbdiagram-a-relational-database-diagram-design-tool/2106/8 "2021-05-13T16:37:53Z")
Awesome! 🙂 Also, you can generate some nice reports using this tool. Thanks for the reply back.