dbForge SQL Complete Express

The built in IntelliSense in SSMS tends to play dead at the wrong moment: table names typed in full, JOIN conditions from memory, and a long SELECT that ends up as one tangled block. dbForge SQL Complete is an add-in for SQL Server Management Studio and Visual Studio that lists tables, columns and procedures after a few letters, fills in ON conditions for JOINs and formats a whole script with one command.

Express is the free edition: completion, snippets, formatting and object tooltips are included; refactoring and the advanced formatting profiles stay in the paid tiers. Setup detects installed SSMS and Visual Studio and adds a SQL Complete menu. Note that the first install runs as a Standard trial and switches to Express when the trial ends.

Features

Context aware completion: Suggests tables, columns, aliases, functions and procedures for the current position, with fuzzy matching.

Statement expansion: SELECT * expands to the full column list, JOINs get their ON clause filled in.

Snippets: Built in T-SQL snippets plus your own.

Formatting: One command applies configurable rules for indentation, casing and line breaks.

Object info: Hover to see table structure, column types and procedure parameters.

Navigation: Go to definition, highlight matching brackets and references.