How does it handle file paths on Windows systems?

The skill enforces a mandatory requirement to use backslashes (\) instead of forward slashes (/) for all file paths on Windows to ensure compatibility with SQL Server tools.

What testing frameworks are supported?

The skill specifically optimizes for tSQLt, the leading open-source unit testing framework for SQL Server, providing automated execution and failure parsing logic.

Does this skill support migration-based deployments?

While it can interpret migration scripts, this skill focuses on state-based deployment using SSDT and DACPACs, as this is the recommended approach for maintainability and version control in 2025.

Can I use this for Azure SQL Database?

Yes, it includes specific patterns for Azure SQL, including the use of Managed Identity and Service Connections to avoid storing plain-text credentials.

Does it create documentation automatically?

No, it follows a strict protocol to only update existing README.md files rather than creating new documentation files, keeping your repository root clean.

SQL Server SSDT CI/CD 2025

Name: SQL Server SSDT CI/CD 2025
Author: JosiahSiegel

byJosiahSiegel

•

Deployment & DevOps

Automates and optimizes SQL Server database deployments using SSDT, tSQLt testing, and state-based CI/CD patterns.

This skill equips Claude with expert knowledge for modernizing SQL Server database lifecycles through robust DevOps practices. It focuses on state-based deployment (declarative SQL projects) using SqlPackage, ensuring that source code represents the desired end-state of the database. The skill integrates tSQLt unit testing to prevent regressions, enforces secure authentication patterns, and provides production-ready pipeline templates for GitHub Actions and Azure DevOps. It specifically addresses 2025 standards, including strict Windows file path handling and repository cleanliness protocols.

Key Features

01Provides secure authentication patterns favoring Windows Auth and Managed Identity

02Implements declarative state-based database deployment using SqlPackage and DACPACs

037 GitHub stars

04Integrates tSQLt unit testing frameworks directly into CI/CD pipelines

05Generates automated deployment reports with manual approval gates for production safety

06Enforces mandatory Windows backslash pathing for SQL Server environment compatibility

Use Cases

01Standardizing SQL Server DevOps workflows across GitHub Actions and Azure DevOps

02Implementing automated T-SQL unit testing to validate database logic during PRs

03Migrating legacy manual SQL deployments to automated state-based SSDT pipelines

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add josiahsiegel/claude-plugin-marketplace ssdt-cicd-best-practices-2025

For use in Claude.ai and ChatGPT

Download Skill