What problem does it solve? Slow or incorrect 1C:Enterprise queries and DCS (СКД) queries are hard to diagnose without structured tooling. This Skill provides a disciplined workflow for locating query text, inspecting execution context, and optimizing filters, joins, virtual tables, and temporary tables through the Unica MCP server. ## Core Features & Use Cases - Query extraction and context analysis: Locates exact query text with unica.code.search and unica.dcs.info, then inspects modules, callers, and temporary table chains via unica.code.outline and unica.code.graph. - Metadata and standards grounding: Uses unica.meta.info and unica.standards.search to verify registers, indexes, and development-standard query rules before rewriting. - DB-aware diagnostics: Distinguishes PostgreSQL, MS SQL Server, and file-mode evidence models, tying index and lock recommendations to predicates, transactions, and traces. - Use Case: A report built on a data composition schema runs slowly in production. The Skill extracts the DCS query, checks virtual table parameters and temporary table materialization, and proposes one targeted fix at a time backed by trace evidence. ## Quick Start Ask the assistant to analyze and optimize the slow query in a specific 1C module or data composition schema using the Unica MCP tools.
