A technical workflow assistant designed to generate standardized Data Definition Language (DDL) for multi-layered data warehouses.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install ddlsop
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 ddlsop 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 specification and guidance tool for developers working with Openclaw Skills. It streamlines the creation of Data Warehouse tables by enforcing strict naming conventions and architectural standards. The skill supports various data layers including DWD, DWS, DIM, and ADS, ensuring that every table is properly mapped to a workspace, business domain, and scheduling strategy.
By leveraging this tool, data engineers can automate the generation of complex SQL scripts that include precise field definitions, partitioning logic, and storage optimizations. It is an essential component for teams looking to maintain a clean and scalable data infrastructure while utilizing the broader ecosystem of Openclaw Skills.
OpenClaw DDL Creator Use Cases
- Designing and deploying new data warehouse tables with standardized naming conventions.
- Automating the creation of partitioned tables for incremental or full data updates.
- Implementing data retention policies through lifecycle (TTL) management across different environments.
- Standardizing metadata and field comments for better data governance and discoverability.
How OpenClaw DDL Creator Works
- The user selects the target workspace environment such as production, test, or development.
- The skill identifies the appropriate data layer and business domain to classify the information.
- A standardized table name is generated based on a specific concatenation rule involving the layer, domain, business description, and scheduling frequency.
- Detailed field information is collected, including snake_case English names, business-oriented Chinese comments, and data types.
- The skill applies partitioning strategies based on whether the table is daily, hourly, or full-update.
- Optimized storage settings like ALIORC and Time-To-Live (TTL) properties are appended to the final DDL output.
OpenClaw DDL Creator Setup
To integrate this capability into your workflow, ensure your environment is configured for Openclaw Skills and follow these steps:
# Install the OpenClaw DDL Creator skill package
openclaw skill add openclaw-ddl-creator
# Run the interactive generator to build your first schema
openclaw-ddl init-table
OpenClaw DDL Creator Data Schema & Taxonomy
The skill organizes table metadata using a structured taxonomy to ensure consistency across the data warehouse. Below is the primary schema organization pattern:
| Attribute | Specification | Example |
|---|---|---|
| Table Naming | {workspace}.{layer}{domain}{desc}_{schedule}{mode} | prod_workspace.dws_ord_daily_order_stats_df |
| Audit Fields | Standardized columns for creation and modification | gmt_create (DATETIME), gmt_modified (DATETIME) |
| Partitioning | Strategy based on scheduling frequency | ds (STRING) for daily, ds + hr for hourly |
| Storage Format | Default high-compression format | STORED AS ALIORC |
| Lifecycle | Retention days mapped to layer importance | ODS (30-90d), DWS (365-730d) |
OpenClaw DDL Creator Advanced Features
- Intelligent naming suffix recommendations based on data types (e.g., _cnt, _amt, _rate).
- Pre-defined audit templates to automatically include creation and modification timestamps.
- Cross-environment workspace management for seamless migration between dev and prod.
- Layer-specific TTL defaults to automate storage cost optimization within Openclaw Skills.
SKILL.md
Loading
Related Openclaw Skills
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.
Oven
A robust command-line utility for tracking oven usage, cooking schedules, and household maintenance tasks.
AnyCrawl
A high-performance web scraping and crawling CLI that provides LLM-optimized markdown for AI agents.
Registration
A terminal-based utility for managing registration records, attendee sign-ups, and data exports with complete privacy and offline functionality.
OpenClaw DDL Creator
An intelligent workflow assistant for creating standardized, production-ready Data Definition Language (DDL) scripts within the OpenClaw ecosystem.
Featured*
