skills.rest
JerryNixon
JerryNixonCOMMUNITY
Explore all skills by this author →
Website𝕏@jerrynixonGitHub

aspire-sql-projects

Builds and deploys SQL Database Projects to .dacpac files via Aspire.

1|1|Updated Feb 26, 2026
Search Tags:#sql-server#aspire#dacpac#sql-project#database-deployment#sqlpackage#declarative-database
One-click install
npx skills add https://github.com/JerryNixon/vslive-2026-las-demos --skill aspire-sql-projects
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: aspire-sql-projects
Source: https://github.com/JerryNixon/vslive-2026-las-demos/tree/main/.github/skills/aspire-sql-projects
Command: npx skills add https://github.com/JerryNixon/vslive-2026-las-demos --skill aspire-sql-projects

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enables declarative SQL database deployment by building a SQL Database Project (.sqlproj) and deploying its resulting .dacpac automatically within Aspire, replacing manual inline SQL scripts and ad-hoc migrations.

Core Features & Use Cases

  • Declarative schema management via a .dacpac produced from a dedicated .sqlproj, enabling consistent deployments.
  • Automatic deployment and diffing with SqlPackage, reducing manual migration scripting and errors.
  • Supports PostDeployment seeds and standard project structure for Tables/Views/Procedures, with integration into Aspire AppHost workflows.

Quick Start

Run aspire run to deploy your SQL Database Project and generate the dacpac automatically.

Frequently Asked Questions about aspire-sql-projects

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I deploy a SQL database project in Aspire?▼

To deploy a SQL database project in Aspire, build a .sqlproj using the Microsoft.Build.Sql SDK, generate a .dacpac, and apply it automatically with SqlPackage. This replaces manual inline SQL scripts and ad-hoc migrations.

What is declarative database deployment using a dacpac?▼

Declarative database deployment uses a .dacpac generated from a SQL Database Project to define schema via Tables and Views. SqlPackage automatically diffs and applies changes, reducing manual migration scripting and errors.

Does Aspire support automatic dacpac deployment for SQL Server?▼

Yes, Aspire AppHost integration supports automatic dacpac deployment for SQL Server. It builds the SQL Database Project and uses SqlPackage tooling to apply schema diffs across local, CI, or containerized environments.

Do I need the Microsoft.Build.Sql SDK to deploy a dacpac in Aspire?▼

Yes, the Microsoft.Build.Sql SDK is required to build the .sqlproj and generate the .dacpac. You also need SqlPackage tooling and Aspire AppHost integration to automate the deployment process.

What's the best way to replace WithCreationScript in Aspire with a SQL project?▼

The best way to replace WithCreationScript in Aspire is using a declarative SQL Database Project. Build a .sqlproj into a .dacpac and deploy it via SqlPackage to automate schema diffs and eliminate inline SQL scripts.

Can I include PostDeployment scripts when deploying a SQL Database Project dacpac?▼

Yes, SQL Database Projects support PostDeployment seed scripts within the standard project structure. These scripts are included when building the .dacpac and deploying it through the Aspire AppHost workflow.

Related Skills

Explore More Software Engineering Skills→
CommunityToolkitCommunityToolkit
619

aspireify

Initialize and configure an Aspire AppHost with service discovery and port mapping.

Official
Advanced
jtucker9jtucker9

migration-planner

Generate ordered migration scripts and rollback plans from schema diffs.

Community
Advanced
Maj3D10Maj3D10
1

aspire

Orchestrate .NET Aspire AppHost resources with service defaults and service discovery.

Community
Intermediate
kk20300113-pngkk20300113-png

database-migrations

Plan zero-downtime PostgreSQL and MySQL schema migrations with batched backfills.

Community
Advanced