An intelligent workflow assistant for creating standardized, production-ready Data Definition Language (DDL) scripts within the OpenClaw ecosystem.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install openclawsh
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install openclawsh using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is OpenClaw DDL Creator?
OpenClaw DDL Creator is a specialized tool designed to enforce data architecture standards and streamline the creation of data warehouse tables. It guides users through a structured process—from selecting the appropriate workspace (Production, Test, or Dev) to defining complex partition strategies and lifecycle policies.
By leveraging Openclaw Skills, this tool ensures that every table follows a strict naming convention and metadata taxonomy. It acts as a bridge between business requirements and technical implementation, ensuring that data layers like ODS, DWD, DWS, and ADS are consistent, documented, and optimized for performance using storage formats like ALIORC.
OpenClaw DDL Creator Use Cases
- Standardizing table names and structures across distributed data engineering teams.
- Automating the generation of complex DDL scripts for new data domain rollouts.
- Ensuring mandatory audit fields and business comments are included in every database schema.
- Implementing uniform data retention policies (TTL) based on data layer importance.
How OpenClaw DDL Creator Works
- The skill initiates a workspace check to determine if the table belongs to prod_workspace, test_workspace, or dev_workspace.
- Users select a data layer (e.g., DWD for detail, DWS for summary) and a specific business domain (e.g., ord for orders, usr for users).
- The skill prompts for scheduling cycles (daily, hourly) and update methods (incremental vs. full) to generate the standardized table name.
- Field definitions are collected, including snake_case names, data types, and mandatory business descriptions.
- Partitioning strategies and storage formats (defaulting to ALIORC) are applied based on the chosen scheduling logic.
- A final lifecycle policy (TTL) is assigned to manage data storage costs before the complete SQL DDL is generated.
OpenClaw DDL Creator Setup
To integrate this skill into your workflow, ensure your environment is configured for Openclaw Skills and execute the following in your terminal:
# Initialize the OpenClaw DDL Creator skill
openclaw install ddl-creator
# Run the skill to start the interactive DDL generation
openclaw run ddl-creator
OpenClaw DDL Creator Data Schema & Taxonomy
The skill organizes metadata and table structures based on the following taxonomy:
| Layer | Code | Description |
|---|---|---|
| Detail Layer | dwd | Cleaned granular data |
| Summary Layer | dws | Thematic lightweight summary tables |
| Dimension Table | dim | Master data (Users, Products, etc.) |
| Application Layer | ads | Application-oriented data marts |
| Raw Data Layer | ods | Original ingested data |
Naming Convention: [Workspace].[Layer]_[Domain]_[Description]_[Cycle][Update]
Example: prod_workspace.dws_ord_daily_order_stats_df
OpenClaw DDL Creator Advanced Features
- Multi-layer support including ODS, DWD, DWS, DIM, and ADS schemas.
- Intelligent naming engine that automatically suffixes tables based on scheduling (e.g., _di for daily incremental, _df for daily full).
- Built-in audit field templates including gmt_create, gmt_modified, and ds (partition date).
- Automated TTL (Time-to-Live) suggestions based on data layer best practices.
- Support for high-compression ALIORC storage and partitioned indexing.
SKILL.md
Loading
Related Openclaw Skills
Registration
A terminal-based utility for managing registration records, attendee sign-ups, and data exports with complete privacy and offline functionality.
OpenClaw DDL Creator
A technical workflow assistant designed to generate standardized Data Definition Language (DDL) for multi-layered data warehouses.
SERP Outline Extractor
A specialized skill for turning keywords and queries into search-informed content outlines, subtopics, and comprehensive SEO briefs.
Issue Request Manager
A comprehensive AI-driven tool for managing the entire lifecycle of issue requests across platforms like GitHub, GitLab, and Jira.
Xiaohongshu Hot Trend
A specialized tool for analyzing public notes and author performance trends on the Xiaohongshu social commerce platform.
Poetic Responder
An AI agent skill that transforms casual check-ins into evocative, poetic scene descriptions using randomized global locations and activities.
Featured*
