convez.ai
SkillDados & AnalyticsAvançado
clickzetta

ClickZetta Skills

clickzetta/clickzetta-skills

Skills de IA para orquestração e automação do ClickZetta Lakehouse

Ver no GitHub
InicialPluginScore · de 0 a 100

Coleção de skills reutilizáveis para IA Agents (Claude Code, Codex, czcode) que encapsulam conhecimento operacional do ClickZetta Lakehouse. Inclui 26+ skills orientados a tarefas cobrindo ingestão de dados, pipelines, modelagem, conectores, governança e operações do lakehouse.

Instalação

$npx convez-ai clickzetta/clickzetta-skills

1 comando no terminal: detecta o formato do repositório (marketplace ou plugin avulso) e instala via Claude Code. Requer Node 18+ e o Claude Code instalado.

Métricas

Estrelas
10
Forks
7
Acompanhando
2
Saúde
37%
Último commit
há 1 semana
Versão
—
Issues abertas
4
Contribuidores
15

Casos de uso

  • Ingestão de dados de múltiplas fontes (OSS, S3, Kafka, MySQL, PostgreSQL)
  • Automação de pipelines SQL e sincronização em tempo real
  • Migração de SQL de Snowflake/Databricks para ClickZetta
  • Modelagem de dados, tabelas dinâmicas e governança no lakehouse
  • Integração com ferramentas BI e execução de tarefas Studio

Veredito

Recurso técnico sólido para times que usam ClickZetta Lakehouse e precisam automatizar fluxos de ingestão, transformação e governança de dados via AI Agents. Bem estruturado, mas requer domínio prévio da plataforma ClickZetta.

README

A tradução para o português deste README ainda está na fila.

clickzetta-skills

This repository contains AI Agent skills for ClickZetta Lakehouse. The skills are designed for Codex, Claude Code, czcode, and other assistants that can load a SKILL.md-based instruction set.

The repository turns ClickZetta operational knowledge into reusable routing rules, workflows, SQL patterns, and reference documents. An assistant can use these skills to select the correct domain workflow, read the minimum required reference material, and generate or execute the right ClickZetta steps for the user's task.

Repository Contents

The repository currently contains 26 top-level clickzetta-* skills, one official documentation knowledge base, and one independent skill (singsight_install):

  • lakehouse-doc-en: English ClickZetta Lakehouse official documentation index and reference corpus.
  • clickzetta-*: task-oriented skills for ingestion, Studio tasks, dbt, modeling, dynamic tables, connectors, external integrations, governance, and operations.

Skill Catalog

