dev-ddl

Generate SQL DDL statements and schema alterations from design documents.

1|Updated Dec 22, 2025
One-click install
npx skills add https://github.com/Harries/hydpromptkit --skill dev-ddl
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dev-ddl
Source: https://github.com/Harries/hydpromptkit/tree/main/skills/dev-ddl
Command: npx skills add https://github.com/Harries/hydpromptkit --skill dev-ddl

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates the generation of database DDL (CREATE TABLE, ALTER TABLE) from design documents, reducing manual drafting and the risk of human error when designing schemas.

Core Features & Use Cases

  • Generate full CREATE TABLE statements when no existing schema is present.
  • Generate incremental ALTER TABLE statements to evolve existing schemas based on design changes.
  • Enforce consistent naming conventions and provide clear, rollback-ready SQL with comments for audits.

Quick Start

Provide a design document and, if available, the current schema to generate the full DDL statements and incremental migrations.

Frequently Asked Questions about dev-ddl

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

FAQPage Schema
How do I generate SQL DDL statements from design documents?

To generate SQL DDL statements from design documents, you provide the design file and any existing schema dump to produce full CREATE TABLE statements or incremental ALTER TABLE migrations. This process automates schema creation and reduces manual drafting errors.

Can I automate database schema migration by generating incremental ALTER TABLE statements?

Yes, you can automate database schema migration by providing your updated design document alongside the current schema dump. The system generates incremental ALTER TABLE statements to evolve existing schemas safely, ensuring your database structure matches the latest design.

What is the best way to enforce consistent naming conventions in database schema creation?

The best way to enforce consistent naming conventions during database schema creation is to automate DDL generation from design documents. The generated SQL statements automatically apply predefined naming rules to tables, columns, and indexes for reliable schema audits.

How do I create safe rollback suggestions for SQL schema alterations?

To create safe rollback suggestions for SQL schema alterations, generate incremental ALTER TABLE statements from your design changes. The output includes clear, rollback-ready SQL with comments, ensuring you can safely revert database migrations if needed.

Do I need a current schema dump to generate DDL for existing databases?

You do not always need a current schema dump, but providing one is required to generate incremental ALTER TABLE statements for evolving schemas. Without an existing schema dump, the system generates full CREATE TABLE statements for new database designs instead.

What does automated DDL generation cover for database schema design?

Automated DDL generation covers tables, columns, and indexes for database schema design. It processes design documents to output standard SQL DDL statements, applying consistent naming conventions and providing rollback-ready SQL comments for audit purposes.