dbForge SQL Complete Features

Documentation

Find technical information on product installation, activation, and utilization

Go to documentation center

Release Notes

Discover the latest product launches, enhancements, and bug fixes

View revision history

AI Assistant

dbForge AI Assistant is a smart copilot for SQL development, which can be perfectly integrated into SSMS and Visual Studio. It generates, explains, optimizes, and troubleshoots SQL code both with and without the context of your databases. It also delivers an AI chat with integrated web search to consult you on everything related to SQL.

dbForge AI Assistant

Context-aware code completion

dbForge SQL Complete analyzes the code you are writing in real time and suggests the most relevant keywords, objects, and code fragments based on the current context.

It supports a wide range of statements, including DDL and security-related commands, helping you write SQL faster and more accurately.

SQL code auto-completion in SQL Editor

SQL code snippets

dbForge SQL Complete includes a library of reusable blocks of code that can be customized to your requirements.

In addition, you can create and manage your own custom snippets for greater productivity and convenience.

SQL code snippets

SQL code formatting

dbForge SQL Complete provides advanced SQL formatting features that improve code readability and help enforce coding standards across teams.

  • Predefined and custom formatting profiles
  • Flexible configurations
  • Bulk formatting
SQL code formatting

SQL code refactoring

Alias refactoring and custom alias mapping

dbForge SQL Complete automatically generates aliases for database objects referenced in SQL statements and applies customizable naming rules.

You can rename aliases in real time, with updates instantly reflected across all references. Additionally, alias generation rules and insertion conditions can be configured manually.

Renaming aliases

Renaming of objects and variables

You can easily rename database objects such as tables, columns, temporary tables and columns, views, stored procedures, and functions.

dbForge SQL Complete also supports renaming local and SQLCMD variables directly in the code.

Renaming variables

T-SQL Debugger

The integrated Debugger helps you analyze the runtime behavior of database objects and identify logic errors.

  • Step-by-step code execution
  • Call stack navigation
  • Breakpoints
  • Watches
T-SQL Debugger

Find Invalid Objects

You can quickly identify and fix invalid database objects with the following features:

  • Search for invalid objects across multiple databases
  • Analysis of results and reporting
  • Object management using ALTER and DROP commands
Find Invalid Objects

Productivity extension

Query History

dbForge SQL Complete allows storing and accessing a detailed history of executed queries.

  • Query history for specific time periods
  • Full information on each executed query
  • Sorting and filtering of data by various criteria
  • Search for specific SQL statements
Query History

Operations with the SSMS results grid

dbForge SQL Complete extends the capabilities of the SSMS results grid with the following features:

  • Instant aggregate calculations
  • Copying of records directly from the grid
  • Data export to CSV, XML, HTML, XLS, and JSON files
  • Generation of scripts from the results grid
Operations in SSMS grid

Results grid aggregates

dbForge SQL Complete automatically calculates aggregates for the data selected in the results grid:

  • MAX
  • MIN
  • AVG
  • SUM
  • COUNT
  • DISTINCT COUNT
Automated calculation of aggregates in SSMS grid

Data visualization

The integrated Data Viewer helps you inspect data in multiple formats, including Hexadecimal, Text, XML, HTML, Rich Text, PDF, JSON, Image, and Spatial.

The appropriate viewer is selected automatically based on the data type.

Data visualization

T-SQL Code Analyzer

T-SQL Analyzer, included in dbForge SQL Complete, helps maintain code quality by:

  • Detecting defects and potential issues
  • Identifying outdated or deprecated T-SQL syntax
  • Verifying compliance with coding standards
T-SQL code analysis

Automation

dbForge SQL Complete supports the automation of recurring tasks from the command line and integration with CI/CD pipelines.

CLI-powered code formatting

You can automate SQL code formatting from the command line with conveniently autogenerated scripts.

Bulk code formatting via CLI

CLI-powered Find Invalid Objects

dbForge SQL Complete allows automating the search for invalid database objects and references by saving task settings as reusable scripts.

Later, these scripts can be executed on demand or scheduled for recurring use through external scheduling utilities.

Automated searching for invalid database objects

Compatibility

SQL Server Management Studio

  • SSMS v22
  • SSMS v21
  • SSMS v20
  • SSMS v19
  • SSMS v18
  • SSMS v17
  • SSMS 2016 (including Express editions)

Visual Studio

  • Visual Studio 2026
  • Visual Studio 2022
  • Visual Studio 2019
  • Visual Studio 2017
  • Visual Studio 2015