How does this skill handle MSSQL migrations for large tables?

It utilizes metadata-only operations for adding NOT NULL columns and prevents the creation of indexes on high-volume tables like dbo.Cipher within standard migration scripts to avoid production outages.

Why does the skill insist on using CREATE OR ALTER?

Idempotency is a core requirement for Bitwarden migrations; using CREATE OR ALTER ensures that scripts can be re-run safely without failing if the procedure already exists.

Does this skill help with EF Core parity?

Yes, it specifically checks that any logic implemented in a stored procedure can be replicated in EF Core to maintain consistency across the entire application.

What is the standard for adding new parameters to procedures?

New parameters must be nullable and include a default value (e.g., = NULL) to ensure that existing C# callers do not break when the procedure is updated.

Bitwarden Dapper & MSSQL Implementation

Name: Bitwarden Dapper & MSSQL Implementation
Author: bitwarden

bybitwarden

•

Database Management

Streamlines the creation of Dapper repository methods and idempotent MSSQL stored procedures following Bitwarden's architectural patterns.

This skill provides specialized guidance for developers working on the Bitwarden server repository, ensuring that Dapper implementations and MSSQL stored procedures adhere to strict organizational standards. It guides the creation of thin repository methods, idempotent SQL scripts, and performance-optimized migrations, preventing common pitfalls such as full table scans on large datasets or breaking changes in stored procedure signatures. By enforcing consistent naming conventions and ensuring parity between Dapper and EF Core implementations, it maintains the integrity and performance of the Bitwarden data access layer.

Key Features

01Generates thin Dapper repository methods with proper parameter mapping

02Optimizes migration scripts using metadata-only operations for NOT NULL columns

03Enforces idempotent CREATE OR ALTER patterns for all stored procedures

042 GitHub stars

05Ensures behavioral parity between Dapper and EF Core implementations

06Validates Bitwarden-specific naming conventions for constraints and procedures

Use Cases

01Modifying existing database schemas without causing outages on large tables

02Creating new repository methods and stored procedures for Bitwarden entities

03Adding parameters to existing stored procedures while maintaining backward compatibility

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bitwarden/ai-plugins implementing-dapper-queries

For use in Claude.ai and ChatGPT

Download Skill