Complete list of useful and must have add-ins for SQL Server Management Studio. This is a list of 35 SSMS add-ins updated on Jan 24, 2019.

SSMSBoost

Download page: SSMSBoost

Release date: 2018-08-10

Support Version: 2008-2017

Developer: Solutions Crew GmbH

Free version: Yes

Price: $150

SSMSBoost add-in adds missing features and improves your productivity when working with Microsoft SQL Server in SQL Server Management Studio.

The main goal of the project is to speed-up daily tasks of SQL DBA and SQL developers and to help you avoid destructive DML executions in production environments.

Licensing options: after 30 day trial period register and get free community license or buy the professional version.

Features list / SSMSBoost version comparison

SqlSmash

Download page: SqlSmash

Release date: 2017-06-10

Support Version: 2008-2017

Developer: Smashing Jedis LLC

Free version: Yes

Price: $99

Write maintainable SQL scripts, Understand code better and Navigate faster with SqlSmash, a productivity plugin for SQL Server Management Studio.

Search Database Objects

Format Sql

Execute Current Query

Insert Statement Generation

Go To Object

Increase/Decrease Text Selection

Data Protection

Find All References

Recent Tabs and Queries

See Related Data

Quick Info

Summarize Script

Go To Definition

SQL Code Guard

Download link: Red Gate SQL Code Guard

Release date: 2017-02-17

Support Version: 2016

Developer: Red Gate

Free version: Yes

Price: No

SQL Code Guard is a free solution for SQL Server that provides fast and comprehensive static analysis for T-Sql code, shows code complexity and objects dependencies.

Integration with SSMS 2016

Integration with Visual Studio 2012/2013

Checkin Policy for TFS (how to install & use)

Support of msbuild (how to use msbuild)

Command line utility (how to use command line utility).

API for custom tool development (demo projects can be found in SQL Code Guard folder)

SQL Search

Download page: SQL Search

Release date: 2017-02-27

Support Version: 2008-2017

Developer: Red Gate

Free version: Yes

Price: No

SQL Search is a free add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases.

Find fragments of SQL in tables, views, stored procedures, functions, views, jobs, and more

Quickly navigate to objects wherever they happen to be on a server

Search across multiple object types and multiple databases

Find all references to an object

Search with booleans and wildcards

Red Gate SQL Test

Download page: Red Gate SQL Test

Release date: 2017-03-21

Support Version: 2008-2017

Developer: Red Gate

Free version: No

Price: $369

Write unit tests (using the open-source tSQLt framework) for SQL Server databases in SQL Server Management Studio

Red Gate SQL Source Control

Download page: Red Gate SQL Source Control

Release date: 2017-06-30

Support Version: 2012-2017

Developer: Red Gate

Free version: No

Price: $495

Connect your databases to your source control system

Version control your schemas and reference data

Version control your schemas and reference data

Handles referential integrity for you

Push and pull Git repos (Synchronize your local and remote Git repositories inside Management Studio)

Roll back any changes you don't want

Lock objects you're working on

Work on a central database or your own local copy

Exclude objects with filters

Deploy your changes without data loss (Avoid losing data during complex deployments with migration scripts)

Supratimas

Download page: Supratimas

Release date: 2017-07-11

Support Version: 2008-2017

Developer: TTRider LLC

Free version: Yes

Price: No

SQL Server query plan execution visualizer

SSMS Tools Pack

Download page: SSMS Tools Pack

Release date: 2016-11-28

Support Version: 2012-2017

Developer: Mladen Prajdic

Free version: No

Price: €30

Keeps your query or window history safe in local files or database

Run script at cursor location and an Accidental data destruction protector

Keep your favorite statements accessible with a shortcut of your choice

Format SQL

Color the query windows based on the server/database name or a regex

Add custom replacement texts to your scripts in four different features

Modifies New Query windows with a template of your choice

Run custom scripts from a chosen node in Object Explorer

SQL Pretty Printer

Download page: SQL Pretty Printer

Release date: 2015-11-05

Support Version: 2008-2014

Developer: Gudu Software

