Does this skill support Entity Framework migrations?

No, this skill is specifically built for projects that use a raw SQL script-loading pattern via .NET Aspire and prohibits the use of EF migrations.

How are new database scripts registered?

When creating a new script, the skill provides instructions to update the AppHost.cs file to include the new file in the SQL concatenation list.

Why does the skill emphasize idempotent SQL?

Since scripts may run every time the .NET Aspire container starts, idempotency ensures that the database isn't corrupted by attempting to recreate existing objects.

Can this skill handle database views?

Yes, it includes specific workflows for managing views, typically stored in create-views.sql and orchestrated through the AppHost.

Where is the source of truth for the database schema?

The source of truth is maintained as a collection of .sql files located within the scripts/database/ directory.

SQL Schema Architect

Name: SQL Schema Architect
Author: cwoodruff

bycwoodruff

•

データベース管理

Manages SQL Server database schemas and data seeding using raw scripts and .NET Aspire orchestration.

The SQL Schema Architect skill is designed for developers working with the MoreSpeakers.com project or similar .NET Aspire environments that favor raw SQL scripts over Entity Framework migrations. It provides a structured workflow for modifying database schemas, creating idempotent T-SQL scripts, and ensuring that the .NET Aspire AppHost correctly orchestrates the script loading process. By following a 'Script-Load' pattern, this skill allows Claude to precisely manage table creation, view definitions, and seed data while maintaining a single source of truth within the scripts directory.

主な機能

01Raw T-SQL script generation and management

02Database seeding and view orchestration

03Automated .NET Aspire AppHost integration logic

04Idempotent SQL pattern enforcement

056 GitHub stars

06Schema dependency and foreign key ordering

ユースケース

01Updating database seed data without using Entity Framework

02Adding new tables or columns to a containerized SQL Server instance

03Modifying .NET Aspire orchestration logic to include new schema scripts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add cwoodruff/morespeakers-com sql-schema

For use in Claude.ai and ChatGPT

Download Skill