db-schema

Design database schemas with entities, relationships, and DDL code.

1|Updated Apr 12, 2026
One-click install
npx skills add https://github.com/tanjed/claude-workflow --skill db-schema-tanjed
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-schema
Source: https://github.com/tanjed/claude-workflow/tree/main/skills/db-schema
Command: npx skills add https://github.com/tanjed/claude-workflow --skill db-schema-tanjed

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Manually designing a database schema is a complex and time-consuming task. This Skill simplifies the process, allowing users to create normalized, production-ready schemas for various domains with a few prompts.

Core Features & Use Cases

  • Domain-specific Schema Design: Generate schemas tailored to a given domain or feature.
  • Automated Steps: Guides through steps to identify entities, relationships, and attributes.
  • DDL Generation: Outputs the final SQL code for tables, indexes, and relationships.
  • Migration Files: Generates migration files compatible with different frameworks.

Quick Start

Generate a database schema for an e-commerce platform.

Frequently Asked Questions about db-schema

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

FAQPage Schema
How do I design a database schema for a specific domain?

To design a database schema, you provide a domain or feature description, and the system generates entities, relationships, and DDL code. It guides you through automated steps to identify attributes and outputs production-ready SQL.

What is database normalization and do I need it to generate DDL?

Database normalization organizes tables to reduce data redundancy. You need an understanding of normalization and basic SQL syntax to effectively generate DDL code and ensure the resulting schema is production-ready.

Can I generate migration files for my framework from a database schema?

Yes, you can generate migration files compatible with popular frameworks. The system outputs the final DDL code for tables and indexes, which can be directly translated into framework-specific migration scripts.

What's the best way to create SQL tables and relationships from a feature description?

The best way to create SQL tables is to use an automated schema design process that identifies entities and relationships from your feature description. It then generates the corresponding DDL code for the database schema.

Does database schema generation work for complex domains like an e-commerce platform?

Yes, database schema generation works for complex domains like an e-commerce platform. It simplifies the process by automatically identifying necessary entities, relationships, and attributes to output a normalized schema.