Skip to main content

Import Overview

TalkingSchema can import existing database schemas so you can visualize, edit, and export them.

Import methods

MethodBest for
Upload SQL fileYou have a .sql dump or migration file
Upload DBML fileYou have a .dbml or .txt file with DBML schema
Paste SQLYou want to copy-paste SQL directly
Paste DBMLYou have a DBML schema (e.g. from schema-as-code tooling)
Smart ImportYou want to generate a schema from text, images, or Jira tickets (coming soon)
Connect to databaseYou 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