Productivity Extension

Tabs coloring

Helps you easily define the server connection a tab is currently related to by the matching color.

With this functionality, you can simply assign a color to the environment for the servers related to development, production, sandbox or test. Additionally, it is possible to add or delete Color Match by clicking the corresponding buttons on the Settings section of the Options menu.

Tabs coloring

Documents sessions

The functionality monitors active open sessions, thus, allowing you to restore accidentally closed or unsaved tabs within the current IDE session.

Custom SSMS main window title

You can change or define your own naming pattern for the SSMS main window caption and SQL document tabs. This way a proportional tab width is achieved so that you can control what is displayed in the tab name.

Restore last closed tab

Easily opens recently closed tabs within one SSMS session, including the unsaved ones.

Close unmodified tabs

The functionality closes the tabs that were not modified during your current MSSMS session.

Executed SQL statements history

SQL query history stores primary information about executed SQL queries for a particular period. You can view, edit, and search the queries you run in the database. Sometimes, users execute complex or lengthy queries but forget to save them or write them down for future reference. With the query execution history, they can easily recall and repeat previously executed queries without the need to reconstruct them from scratch.

Executed SQL statements history

Run script on multiple databases

With the multi scripts feature, you can select databases on the current server and execute a script against them from one query window. You can also specify the mode, in which the script will be executed for the selected databases: parallel or sequential.

Document Outline window

It displays a current document structure and considerably simplifies navigation in large SQL documents. You can synchronize the structure with text directly from the code.

Document outline window

Execute current statement

You can execute a specific SQL statement without selecting it. You just need to place the mouse pointer over the statement and press Ctrl+Shift+E or Alt+Enter, and dbForge SQL Complete will define the statement boundaries itself.

Execute to cursor

A handy feature allowing you to execute a script to the current position of the cursor.

Go to definition for database objects

Navigate from Code Editor straight to a specific object in Object Explorer (Server Explorer in Visual Studio).

Decrypt encrypted objects

dbForge SQL Complete easily handles encrypted objects, it shows the DDL of an encrypted object in a separate SQL document.

Highlight occurrences of identifiers

If you click an identifier in your code, SQL Complete will highlight all other occurrences of this identifier within your statement with grey color. The feature helps quickly discover where the current identifier is used.

Highlight BEGIN and END

If you click a BEGIN or END delimiter in your code, SQL Complete will highlight the BEGIN/END syntax pair in your statement with grey color. The feature helps quickly find matching BEGIN and END statements in a query.


The matching BEGIN TRY/END TRY statements will be highlighted with grey color after you click one of them. The feature significantly facilitates coding by helping quickly find matching statements in long and complex queries.


Discover matching BEGIN CATCH/END CATCH pairs in complex queries. After clicking one of the statements, the syntax pair will be highlighted.

Highlight CASE and END

Highlighting matching CASE and END operators can significantly reduce your coding time as CASE expressions used in SQL syntax can be quite long and navigating through them is not an easy task.

Highlight COLUMNS and VALUES in INSERT statement

SQL Complete highlights the name of the columns and its corresponding value in the INSERT statements to help you insert valid values. The feature significantly facilitates writing queries to insert values into multiple columns.

Navigation between queries

When you work with large scripts, SQL Complete will help you quickly find the beginning of an SQL statement. Just press a certain hotkey combination and the cursor will sequentially jump to the beginning of each statement in the SQL document.

Navigation between BEGIN and END

Find matching BEGIN/END pairs in complex queries. By pressing SHIFT+F12, your cursor will jump up or down to the matching keywords.

Navigation between BEGIN TRY/END TRY

When working with large scripts, it is important to be able to quickly navigate between paired keywords in an SQL statement. With SQL Complete you can jump between BEGIN TRY and END TRY in a blink.

Navigation between BEGIN CATCH/END CATCH

Find matching BEGIN CATCH/END CATCH pairs in complex queries. By pressing Shift+F12, your cursor will jump up or down to the matching keywords.

Navigation between CASE и END

The CASE expressions used in statements can be quite long and navigating between their beginnings and ends can be a daunting task. To solve this problem, jumping between CASE and END has been introduced.

Navigation between brackets

You can quickly jump between matching brackets within a statement by pressing Ctrl+]. This SSMS built-in feature helps save time and energy when writing long and complex queries.

Navigation to a label

Managing and troubleshooting the flow of SQL code can be quite backbreaking, however, with SQL Complete, you can jump between the GOTO statements and labels they are targeted to in a wink of an eye.

Navigation between COLUMNS and VALUES in INSERT statement

In large INSERT statements, it's often hard to determine which value corresponds to which column, and vice versa. This functionality will help you quickly locate a corresponding value for the current column.

Generate CREATE/ALTER script for server objects

This option lets you generate a script for object's modification after you drag the carriage to that object.

Generate CRUD

Quickly generate CRUD (CREATE, READ, UPDATE, DELETE) stored procedures for tables using customizable procedure that can be changed to better suit your needs.

Generate CRUD

Inline EXEC

Unwraps the sp_executesql procedure into a neat and readable static SQL query.

Convert EXEC to script

This feature allows to simplify debugging by replacing the call to a stored procedure with the stored procedure body. It takes the contents of the stored procedure and replaces the call in your query with them.

Convert EXEC to script

Convert Inline EXEC to Script

Unwraps the sp_executesql procedure into a neat and readable static SQL query.

Execution warnings

This feature analyzes potentially dangerous statements (DELETE, DROP, TRUNCATE, and UPDATE) and generates a pop-up alert if a user is about to execute a statement that may cause data loss. For example, the execution warning will be thrown up if you try to execute a DELETE statement with no WHERE clause.

Execution notifications

When a query is successfully executed, a pop-up dialog box notifies you about the time of execution. If the query was running more than 23:59:59 hours, days are added to the time in the Execution Notification.

Transaction reminder

Whenever there open transactions during query execution, a reminder will pop-up informing you about the number of uncommitted transactions.

Generate Script As from SSMS data grid

You can generate a script from the SSMS grid based on the data in the table for the following statements: INSERT, INSERT #tmpTable, WHERE IN(), WHERE AND OR, UPDATE. You can select the result statement to be saved to a file, copied to a clipboard, or opened in a new window.

Copy data from SSMS grid to file or clipboard

The data from a cell or entire table can be copied from the results grid to a file or clipboard in any of the available formats (CSV, XML, HTML, JSON).

Grid aggregates

Aggregates are automatically displayed at the bottom of the SSMS Results Grid. Select a range of values in the Results Grid to calculate aggregates. On the Aggregate Panel, you will see MAX, MIN, AVG, SUM, COUNT, DISTINCT ON for these values. To copy a value from the Aggregate Panel, double-click it or select it with a cursor and press Ctrl+C. Alternatively, double-click the value you want to copy and select the Copy command from the context menu that appears.

Data visualizers

In the Results Grid, data in Hexadecimal, Text, XML, HTML, Rich Text, PDF, JSON, Image, Spatial formats may be visually represented via the Data Viewer window.

Data can also be conveniently saved as a file. For example, hex data shown in a grid can be saved as a JPEG image.

Data Visualizers

Find in Results Grid

Searches all the matching data in the grid by the specified value. Extend the search by adding the following search details: Match Case to set a case-sensitive search Whole Words to look for the single words Use Regular Expressions to set the search by Reg Exp Close button to close the search bar All the data found will be highlighted in the Results Grid.