AI Copilot Overview
TalkingSchema's AI copilot understands relational database concepts and translates your natural language into schema changes. It operates in two modes.
Two modes, one AI
| Draw Mode | Plan Mode | |
|---|---|---|
| How it works | AI patches schema instantly | AI proposes a plan, waits for approval |
| Best for | Rapid prototyping | Deliberate, reviewed changes |
| Schema changes | Applied immediately | Applied after you click "Keep all" |
| Undo | Via undo button | Reject the plan |
| Speed | Fastest | More deliberate |
Switching modes
The mode toggle is located above the send button in the chat panel. Toggle the switch:
- Switch off → Draw Mode
- Switch on → Plan Mode
The default mode is Plan.
How the AI understands your schema
The AI has full context of your current schema at all times. It understands:
- Table names, field names, and types
- Primary and foreign key relationships
- Enum definitions and their values
- Cardinality (one-to-one, one-to-many, many-to-many)
- SQL best practices (normalization, naming conventions)
What the AI can do
- Create, modify, and delete tables
- Add, rename, and remove fields
- Set field constraints (NOT NULL, UNIQUE, DEFAULT, auto-increment)
- Create foreign key relationships
- Create and modify enums
- Add indexes (via SQL export)
- Explain your schema in plain language
Frequently asked questions
Can the AI make mistakes?
Yes. Always review the ERD after significant changes. Use Plan Mode for complex structural changes to see what the AI proposes before committing.
Does the AI remember previous messages?
Yes. Each conversation thread maintains full context. The AI knows the full history of your schema and the conversation.
Can I undo AI changes?
Yes. The Schema Changes Banner appears when the AI modifies your schema. Click "Undo all" to revert to the previous state.