skills.rest
kollaborai
kollaboraiCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Design normalized SQLAlchemy schemas and configure Alembic migrations for relational databases.

1|Updated May 5, 2026
Search Tags:#database design#indexing#migrations#data integrity#sqlalchemy#alembic#schema normalization
One-click install
npx skills add https://github.com/kollaborai/kollab --skill database-design-kollaborai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/kollaborai/kollab/tree/main/bundles/skills/database-design
Command: npx skills add https://github.com/kollaborai/kollab --skill database-design-kollaborai

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the common pain points of inconsistent database design, data anomalies from poor normalization, and fragile, unversioned database changes that cause production outages and slow down development teams.

Core Features & Use Cases

  • Normalized Schema Design: Follows 1NF, 2NF, 3NF, and BCNF rules to eliminate redundancy and prevent data anomalies, with support for all common relationship types including one-to-many, many-to-many, and one-to-one.
  • Migration Management: Full Alembic integration for versioned, reversible database migrations, including support for both schema changes and data transformations.
  • Performance & Integrity: Includes indexing strategy guidance, constraint enforcement, query optimization to avoid N+1 issues, transaction management, and soft delete implementation for audit compliance.
  • Use Case: A development team building a new e-commerce platform can use this Skill to design a normalized schema for users, products, and orders, set up proper foreign keys and indexes, create versioned migrations for schema changes, and implement soft deletes for order history retention.

Quick Start

Use the database-design skill to create a normalized SQLAlchemy schema for a task management application with users, projects, and tasks, then configure Alembic to manage versioned migrations for the database.

Frequently Asked Questions about database-design

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

FAQPage Schema
How do I design a normalized database schema with SQLAlchemy?▼

To design a normalized database schema with SQLAlchemy, apply 1NF, 2NF, 3NF, and BCNF rules to eliminate redundancy. This approach prevents data anomalies and establishes reliable entity relationship modeling for one-to-many, many-to-many, and one-to-one connections.

How do I manage reversible database migrations using Alembic?▼

Managing reversible database migrations using Alembic involves configuring versioned schema changes and data transformations. This workflow ensures structured updates and safe rollbacks, preventing production outages caused by fragile, unversioned database modifications.

What's the best way to avoid N+1 query issues and optimize database indexing?▼

To avoid N+1 query issues and optimize database indexing, implement a targeted indexing strategy alongside query optimization. This ensures efficient data retrieval and enforces constraints for maintaining strict data integrity across your relational database.

Does this database design approach support soft deletes and transaction management for PostgreSQL and MySQL?▼

Yes, this database design approach supports soft deletes and transaction management for PostgreSQL, MySQL, and SQLite. It implements soft deletes for audit compliance and manages transactions to ensure reliable data operations across supported relational databases.

How do you enforce data integrity constraints during relational schema design?▼

Enforcing data integrity constraints during relational schema design requires applying normalization rules and setting up proper foreign keys. This prevents inconsistent data, eliminates redundancy, and guards against anomalies throughout application development.

Related Skills

Explore More Software Engineering Skills→
earayuearayu
34

database-migration

Generate and apply Alembic migrations for SQLAlchemy models in Neon environments.

Community
Advanced
autorundevautorundev
1

db-migrations

Automate database migrations for Python applications using Alembic and raw SQL.

Community
Advanced
tonone-aitonone-ai
69

flux-schema

Design normalized database schemas with 3NF, constraints, and reversible migrations.

Official
Advanced
ps-carvalhops-carvalho

database-design

Generate normalized database schemas with indexing and migration strategies.

Community
Advanced