Your swiss knife SQL for Sublime Text.
Project website: http://mtxr.github.io/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.
These fellows helped SQLTools become better than ever. Thank you so much!
- View table schemas (
CTRL+e, CTRL+d
) - View Queries history (
CTRL+e, CTRL+h
) - Show table records (
CTRL+e, CTRL+s
) - Auto complete (for PostgreSQL & MySQL. Looking for help with other SGDBs)
- Run SQL Queries (
CTRL+e, CTRL+e
) - Show explain plan for queries (PostgreSQL, MySQL, Oracle, Vertica, SQLite) (
CTRL+e, CTRL+x
) - Formatting SQL Queries (
CTRL+e, CTRL+b
) - Threading Support (prevent ST lockups)
- Query timeout (Kill thread if query takes too long)
- Unescape chars for languages (PHP " is replace by ")
- Save queries (
CTRL+e, CTRL+q
) - List and Run saved queries (
CTRL+e, CTRL+a
) - Remove saved queries (
CTRL+e, CTRL+r
)
Up coming features:
- Auto complete for Oracle, Vertica, Firebird and SQLite
If you are using Sublime Package Control, you can easily install SQLTools via the Package Control: Install Package
menu item.
- Press
CTRL+SHIFT+p
- Type "Install Package"
- Find SQLTools
- Wait & Done!
I strongly recomend you to use Package Control. It helps you to keep the package updated with the last version.
- Download the files zip file here
- Unzip the files and rename the folder to
SQLTools
- Find your
Packages
directory using the menu itemPreferences -> Browse Packages...
- Copy the folder into your Sublime Text
Packages
directory
Sublime Text has its PATH set from launchctl, not by your shell. Binaries installed by packages such as homebrew, for instance Postgresql
, cannot be found by Sublime Text and results in a null pointer exception thrown by SQLTools
. Installing the package Fix Mac Path
resolve this issue. This package can be downloaded here.
Documentation: http://mtxr.github.io/SQLTools/