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

SQLTools

by mtxr ST3

SQLTools for Sublime Text 3

Details

Installs

  • Total 68K
  • Win 43K
  • Mac 15K
  • Linux 9K
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 May 12 May 11 May 10 May 9 May 8 May 7 May 6 May 5 May 4 May 3 May 2 May 1 Apr 30 Apr 29 Apr 28 Apr 27 Apr 26 Apr 25
Windows 4 4 4 6 5 11 7 3 2 1 6 11 4 6 3 2 8 4 8 10 4 5 0 1 7 3 12 5 7 5 3 3 9 9 6 4 5 6 3 2 8 10 13 7 2 5
Mac 0 1 1 6 5 3 3 5 0 1 2 4 3 4 6 1 3 5 5 2 6 2 0 0 5 3 5 4 5 1 0 0 3 4 3 4 2 1 2 1 4 8 5 2 1 2
Linux 0 0 3 0 3 2 2 0 0 0 1 3 2 2 1 1 1 1 0 2 0 1 1 0 3 3 1 1 3 0 0 0 0 1 2 0 0 0 2 1 4 1 2 0 1 0
05101520Jun 9Jun 6Jun 3May 31May 28May 25May 22May 19May 16May 13May 10May 7May 4May 1Apr 28Apr 25Jun 9 Linux: 0 Mac: 0 Windows: 4Jun 8 Linux: 0 Mac: 1 Windows: 4Jun 7 Linux: 3 Mac: 1 Windows: 4Jun 6 Linux: 0 Mac: 6 Windows: 6Jun 5 Linux: 3 Mac: 5 Windows: 5Jun 4 Linux: 2 Mac: 3 Windows: 11Jun 3 Linux: 2 Mac: 3 Windows: 7Jun 2 Linux: 0 Mac: 5 Windows: 3Jun 1 Linux: 0 Mac: 0 Windows: 2May 31 Linux: 0 Mac: 1 Windows: 1May 30 Linux: 1 Mac: 2 Windows: 6May 29 Linux: 3 Mac: 4 Windows: 11May 28 Linux: 2 Mac: 3 Windows: 4May 27 Linux: 2 Mac: 4 Windows: 6May 26 Linux: 1 Mac: 6 Windows: 3May 25 Linux: 1 Mac: 1 Windows: 2May 24 Linux: 1 Mac: 3 Windows: 8May 23 Linux: 1 Mac: 5 Windows: 4May 22 Linux: 0 Mac: 5 Windows: 8May 21 Linux: 2 Mac: 2 Windows: 10May 20 Linux: 0 Mac: 6 Windows: 4May 19 Linux: 1 Mac: 2 Windows: 5May 18 Linux: 1 Mac: 0 Windows: 0May 17 Linux: 0 Mac: 0 Windows: 1May 16 Linux: 3 Mac: 5 Windows: 7May 15 Linux: 3 Mac: 3 Windows: 3May 14 Linux: 1 Mac: 5 Windows: 12May 13 Linux: 1 Mac: 4 Windows: 5May 12 Linux: 3 Mac: 5 Windows: 7May 11 Linux: 0 Mac: 1 Windows: 5May 10 Linux: 0 Mac: 0 Windows: 3May 9 Linux: 0 Mac: 0 Windows: 3May 8 Linux: 0 Mac: 3 Windows: 9May 7 Linux: 1 Mac: 4 Windows: 9May 6 Linux: 2 Mac: 3 Windows: 6May 5 Linux: 0 Mac: 4 Windows: 4May 4 Linux: 0 Mac: 2 Windows: 5May 3 Linux: 0 Mac: 1 Windows: 6May 2 Linux: 2 Mac: 2 Windows: 3May 1 Linux: 1 Mac: 1 Windows: 2Apr 30 Linux: 4 Mac: 4 Windows: 8Apr 29 Linux: 1 Mac: 8 Windows: 10Apr 28 Linux: 2 Mac: 5 Windows: 13Apr 27 Linux: 0 Mac: 2 Windows: 7Apr 26 Linux: 1 Mac: 1 Windows: 2Apr 25 Linux: 0 Mac: 2 Windows: 5Jun 9 Linux: 0 Mac: 0 Windows: 4Jun 8 Linux: 0 Mac: 1 Windows: 4Jun 7 Linux: 3 Mac: 1 Windows: 4Jun 6 Linux: 0 Mac: 6 Windows: 6Jun 5 Linux: 3 Mac: 5 Windows: 5Jun 4 Linux: 2 Mac: 3 Windows: 11Jun 3 Linux: 2 Mac: 3 Windows: 7Jun 2 Linux: 0 Mac: 5 Windows: 3Jun 1 Linux: 0 Mac: 0 Windows: 2May 31 Linux: 0 Mac: 1 Windows: 1May 30 Linux: 1 Mac: 2 Windows: 6May 29 Linux: 3 Mac: 4 Windows: 11May 28 Linux: 2 Mac: 3 Windows: 4May 27 Linux: 2 Mac: 4 Windows: 6May 26 Linux: 1 Mac: 6 Windows: 3May 25 Linux: 1 Mac: 1 Windows: 2May 24 Linux: 1 Mac: 3 Windows: 8May 23 Linux: 1 Mac: 5 Windows: 4May 22 Linux: 0 Mac: 5 Windows: 8May 21 Linux: 2 Mac: 2 Windows: 10May 20 Linux: 0 Mac: 6 Windows: 4May 19 Linux: 1 Mac: 2 Windows: 5May 18 Linux: 1 Mac: 0 Windows: 0May 17 Linux: 0 Mac: 0 Windows: 1May 16 Linux: 3 Mac: 5 Windows: 7May 15 Linux: 3 Mac: 3 Windows: 3May 14 Linux: 1 Mac: 5 Windows: 12May 13 Linux: 1 Mac: 4 Windows: 5May 12 Linux: 3 Mac: 5 Windows: 7May 11 Linux: 0 Mac: 1 Windows: 5May 10 Linux: 0 Mac: 0 Windows: 3May 9 Linux: 0 Mac: 0 Windows: 3May 8 Linux: 0 Mac: 3 Windows: 9May 7 Linux: 1 Mac: 4 Windows: 9May 6 Linux: 2 Mac: 3 Windows: 6May 5 Linux: 0 Mac: 4 Windows: 4May 4 Linux: 0 Mac: 2 Windows: 5May 3 Linux: 0 Mac: 1 Windows: 6May 2 Linux: 2 Mac: 2 Windows: 3May 1 Linux: 1 Mac: 1 Windows: 2Apr 30 Linux: 4 Mac: 4 Windows: 8Apr 29 Linux: 1 Mac: 8 Windows: 10Apr 28 Linux: 2 Mac: 5 Windows: 13Apr 27 Linux: 0 Mac: 2 Windows: 7Apr 26 Linux: 1 Mac: 1 Windows: 2Apr 25 Linux: 0 Mac: 2 Windows: 5Jun 9 Linux: 0 Mac: 0 Windows: 4Jun 8 Linux: 0 Mac: 1 Windows: 4Jun 7 Linux: 3 Mac: 1 Windows: 4Jun 6 Linux: 0 Mac: 6 Windows: 6Jun 5 Linux: 3 Mac: 5 Windows: 5Jun 4 Linux: 2 Mac: 3 Windows: 11Jun 3 Linux: 2 Mac: 3 Windows: 7Jun 2 Linux: 0 Mac: 5 Windows: 3Jun 1 Linux: 0 Mac: 0 Windows: 2May 31 Linux: 0 Mac: 1 Windows: 1May 30 Linux: 1 Mac: 2 Windows: 6May 29 Linux: 3 Mac: 4 Windows: 11May 28 Linux: 2 Mac: 3 Windows: 4May 27 Linux: 2 Mac: 4 Windows: 6May 26 Linux: 1 Mac: 6 Windows: 3May 25 Linux: 1 Mac: 1 Windows: 2May 24 Linux: 1 Mac: 3 Windows: 8May 23 Linux: 1 Mac: 5 Windows: 4May 22 Linux: 0 Mac: 5 Windows: 8May 21 Linux: 2 Mac: 2 Windows: 10May 20 Linux: 0 Mac: 6 Windows: 4May 19 Linux: 1 Mac: 2 Windows: 5May 18 Linux: 1 Mac: 0 Windows: 0May 17 Linux: 0 Mac: 0 Windows: 1May 16 Linux: 3 Mac: 5 Windows: 7May 15 Linux: 3 Mac: 3 Windows: 3May 14 Linux: 1 Mac: 5 Windows: 12May 13 Linux: 1 Mac: 4 Windows: 5May 12 Linux: 3 Mac: 5 Windows: 7May 11 Linux: 0 Mac: 1 Windows: 5May 10 Linux: 0 Mac: 0 Windows: 3May 9 Linux: 0 Mac: 0 Windows: 3May 8 Linux: 0 Mac: 3 Windows: 9May 7 Linux: 1 Mac: 4 Windows: 9May 6 Linux: 2 Mac: 3 Windows: 6May 5 Linux: 0 Mac: 4 Windows: 4May 4 Linux: 0 Mac: 2 Windows: 5May 3 Linux: 0 Mac: 1 Windows: 6May 2 Linux: 2 Mac: 2 Windows: 3May 1 Linux: 1 Mac: 1 Windows: 2Apr 30 Linux: 4 Mac: 4 Windows: 8Apr 29 Linux: 1 Mac: 8 Windows: 10Apr 28 Linux: 2 Mac: 5 Windows: 13Apr 27 Linux: 0 Mac: 2 Windows: 7Apr 26 Linux: 1 Mac: 1 Windows: 2Apr 25 Linux: 0 Mac: 2 Windows: 5

Readme

Source
raw.​githubusercontent.​com

SQLTools

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.

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: https://code.mteixeira.dev/SublimeText-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 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)

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 latest released 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.

Configuration

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