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.
- 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.
Now, package includes pyODBC (4.0.22) binaries:
- Windows: ST3 x64 (x32 with old pyodbc 3.0.7)
- Linux: ST3 x64
- OSX: ST3 x64
- 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)
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 Easywhen the list appears.
Package Control will automatically keep TSQL Easy up to date with the latest version.
SQL Request
Activity monitor
Long running queries
