Is ERDMates free to use?

Yes, ERDMates has a free plan with no credit card required. The free plan includes basic ERD editing, limited monthly AI generation, and up to 3 projects. Paid plans (Plus at $6/month, Pro at $15/month) unlock more features.

Can I edit AI-generated ERDs?

Yes, all AI-generated ERDs are fully editable. You can add or remove tables and columns, change data types, modify relationships, rename fields, and adjust any part of the schema using the visual drag-and-drop editor.

Can I collaborate with team members in real-time?

Yes, ERDMates supports real-time collaborative editing using Yjs CRDT technology. Multiple team members can edit the same ERD simultaneously with no conflicts. Team collaboration is available on Plus and higher plans.

What databases and SQL dialects does it support?

ERDMates supports PostgreSQL, MySQL, SQLite, and MSSQL for SQL DDL export. For ORM code generation, it supports 8 frameworks: Prisma, TypeORM, Drizzle, Sequelize, SQLAlchemy, Django ORM, JPA/Hibernate, and Entity Framework Core.

Can I convert existing SQL scripts to an ERD?

Yes, paste your existing CREATE TABLE SQL statements and ERDMates will automatically parse them and convert to a visual ERD diagram. If parsing fails, the AI can attempt to interpret and fix ambiguous SQL.

Is my project data secure?

Yes. All data is transmitted over HTTPS (TLS encryption) and stored in AWS RDS PostgreSQL with encryption at rest. We implement security best practices including HttpOnly cookies, CSRF protection, and input sanitization.

Can I use ERDMates offline?

Basic ERD viewing and manual editing work without internet. However, AI features (generation, chat, optimization) and real-time collaboration require an active internet connection.

Is ERDMates accessible on mobile devices?

ERDMates is a web application accessible from mobile browsers. It is optimized for desktop and laptop screens due to the nature of diagram editing. A dedicated mobile experience is planned.

Auto-Generate ERD with AIAuto-Generate ERD with AI

Simply describe in natural language and AI designs the perfect database structureSimply describe in natural language and AI designs the perfect database structure

Pricing Plans

Choose the perfect plan for your project scale

Free

For personal projects and learning

$0/month

🤖 AI Generation: 10/month

Basic ERD editor
10 AI ERD generations per month
Unlimited projects
Personal use (1 person)
Export (PNG, SQL, ORM)
Community support
⚠️ Ad-supported

Popular

Coming Soon

Plus

For individual developers and small teams

₩7,900/month

🤖 AI Generation: 200/month

Everything in Free (except ads)
200 AI ERD generations per month
Unlimited projects
Team collaboration (up to 5)
Dedicated email support
✨ Ad-free experience

Coming Soon

Pro

For professional teams and growing companies

₩19,900/month

🤖 AI Generation: Unlimited

Everything in Plus
Unlimited AI ERD generations
Team collaboration (up to 15)
AI priority processing (faster response)
Dedicated email support
API access
✨ Ad-free experience

Enterprise

For large teams and organizations

Contact

🤖 AI Generation: Unlimited + Priority

Everything in Pro
Unlimited AI generation (priority queue)
Custom AI model training
Unlimited collaborators
SSO / SAML authentication
Dedicated support & SLA
On-premise deployment option
Custom contracts
✨ Ad-free experience

All plans start free with no credit card required. Upgrade anytime.

Traditional Way

Erdmates solves the limitations of traditional ERD tools

Before

Learning complex tools like ERwin or Lucidchart takes hours of training time

Manually creating tables, columns, and indexes one by one is tedious and error-prone

Relationship mistakes cause data integrity issues that are discovered late in development

File-based sharing causes version conflicts and makes team collaboration difficult

After

Describe your desired structure in natural language and AI instantly generates a professional ERD

AI automatically designs the optimal table structure and relationships, reducing design time by 90%

FK relationships and constraints are automatically connected, ensuring data integrity

Yjs-based real-time simultaneous editing lets the whole team collaborate on the same canvas

3 Simple Steps

Complete a professional ERD in just 3 steps — no complex tools required

Describe

Describe your desired database structure in everyday language. Type freely like "I need user, product, and order tables, and users can place multiple orders."

AI Analysis

AI analyzes your input to determine the optimal table structure, column types, and constraints. It applies normalization principles to design an efficient database schema.

ERD Generation

A visual ERD diagram is instantly generated based on the analysis. The created ERD can be immediately edited or exported to SQL.

Key Features

Powerful AI-driven features that revolutionize your database design workflow

AI ERD Generation

Describe your database structure in plain language and AI automatically creates tables, columns, and relationships. Complete a professional ERD diagram in seconds.

Real-time Collaboration

Edit the same ERD simultaneously with teammates and see changes reflected in real time. Collaborate efficiently on database design even with remote teams.

Smart Relationship Linking

Automatically recognizes and visualizes foreign key (FK) relationships between tables. Set up 1:1, 1:N, and N:M relationships intuitively with drag and drop.

Auto SQL Generation

Automatically generate DDL SQL for PostgreSQL, MySQL, SQLite, and MSSQL from your ERD. Draw the diagram and instantly get executable queries.

Version Control

All changes are automatically saved so you can restore to any previous version at any time. Edit your ERD freely without worrying about mistakes.

Multiple Export Formats

Export your ERD to PNG/SVG images, SQL DDL, Prisma, TypeORM, Drizzle ORM, and many other formats. Choose the format that fits your development environment.

Perfect For

Professionals from various fields work with ERDMates

Backend Developers

Quickly design DB structure before API development

Startups

Fast prototyping in early product stages

Product Planners

Plan DB structure without technical knowledge

Students

Database assignments and projects

Real-World Example

Describe an e-commerce database in natural language, and it generates like this

Before: Text Input

"I want to build an e-commerce site.
I need users, products, orders, and reviews.
A user can place multiple orders
and can leave reviews on products."

After: Auto-generated ERD

Trusted Service

10,000+

ERDs Created

50,000+

Tables Created

1,000+

Active Users

100+

Team Projects

Start Now

Experience AI ERD generation for free