Free version: No

Price: No

improve SQL readability

use a standard style within your organization

use automatic formatting eliminates any disagreements

embed well formatted and syntax colored SQL into your documents

add SQL format feature within 5 minutes

quickly convert between SQL and C#, Java, etc.

SQL Sentry Plan Explorer

Download page: SQL Sentry Plan Explorer

Release date: 2017-05-25

Support Version: 2008-2017

Developer: SQL Sentry

Free version: Yes

Price: No

With both a free and PRO version, Plan Explorer builds upon the graphical plan view in SSMS to make query plan optimization more efficient. It is a lightweight standalone app that contains many of the plan analysis features introduced in SQL Sentry v6, and does not require a collector service or database.

TSQL Code Smells Finder

Download page: TSQL Code Smells Finder

Release date: 2013-02-15

Support Version: 2008-2014

Developer: Dave ballantyne

Free version: Yes

Price: No

TSQL Code can smell, it may work just fine but there can be hidden dangers held within. This is a proof of concept work which will analyze TSQL scripts in an attempt to weed out some of these dangers.

SQLTreeo

Download page: SQLTreeo

Release date: 2017-06-06

Support Version: 2008-2017

Developer: Jakub Dvorak

Free version: No

Price: €50

Create custom folders for databases, stored procedures, tables, views and user defined functions

Drag&Drop objects in folders

Management interface for bulk folder operations

Ctrl+click command to alter SQL object

Seamless sharing with other team members

Bulk folders creation

Dynamic folders

ApexSQL Complete

Download page: ApexSQL Complete

Release date: 2017-10-26

Support Version: 2008-2017

Developer: ApexSQL tools

Free version: Yes

Price: No

Automatically complete SQL statements

Review an objects script and description

Improve productivity with snippets

Identify the structure of complex SQL queries

Keep track of all your tabs

Log every executed query

Easily navigate to SQL objects

Check queries in test mode

ApexSQL Refactor

Download page: ApexSQL Refactor

Release date: 2017-05-08

Support Version: 2008-2017

Developer: ApexSQL tools

Free version: Yes

Price: No

With ApexSQL Refactor you can:

Format SQL with over 160 options

Qualify objects and expand wildcards

Encapsulate SQL into procedures

Add surrogate keys

Replace one-to-many relationships

Change procedure parameters

Safely rename SQL objects

Locate & highlight unused variables

ApexSQL Search

Download page: ApexSQL Search

Release date: 2017-06-19

Support Version: 2008-2017

Developer: ApexSQL tools

Free version: Yes

Price: No

With ApexSQL Search you can:

Search for SQL objects

Quickly find data in SQL tables

Visualize relationships between objects

Edit extended properties

Easily navigate to result objects

Rename SQL objects safely

ApexSQL Source Control

Download page: ApexSQL Source Control

Release date: 2017-10-12

Support Version: 2008-2017

Developer: ApexSQL tools

Free version: No

Price: $299

Integrate SQL source control directly into SSMS

Use dedicated or shared development models

View conflicts and resolve directly in the UI

View a detailed history of changes

Lock objects to prevent overwrites

Set team policies for check outs and locks

Apply changes with dependency aware scripts

Create and apply label from source control

ApexSQL Unit Test

Download page: ApexSQL Unit Test

Release date: 2017-08-22

Support Version: 2008-2017

Developer: ApexSQL tools

Free version: No

Price: $499

Integrate SQL unit testing directly into SSMS

Install and manage tSQLt from multiple sources

Create and organize test classes

Automate test execution using the CLI

Create and organize unit tests

Write tests using T-SQL

Run tests with a single click

Manage all tests with a single form

Spotlight Developer

Download page: Spotlight Developer

Release date: 2016-02-14

Support Version: 2008-2014

Developer: Spotlight Essentials

Free version: Yes

Price: No

