An SSMS plugin that streamlines SQL development with workflow enhancements.
As a SQL developer, I've encountered many of the shortcomings and limitations of SSMS. Looking for an opportunity to practice C#, I decided to create a tool that addresses the issues I personally faced. I realize there may already be both free and paid tools out there that solve similar problems in one way or another. However, my main interest is in practicing C#, writing code, solving challenges on my own, and building something that helps me in everyday work. I’ll be happy if others also find this tool as useful as I do.
- SSMS 19
- SSMS 20
- SSMS 21
- SSMS 22
Hotkeys and other parameters are specified by default.
-
Code regions support: Automatically folds regions in the editor based on --#region and --#endregion comments when a window is opened.
-
Regions refresh: Instantly update all code regions using Ctrl+K, Ctrl+O or via the context menu.
-
SQL script generation: Generate the SQL script for the object under the caret in a new window using Ctrl+F11 or the context menu.
-
Object Explorer navigation: Jump to the corresponding object in Object Explorer based on the object under the caret with Shift+F11 or the context menu.
-
Result grid search: Search across all result grids using Ctrl+Alt+F or from the main menu.
-
Mixed language typo check: Detect adjacent Cyrillic and Latin characters when saving a document.
-
A text marker indicating that a variable has been declared but not used.
-
A text marker indicating that a variable is being used but not declared.
-
Ability to view cell contents as formatted JSON in a new window.
-
Copying selected or all headers from Results Grids.
-
Marking and unmasking the beginning and end of a comment for a block of text. Works with -- and /.../ depending on the current state Ctrl+Num*.
Options page at Tools - Options - SSMSMint
You have two options:
- The build process will automatically copy all necessary files into the SSMS extension folder.
- Unpack the archive from the Releases section to the Extensions folder of your SSMS installation (default paths below, or your custom installation path):
- SSMS 19: C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Extensions
- SSMS 20: C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions
- SSMS 21: C:\Program Files\Microsoft SQL Server Management Studio 21\Release\Common7\IDE\Extensions
- SSMS 22: C:\Program Files\Microsoft SQL Server Management Studio 22\Release\Common7\IDE\Extensions
Restart SSMS after placing the files in the extension directory.
I will be glad to hear your ideas and suggestions. Also, if you encounter any errors, please send them to this repository.