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

TSQLEasy

by tosher ST3

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

Labels language syntax, sql, sql server, t-sql

Details

Installs

  • Total 5K
  • Win 4K
  • Mac 316
  • Linux 306
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 Aug 9 Aug 8 Aug 7 Aug 6 Aug 5 Aug 4 Aug 3 Aug 2 Aug 1 Jul 31 Jul 30 Jul 29 Jul 28 Jul 27 Jul 26 Jul 25 Jul 24 Jul 23 Jul 22
Windows 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 1 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 1
Mac 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Linux 0 0 0 1 0 0 0 0 0 0 0 0 0 1 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

Readme

Source
raw.​githubusercontent.​com

Sublime Text plugin: TSQL Easy

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

NOTE: Sublime text 2 is not supported anymore. Please use Sublime text 3.

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 (4.0.22) binaries:

  • Windows: ST3 x64 (x32 with old pyodbc 3.0.7)
  • Linux: ST3 x64
  • OSX: ST3 x64

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)

Installation

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.

Screenshots

SQL Request

SQL request

Activity monitor

SQL request

Long running queries

SQL request

External dependencies