dbForge SQL Complete Express

dbForge SQL Complete Express is a free add-in for SQL Server Management Studio and Visual Studio. It offers powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense ®. Besides extending List Members, Complete Word and Parameter Info features, dbForge SQL Complete adds SQL Formatter.

Key Features

Smart filtering to suggest relative keywords and objects

dbForge SQL Complete filters the suggestion list based on various criteria: first typed symbols, a whitespace, camel case, a square bracket. You can be sure, whatever you type, the suggestions will be just what you want.

Integrated AI Assistant

dbForge AI Assistant extends SQL Complete with AI-powered capabilities for SQL development. It generates valid SQL from natural language input, produces context-aware queries based on the current database schema, and assists with query optimization and troubleshooting.

Additionally, the AI Assistant provides explanations of SQL syntax, analyzes execution errors, and answers database-related questions. The built-in web search ensures the use of relevant, up-to-date information.

SQL Query History

SQL Query History stores information about previously executed queries for a specified period of time. This information includes query text, size, status, associated database and server, and further details about the execution that might come in handy in a number of cases. For instance, you can do the following:

• quickly access and run queries that must be executed regularly
• investigate a particular work case (e.g., if there is a problem likely caused by a query, you can quickly locate it and address the problem most effectively)
• check the backup history
• recover a specific query if your SQL Server crashes

Parameter information for functions

When you are typing names of user-defined and built-in functions and procedures, dbForge SQL Complete displays their parameter information in a hint.

Customizable SQL formatting (partial support')

Produce clear and well-formatted code without worrying about all those indents, whitespaces, wrappings, line breaks, etc. Just keep typing your SQL and see it automatically transformed based on your preferences and formatting rules. With a wide selection of formatting options you can set any formatting style you need.

Context-sensitive suggestion of keywords (partial support')

dbForge SQL Complete thoroughly defines the context to predict what you want to type next. It displays only relative keywords and names of database objects. Just type several symbols and see the required word in the suggestion list. It takes only to press Enter and go on with your query.

Determining a current database or schema

dbForge SQL Complete displays a list of database objects from the current database or schema even if their names are not specified in a query. The names of the current database or schema are determined based on connection properties of the current SQL document. Besides, dbForge SQL Complete finds USE statements in the code and changes the current database for subsequent SQL statements.

Semi-transparent view of the suggestion box

When your code is overlapped by the suggestion box, do not close the suggestion box. Hold Ctrl to make the suggestion box switch to semi-transparent view.

Execute current statement

Now user can execute the current SQL statement without selecting it. You can just place the cursor within the statement and select the needed menu item from the context menu - and dbForge SQL Complete will define statement boundaries itself.

' Partial support comparing to the Enterprise edition of dbForge SQL Complete