A .sql file normally stores database statements as text. Set an editor as the default when you want to inspect a migration or query before executing it. Opening source in an editor does not connect to a database.
Method 1: Use Finder
- In Finder, select a sample file such as schema.sql.
- Press Command–I, or choose File → Get Info.
- Expand Open with and choose Visual Studio Code. If it is missing, choose Other and locate the installed app.
- Click Change All and confirm the macOS prompt.
- Double-click another file of the same type to check the new default.
Method 2: Manage associations with Pahkui
Pahkui lets you browse by app or by format. When setting up an editor for several file types, you can inspect the current defaults and review pending changes in one window. Requires macOS 14 or later.
- Open Pahkui, switch to Format, and search for the extension you need from .sql.
- Select Visual Studio Code. Use Choose another app if it is not listed.
- Review the pending association, click Apply changes, and confirm the new app in the macOS dialog.
The formats in this guide require Pahkui Pro, a one-time purchase for lifetime use. The manual Finder method does not require a purchase. See pricing
If the default app does not change
- A SQL dump may be very large; if the editor struggles, use an appropriate inspection or database tool.
- Connection details and the SQL dialect are separate settings, and the same script may not run on every database.
- If Visual Studio Code is missing, confirm it is installed and can open the sample directly, then locate it with Other. If an extension is absent from the catalog, add the format in Pahkui. Changing an association does not add format support to the target app.
Common questions
Will opening SQL execute it?
This workflow opens text in VS Code. Executing statements requires a separate database connection and run action.
How do I restore the previous app for .sql?
Choose the previous app again in Finder or Pahkui and confirm the change. This updates the type association without deleting files. Use the Open With context menu for a one-time exception.