Users of SQL Server Management Studio can monitor all their connections via a heatmap, alarms list and realtime diagnostics for FREE. Once installed and configured, users can monitor their connections immediately. The powerful monitoring features communicate important information regarding the status of connections. Severity is color coded so it’s easy to see at a glance what needs your attention. It is easy to connect Spotlight Developer to your Spotlight on SQL Server Diagnostic Server. This makes it possible for you to take advantage of data collections for all your connections in Spotlight on SQL Server. You also get a FREE System health Check, Performance Health Analysis and comprehensive information about your most expensive queries.

dbForge Source Control

Download page: dbForge Source Control

Release date: 2017-09-30

Support Version: 2005-2017

Developer: Devart

Free version: No

Price: $249

dbForge Source Control for SQL Server is a powerful SSMS add-in for managing SQL Server database changes in source control. The tool can link your databases to all popular source control systems, and delivers smooth and clear workflow in a familiar interface.

dbForge Unit Test

Download page: dbForge Unit Test

Release date: 2017-09-30

Support Version: 2005-2016

Developer: Devart

Free version: No

Price: $199

An intuitive and convenient GUI for implementing automated unit testing in SQL Server Management Studio. The tool is based on the open-source tSQLt framework, so SQL developers can now benefit from writing unit tests in regular T-SQL. dbForge Unit Test for SQL Server functionality allows you to develop stable and reliable code that can be properly regression tested at the unit level.

dbForge Data Pump

Download page: dbForge Data Pump

Release date: 2017-09-30

Support Version: 2005-2017

Developer: Devart

Free version: No

Price: $149

dbForge Data Pump for SQL Server is an SSMS add-in for filling SQL databases with external source data and migrating data between systems. The tool supports 10+ widely used data formats and includes a number of advanced options and templates for recurring scenarios.

dbForge Index Manager

Download page: dbForge Index Manager

Release date: 2017-09-30

Support Version: 2005-2017

Developer: Devart

Free version: No

Price: $99

dbForge Index Manager for SQL Server is a handy SSMS add-in for analyzing the status of SQL indexes and fixing issues with index fragmentation. The tool allows you to quickly collect index fragmentation statistics and detect databases that require maintenance. You can instantly rebuild and reorganize SQL indexes in visual mode or generate SQL script for the future use. dbForge Index Manager for SQL Server will significantly boost SQL Server performance without much effort.

dbForge Search

Download page: dbForge Search

Release date: 2017-09-30

Support Version: 2005-2017

Developer: Devart

Free version: Yes

Price: No

dbForge Object Search for SQL Server is a FREE add-in for SQL Server Management Studio that allows you to search SQL objects and data in your databases. It can be very difficult to find a required table or to remember names of your stored routines, when a database contains lots of objects. With dbForge Object Search for SQL Server you no longer need to look through the entire SSMS Object Explorer to find a required object.

dbForge Monitor

Download page: dbForge Monitor

Release date: 2017-04-20

Support Version: 2008-2016

Developer: Devart

Free version: Yes

Price: No

The Overview tab of the tool allows you to see what actually happens at your SQL Server from various angles.

With the IO data tab of the tool, you can easily view statistics of the read and write operations for each database file.

The Wait Stats tab, you can identify the resources that slow down the server. It shows the list of waiting tasks encountered by execution threads because resources required for the request fulfillment were busy or not available.

dbForge Monitor includes an SQL query performance analyzer that allows you to detect and optimize the most expensive queries that overload the system. Apart from the list of the poorly performing queries, the tool shows the query text and query profiling data that can help you to rewrite a query in the most productive way.

dbForge SQL Complete

Download page: dbForge SQL Complete

Release date: 2017-09-30

Support Version: 2000-2016

Developer: Devart

Free version: Yes

Price: $149

dbForge SQL Complete provides a wide range of code completion features that relieve users from remembering long and complex object names, column names, SQL operators, etc., but instead allows concentrating on writing high-quality SQL code with proper formatting that is easy to understand and interpret.

SoftTree SQL Assistant

Download page: SoftTree SQL Assistant

Release date: 2016-03-18

Support Version: 2008-2014

Developer: SoftTree

Free version: No

Price: $179

SQL Assistant equips database developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

SQL Enlight for SSMS

