SSMS will make a hyperlink in the results grid for any data cast to the XML data type or when the query result is JSON, and if you click the hyperlink, it opens a new text document populated with the data from that grid cell.
This extension simply parses and pretty-prints the data when it can be parsed as JSON.
- Pretty-print and formatting of JSON results
- Seamless integration with SSMS
Grab the latest build and run the VSIX
To manually install the SSMSJsonViewer extension, follow these steps:
-
Build the Project
- Open the solution in Visual Studio.
- Build the solution to generate the extension artifacts (DLLs, etc.).
-
Locate the Build Artifacts
- After building, locate the output files (typically in the
bin\Debugorbin\Releasefolder of theSSMSJsonViewerproject).
- After building, locate the output files (typically in the
-
Copy Artifacts to SSMS Extensions Folder
- Manually copy the build artifacts to the SSMS extensions directory. The default path is usually:
- For SSMS 21:
C:\Program Files\Microsoft SQL Server Management Studio 21\Release\Common7\IDE\Extensions\SSMSJsonViewer
- For SSMS 21:
- Manually copy the build artifacts to the SSMS extensions directory. The default path is usually:
-
Restart SSMS
- Close and reopen SSMS to load the extension.
- The post-build task in this project automates the copying of artifacts to the SSMS extensions folder. If you prefer manual installation, follow the steps above.
- Ensure SSMS is closed before copying files to avoid file access issues.