ctrl+shift+p filters: :st2 :st3 :win :osx :linux
Browse

SQLTools

by mtxr ST3

SQLTools for Sublime Text 3

Details

Installs

  • Total 24K
  • Win 15K
  • OS X 5K
  • Linux 3K
Sep 24 Sep 23 Sep 22 Sep 21 Sep 20 Sep 19 Sep 18 Sep 17 Sep 16 Sep 15 Sep 14 Sep 13 Sep 12 Sep 11 Sep 10 Sep 9 Sep 8 Sep 7 Sep 6 Sep 5 Sep 4 Sep 3 Sep 2 Sep 1 Aug 31 Aug 30 Aug 29 Aug 28 Aug 27 Aug 26 Aug 25 Aug 24 Aug 23 Aug 22 Aug 21 Aug 20 Aug 19 Aug 18 Aug 17 Aug 16 Aug 15 Aug 14 Aug 13 Aug 12 Aug 11 Aug 10
Windows 0 12 14 24 39 40 33 32 9 15 41 40 37 30 34 15 14 30 32 45 29 27 18 10 27 24 37 27 36 15 17 27 31 39 22 28 18 21 44 27 36 28 38 15 6 30
OS X 0 4 2 12 13 8 14 8 3 2 13 16 13 12 8 4 4 7 11 10 13 9 1 4 6 12 18 18 7 6 2 12 15 14 9 9 2 4 13 11 15 13 11 1 6 5
Linux 0 1 7 10 9 5 5 2 2 7 9 6 5 9 5 1 6 7 10 8 5 10 4 6 6 5 6 10 4 6 5 10 10 8 6 3 1 2 10 3 5 4 2 3 2 6

Readme

Source
raw.​githubusercontent.​com

SQLTools

Join the chat at https://gitter.im/SQLTools/Lobby

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: http://mtxr.github.io/SQLTools/

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

Donate

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.

PayPal donate button

Features

  • Works with PostgreSQL, MySQL, Oracle, MSSQL, SQLite, Vertica, Firebird
  • 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)

Installing

Using Sublime Package Control

If you are using Sublime Package Control, you can easily install SQLTools via the Package Control: Install Package menu item.

  1. Press CTRL+SHIFT+p
  2. Type Install Package
  3. Find SQLTools
  4. Wait & Done!

Download Manually

I strongly recommend you to use Package Control. It helps you to keep the package updated with the last version.

  1. Download the files zip file here
  2. Unzip the files and rename the folder to SQLTools
  3. Find your Packages directory using the menu item Preferences -> Browse Packages...
  4. Copy the folder into your Sublime Text Packages directory

Using SQLTools with Mac OS X

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.

Contributors

This project exists thanks to all the people who contribute.

Backers

Thank you to all our backers! 🙏 [Become a backer]

Sponsors

Support this project by becoming a sponsor. Your logo will show up here with a link to your website. [Become a sponsor]

Configuration

Documentation: http://mtxr.github.io/SQLTools/