.sql — SQL Script
Data application/sql
What a .sql file is
Plain-text database statements — either schema definitions or a full dump of data as INSERT statements.
How to open it
Any text editor, or piped into a database client: mysql < dump.sql, psql -f dump.sql.
Worth knowing
Dumps of large tables get enormous. Compress them, and check the file starts with the statements you expect before running it against anything.
Other data formats
- .csv — Comma-Separated Values
- .json — JavaScript Object Notation
- .yaml — YAML Ain't Markup Language
- .parquet — Apache Parquet