Data file
What is a .sql file?
A .sql file is plain text containing database commands — usually a dump of a database's structure and contents.
How to open a .sql file
- WindowsVS Code
- WindowsNotepad++
- WindowsDBeaver, to run it
- MacVS Code
- MacTablePlus
- Linux`less`, or `psql -f file.sql`
How to convert a .sql file
- If you can view the data, exporting to .csv is usually the most portable option.
The technical record
For archivists, developers and the merely curious: these are the PRONOM registry entries for .sql.
| Format name | Version | MIME type | PUID |
|---|---|---|---|
| Structured Query Language Data | — | — | fmt/206 |