dbForge SQL Complete

Powerful T-SQL code completion and formatting add-in for SQL Server tools

Overview

dbForge SQL Complete is a robust productivity extension designed for database developers and administrators working within Microsoft SQL Server Management Studio (SSMS) and Visual Studio. The tool is available in both free and premium editions, catering to different levels of professional needs. With advanced code autocompletion, intelligent formatting, and insightful navigation features, SQL Complete serves as a valuable enhancement over the default T-SQL IntelliSense.

Feature-Rich Code Assistance

One of the core strengths of dbForge SQL Complete is its context-aware autocompletion. The add-in offers real-time suggestions tailored to the user’s queries and the current database schema. By intelligently filtering available objects, columns, and functions, it helps reduce syntax errors and speeds up development. Features such as quick parameter information for functions and automatic alias generation further reduce manual coding effort and improve code clarity.

Advanced SQL Formatting

The integrated SQL Formatter brings significant customization options for writing cleaner and more readable scripts. Users can configure formatting rules according to team or project standards, allowing for consistent coding styles across large codebases. This functionality is particularly useful in collaborative environments, helping maintain high standards of code quality.

Smart Navigation and Exploration

Navigation within large databases is easier with tools like "Go to definition" and the Document Outline window. This enables fast inspection of database objects and code structure. Features such as quick object information and highlighting all occurrences of an identifier also streamline understanding of complex scripts.

Enhanced Coding Productivity

The add-in accelerates routine tasks with features like code snippets, expansion of column lists, and tailored suggestions for JOIN conditions or INSERT/ALTER/EXEC statements. Users can also execute the current statement directly from the editor, further speeding up testing and development cycles. Support for T-SQL statements in stored procedures and functions ensures a seamless coding experience even in more advanced scenarios.

Broad Compatibility and Integration

SQL Complete supports multiple versions of SSMS and Visual Studio, including editions as early as Visual Studio 2008 up through more recent releases. This compatibility makes it suitable for professionals working across different environments or maintaining legacy SQL projects.

User Experience and Performance

The interface is thoughtfully designed, with a semi-transparent suggestion box that remains unobtrusive but accessible. The overall performance of SQL Complete is responsive, providing quick feedback without slowing down large scripts. While the feature set is extensive, the tool remains accessible to both seasoned database professionals and those newer to SQL development.