Download page: SQL Enlight for SSMS

Release date: 2016-04-25

Support Version: 2008-2014

Developer: UbitSoft

Free version: No

Price: $195

Advanced static analysis

T-SQL code formatting

Statements history

Validate T-SQL code for syntax errors

Script Summary

Refactoring

Continuous integration support

SQL Hunting Dog

Download page: SQL Hunting Dog

Release date: 2016-03-03

Support Version: 2008-2014

Developer: Alex Maslyukov

Free version: Yes

Price: No

Quickly find tables, stored procedure, functions and views

Completely removes the pain of clunky Object Explorer

Switch between different servers and databases

Perform common operation (select data, modify table, design table, etc.) with ease

Poor Mans T-SQL Formatter

Download page: Poor Mans T-SQL Formatter

Release date: 2013-10-23

Support Version: 2008-2012

Developer: Tao Klerks

Free version: Yes

Price: No

This formatter does implement a high-level SQL tokenizer and parser, but the granularity of the parser is not very high. It does not distinguish between different types of DML, it does not parse full expression trees, etc - there's a lot it doesn't do, it just does the bare minimum to support the target formatting.

Tabs Studio

Download page: Tabs Studio

Release date: 2017-08-24

Support Version: 2012-2017

Developer: Vlasov Studio

Free version: No

Price: $49

Tabs Studio is a Visual Studio and SSMS extension empowering you to work comfortably with any number of open documents.

Multiple rows of tabs

Tab grouping

Tab coloring

Title transformation

Keyboard navigation

Flexible behavior

Customizable presentation

Extensibility API

Workload Addin

Download page: Workload Addin

Release date: 2017-02-07

Support Version: 2008-2012

Developer: Tomáš Bauer

Free version: Yes

Price: No

There are tools in SQL Server that allow to collect SQL statements for a certain period. The problem of these tools is that the amount of data recorded in this way may not be small and that the recorded data requires further processing. Also, work with these tools may not be easy. This article describes a tool that solves the problem described above. This tool can automatically collect information about executed SQL statements and it does their analysis and stores the required information in a custom SQL database, avoiding unnecessary or duplicate SQL statements being stored.

SQL Server Diagnostics

Download page: SQL Server Diagnostics

Release date: 2017-06-22

Support Version: 2016-2017

Developer: Microsoft

Free version: Yes

Price: No

SQL Server Diagnostics is a collection of micro-services which enables SQL Server customers to self-help and debug SQL Server issues related to memory dumps and receive recommended fixes for their issues.

VersionSQL

Download page: VersionSQL

Release date: 2017-02-16

Support Version: 2012-2017

Developer: VersionSQL

Free version: Yes

Price: $149

Lightweight add-in to connect your databases to your source control system

Spotlight Tuning Pack

Download page: Spotlight Tuning Pack

Release date: 2018-06-01

Support Version: 2012-2017

Developer: Quest Software Inc

Free version: Yes

Price: $180

Powerful SQL optimization and query plan analysis. The analysis will indicate whether the Query Plan can be tuned to improve performance, or whether the SQL Statement can be rewritten to optimize its efficiency.

Michel Max - SSMS Tools

Download page: Michel Max - SSMS Tools

Release date: 2018-11-16

Support Version: 2012-2019

Developer: Michel Max

Free version: Yes

Price: No

Format SQL Code.

Prepare the Procedures/Functions to be called.

Regions to organize the code.

Retrieve the complete Information of a Table.

Tab Colorize, base in the configuration window you can colorize the existing session based in the filters that you applied, making easy to the developer to identify each server/database he/she is working on.

Selection Highlight for the same word in the SQL Code.

Style Markers for the same word in the SQL Code.

Configurable CRUD creation.

Copy/Paste Table Structure and Data (Client Side).

Grid Search, with advanced Extended and Regular Expression.

Grid Search Highlight.

Grid Style Markers.

Grid Export to JSON, Excel XML.

Grid Image Capture.

Configurable Header Text Template, with quick insert, so you can easily sign you codes.

Quick encapsulate code in region.

Other versions: