dbForge SQL Complete Features: Code Completion, Statement Expansion, Refactoring, SQL Snippets

Completion-aided SQL coding

Context-aware code completion
Predefined and custom SQL snippets
Smart code refactoring

Context-aware code completion

Ever wondered how to make your SQL coding 2 to 4 times faster? As witnessed by the users of dbForge SQL Complete, it is extremely easy. Right from the start, you get it all with IntelliSense-style context-aware code completion, which includes relevant keyword and object suggestions, phrase completion, statement expansion, instant syntax validation, and JOIN clause auto-generation. Also note that you can get quick info on database objects while coding by simply hovering the cursor over them.

See in action

Predefined and custom SQL snippets

Want to get your daily coding done even faster? Then have a look at the library of predefined SQL code snippets—modifiable and reusable fragments of code that can be easily expanded from shortcuts. Moreover, you can enlarge the library and tailor it to your needs and preferences with your own custom snippets. Group and sort them the way you like and share them with your fellow SQL developers.

See in action

Smart code refactoring

Want to save more of your precious time? Meet smart refactoring, yet another major feature that will make your daily work as convenient as ever. For instance, SQL Complete auto-generates aliases for tables, views, table-valued functions, and synonyms—and if you need to rename them, you can do it directly in the code. All references to the renamed aliases will be automatically replaced with the relevant ones. In a similar way, you can rename variables and scripted database objects of any type.

Code standardization

Flexible SQL formatting
Automated formatting from the command line

Flexible SQL formatting

All right, now you write code fast, but how do you keep it clean and perfectly readable? Use the integrated formatting tools of SQL Complete, which help you manage cases, line breaks, whitespaces, indenting, and wrapping—all according to the rules of your current formatting style.

This is where the library of predefined formatting profiles comes into play. Each profile defines a formatting style that you can modify the way you want. You can easily create and manage new profiles, as well as share them with your teammates. This helps standardize coding styles for entire teams and keep the code written by different developers consistent at all times.

See in action

Automated formatting from the command line

How about reducing your manual work even further? If you're interested, we would like to suggest CLI-powered automated formatting. All you need to do is open the command prompt, enter the path to SQL Complete, jot down the formatting command with the required parameters and arguments, and launch it. Simple as that.

See in action

Killer features for advanced users

T-SQL Debugger
Grid aggregates
Data visualization

See in action

T-SQL Debugger

Do you miss the long-lost debugging tools in SSMS? Now you can easily bring them back with SQL Complete! Its built-in T-SQL Debugger allows troubleshooting complex queries, stored procedures, triggers, and functions directly in the IDE.

With the help of the Debugger, you can observe the runtime behavior of your database objects, locate logic errors, break or pause script execution using breakpoints, and use the handy Watches pane to evaluate your variables.

See in action

Grid aggregates

What if you often have to deal with the calculation of aggregates? Then we've got a feature that will be extremely helpful, since it automatically displays these calculations at the bottom of the SSMS results grid.

Simply select the required range of values in the grid, and you will see the MAX, MIN, AVG, SUM, COUNT, and DISTINCT functions for these values on the Aggregates panel. In case of need, you can just as easily copy values from that panel.

See in action

Data visualization

How about being able to visualize data from the grid in a matter of moments? Well, it has never been easier with the integrated Data Viewer, which conveniently displays your data in the Hexadecimal, Text, XML, HTML, Rich Text, PDF, JSON, Image, and Spatial formats.

Note that when you navigate across the results grid, the format automatically changes according to the data type for each column, yet you can easily tweak it with handy controls.

The greatest of the latest

T-SQL Code Analyzer
Support for Visual Studio 2022

T-SQL Code Analyzer

Need additional firepower to keep errors in code at bay? Then here is one of the most notable new additions to SQL Complete—T-SQL Code Analyzer—which delivers the fastest and easiest way to validate the quality of your code. Using the Analyzer, you can identify and analyze errors in SQL statements.

The way it works is simple. Once you run an analysis, errors and warnings, if any, are displayed in the Error List. To locate an error or warning in the code, right-click it and select Go to Error from the shortcut menu. Note that you can also add and modify code analysis rules in Options.

See in action

Support for Visual Studio 2022

What if you prefer Microsoft Visual Studio over SSMS? No problem. You can fully experience the functional capabilities and performance of dbForge SQL Complete in Visual Studio 2022, which is the latest and most powerful incarnation of this IDE and provides an ideal platform for SQL Complete to help you write error-free code, taking full advantage of the cutting-edge features that Visual Studio 2022 offers.

This integration represents our commitment to staying at the forefront of development technology and delivering tools that evolve with the needs of professionals in the field.

See in action