Format guide

SQL

SQL dump (CREATE TABLE + INSERT INTO)

A SQL dump file contains the SQL statements needed to recreate a database: CREATE TABLE for schema, INSERT INTO for rows, optionally indexes, constraints, and triggers. The portable subset (single-quoted strings, ANSI types) runs unmodified on Postgres, MySQL, SQLite, and SQL Server. The output of `pg_dump`, `mysqldump`, and SQLite's `.dump` command — the standard backup/seed format for relational databases.

How to open a SQL file

Any text editor. To execute: `psql < dump.sql`, `mysql < dump.sql`, `sqlite3 db < dump.sql`. Database GUIs (DBeaver, TablePlus, DataGrip, pgAdmin) all import SQL dump files via their migration wizards.

Primary use

Database backups and data seeding.

Convert other formats to SQL

CSV → SQL
JSON → SQL

Convert SQL to other formats

SQL → CSV

Looking for something else? Browse the full list of 192 converters.