SQLShack

Top free add-ins for SQL Server Management Studio (SSMS)

September 13, 2018 by

This collection of content presents an overview of free SQL Server Management Studio (SSMS) add-ins, with product page links for each of the tools and screenshots if available. SSMS add-ins are presented in alphabetical order. If you noticed a free tool we missed, please let us know in the comments below.

ApexSQL Compare
ApexSQL Complete
ApexSQL Decrypt
ApexSQL Plan
ApexSQL Refactor
ApexSQL Search
dbForge Search
dbForge Monitor
Poor Man’s T-SQL Formatter
SQL Hunting Dog
SQL Search
Supratimas
SentryOne Plan Explorer (formerly SQL Sentry Plan Explorer)
Spotlight Tuning Pack

ApexSQL Compare

Product page: ApexSQL Compare
Supported versions: 2012 – 17
Author: ApexSQL
Description: ApexSQL Compare is a tool that can compare files, SQL Server objects, and folders. It can also be integrated as an add-in into SQL Server Management Studio and Visual Studio or it can be used directly from command line interface. It can perform two-way script comparison and create a merged file. Three comparison modes include Character, Line and Block comparison modes, along with the appropriate syntax highlighting.


ApexSQL Complete

Product page: ApexSQL Complete
Supported versions: 2012 – 17
Author: ApexSQL
Description: ApexSQL Complete is a SQL Server Management Studio and Visual Studio add-in, that speeds up coding by automatically completing SQL code statements, filling in SQL code fragments and more.


ApexSQL Decrypt

Product page: ApexSQL Decrypt
Supported versions: 2012 – 17
Author: ApexSQL
Description: ApexSQL Decrypt is a SQL Server development tool and SQL Server Management Studio add-in that can decrypt SQL objects from multiple SQL databases, located on different SQL Servers. Before decryption, the original DDL script can be previewed in the Query window as the CREATE or ALTER script type. Decryption can be done directly on a database, or by creating one SQL script for all objects or one SQL script per object.


ApexSQL Plan

Product page: ApexSQL Plan
Supported versions: 2012 – 17
Author: ApexSQL
Description: ApexSQL Plan is a SQL query analysis and optimization tool which can be used as an add-in for SQL Server Management Studio. It identifies performance issues and deadlocks, analyzes stored procedures, SQL Server query issues and query execution plans, and helps you understand query performance characteristics.


ApexSQL Refactor

Product page: ApexSQL Refactor
Supported versions: 2012 – 17
Author: ApexSQL
Description: ApexSQL Refactor is a SQL Server Management Studio and Visual Studio formatting and refactoring add-in for SQL Server with nearly 200 formatting options and 15 refactors such as table partitioning, safe rename, wildcard expansion and more.


ApexSQL Search

Product page: ApexSQL Search
Supported versions: 2012 – 17
Author: ApexSQL
Description: ApexSQL Search is a SQL Server Management Studio and Visual Studio add-in, for SQL object and data text search, managing extend properties, rename objects without breaking dependencies and showing visual relationships between objects.


dbForge Search

Product page: dbForge Search
Supported versions: 2012 – 17
Author: Devart
Description: dbForge Search is a free add-in for SQL Server Management Studio that allows you to search SQL objects, data, and text in your databases. It can be very difficult to find a required table or to remember the names of your stored routines when a database contains lots of objects. With dbForge Search, you no longer need to look through the entire SSMS Object Explorer to find a required column name, or text in a stored procedure.


dbForge Monitor

Product page: dbForge Monitor
Supported versions: 2012 – 2016
Author: Devart
Description: dbForge Monitor is a free add-in for Microsoft SQL Server Management Studio that allows you to track and analyze SQL Server performance. The tool includes various tools for SQL Server diagnostics, including a bunch of SQL performance metrics allowing to see the comprehensive and clear picture of all processes taking place on the server, detect most expensive queries, waiting for tasks, and performance bottlenecks. With dbForge Monitor, you will save hours of time spent on SQL Server performance analysis!


Poor Man’s T-SQL Formatter

Product page: Poor Man’s T-SQL Formatter
Supported versions: 2014 – 17
Author: TaoK
Description: This is a free and open-source SQL (T-SQL) formatter. Available in a variety of forms SQL Server Management Studio and Visual Studio Addin/Extension that allows you to format the current file or selected text with a single hotkey – supports any version of SSMS or SSMS Express, and any Full (not Express) version of Visual Studio.


SQL Hunting Dog

Product page: SQL Hunting Dog
Supported versions: 2008 – 2014
Author: Alex Maslyukov
Description: SQL Hunting Dog is a free SQL Server tool. It works as an add-in and gives you quick search and smooth navigation. Do not use it very often, otherwise, you will become addictive.


SQL Search

Product page: SQL Search
Supported versions: 2012 – 17
Author: RedGate
Description: SQL Search is a free add-in for SQL Server Management Studio and Visual Studio 2017, that lets you quickly search for SQL across your databases.


Supratimas

Product page: Supratimas
Supported versions: 2008 – 17
Author: Supratimas
Description: Pure HTML5, a browser-based analysis tool for Microsoft SQL Server® query execution plans. No installation required, no query plan data transmitted to our servers.


SentryOne Plan Explorer (formerly SQL Sentry Plan Explorer)

Product page: SentryOne Plan Explorer
Supported versions: 2008 – 17
Author: SentryOne
Description: Jump directly to Plan Explorer from SQL Server Management Studio with the SSMS add-in. Simply right-click an execution plan and choose the ”View with SentryOne Plan Explorer“ context menu option. The add-in works with SQL Server Management Studio for SQL Server 2005 and later.


Spotlight Tuning Pack

Product page: Spotlight Tuning Pack
Supported versions: 2012 – 17
Author: Quest
Description: Powerful SQL optimization and query plan analysis within SQL Server Management Studio. 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.


SQLShack

SQLShack

SQL Shack was created as a community service from ApexSQL, with the goal to share SQL Server knowledge through articles written by SQL Server professionals and community members
SQLShack

Latest posts by SQLShack (see all)

1,870 Views