SQL Database Project Power Tools

Download this extension from the Visual Studio Marketplace or get the CI build

---

Visual Studio Tools to enhance the SQL Database Project developer experience.

Getting Started Guide | Getting started with Data API Builder SQL MCP Server | Overview blog post: SQL Project Power Tools for Visual Studio

Features

The tool contains the following features.

• Templates - for use with New Project and for adding new items
• Import database - import the schema and database settings from an existing database
• Schema compare - visually compare your database project with a live database and apply changes to the database or your project
• Analyze - report with static code analysis result of your database project
• Manage code analysis rules - visually enable/disable static code analysis rules and set rule severity for your database project
• Create Mermaid E/R diagram - create an Entity/Relationship diagram of selected tables from your database project
• .dacpac Solution explorer node - view the contents of a dacpac file in Solution Explorer
• Script Table Data - generate insert statements for table data in your database project, based on generate-sql-merge
• Add new pre- and post-deployment scripts - easily add new pre- and post-deployment scripts to your database project
• Scaffold Data API Builder (preview) - generate a Data API Builder configuration file based on your database project, for use with Data API Builder

Power Pack

I have also published SQL Project Power Pack which adds additional features.

• T-SQL Analyzer - live code analysis of your T-SQL object creation code for design, naming and performance issues using more than 140 rules.
• SQL Formatter - formats T-SQL code to a consistent and readable layout with .editorconfig support.

SSMS Extension

An SSMS extension build is available from VSIX Gallery, bringing similar features to SQL Server Management Studio (SSMS 22+). SDK-style (Microsoft.Build.Sql) database projects are supported.

• Import database - import the schema and database settings from an existing database
• Schema compare - visually compare your database project with a live database and apply changes to the database or your project
• Analyze - report with static code analysis result of your database project
• Manage code analysis rules - visually enable/disable static code analysis rules and set rule severity for your database project
• Create Mermaid E/R diagram - create an Entity/Relationship diagram of selected tables from your database project
• Script Table Data - generate insert statements for table data in your database project, based on generate-sql-merge
• Add new pre- and post-deployment scripts - easily add new pre- and post-deployment scripts to your database project
• Scaffold Data API Builder (preview) - generate a Data API Builder configuration file based on your database project, for use with Data API Builder

Advanced topics

Have a look at the SQL Database Projects documentation on Microsoft Learn, and our extensive user guide for more information on topics like:

• reference user and system databases
• set database and build properties
• use pre- and post-deployment scripts
• pack and publish dacpacs
• use sqlcmd variables
• static code analysis customization
• and much more

How can I help?

If you enjoy using the extension, please give it a ★★★★★ rating on the Visual Studio Marketplace.

Should you encounter bugs or have feature requests, head over to the GitHub repo to open an issue if one doesn't already exist.

Another way to help out is to sponsor me on GitHub.

If you would like to contribute code, please fork the GitHub repo and submit a pull request.