AI ERD MCP Server

AI ERD

AI ERD is an AI-powered platform for designing database schemas through entity-relationship diagrams. This bundle provides diagram creation, schema editing, and SQL generation.

Capabilities

Diagram management:

• Create new ER diagrams from natural language descriptions
• Edit existing diagrams by adding or modifying entities
• Generate SQL DDL from diagram definitions
• Import existing schemas for visualization

Entity and relationship modeling:

• Define tables with columns, data types, and constraints
• Create relationships (one-to-one, one-to-many, many-to-many)
• Set primary keys, foreign keys, and indexes
• Add constraints (NOT NULL, UNIQUE, DEFAULT)

AI assistance:

• Generate complete schemas from natural language descriptions
• Get schema optimization suggestions
• Identify missing relationships or normalization issues

Workflows

Design a new database: Describe the domain in natural language (e.g., "e-commerce platform with users, products, orders"). The AI generates a complete ER diagram with tables, columns, and relationships. Refine by adding or modifying entities.

Modify an existing schema: Load a diagram, then add tables or modify columns with natural language instructions. The AI handles relationship inference and constraint propagation.

Generate migration SQL: After finalizing the diagram, export as SQL DDL for your target database. Review the generated SQL before applying.

Gotchas

• Diagram state: Diagrams are saved per-user. List existing diagrams to avoid duplicates.
• AI interpretation: Natural language descriptions may be interpreted differently than intended. Review the generated diagram before generating SQL.
• Database dialect: SQL generation targets a specific dialect. Specify the target (Postgres, MySQL, SQLite) to get compatible DDL.