CategorySkillScope
Official docslakehouse-doc-enOfficial ClickZetta Lakehouse documentation covering SQL, functions, permissions, VClusters, data sharing, SDKs, BI tools, AI functions, and general platform usage.
Foundation and connectivityclickzetta-overviewProduct overview, object model, architecture, Studio modules, brand naming, and service endpoints.
Foundation and connectivityclickzetta-sql-migrationSQL migration guidance from Snowflake, Databricks, and Spark SQL to ClickZetta SQL.
Data ingestion and pipelinesclickzetta-data-ingest-pipelineRouter for choosing ingestion methods based on source type, latency, sync scope, and whether ingestion is one-time or continuous.
Data ingestion and pipelinesclickzetta-file-import-pipelineImport data from URLs, local files, or Volume paths using format inference, table creation, and COPY INTO.
Data ingestion and pipelinesclickzetta-oss-ingest-pipelineBatch or continuous ingestion from OSS, S3, or COS through Storage Connections, External Volumes, Pipes, and COPY INTO.
Data ingestion and pipelinesclickzetta-kafka-ingest-pipelineKafka ingestion through READ_KAFKA Pipes or Kafka External Table plus Table Stream pipelines.
Data ingestion and pipelinesclickzetta-batch-sync-pipelineStudio offline batch sync tasks for single-table sync, multi-table mirrors, and sharded-table merge scenarios.
Data ingestion and pipelinesclickzetta-realtime-sync-pipelineStudio single-table real-time sync tasks for Kafka, MySQL, PostgreSQL, and related sources.
Data ingestion and pipelinesclickzetta-cdc-sync-pipelineStudio multi-table CDC sync from MySQL or PostgreSQL into Lakehouse, including full database mirror and sharded-table merge modes.
Data ingestion and pipelinesclickzetta-sql-pipeline-managerSQL-native management for Dynamic Tables, Materialized Views, Table Streams, Pipes, and layered SQL pipelines.
Data ingestion and pipelinesclickzetta-table-stream-pipelineTable Stream change data capture workflows, offset handling, preview, consumption, and idempotent downstream writes.
Data ingestion and pipelinesclickzetta-studio-task-managerStudio task creation, folder organization, scheduling, dependencies, deployment, task operations, and engineering conventions.
Data ingestion and pipelinesclickzetta-pipeline-reviewPipeline review and diagnostics across Studio tasks, Lakehouse objects, pipeline SQL, and run histories.
Data ingestion and pipelinesclickzetta-dbt-studio-pipelinePublish dbt models into Studio assets and configure scheduled execution from dbt artifacts.
Modeling and analyticsclickzetta-dw-modelingData warehouse modeling for ODS/DWD/DWS/ADS, Medallion architecture, schema design, and pipeline-aware modeling.
Modeling and analyticsclickzetta-dbt-project-setupdbt-clickzetta project initialization, profiles.yml, dbt_project.yml, and layered project standards.
Modeling and analyticsclickzetta-dbt-modelingdbt source discovery, model design, incremental materialization, tests, and model generation.
Modeling and analyticsclickzetta-dynamic-tableDynamic Table creation, refresh configuration, incremental computation, ALTER workflows, refresh history, and best practices.
Modeling and analyticsclickzetta-data-scienceData science workflows using SQL, ZettaPark, notebooks, EDA, feature engineering, inference, and vector retrieval.
Modeling and analyticsclickzetta-semantic-viewSemantic View modeling with logical tables, dimensions, metrics, filters, and semantic layer queries.
SDK and integrationsclickzetta-zettaparkZettaPark DataFrame API, Session setup, reads, transformations, writes, file operations, and SQL execution.
SDK and integrationsclickzetta-spark-flink-connectorSpark Connector reads/writes and Flink Write Connector CDC or append-only writes.
SDK and integrationsclickzetta-external-functionExternal Functions, Python/Java UDF packaging, and cloud function integration.
SDK and integrationsclickzetta-ai-functionBuilt-in AI functions: AI_COMPLETE (call LLMs) and AI_EMBEDDING (text vectors) with API CONNECTION setup.
Operations and governanceclickzetta-volume-managerExternal Volume, User Volume, Table Volume, object storage mounting, file operations, import, and export.
Operations and governanceclickzetta-table-lineageTable lineage and cost visualization based on information_schema.job_history and generated HTML artifacts.
Observabilitysingsight_installConnect AI coding agents (Claude Code, Hermes, OpenClaw, Opencode) to the Singsight observability platform via OpenTelemetry.

Routing Guide

Use the table below when deciding which skill should handle a user request.

