skills.rest
bryan-zxc
bryan-zxcCOMMUNITY
Explore all skills by this author →
GitHub

create-table

Create DuckDB tables from files or query results with layer naming conventions.

Updated Mar 13, 2026
Search Tags:#sql#etl#create#duckdb#data-loading#table-management
One-click install
npx skills add https://github.com/bryan-zxc/popmartdemo --skill create-table-bryan-zxc
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: create-table
Source: https://github.com/bryan-zxc/popmartdemo/tree/main/.claude/skills/create-table
Command: npx skills add https://github.com/bryan-zxc/popmartdemo --skill create-table-bryan-zxc

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill streamlines creating new DuckDB tables from input data or derived results, reducing manual SQL boilerplate and setup effort.

Core Features & Use Cases

  • Table creation from files: load CSV, Parquet, or Excel data into a new DuckDB table.
  • Derived tables: generate tables by querying and transforming existing tables.
  • Export-ready structure: prepare tables for reporting by aligning naming conventions and layers.

Quick Start

Load a CSV file into a new DuckDB table named l10wrk_sales.

Frequently Asked Questions about create-table

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

FAQPage Schema
How do I create a DuckDB table from a CSV file?▼

This skill supports loading CSV, Parquet, or Excel files directly into a new DuckDB table. It reduces manual SQL boilerplate by automatically handling the table creation and data ingestion process.

How do I generate derived tables from existing DuckDB data?▼

You generate derived tables by querying and transforming existing DuckDB data. The skill applies naming conventions like l20drv_ to ensure derived tables align with the required data layers.

What naming conventions are enforced when creating DuckDB tables?▼

The skill enforces naming conventions like l10wrk_, l20drv_, and l30exp_ for DuckDB tables. These prefixes align tables with working, derived, and export layers for structured data management.

Can I load Parquet and Excel files into DuckDB tables?▼

Yes, you can load Parquet and Excel files into DuckDB tables. The skill supports table creation from multiple file formats, streamlining the data loading process without requiring manual SQL setup.

Do I need DuckDB installed to use this table creation skill?▼

Yes, you need DuckDB installed because this skill requires it to create and manage tables. It relies on DuckDB to enforce naming conventions and load data from files or query results.

What is the best way to prepare export-ready tables in DuckDB?▼

The best way to prepare export-ready tables is to use the l30exp_ naming convention when creating your DuckDB table. This skill aligns your table structure with the export layer for reporting purposes.

Related Skills

Explore More Data & Analytics Skills→
nq-rdlnq-rdl

convert-file

Convert data files between formats using DuckDB COPY statements.

Official
Intermediate
itsadijmbtitsadijmbt
1

duckdb-en

Translate user intent into DuckDB CLI SQL, flags, dot commands, and export formats.

Community
Intermediate
masermediagroup-stackmasermediagroup-stack
1

transforming-data

Transform raw data into analytics-ready datasets using ETL/ELT patterns.

Community
Advanced
ASTRA-TECHNOLOGY-COMPANY-LIMITEDASTRA-TECHNOLOGY-COMPANY-LIMITED

data-standard

Apply Korean public data standard terminology and naming conventions to database artifacts.

Official
Intermediate