database-schema-designer

Design relational database schemas from application requirements into PostgreSQL models.

Updated Apr 24, 2026
One-click install
npx skills add https://github.com/Veloxia-agency/VELOXIA-WEB --skill database-schema-designer-veloxia-agency
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-schema-designer
Source: https://github.com/Veloxia-agency/VELOXIA-WEB/tree/main/.claude/skills/engineering/skills/database-schema-designer
Command: npx skills add https://github.com/Veloxia-agency/VELOXIA-WEB --skill database-schema-designer-veloxia-agency

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill turns product and backend requirements into well-structured relational database designs, helping you avoid bad table layouts, broken relationships, and migration headaches.

Core Features & Use Cases

  • Schema planning: Convert feature requirements into entities, relationships, constraints, and indexes.
  • Production-ready output: Generate ERDs, migration plans, seed data, and implementation patterns for common ORM and migration tools.
  • Advanced data architecture: Handle multi-tenancy, soft deletes, audit trails, versioning, RLS policies, and polymorphic associations for real applications.

Quick Start

Ask for a normalized PostgreSQL schema for your feature requirements, including tables, relationships, indexes, and migration guidance.

Frequently Asked Questions about database-schema-designer

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

FAQPage Schema
How do I design a normalized PostgreSQL schema from application requirements?

Designing a normalized PostgreSQL schema involves translating feature requirements into structured tables, relationships, and constraints. This process prevents broken relationships and yields migration-ready models for production workflows.

Can I generate Drizzle migrations and RLS policies together?

Yes, generating Drizzle migrations with RLS policies is supported. The schema design process integrates multi-tenancy, audit trails, and Row-Level Security policies directly into your migration-ready ORM outputs.

What is the best way to plan multi-tenancy and soft deletes in a relational database?

Planning multi-tenancy and soft deletes requires mapping advanced data architecture patterns into your table structures. This schema design approach integrates isolation strategies and audit trails directly into constraints and relationships.

Does this database schema design approach support Prisma and TypeORM outputs?

Yes, this database schema design approach supports Prisma and TypeORM outputs. It translates table structures and constraints into implementation patterns tailored for these specific ORM and migration tools.

How do I create an ERD with proper indexes and seed data?

Creating an ERD with proper indexes and seed data involves converting feature requirements into structured table relationships and constraints. This generates a visual schema plan alongside initial seed data for production readiness.