Datus-ai

Operate a remote Apache Airflow 2.x or 3.x deployment (list/trigger/monitor DAGs, tasks, variables, connections, pools, backfills) and deploy DAG files to S3 or a dags folder via the `datus airflow` CLI

Configure an environment profile for the `datus airflow` plugin (API endpoint, credentials, optional S3/dags-folder deployment target)

Configure or troubleshoot an Alibaba Cloud ACK profile and its paired datus k8s provider profile, including the default credential chain, access keys or STS, RAM roles, RRSA/external credentials, endpoint selection, and verification.

Inspect Alibaba Cloud ACK clusters, node pools, add-ons, tasks, and authentication, and hand temporary ACK credentials to datus k8s. Use for ACK inventory, health, change diagnostics, add-on status, or Kubernetes access through an ACK provider profile.

Configure an environment profile for the `datus s3` plugin (AWS region + credentials, optional default bucket and SSE-KMS key)

Configure or troubleshoot an Azure Blob or ADLS Gen2 profile for datus adls, including Entra DefaultAzureCredential, service principals, managed identity, account key or SAS, sovereign clouds, HNS behavior, permissions, and verification.

Browse, inspect, preview, upload, download, copy, sync, move, delete, and sign Azure Blob or ADLS Gen2 paths, and inspect filesystems or manage ACLs with datus adls. Use for abfss:// data movement, artifacts, SAS URLs, or hierarchical namespace ACL operations.

Configure or troubleshoot an Azure Kubernetes Service profile and its paired datus k8s provider profile, including Azure cloud, DefaultAzureCredential, service principals, managed identity, private endpoints, and verification.

Dosi native OSI dataset, relationship, and metric authoring guidance

Datus skill file format and packaging reference. Consult when creating or revising a skill requires optional frontmatter fields, directory layout, or agent.yml integration details.

Decide where a produced artifact must be persisted before writing it, then route semantic_models and metrics through semantic_modeling, reference_sql through gen_sql_summary, knowledge through extract-knowledge (lite), memory through add_memory, skills…

Create or update custom Datus subagents by editing the loaded agent.yml. Use when a workflow needs persistent agentic_nodes scoped to already-built tables, metrics, or reference SQL.

Bootstrap project reference SQL and metrics from a BI dashboard through an installed plugin. Use when the user asks to initialize, import, extract, or build context, reference SQL, semantic models, or metrics from a dashboard or requests dashboard bootstrap.

Build the project's vector-indexed knowledge base from files plus database metadata — optionally scoped to specific files / tables / datasources / domains. Scan the in-scope material, classify it into business domains, explore each domain's tables and docs in…

Lightweight initialization of a project's core scope, optionally limited to files, tables or domains. Reads SQL and persisted lineage, human docs and live schema without querying table data. Writes confirmed knowledge to AGENTS.md and knowledge/*.md;…

Mine shortest atomic facts from (question + gold_sql) pairs into ./knowledge/*.md; either by simulating SQL drafting (lite) or by driving the gen_sql subagent in blind iteration (deep)

Generate and interpret HiveServer2 SQL for Apache Hive and Transwarp Inceptor, using the configured server type to select product-specific semantics.

Generate and review Athena SQL engine v3 queries using Trino expressions, Hive DDL, catalog/database names, nested data and partition pruning. Read the write reference for S3 tables, CTAS, INSERT and Iceberg mutations.

Discover SAP HANA tables, inspect columns, and generate HANA SQL while preserving quoted identifiers and tenant/schema boundaries.

Generate and review BigQuery GoogleSQL with project/dataset names, nested data, time zones and partition pruning. Read the DDL reference for table creation and migration.

Generate and interpret Apache Doris SQL with catalog, OLAP key-model and aggregate-state semantics. Task references cover physical tables, writes, loading, and materialized-view queries or rewrite diagnosis.

Generate and interpret GaussDB(DWS) SQL with PostgreSQL 9.2 and ORA/TD/MySQL compatibility semantics. Read the task reference for layout, DDL portability and materialized views.

Generate and interpret GaussDB/openGauss SQL with PostgreSQL query syntax and A/B/PG compatibility modes. Read the task reference for distributed layout, upserts and transactions.

Generate and interpret Hologres SQL with its PostgreSQL subset, namespaces, types and foreign-table semantics. Read the task reference for physical layout, DDL and writes.

Create or change the Apache Ossie semantic model (dosi/model.yaml) — datasets, relationships, metrics, time dimensions — and check it against reference numbers. Use when the user wants to build a semantic model or metric layer, add a table or metric, change a…

Build or use an Apache Ossie ontology (dosi/ontology.yaml) — business concepts such as Customer, Order, Product, their relationships and roles — and ask questions by concept path. Use only when the user asks about an ontology, business concepts or entity…

Connect dosi to the user's data — a warehouse (Snowflake, BigQuery, Databricks, Postgres, MySQL, ClickHouse, Trino, …) or local files. Use when the user asks to connect, switch or fix a database connection, when a data question arrives and no connection…

Answer any data question — numbers, trends, breakdowns, rankings, "why did X change", or lists of records — through the dosi semantic layer instead of hand-written SQL. Use whenever the user asks about their data (revenue, orders, customers, any KPI) in a…

Check or update the dosi engine this plugin runs. Use when the user asks which dosi version is installed, whether there is a newer one, or to upgrade or update dosi.

Show how a metric is computed and where its data comes from — metric lineage (tables → datasets → metrics → derived metrics), and the ontology's concept graph when one exists. Use when the user asks "how is X calculated", "where does this number come from",…

Research, write, wire in, preview and PR one SEO blog post for datus.ai (the Datus-website repo) end to end, then record it so no topic is ever written twice. Use when the operator asks for a blog post — 写一篇 blog、从 /glossary 挑一个方向写文章、写一篇 SEO 博客、新增 blog…

Produce the weekly datus.ai SEO report from Google Search Console + GA4, cross-checked against the blog posts shipped that week, and hand the search opportunities to /datus-blog as topic input. Use when the operator asks for the SEO 周报, GSC / GA4 weekly…