skills.rest
ViewWay
ViewWayCOMMUNITY
Explore all skills by this author →
GitHub

Database Designer

Generate SQL DDL, ER diagrams, migrations, and seed data for MySQL, PostgreSQL, and SQLite.

Updated Apr 2, 2026
Search Tags:#design#database#migration#sql#normalization#seeding#er-diagrams
One-click install
npx skills add https://github.com/ViewWay/openclaw-skills --skill database-designer-viewway
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Designer
Source: https://github.com/ViewWay/openclaw-skills/tree/main/database-design
Command: npx skills add https://github.com/ViewWay/openclaw-skills --skill database-designer-viewway

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This skill helps developers design robust, normalized database schemas and supporting migration and seeding workflows to accelerate reliable product development.

Core Features & Use Cases

  • Normalize schemas and enforce data integrity across tables.
  • Generate engine-specific DDL (CREATE/ALTER) for MySQL, PostgreSQL, and SQLite with proper timestamps and constraints.
  • Provide ER diagrams and seed data generation to support planning, testing, and deployment.

Quick Start

Define your database schema and run migrations to bootstrap a new project.

Frequently Asked Questions about Database Designer

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

FAQPage Schema
How do I generate SQL DDL for multiple database engines from a single schema?▼

To generate SQL DDL for multiple engines, define your schema once and automate the creation of engine-specific CREATE and ALTER statements. This process targets MySQL, PostgreSQL, and SQLite, ensuring proper timestamps and constraints for each platform.

What is the best way to create ER diagrams and seed data for database testing?▼

Creating ER diagrams and seed data involves automating schema visualization and test data generation. This approach provides structured ER diagrams for planning and seed data workflows to support reliable database testing and deployment.

How do I normalize database schemas and enforce data integrity across tables?▼

Normalizing database schemas and enforcing data integrity involves applying structural rules across tables to eliminate redundancy. This automation ensures robust, normalized schemas that maintain consistent relationships and data constraints.

Does this database migration tool support MySQL, PostgreSQL, and SQLite?▼

Yes, this database migration tool supports MySQL, PostgreSQL, and SQLite. It generates engine-specific DDL with proper constraints and timestamps, ensuring reliable schema migrations across these three database platforms.

How do I automate end-to-end database design from schema definition to seeding?▼

Automating end-to-end database design requires defining your schema and running automated workflows for migrations and seeding. This covers normalization, indexing, DDL generation, and ER diagram creation to bootstrap new software projects.

Why should I use an automated database schema design workflow for new projects?▼

Using an automated database schema design workflow accelerates reliable product development by enforcing structure and generating migrations. It prevents manual SQL errors and provides ER diagrams and seed data for robust, scalable databases.

Related Skills

Explore More Software Engineering Skills→
ref-docsref-docs

database-schema-designer

Design database schemas with ER diagrams, normalization, and DDL generation.

Official
Advanced
dhruvinrsonidhruvinrsoni

database-design

Design relational and NoSQL database schemas with migrations and indexes.

Community
Advanced
Rune-kitRune-kit
82

db

Generate and validate database schema migrations for ORMs and raw SQL.

Official
Advanced
0xtaoist0xtaoist

ln-723-seed-data-generator

Convert ORM schemas or entity definitions into deterministic seed data in multiple formats.

Community
Advanced