db-schema

Generate SQLModel classes and Neon DB migration scripts from entity descriptions.

3|Updated Dec 29, 2025
One-click install
npx skills add https://github.com/IsmailAbdulkareem/Hackathon-II-Todo-Cli --skill db-schema-ismailabdulkareem
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-schema
Source: https://github.com/IsmailAbdulkareem/Hackathon-II-Todo-Cli/tree/main/.claude/skills/db-schema
Command: npx skills add https://github.com/IsmailAbdulkareem/Hackathon-II-Todo-Cli --skill db-schema-ismailabdulkareem

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the creation of database schema definitions and migration scripts, significantly reducing the manual effort and potential errors in setting up and evolving your database structure.

Core Features & Use Cases

  • SQLModel Generation: Creates Python classes for database tables using SQLModel, including relationships, fields, and constraints.
  • Migration Script Creation: Generates SQL migration files for database schema changes.
  • Seed Data Generation: Optionally creates initial data for testing purposes.
  • Use Case: When starting a new feature that requires user and task management, describe the entities and their relationships to the Skill, and it will generate the necessary Python models and SQL migration scripts for your Neon DB.

Quick Start

Use the db-schema skill to generate SQLModel classes and migrations for User and Todo entities, with a one-to-many relationship from User to Todo.

Frequently Asked Questions about db-schema

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

FAQPage Schema
How do I generate SQLModel classes and database migrations from entity descriptions?

Generate SQLModel classes and database migrations by describing your entities and their relationships; the Skill outputs Python models with UUID primary keys, timestamp fields, soft delete, enum types, and cascade deletes for FastAPI applications.

Can I automate database schema creation for FastAPI using SQLModel?

Yes, you can automate database schema creation for FastAPI by providing entity descriptions to generate SQLModel table classes, relationship definitions, and Neon DB migration scripts with proper typing and snake_case naming conventions.

What's the best way to handle SQLModel relationships and cascade deletes in Python?

The best way to handle SQLModel relationships and cascade deletes is to define them in your entity descriptions, which generates properly typed Python classes with relationship mappings, UUID primary keys, and cascade delete constraints automatically.

Does this database schema generation support soft delete and enum types in SQLModel?

Yes, database schema generation supports soft delete, enum types, UUID primary keys, and timestamp fields when creating SQLModel classes, ensuring comprehensive schema definitions for your Python application's database structure.

How do I create Neon DB migration scripts for SQLModel tables?

Create Neon DB migration scripts by describing your desired entities and relationships; the Skill generates SQL migration files alongside SQLModel Python classes, automating database schema evolution with snake_case naming and proper typing.

Can I generate seed data for testing when creating SQLModel database schemas?

Yes, you can optionally generate seed data for testing purposes when creating SQLModel database schemas, providing initial data alongside your generated Python models and SQL migration scripts for development environments.