Looking for maintainers! I'm currently using VSCode as my editor, so I'm not actively maintaining this project anymore.

If you are interested in maintaining this project, contact me.

If you are interested in checking VSCode version, see https://github.com/mtxr/vscode-sqltools.

Your swiss knife SQL for Sublime Text.

Write your SQL with smart completions and handy table and function definitions, execute SQL and explain queries, format your queries and save them in history.

Project website: https://code.mteixeira.dev/SublimeText-SQLTools/

If you are looking for VSCode version go to https://github.com/mtxr/vscode-sqltools.

SQLTools was developed with ♥ to save us time during our programming journey. But It also takes me time and efforts to develop SQLTools.

SQLTools will save you (for sure) a lot of time and help you to increase your productivity so, I hope you can donate and help SQLTools to become more awesome than ever.

• Works with PostgreSQL, MySQL, Oracle, MSSQL, SQLite, Vertica, Firebird and Snowflake
• Smart completions (except SQLite)
• Run SQL Queries   CTRL+e, CTRL+e
• View table description   CTRL+e, CTRL+d
• Show table records   CTRL+e, CTRL+s
• Show explain plan for queries   CTRL+e, CTRL+x
• Formatting SQL Queries   CTRL+e, CTRL+b
• View Queries history   CTRL+e, CTRL+h
• Save queries   CTRL+e, CTRL+q
• List and Run saved queries   CTRL+e, CTRL+l
• Remove saved queries   CTRL+e, CTRL+r
• Threading support to prevent lockups
• Query timeout (kill thread if query takes too long)

1. Download & Install Sublime Text 3 (https://www.sublimetext.com/3)
2. Go to the menu Tools -> Install Package Control, then, wait few seconds until the installation finishes up
3. Now, Go to the menu Preferences -> Package Control
4. Type Add Channel on the opened quick panel and press Enter
5. Then, input the following address and press Enter

   https://raw.githubusercontent.com/evandrocoan/StudioChannel/master/channel.json
   

6. Go to the menu Tools -> Command Palette... (Ctrl+Shift+P)
7. Type Preferences: Package Control Settings – User on the opened quick panel and press Enter
8. Then, find the following setting on your Package Control.sublime-settings file:

   "channels":
   [
       "https://packagecontrol.io/channel_v3.json",
       "https://raw.githubusercontent.com/evandrocoan/StudioChannel/master/channel.json",
   ],

9. And, change it to the following, i.e., put the https://raw.githubusercontent... line as first:

   "channels":
   [
       "https://raw.githubusercontent.com/evandrocoan/StudioChannel/master/channel.json",
       "https://packagecontrol.io/channel_v3.json",
   ],

   • The https://raw.githubusercontent... line must to be added before the https://packagecontrol.io... one, otherwise, you will not install this forked version of the package, but the original available on the Package Control default channel https://packagecontrol.io...
10. Now, go to the menu Preferences -> Package Control
11. Type Install Package on the opened quick panel and press Enter
12. Then, search for SQLTools and press Enter

See also:

1. ITE - Integrated Toolset Environment
2. Package control docs for details.

Sublime Text has it's environment variable PATH set from launchctl, not by your shell. Binaries installed by packages such as homebrew, for instance psql DB CLI for PostgreSQL, cannot be found by Sublime Text and results in error in Sublime Text console by SQLTools. Installing the package Fix Mac Path or setting the full path to your DB CLI binary in SQLTools.sublime-settings resolves this issue. Package can be downloaded via PackageControl or github.

This project exists thanks to all the people who contribute.

Documentation: https://code.mteixeira.dev/SublimeText-SQLTools/