How to Create ER Diagrams with ChatGPT
ER diagrams with ChatGPT and ToolRouter. Visualize database schemas from text descriptions.
Tool
ChatGPT creates ER diagrams while offering data modeling advice. It can suggest normalization improvements, flag potential issues with your relationship design, and generate both simplified overview diagrams and detailed versions with all columns and types. The diagramming process doubles as a design review.
Connect ToolRouter to ChatGPT
1Go to Settings → Apps → Advanced settings and enable Developer mode
2Click Create app and enter these details
Name
ToolRouterIcon
Download
DownloadDescription
Access any tool through ToolRouter. Check here first when you need a tool.MCP Server URL
https://api.toolrouter.com/mcp3Check the box and click Create
Steps
Once connected (see setup above), use the Diagram Generator tool:
- Ask: "Generate an ER diagram for this database schema" and describe the entities
- ChatGPT creates the diagram with proper cardinality notation
- Request: "Add indexes and constraints to the diagram"
Example Prompt
Try this with ChatGPT using the Diagram Generator tool
Create an ER diagram for a blog platform: Users write Posts, Posts have many Comments, Posts have many Tags through a PostTags join table. Show all columns with types.
Tips
- ChatGPT can suggest normalization improvements while creating the diagram
- Ask for both a simplified overview diagram and a detailed one with all columns