skills.rest
ollieb89
ollieb89COMMUNITY
Explore all skills by this author →
GitHub

database-design

Generate SQLAlchemy models, Alembic migrations, and Pydantic schemas from field definitions.

Updated Feb 18, 2026
Search Tags:#schema design#database#postgresql#migrations#orm#sqlalchemy
One-click install
npx skills add https://github.com/ollieb89/viflo --skill database-design-ollieb89
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/ollieb89/viflo/tree/main/.agent/skills/database-design
Command: npx skills add https://github.com/ollieb89/viflo --skill database-design-ollieb89

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the process of designing, generating, and managing database schemas, ensuring robust and efficient data storage.

Core Features & Use Cases

  • Schema Generation: Automatically create SQLAlchemy models, Alembic migrations, Pydantic schemas, and repository classes from field definitions.
  • Migration Safety: Analyze migrations for potential production issues before deployment.
  • PostgreSQL Patterns: Provides guidance on data types, indexing, and best practices specific to PostgreSQL.
  • Use Case: When starting a new project, use this Skill to quickly scaffold your initial database schema, including models, migrations, and basic CRUD repositories.

Quick Start

Generate a new SQLAlchemy model, migration, and Pydantic schema for a 'User' entity with 'email' and 'name' fields.

Frequently Asked Questions about database-design

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

FAQPage Schema
How do I generate SQLAlchemy models and Alembic migrations from field definitions?▼

You can scaffold SQLAlchemy models, Alembic migrations, Pydantic schemas, and repository classes automatically by providing field definitions to streamline your database schema design process. This automates schema generation, including models and basic CRUD repositories.

What's the best way to ensure PostgreSQL migration safety before deploying to production?▼

To ensure PostgreSQL migration safety, analyze migrations for potential production issues before deployment. This involves checking schema changes against best practices for indexing, data types, and migration safety to prevent disruptions.

Does this database schema design tool work with PostgreSQL and SQLAlchemy?▼

Yes, this database schema design tool works specifically with PostgreSQL and SQLAlchemy. It provides comprehensive tools and guidance for managing schemas, offering best practices for indexing and data types specific to PostgreSQL.

How do I scaffold a basic CRUD repository when starting a new database project?▼

You scaffold a basic CRUD repository by using the schema generation features when starting a new project. It automatically creates repository classes alongside SQLAlchemy models, Alembic migrations, and Pydantic schemas from your defined fields.

What PostgreSQL patterns are recommended for optimizing database schema indexing?▼

Recommended PostgreSQL patterns for optimizing database schema indexing involve following specific guidance on data types and indexing best practices. These patterns ensure robust and efficient data storage within your PostgreSQL database schema.

Related Skills

Explore More Software Engineering Skills→
NelkitNelkit
1

alembic-migration

Automate PostgreSQL schema changes with SQLAlchemy ORM and Alembic migrations.

Community
Intermediate
boludo00boludo00
80

postgresql

Manage PostgreSQL schemas, migrations, and queries with SQLAlchemy and Alembic.

Community
Advanced
edyrujaedyruja

pydantic-models-py

Generate Base, Create, Update, Response, and InDB Pydantic v2 models.

Community
Advanced
arcasilesgrouparcasilesgroup
54

ai-schema

Design, optimize, and manage database schemas and migrations across ORMs.

Official
Advanced