How does the skill handle zero-downtime deployments?

It utilizes Evolutionary Database Design (EDD), which breaks changes into three phases (Initial, Transition, and Finalization) to ensure the code remains compatible with the database throughout a release cycle.

What database providers are supported?

The skill supports MSSQL (via Dapper/Stored Procedures) and PostgreSQL, MySQL, and SQLite (via Entity Framework Core).

Can I use this for non-Bitwarden projects?

While the principles of dual-ORM and EDD are useful generally, this skill is specifically tuned for the conventions, file structures, and requirements of the Bitwarden codebase.

What is Bitwarden's dual-ORM strategy?

Bitwarden maintains two parallel data access implementations: Dapper for MSSQL and Entity Framework Core for PostgreSQL, MySQL, and SQLite. This skill ensures both are updated simultaneously.

Does this skill help with naming conventions?

Yes, it enforces Bitwarden's specific migration naming (YYYY-MM-DD_##_Description.sql) and strict prefixing for primary keys, foreign keys, and indexes.

Bitwarden Database Architect

Name: Bitwarden Database Architect
Author: bitwarden

bybitwarden

•

数据库管理

Manages Bitwarden-specific database migrations, schema changes, and dual-ORM implementations for MSSQL and EF Core.

This skill provides specialized guidance for working within Bitwarden's unique database environment, which utilizes a dual-ORM architecture. It ensures that any schema or data changes are implemented correctly across both MSSQL (using Dapper and stored procedures) and PostgreSQL/MySQL/SQLite (using Entity Framework Core). The skill enforces Evolutionary Database Design (EDD) principles for zero-downtime deployments, automates strict naming conventions for migrations and constraints, and ensures all SQL scripts are idempotent and follow Bitwarden's established 'dbo' schema requirements.

主要功能

01Dual-ORM implementation support for Dapper and EF Core parity

02Strict enforcement of Bitwarden database naming conventions and constraints

032 GitHub stars

04Cross-provider database integration testing guidance

05Multi-phase Evolutionary Database Design (EDD) migration logic

06Automated SQL migration file naming and idempotent script generation

使用场景

01Adding new nullable columns or tables with zero-downtime migration scripts

02Refactoring existing database schemas while maintaining backwards compatibility across deployment phases

03Synchronizing stored procedure logic in MSSQL with EF Core repository implementations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bitwarden/ai-plugins writing-database-queries

For use in Claude.ai and ChatGPT

Download Skill