skills.rest
Uniquecrete
UniquecreteCOMMUNITY
Explore all skills by this author →
GitHub

zo-dataset-creator

Generate Zo UI-compatible schema.yaml and datapackage.json from DuckDB databases.

Updated May 6, 2026
Search Tags:#duckdb#schema generation#yaml schema#dataset validation#datapackage.json#zodatasets
One-click install
npx skills add https://github.com/Uniquecrete/ThinkFasterv1 --skill zo-dataset-creator-uniquecrete
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: zo-dataset-creator
Source: https://github.com/Uniquecrete/ThinkFasterv1/tree/main/Skills/zo-dataset-creator
Command: npx skills add https://github.com/Uniquecrete/ThinkFasterv1 --skill zo-dataset-creator-uniquecrete

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires duckdb, pyyaml, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Creating Zo Datasets manually often results in missing files or incorrectly formatted schema.yaml, which prevents tables from appearing in the Zo UI.

Core Features & Use Cases

  • Scaffold new datasets: Creates the required datapackage.json, schema.yaml placeholder, and directory structure so the dataset is recognized by Zo.
  • Auto-generate schema.yaml from DuckDB: Generates the Zo UI–compatible list-based schema using the dataset’s data.duckdb, including table/column COMMENT descriptions when present.
  • Fix broken datasets: Validates required components and regenerates schema.yaml to resolve common issues like stale schema or wrong formatting.
  • Use case: When you finish loading data into data.duckdb (e.g., tables created from CSV/JSON), run schema generation so Zo reliably displays tables with proper columns and descriptions.

Quick Start

Ask the Skill to scaffold a new dataset named sales-data and then generate a Zo UI–ready schema.yaml from its data.duckdb.

Frequently Asked Questions about zo-dataset-creator

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

FAQPage Schema
How do I generate a schema.yaml file from a DuckDB database for Zo datasets?▼

To generate a schema.yaml from DuckDB, the Skill reads your data.duckdb and auto-creates a list-based schema with table and column definitions. This ensures the Zo UI correctly displays your dataset tables.

Why are my tables not showing up in the Zo UI?▼

Tables fail to show in the Zo UI when the schema.yaml is incorrectly formatted or missing. You can resolve this by validating required dataset components and regenerating the schema.yaml from your DuckDB database.

What's the best way to scaffold a new Zo dataset from scratch?▼

The best way to scaffold a new Zo dataset is to generate the required datapackage.json, schema.yaml placeholder, and directory structure. This ensures the dataset is properly recognized and rendered by Zo.

Can I update my schema.yaml after making changes to my DuckDB schema?▼

Yes, you can update your schema.yaml after DuckDB schema changes by regenerating it. The Skill re-reads the updated data.duckdb to produce a fresh schema.yaml, replacing stale definitions with current table and column structures.

Does DuckDB schema generation include table and column comments for Zo?▼

Yes, DuckDB schema generation includes table and column comments for Zo. When generating the schema.yaml, the Skill extracts any existing COMMENT descriptions from the DuckDB database to populate the UI display.

Related Skills

Explore More Data & Analytics Skills→
ankitjh4ankitjh4

zo-dataset-creator

Generate Zo-compatible schema.yaml from DuckDB table and column metadata.

Community
Intermediate
YSheldonYSheldon

data-visualization

Build interactive dashboards, charts, and tables from multiple data sources.

Community
Advanced
zocomputerzocomputer
45

zo-dataset-creator

Create and validate Zo Datasets with schema generation from DuckDB.

Official
Intermediate
robdmcrobdmc

duckdb-sql

Generate DuckDB SQL queries from plain English questions using asset schemas.

Community
Advanced