What is a .sql file?
A .sql file is an SQL code. Its registered MIME type is application/sql, which places it in the application or document family of formats.
Technically it is a specialised form of text/plain (the .asc format), so tools that understand that format can often read at least part of it.
SQL is a text-based format: the contents are readable characters, so any text editor can open it, and it compresses well.
SQL file format details
| Extension | .sql |
|---|---|
| Format | SQL code |
| MIME type | application/sql, application/x-sql, text/x-sql |
| Category | Application or document |
| Text or binary | Text |
| Based on | text/plain |
| File signature | None fixed |
| Registered with IANA | Yes |
| Other extensions | None |
How to open SQL files
| Windows | SQL files are plain text, so Notepad opens them: right-click the file, choose Open with, then Notepad. Notepad++ and VS Code are free and show long files more comfortably. |
|---|---|
| Mac | TextEdit opens plain text files. For code or data files, a free editor such as BBEdit or VS Code keeps the formatting intact. |
| iPhone and iPad | Save the file to the Files app and tap it; iOS previews most plain text. Or drop it on the viewer above, which shows the text right in the browser. |
| Android | Most file manager apps open plain text files in a built-in viewer. The viewer above also works in Chrome. |
Can you convert a .sql file?
TapToConvert does not convert SQL files. The usual route is to open the file in the program that made it and use its Export or Save as option.
SQL file FAQ
What is a .sql file?
A .sql file is an SQL code, with the MIME type application/sql.
How do I open a .sql file?
With any text editor, such as Notepad on Windows or TextEdit on a Mac, or with the viewer on this page.
Is a .sql file safe to open?
SQL files hold data rather than programs, but any file from an unknown source can be crafted to exploit the software that opens it. Keep that software up to date. The viewer on this page only reads the bytes and never runs anything.
What is the MIME type of .sql?
application/sql, and it is also seen as application/x-sql or text/x-sql. Web servers send this type so browsers know how to handle the file.
Is SQL a text or binary format?
Text. Its contents are readable characters.
File type facts come from the IANA media type registry, the mime-db project and the freedesktop.org shared MIME database.