SuperAPI AI Directory

skd-info

General & other

View repository

Updated 10-15 21:50

About this skill

/skd-info — Data Composition Schema analysis

Reads the Template.xml of the Data Composition Schema (DCS) and outputs a compact summary. Replaces the need to read thousands of lines of XML.

Parameters and command

Parameter Description
TemplatePath Path to Template.xml or to the template directory (auto-resolve in Ext/Template.xml)
Mode Analysis mode (by default overview)
Name Name of the dataset (query), fields (fields/calculated/resources/trace), variant (variant), or grouping/field (templates)
Batch Query batch number, 0 = all (query only)
Raw (query only) raw query text in full, without headers/table of contents/batch separators. For export to .sql and return via skd-edit set-query @file
Limit / Offset Pagination (by default 150 lines; -Raw is not truncated)
OutFile Write the result to a file (UTF-8 BOM)
powershell.exe -NoProfile -File "${CLAUDE_SKILL_DIR}/scripts/skd-info.ps1" -TemplatePath "<путь>"

With mode specified:

... -Mode query -Name НоменклатураСЦенами
... -Mode query -Name ДанныеТ13 -Batch 3
... -Mode query -Name ДанныеТ13 -Raw -OutFile query.sql
... -Mode fields -Name КадастроваяСтоимость
... -Mode calculated -Name КоэффициентКи
... -Mode resources -Name СуммаНалога
... -Mode trace -Name "Коэффициент Ки"
... -Mode variant -Name 1
... -Mode templates
... -Mode templates -Name ВидНалоговойБазы

Modes

Mode Without -Name С -Name
overview Schema navigation map + Next hints —
query — Dataset query text (with batch table of contents); -Raw — clean export for editing
fields Map: field names by dataset Field detail: dataset, type, role, format
links All dataset links —
calculated Map: calculated field names Expression + title + constraints
resources Map: resource names (* = grouped formulas) Aggregation formulas by groupings
params Parameters table: type, value, visibility —
variant List of variants Grouping structure + filters + output
templates Map of template bindings (field/group) Template contents: rows, cells, expressions
trace — Full chain: dataset → calculation → resource
full Full summary: overview + query + fields + resources + params + variant —

Pattern: without -Name — map/index, with -Name — detail of a specific element. Mode full combines 6 key modes into a single call.

Typical workflow

  1. overview — understand the structure, see the hints
  2. trace -Name <поле> — learn how a report column is calculated (from header to query in a single call)
  3. query -Name <набор> — view the text of the SQL query
  4. variant -Name <N> — view the groupings and filters of the variant

Query round-trip: query -Name <набор> -Raw -OutFile q.sql → edit q.sql → /skd-edit <tpl> -Operation set-query -Value "@q.sql". Flag -Raw returns the query in full without decorations, so export ↔ return are exact (including multi-packet queries with temporary tables).

Verification

/skd-info <path>                            — overview (точка входа)
/skd-info <path> -Mode trace -Name <field>  — трассировка поля