huawei-cloud-doris-sql-check SKILL.md skillA

huawei-cloud-doris-sql-check from huaweicloud/huaweicloud-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add huaweicloud/huaweicloud-skills/huawei-cloud-doris-sql-check@git:20260730.b4f666c

Pins git:20260730.b4f666c in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
huaweicloud/huaweicloud-skills
Path
skills/bigdata/mrs/huawei-cloud-doris-sql-check/SKILL.md
Versions recorded
1
Latest version
git:20260730.b4f666c, committed Jul 30, 2026
Size
29,014 bytes
Repository stars
59
License
MIT

Comprehensive SQL statement checking for Apache Doris (based on Doris 3.1.4 Nereids ANTLR4 grammar), supporting two check modes: 1. Syntax Check - Keyword validation, statement structure verification, clause completeness, Doris-specific syntax compatibility (DISTRIBUTED BY, PARTITION BY, ENGINE, DUPLICATE/AGGREGATE/UNIQUE KEY, INSERT OVERWRITE, LOAD, EXPORT, MTMV, BACKUP/RESTORE etc.) 2. Specification Check - Object design standards, data operation standards, naming conventions based on Apache…

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Doris SQL Check Skill

You are an Apache Doris SQL specification checking expert, responsible for comprehensive SQL statement checking for Apache Doris (based on Doris 3.1.4 source code). You have a custom-built Doris SQL tokenizer and recursive descent parser that can precisely identify Doris-specific syntax from the Nereids ANTLR4 grammar (`DorisLexer.g4` / `DorisParser.g4`).

## Overview

**Architecture**: This skill uses a three-stage pipeline: Tokenizer (lexical analysis) → Parser (syntax analysis) → Rule Engine (syntax + specification checking) → Report Generation.

**Applicable Scenarios**:

- Validate SQL syntax before executing on a Doris cluster (FE/BE)
- Review SQL statements against Apache Doris development best practices
- Check Doris-specific syntax (DISTRIBUTED BY HASH/RANDOM, PARTITION BY RANGE/LIST/AUTO, BUCKETS, PROPERTIES, ENGINE, DUPLICATE/AGGREGATE/UNIQUE KEY, INSERT OVERWRITE TABLE, LOAD LABEL, ROUTINE LOAD, EXPORT, MTMV, BACKUP/RESTORE SNAPSHOT, ADMIN SET/SHOW, CANCEL, KILL, TABLESAMPLE, OUTFILE, Hint /*+ */, full-text MATCH_*, COLOCATE GROUP)
- Identify potential performance anti-patterns in Doris SQL statements

**Typical Use Cases**:
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add huaweicloud/huaweicloud-skills/huawei-cloud-doris-sql-check@sha256:9c76c6105383f434

