T-SQL IntelliSense (Beta)
Beta: This extension is under active development. Features may change and bugs are expected. Feedback and bug reports are welcome!
SQL Server IntelliSense for VS Code — a Redgate SQL Prompt alternative.
Connect to SQL Server databases and get intelligent code completion, query execution, and schema navigation.
Roadmap
- [ ] SQL formatter / code beautifier
- [ ] Execution plan viewer
- [ ] Multi-database connection (switch between databases)
- [ ] Intellisense for temp tables and table variables
- [ ] CTE and subquery column resolution
- [ ] Snippet editor UI
- [ ] Schema compare
- [ ] Unit test integration (tSQLt)
Features
IntelliSense
- Table/View completion after
FROM / JOIN with auto-alias generation
- Column completion after
alias. with type info, PK/FK icons
- SP completion after
EXEC with automatic parameter fill
- JOIN ON conditions — FK matches first, then same-name columns
- GROUP BY — "All non-aggregated columns" snippet
- SQL function snippets — COUNT, SUM, ROW_NUMBER, CAST, ISNULL, etc.
- Keyword suggestions — WHERE, ORDER BY, JOIN after table names
- SELECT * expand — expands to all aliased columns
- Table popup: CREATE TABLE script, PK, indexes, FK constraints, triggers
- View popup: CREATE VIEW definition from database
- Copy Script / Open Script clickable links
Navigation
- F12 Go to Definition — SP, Function, View, Table definitions
- F2 Rename — alias rename across all usages
Query Execution
- F5 to run queries (prioritized over mssql extension)
- Run Query button in editor toolbar
- GO batch separator support
- Multiple result set support (tabs or stacked view)
- CSV/JSON export, sortable columns
Redgate SQL Prompt Snippets
- Load existing Redgate SQL Prompt snippets from a folder
- Set via
T-SQL IntelliSense: Set Snippet Folder command
- Supports
$CURSOR$, $PASTE$, and named placeholders ($table_name$)
- Clipboard integration for
$PASTE$ placeholders
Project Sync
- Automatically sync DDL changes to SQL Server Database Projects
- Supports
CREATE, ALTER, and CREATE OR ALTER statements
- PROC, VIEW, FUNCTION, TRIGGER, TABLE support
Query Shortcuts (SSMS-style)
| Shortcut |
Default Query |
Description |
Alt+F1 |
EXEC sp_help '@WORD' |
Object info |
Ctrl+1 |
EXEC sp_who |
Active sessions |
Ctrl+2 |
EXEC sp_lock |
Locks |
Ctrl+3 |
SELECT TOP 100 * FROM @WORD |
Quick data preview |
SQL Snippets
| Shortcut |
Result |
loj |
LEFT OUTER JOIN ... ON |
lj |
LEFT JOIN ... ON |
ij |
INNER JOIN ... ON |
rj |
RIGHT JOIN ... ON |
cj |
CROSS JOIN ... |
st |
SELECT TOP 100 * FROM ... |
Settings
| Setting |
Default |
Description |
tsql-intellisense.connections |
[] |
Saved connection profiles |
tsql-intellisense.autoRefreshMinutes |
30 |
Schema cache refresh interval (0 to disable) |
tsql-intellisense.resultDisplayMode |
stacked |
Result display: tabs or stacked |
tsql-intellisense.queryShortcuts |
SSMS defaults |
Query shortcut definitions |
tsql-intellisense.snippetFolder |
"" |
Redgate SQL Prompt snippet folder path |
Getting Started
- Install the extension
- Open a
.sql file
- Run
T-SQL IntelliSense: Connect to Database from Command Palette
- Start typing — IntelliSense will suggest tables, columns, and more
License
MIT
| |
