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

TSQLEasy

by tosher WinLinux ST2/ST3

TSQL Easy is a plugin for Sublime Text editor (ver. 2/3) that adds possibility to read/write/execute sql requests to Microsoft SQL Server through the use of pyodbc library.

Details

Installs

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

Readme

Source
raw.​githubusercontent.​com

Sublime Text plugin: TSQL Easy

TSQL Easy is a plugin for Sublime Text editor (ver. 2/3) that adds possibility to read/write/execute sql requests to Microsoft SQL Server and some IDE-like functionality. Server connections based on pyODBC library.

Main features

  • Manage connections to SQL Servers.
  • Execute sql requests on SQL Server.
  • Completions of table names from server.
  • Completions of table columns from server.
  • Possibility to receive code of procedure, functions by text under cursor.
  • Possibility to open local files with the same name as stored procedure (function, etc.): ProcedureName -> ProcedureName.sql.
  • Improved syntax highlighting for TSQL.
  • Reports: Activity monitor, Long running queries

Warning! Server connection required for full functionality or use fake server with empty driver value for work offline without completions, etc.

PyODBC

Now, package includes pyODBC (3.0.7) binaries:

  • Windows: ST2/3 x32/x64
  • Linux: ST2/3 x64
  • Pull requests are welcome! :)

Commands

  • Open console - open new console for sql requests
  • Server select - change predefined sql server connection
  • Execute - execute the request (F5)
  • Open server object - open procedure or function under cursor from server
  • Open local object - open procedure or function under cursor from local path
  • Activity monitor (+refresh, +show query)
  • Long running queries (+refresh, +show query)

Install

Package Control

The easiest way to install this is with Package Control.

  • If you just went and installed Package Control, you probably need to restart Sublime Text before doing this next bit.
  • Bring up the Command Palette (Command+Shift+p on OS X, Ctrl+Shift+p on Linux/Windows).
  • Select “Package Control: Install Package” (it'll take a few seconds)
  • Select TSQL Easy when the list appears.

Package Control will automatically keep TSQL Easy up to date with the latest version.