Import Overview
TalkingSchema can import existing database schemas so you can visualize, edit, and export them.
Import methods
| Method | Best for |
|---|---|
| Upload SQL file | You have a .sql dump or migration file |
| Upload DBML file | You have a .dbml or .txt file with DBML schema |
| Paste SQL | You want to copy-paste SQL directly |
| Paste DBML | You have a DBML schema (e.g. from schema-as-code tooling) |
| Smart Import | You want to generate a schema from text, images, or Jira tickets (coming soon) |
| Connect to database | You want to import a live schema from Supabase or Neon |
What gets imported
When you import a schema, TalkingSchema extracts:
- Table definitions (name, fields, types)
- Primary key constraints
- Foreign key relationships
- Unique and NOT NULL constraints
- Enum type definitions (PostgreSQL)
- Index definitions (where possible)
After importing
Once imported, your schema appears in the ERD canvas. You can:
- Visualize the existing structure
- Ask the AI to explain it: "Explain this schema to me"
- Ask the AI to improve it: "Suggest normalization improvements"
- Make changes: "Add soft delete to all tables"
- Export in a different format
Supported SQL dialects for import
- PostgreSQL
- MySQL
- SQLite