dbForge SQL Complete

dbForge SQL Complete is a useful add-in for Microsoft SQL Server Management Studio and Microsoft Visual Studio. Free and advanced paid editions of the SQL code formatter offer powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense.

Key Features

Code Completion

Code completion in SQL Complete predicts not only keywords and object names, but also whole code fragments to simplify and accelerate your work. Intelligent suggestions with smart filtering make the code typing process really smooth and fast.

SQL Formatter

SQL code can be automatically formatted using SQL Complete. The formatter can work either with available code or the code that is being typed. You don't need to pay that much attention to case, line breaks, whitespaces, indenting, wrapping, etc - the application will take care of them all for you.

Try SQL Formatter online without having to download or install anything!

Statement expansion

INSERT, ALTER, and EXEC statements will be expanded to the full code template on pressing the Tab key to avoid tedious typing.

Except the template, the type of column data will be generated in the comments.

View feature in action

SQL Snippets

For frequent repetitive usage of code fragments, SQL snippets feature can be used. The application shows available code templates in the dropdown prompt list, and any of them can be inserted into the code you are typing on pressing Tab. In Snippets Manager, predefined templates can be modified and new ones can be added.

Quick object information

The application gives you essential information on database objects while you are writing code. Get such information for tables, procedures, and other objects.

Parameter information prompts you with stored procedure and function parameters when writing call statements and relieves your memory.

Param info screenshot

Code Navigation

With the Go to definition option, you can locate the needed object in the Object Explorer tree in a moment.

Document outline window, in its turn, allows navigating through large SQL documents. The window shows the structure of the current SQL document which can be easily synchronized with the code both ways.

View feature in action

SQL Complete vs Microsoft native T-SQL IntelliSense®

SQL Code Completion

Much faster work

SQL Complete is designed to increase productivity. Application developers and DBAs work with SQL will become much faster thanks to our tool, as it provides smart prompts basing on the code context, selected database, etc. The application takes the smallest hint to guess what you are trying to write.

SQL Code Completion

Support for all SQL Server versions

With standard tool you won't get SQL Server Management Studio IntelliSense for all versions of Microsoft SQL Server. Don't think when choosing with which SQL Server to work - at least, don't mind the availability of IntelliSense for this server - SQL Complete supports all of them! Just install your server and our application - and work wonders in your SQL coding!

SQL Code Completion

Pretty code with SQL formatting

SQL Complete gives you a great opportunity to fight unintelligible poorly formatted SQL code. Set wide range of formatting options so that the code is formatted in accordance with your needs and preferences - code will be easier to read, understand, debug, and test.

dbForge SQL Complete: SQL Coding Style Standardization

Coding style standardization

Always having problems with the fact that each person in your team invents his or her own SQL standards? With SQL Complete there is a way to put an end to this chaos. Introduce and maintain corporate SQL writing standards using a special tool for exporting and importing settings.

To see the complete list of differences between SQL Complete and built-in SSMS Intellisense, read the SQL Complete - Alternative to Native Microsoft T-SQL Intellisense article.

SQL Complete Express - free SQL IntelliSense add-in for SSMS

You can use SQL Complete Express as a free add-in for SQL Server Management Studio. You are eligible to use SQL Complete Express either for non-commercial or commercial purposes. This edition of our SQL code completion tool provides basic functionality for autocompleting and formatting code for free.

SQL Complete for Free

Use SQL Complete, if you:

  • Newbie in development
  • Could not prove the necessity of spending extra amount of money from the company budget to buy the Standard edition
  • Enthusiast that works for nonprofit organizations such as universities, churches, educational institutions, municipalities and their agencies
SQL Complete Free Edition

FREE edition provides:

  • Code completion for SELECT, INSERT, UPDATE, EXEC, and DELETE statements
  • Basic SQL formatting functionality
  • Smart filtering in the suggestion list
  • Parameter information for procedures and functions

In spite of the limitations of the Express edition of our SQL autocomplete add-in, we keep an eye on the fact that it should provide more extended IntelliSense capabilities than the standard functionality .

What people say

Just thought I'd let you know that you've all done an awesome job fixing that issue - thank you all so very much. No more crashes and I have to say that I'm extremely impressed with your response times, issue resolution times and customer service - all excellent!
Well done and thank you all so much!!!

Tony Hales, Software Developer, DeMontfort Fine Art

By the way SQL Complete is one of the greatest tools I've seen for SQL Server.

Andreas Fuchs, IT Systemtechnik, Soennecken