SQL Database Project Power Tools Gallery feed (extension)

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 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. Blog post
• 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
• Publish programmability objects on save (preview) - automatically publish supported CREATE statements (stored procedures, views, functions, triggers) to a target database when .sql files are saved. Blog post
• Scaffold SQL MCP Server (preview) - generate a SQL MCP Server configuration file based on your database project, for use with SQL MCP Server
• Add Azure DevOps Pipeline (preview) - generate a commented starter pipeline with passwordless deployment, firewall handling, the latest SqlPackage and plan/approve stages. Guide

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 SSMS 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
• 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. Blog post
• 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
• Publish programmability objects on save (preview) - automatically publish supported CREATE statements (stored procedures, views, functions, triggers) to a target database when .sql files are saved. Blog post
• SQL MCP Server Scaffold (preview) - generate a SQL MCP Server configuration file based on your database project, for use with SQL MCP Server
• Add Azure DevOps Pipeline (preview) - generate a commented starter pipeline with passwordless deployment, firewall handling, the latest SqlPackage and plan/approve stages. Guide

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.