skills.rest
jguadagno
jguadagnoCOMMUNITY
Explore all skills by this author →
Website𝕏@jguadagnoGitHub

sql-schema

Automate database schema setup and migration with SQL scripts in AppHost.

18|3|Updated Jul 3, 2020
Search Tags:#database#schema#sql#scripts#management
One-click install
npx skills add https://github.com/jguadagno/jjgnet-broadcast --skill sql-schema
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-schema
Source: https://github.com/jguadagno/jjgnet-broadcast/tree/main/.claude/skills/sql-schema
Command: npx skills add https://github.com/jguadagno/jjgnet-broadcast --skill sql-schema

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Manages database schema modifications without relying on Entity Framework migrations, enabling manual and precise control through SQL scripts.

Core Features & Use Cases

  • Schema Modification: Add or change database tables, columns, and seed data using raw SQL scripts.
  • Workflow Automation: Orchestrate database initialization during container startup, ensuring consistent environment setup.
  • Use Case: When needing to introduce a new data table or update schema without migration tools, modify the relevant SQL files and ensure AppHost is configured to include them.

Quick Start

Create or modify SQL scripts in the scripts/ directory, then update AppHost.cs to include any new scripts to deploy changes.

Frequently Asked Questions about sql-schema

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

FAQPage Schema
How do I manage SQL database schema updates without Entity Framework migrations?▼

To update database schemas without migration frameworks, you create or modify raw SQL scripts in a designated directory and configure application startup logic to include them. This ensures schema changes are properly ordered and idempotent.

How do I automate database schema initialization during Docker container startup?▼

To automate database schema initialization during Docker container startup, you orchestrate the execution of raw SQL scripts through application startup logic. This ensures consistent environment setup by applying predictable schema modifications without relying on migration frameworks.

When should I use raw SQL scripts instead of a migration framework for database changes?▼

You should use raw SQL scripts instead of a migration framework when operating in controlled environments or Dockerized workflows requiring predictable schema updates. This approach suits database administrators and developers needing manual, precise control over schema modifications.

How do I ensure database schema changes are idempotent when using raw SQL scripts?▼

Ensuring database schema changes are idempotent with raw SQL scripts involves properly ordering the script execution within application startup logic. This manual process guarantees that applying schema modifications multiple times yields the same database state without errors.

Can I use raw SQL scripts to add seed data and new tables to an existing database?▼

Yes, raw SQL scripts can add seed data and new tables to an existing database. You place the scripts in the designated directory and update the application host configuration to include them, ensuring the new schema and seed data deploy correctly.

Related Skills

Explore More Software Engineering Skills→
kaninekanine

arduino-dbstorage-sqlstore

Manage SQLite persistent storage for Arduino Uno Q Python applications.

Community
Intermediate
jeremylongshorejeremylongshore
2.6k

generating-database-seed-data

Generate SQL or JavaScript seed scripts with Faker-based realistic data.

Community
Intermediate
Runchuan-BURunchuan-BU
401

debug

Diagnose containerized BioClaw agent execution issues by analyzing logs, mounts, and environment variables.

Community
Advanced
1Mangesh11Mangesh1
3

sql-migrations

Manage and version database schema migrations across Prisma, Drizzle, and raw SQL.

Community
Advanced