The line at the top of this page pins the label git:20260730.b4f666c, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_4koporzghms5ywhi.svg)](https://markdownregistry.com/a/art_4koporzghms5ywhi)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on Jul 30, 2026.

versioncommittedcommitsizeaudit
git:20260730.b4f666c latest2026-07-30 b4f666c 29,014 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (29014 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

huaweicloud/huaweicloud-skills · 59 stars · license MIT · pushed 2026-11-07 · branch master

API

GET https://markdownregistry.com/api/v1/artifacts/art_4koporzghms5ywhi
GET https://markdownregistry.com/api/v1/resolve?ref=huaweicloud/huaweicloud-skills/huawei-cloud-doris-sql-check
GET https://markdownregistry.com/api/v1/blob/9c76c6105383f434623762fa171413cc05f3a6d768a1772f30f25391541adb2a

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from huaweicloud/huaweicloud-skills

huawei-cloud-agentorchard-find-skills SKILL.md skill
huaweicloud/huaweicloud-skills · skills/agentorchard/common/huawei-cloud-agentorchard-find-skills/SKILL.md · Search, discover, browse and install AI Gallery Agent skills via natural language. Triggers include: "AI Gallery", "AI…
git:20260901.083a756 · audit A · 59 stars
huawei-cloud-agentarts-obs-diagnosis SKILL.md skill
huaweicloud/huaweicloud-skills · skills/ai/agentarts/huawei-cloud-agentarts-obs-diagnosis/SKILL.md · Observability no-data diagnosis skill for Huawei Cloud AgentArts agent-ops platform. Systematically diagnoses missing…
git:20260930.dabbbec · audit A · 59 stars
huawei-cloud-agentarts-otel-ingestion SKILL.md skill
huaweicloud/huaweicloud-skills · skills/ai/agentarts/huawei-cloud-agentarts-otel-ingestion/SKILL.md · OpenTelemetry ingestion skill for Huawei Cloud AgentArts observability platform. Provides OTel telemetry data…
git:20260924.742ec33 · audit A · 59 stars
huawei-cloud-cloudrobo-asset SKILL.md skill
huaweicloud/huaweicloud-skills · skills/ai/cloudrobo/huawei-cloud-cloudrobo-asset/SKILL.md · Manage the full lifecycle of CloudRobo assets — query repositories and catalogs, create/list/show/update/delete assets…
git:20261015.26c63fd · audit A · 59 stars
huawei-cloud-cloudrobo-data-pipeline SKILL.md skill
huaweicloud/huaweicloud-skills · skills/ai/cloudrobo/huawei-cloud-cloudrobo-data-pipeline/SKILL.md · Guide users to create or revise custom CloudRobo pipelines from natural-language requirements, generating validated…
git:20261104.9745123 · audit A · 59 stars
huawei-cloud-cloudrobo-dataset SKILL.md skill
huaweicloud/huaweicloud-skills · skills/ai/cloudrobo/huawei-cloud-cloudrobo-dataset/SKILL.md · Manage CloudRobo data processing (proc-tasks) and data evaluation (eval-tasks) — query algorithms…
git:20260911.a9d944c · audit A · 59 stars
huawei-cloud-cloudrobo-dispatch SKILL.md skill
huaweicloud/huaweicloud-skills · skills/ai/cloudrobo/huawei-cloud-cloudrobo-dispatch/SKILL.md · Manage CloudRobo embodied-agent task dispatch (robo-dispatcher) — create embodied tasks that drive a robot via an…
git:20260908.11bbb39 · audit A · 59 stars
huawei-cloud-cloudrobo-infer SKILL.md skill
huaweicloud/huaweicloud-skills · skills/ai/cloudrobo/huawei-cloud-cloudrobo-infer/SKILL.md · Manage CloudRobo inference services — deploy a model into a managed inference service, list/query deployed services and…
git:20260908.a9743de · audit A · 59 stars
huawei-cloud-cloudrobo-inference-adapter SKILL.md skill
huaweicloud/huaweicloud-skills · skills/ai/cloudrobo/huawei-cloud-cloudrobo-inference-adapter/SKILL.md · Guides adapting a VLA model's inference server interface to the CloudRobo standard interface/protocol. Use this skill…
git:20261103.c6aca33 · audit A · 59 stars
huawei-cloud-cloudrobo-model-adapt-workflow SKILL.md skill
huaweicloud/huaweicloud-skills · skills/ai/cloudrobo/huawei-cloud-cloudrobo-model-adapt-workflow/SKILL.md · One-stop workflow for adapting models on the CloudRobo platform. Chains 4 sub-skills…
git:20261105.21cb5db · audit A · 59 stars
huawei-cloud-cloudrobo-model-workflow SKILL.md skill
huaweicloud/huaweicloud-skills · skills/ai/cloudrobo/huawei-cloud-cloudrobo-model-workflow/SKILL.md · Model development orchestration Skill covering asset query, model training, inference deployment, and real-robot…
git:20260910.c97166f · audit A · 59 stars
huawei-cloud-cloudrobo-npu-patcher SKILL.md skill
huaweicloud/huaweicloud-skills · skills/ai/cloudrobo/huawei-cloud-cloudrobo-npu-patcher/SKILL.md · Applies to adapting PyTorch-framework VLA models to Ascend NPU, fixing CUDA issues, or optimizing NPU performance…
git:20261104.1443652 · audit A · 59 stars

Every file in huaweicloud/huaweicloud-skills

Browse by kind, by grade A, or by owner.