User intentRecommended entry point
Understand ClickZetta concepts, Workspace, Schema, VCluster, object hierarchy, or Studio modules.clickzetta-overview
Configure Python, JDBC, SQLAlchemy, ZettaPark, or general Lakehouse connections.clickzetta-zettapark / lakehouse-doc-en
Choose an ingestion method without knowing whether to use files, object storage, Kafka, batch sync, real-time sync, or CDC.clickzetta-data-ingest-pipeline
Import files from a local path, URL, Volume, object storage, or Kafka.clickzetta-file-import-pipeline / clickzetta-oss-ingest-pipeline / clickzetta-kafka-ingest-pipeline
Build Studio offline sync, single-table real-time sync, or multi-table CDC tasks.clickzetta-batch-sync-pipeline / clickzetta-realtime-sync-pipeline / clickzetta-cdc-sync-pipeline
Manage Studio tasks, folders, schedules, dependencies, deployments, and task state.clickzetta-studio-task-manager
Initialize a dbt project, build dbt models, or publish dbt models to Studio.clickzetta-dbt-project-setup / clickzetta-dbt-modeling / clickzetta-dbt-studio-pipeline
Design SQL pipelines, Dynamic Tables, Materialized Views, Pipes, or Table Streams.clickzetta-sql-pipeline-manager / clickzetta-dynamic-table / clickzetta-table-stream-pipeline
Review an existing pipeline, diagnose task failures, inspect dependencies, or identify data quality issues.clickzetta-pipeline-review
Write native ClickZetta SQL, look up syntax, functions, permissions, VClusters, or official product behavior.lakehouse-doc-en
Migrate SQL from Snowflake, Databricks, or Spark SQL.clickzetta-sql-migration
Query metadata, table structures, job history, cost attribution, permissions, Time Travel, recovery, or platform operations.lakehouse-doc-en
Investigate query performance, EXPLAIN, Result Cache, OPTIMIZE, small files, or execution plans.lakehouse-doc-en
Manage users, roles, grants, masking policy, network policy, lifecycle, data sharing, SDK, BI, or Java/Python application docs.lakehouse-doc-en
Manage Volumes, object storage mounts, file upload/download, import, or export.clickzetta-volume-manager
Work with Spark, Flink, ZettaPark, External Functions, or External Catalogs.clickzetta-spark-flink-connector / clickzetta-zettapark / clickzetta-external-function / lakehouse-doc-en

Repository Layout

Each top-level skill is stored in one directory:

clickzetta-<domain>/
├── SKILL.md
└── references/
    └── *.md

SKILL.md is the routing and workflow entry point. It should define:

  • the skill name and trigger description in front matter;
  • when the skill should and should not be used;
  • the minimal workflow the agent should follow;
  • which reference files to read for detailed syntax, examples, or troubleshooting.

references/ contains detailed technical material, SQL snippets, operational playbooks, API notes, and examples. Agents should load only the specific reference files needed for the current task.

Some skills contain additional sub-skill or best-practice directories. For example:

clickzetta-dynamic-table/
├── dt-creator/
├── sql-to-dt/
└── best-practices/

Official Documentation Skill

lakehouse-doc-en is the authoritative fallback for native ClickZetta behavior. Use it when:

  • a topic has been consolidated into official documentation rather than a dedicated operational skill;
  • the user asks for SQL syntax, functions, permissions, VCluster behavior, data sharing, Time Travel, SDK, BI, AI functions, or other official product capabilities;
  • a workflow skill needs product-level confirmation from the docs.

Maintenance Notes

When adding, renaming, or deleting a skill:

  1. Update the top-level skill directory.
  2. Update .well-known/skills/index.json.
  3. Update this README.md catalog and routing table.
  4. Search the repository for stale skill references.

For deleted or consolidated topics, route users to lakehouse-doc-en unless there is another active task-specific skill that clearly owns the workflow.

Usage

Install or expose this repository's skill directories to an AI coding assistant that supports SKILL.md-based skills. Users can then describe ClickZetta tasks directly, for example:

Import CSV files from OSS into public.orders on a schedule.
Build a CDC pipeline from MySQL to Lakehouse and publish it as a Studio task.
Create a Dynamic Table for the DWS order summary layer and configure refresh behavior.

The assistant should route the request through the appropriate SKILL.md, read only the required references, and generate the concrete SQL, cz-cli commands, Studio workflow, or troubleshooting steps for the task.

Ver o original no GitHub

Bom para

Relacionados