Import SQL File

Upload a .sql file to import an existing schema into TalkingSchema.

Steps

1. Click the Import button in the top toolbar
2. Select Upload SQL file
3. Choose your .sql file from your computer
4. TalkingSchema parses the file and populates the ERD

Supported file types

• .sql — SQL dump files, migration files
• Any file containing CREATE TABLE statements

Tips

• Works with PostgreSQL pg_dump output
• Works with MySQL mysqldump output
• Works with SQLite .dump output
• Comments in the SQL file are ignored
• INSERT statements are ignored — only schema (DDL) is imported

Troubleshooting

Schema doesn't appear after upload:

• Ensure the file contains CREATE TABLE statements
• Try pasting the SQL instead via Paste SQL

Only some tables appear:

• The parser skips unsupported SQL syntax
• Simplify complex DDL and try again

Related

• Paste SQL — paste SQL directly without uploading a file
• Import DBML File — import using DBML format instead
• SQL Export — export your schema back to SQL