A plugin like "Resharper" for SQL Server Management Studio?

Question

Does anybody know of a program or plugin for SQL Server Management Studio which is like Resharper for MS Visual Studio?

For example, it would be great to enter Ctrl-Shift-N and after starting to enter the name of a stored procedure to see list of stored procedures with most general commands like - alter, drop and create.

Answer 1

Topic is old enough, but for me it is actual in 2025 because Microsoft provided SQL Server Data Tools for Visual Studio but don't care anymore about SQL Server developing. Thats why I investigate some time for a little research of available tools making life easier for a developer. Criteria list was

• Something like ReSharper, dedicated for developer, not DBA
• Free or up to ~200$ a year
• Integration with SSMS and VS

Large and complex SQL toolkits from RedGate, Devart or ApexSQL were skipped as it's prices starts from 500-1000$ a year.

All that was left were two strong rivals - SQL Prompt and SQL Complete. Both of them have many similar features

• various shortcuts (like type 'ssf'+Tab='select * from')
• column pickers (writing a select you see all columns from table and can check with mouse required ones)
• see dependiences for tables, columns and other objects
• fast navigate from code in query window to object explorer to required object (table, procedure..)
• code formatters with various styles
• tab/execute history with filers and searches
• rename all table alias or variable occurences

I choosed SQL Prompt because it is much better with VS and has ReSharper-like underline suggestions like "unused variable", "deprecated feature, it is recommended to use .. instead of this". SQL Complete is more dedicated for SSMS, has a little more features inside SSMS (like Document outline) but there are no code analysis with VS and not so comfortable code analysis on SSMS - you must click or run additional button, results are on separate tab/window not underline current code on main/query window.

Free tools to mention:

• SSMS Boost
• SQL Complete Express Edition

Some other paid tools to mention:

• QueryTool (separate IDE environment, not SSMS plugin)
• SSMS Tools Pack
• SoftTree SQL Assist (separate IDE environment, not SSMS plugin)

Answer 2

I came across another interesting plugin called SqlSmash. It works with SSMS 2012 and is free for now it looks like.

Features from the website:

• Go To Object: Easily navigate to any of the tables, stored procedures, functions or triggers in any of your databases.
• Format Sql: Apply your casing preferences to the keywords, variables and identifiers and indent the Sql.
• Execute Current Query: Only execute the query that your cursor is placed at.
• Search Objects: Search all your database objects for any text.
• Summarize Script: Summarize complex scripts and navigate around easily.
• Go To Definition: Show the definition of a Sql object quickly.
• Find All References: Find what other objects are referencing the Sql Object under your cursor.
• Quick Info: Get a quick overview about the Sql Object under your cursor.

Answer 3

Look at the ApexSQL refactor, it is FREE amazing add-in for Visual Studio and SQL Management Studio. http://www.apexsql.com/sql_tools_refactor.aspx

Answer 4

I don't think it has that autocomplete feature you've mentioned (which is in MS Management Studio >= 2008) but the "SSMS Tools Pack" add-in has some other features you might be interested in: http://www.ssmstoolspack.com/

Features:

• SQL Snippets
• Window Connection Coloring
• Window Content History, Query Execution History and Current Window History
• Format SQL
• Search Table, View or Database Data
• Run one script on multiple databases
• Copy execution plan bitmaps to clipboard or file
• Search Results in Grid Mode
• Generate Insert statements from resultsets, tables or database
• Regions and Debug sections
• Running custom scripts from Object Explorer
• CRUD stored procedure generation
• New query template
• General options

Answer 5

You can try SQL Prompt by redgate