Database Schema Designer

Generate SQL migrations, ORM models, and RLS policies from natural language requirements.

Updated Mar 7, 2026
One-click install
npx skills add https://github.com/tapanshah/Claude-Skills --skill database-schema-designer-tapanshah
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Database Schema Designer
Source: https://github.com/tapanshah/Claude-Skills/tree/main/engineering/database-schema-designer
Command: npx skills add https://github.com/tapanshah/Claude-Skills --skill database-schema-designer-tapanshah

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the complex process of designing relational database schemas, generating necessary code artifacts, and ensuring data integrity and security.

Core Features & Use Cases

  • Schema Design: Translates natural language requirements into normalized database schemas.
  • Code Generation: Creates migrations (Drizzle, Prisma, TypeORM, Alembic), TypeScript/Python types, and seed data.
  • Security: Implements Row-Level Security (RLS) policies for multi-tenancy.
  • Use Case: When building a new SaaS application requiring user management, projects, and tasks, use this Skill to design the core tables, generate the Prisma schema, and create initial Alembic migrations.

Quick Start

Design a database schema for a task management system with users, projects, and tasks, including soft deletes and audit trails.

Frequently Asked Questions about Database Schema Designer

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

FAQPage Schema
How do I generate a database schema from natural language requirements?

To generate a database schema from natural language, describe your data models and relationships in plain text. The system translates these requirements into normalized relational schemas, creating core tables and defining relationships automatically for efficient data modeling.

Can I generate ORM models and SQL migrations for Prisma or Drizzle?

Yes, you can generate ORM models and SQL migrations for Prisma, Drizzle, TypeORM, and SQLAlchemy. The process creates framework-specific migration files, TypeScript or Python types, and seed data directly from your designed schema.

How do I set up Row-Level Security policies for multi-tenancy?

Setting up Row-Level Security (RLS) policies for multi-tenancy involves generating specific SQL policies that isolate data per tenant. The system designs these RLS policies alongside your schema to ensure secure data isolation across your application.

What is the best way to add soft deletes and audit trails to a SQL schema?

The best way to add soft deletes and audit trails to a SQL schema is by defining these requirements during the initial design phase. The system incorporates soft deletion flags and audit trail columns directly into your generated migrations and ORM models.

Does this database schema design approach support SaaS applications?

Yes, this database schema design approach supports SaaS applications by providing multi-tenancy features, secure RLS policies, and structured relational schemas for user management, projects, and tasks. It generates the necessary code artifacts for SaaS data isolation.