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

SQLTools

by mtxr ST3

SQLTools for Sublime Text 3

Details

Installs

  • Total 9K
  • Win 6K
  • OS X 2K
  • Linux 1K
Jun 27 Jun 26 Jun 25 Jun 24 Jun 23 Jun 22 Jun 21 Jun 20 Jun 19 Jun 18 Jun 17 Jun 16 Jun 15 Jun 14 Jun 13 Jun 12 Jun 11 Jun 10 Jun 9 Jun 8 Jun 7 Jun 6 Jun 5 Jun 4 Jun 3 Jun 2 Jun 1 May 31 May 30 May 29 May 28 May 27 May 26 May 25 May 24 May 23 May 22 May 21 May 20 May 19 May 18 May 17 May 16 May 15 May 14 May 13
Windows 20 21 14 11 22 31 31 21 19 9 7 22 22 29 22 19 13 11 26 27 29 21 25 11 14 17 17 27 18 14 6 11 24 24 30 18 19 9 13 28 28 27 19 12 8 7
OS X 9 11 3 3 6 10 8 6 11 1 5 7 9 11 5 11 6 3 13 7 6 5 7 3 3 8 6 8 12 4 4 3 6 4 4 8 5 1 4 9 6 13 9 8 2 3
Linux 1 7 2 0 6 4 8 3 3 2 3 11 6 1 6 4 5 2 8 5 4 5 6 2 0 3 9 8 5 4 0 3 15 2 7 7 10 6 2 2 4 11 4 6 1 4

Readme

Source
raw.​githubusercontent.​com

SQLTools v0.5.4 SQLTools

Codacy Badge

Your swiss knife SQL for Sublime Text.

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

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

Contributors

These fellows helped SQLTools become better than ever. Thank you so much!

Features

  • Smart auto completions (for PostgreSQL, MySQL, Oracle, MSSQL, Vertica, Firebird)
  • Run SQL Queries (CTRL+e, CTRL+e) Auto complete (PostgreSQL & MySQL) && Run SQL Queries
  • View table schemas (CTRL+e, CTRL+d) View table schemas
  • View Queries history (CTRL+e, CTRL+h)
  • Show table records (CTRL+e, CTRL+s) Show table records
  • Show explain plan for queries (PostgreSQL, MySQL, Oracle, Vertica, SQLite) (CTRL+e, CTRL+x)
  • Formatting SQL Queries (CTRL+e, CTRL+b) Formatting SQL Queries
  • 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)

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 recomend 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 evironment 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.

Configuration

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