gen-table

What problem does it solve?

Manually writing database DDL statements to create tables is time-consuming and error-prone, especially when materializing query results or translating natural language requirements into schema definitions. This Skill eliminates that manual work by automatically generating and executing valid table creation statements from either SQL queries or plain language descriptions.

Core Features & Use Cases

• CTAS from SQL: Directly materialize JOIN, aggregate, or other SELECT queries as persistent tables without manual schema definition.
• Natural Language to DDL: Convert plain language table requirements into valid CREATE TABLE statements without writing DDL manually.
• Safety & Workflow Support: Interactive DDL confirmation for ad-hoc use, strict guardrails for batch/workflow mode to prevent unintended destructive operations, and automatic error recovery for failed creation attempts.
• Use Case: A data analyst with a complex query joining multiple source tables to calculate customer lifetime value can use this Skill to instantly materialize the result as a reusable wide table, no manual DDL writing required.

Quick Start

Use the gen-table skill to create a persistent table named customer_lifetime_value from your SQL query that calculates total spend per customer.