Database Designer

Name: Database Designer
Availability: InStock
Author: ViewWay

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

Ready to run

npx skills add https://github.com/ViewWay/openclaw-skills --skill database-designer-viewway

💬 Prompt for ChatGPT / Claude Chat▼

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.