ERD
An ERD is one of the documents an AiNecto project keeps, alongside Markdown, HTML, Diagram, and OpenAPI documents. AiNecto itself is shared project memory for people and AI agents — see the docs home.
Stop letting AI guess your database schema.
Describe your database in plain language or paste SQL — AI builds the ERD instantly. Connect via MCP and let Claude Code, Codex, Copilot, Cursor, Gemini, or Windsurf read and modify the exact schema instead of guessing.
Why an ERD?
When you ask an AI assistant to write code that touches your database, it has to guess the schema unless you paste it in every time. That guess is wrong often enough to cause subtle bugs — wrong column names, wrong types, missing foreign keys, hallucinated tables.
An ERD document gives your AI coding tools a schema they can read directly:
- Design once — Build the schema visually, by natural language, or by importing existing SQL.
- Connect via MCP — Your AI coding assistant calls AiNecto's MCP server to read or modify the real schema.
- Generate accurate code — The AI works against actual table names, column types, and relationships — no guessing.
Create an ERD
Open AiNecto, sign in, and create a new ERD document in your project. You can start three ways:
- Empty canvas — Add tables manually with the visual editor.
- Natural language — Open the AI panel, describe your domain ("a SaaS app with users, projects, and tasks"), and let AI generate the initial schema.
- SQL import — Paste a
CREATE TABLEscript (MySQL, PostgreSQL, Oracle, or SQL Server) and AiNecto converts it.
Refine the schema
Use the visual canvas to fine-tune:
- Drag tables to organize the layout
- Click a table to edit columns, indexes, and foreign keys in the side panel
- Draw relationships by point-and-click between columns
- Group related tables with colored containers
See Core Concepts for the data model and Visual Canvas for editor details.
Work on it through MCP
Once your AI coding tool is connected through MCP, your assistant can list tables, read columns, create new entities, modify relationships, and snapshot every change — all against the real schema.
What's next
- Core Concepts — diagrams, tables, relationships, enums, and groups
- Visual Canvas — editor, shortcuts, multi-select
- AI Features — natural language to ERD, AI Chat, title suggestion
- Import & Export — SQL, DBML, PNG, SVG