Skills
.Work. You
Rest

1c-query-opt

Community

Optimize 1C queries for speed

Data & Analytics#indexes#scd#bsl#temporary tables#1c query optimization#virtual tables#join vs subquery
AuthorArman-Kudaibergenov
Version1.0.0
Installs0

System Documentation

What problem does it solve?

The skill helps resolve slow or inefficient 1C:Enterprise query performance by guiding you toward query patterns that better fit the platform’s execution model.

Core Features & Use Cases

  • Optimizes JOIN and subqueries: recommends using JOIN correctly, avoiding N+1 patterns, and replacing problematic joins with temporary tables.
  • Improves virtual table usage: encourages pushing filters into virtual table parameters and preventing unnecessary post-filtering.
  • Stabilizes query shape for the optimizer: suggests expressing composite types, using presentation for display, combining OR conditions carefully, and choosing between ОБЪЕДИНИТЬ and ОБЪЕДИНИТЬ ВСЕ appropriately.
  • Guides temporary-table workflows and indexing: advises extracting to temporary tables first, then joining, with correct INDX/IINDEXATION strategies.

Quick Start

Ask the AI to optimize your slow 1C query by applying temporary tables, correct virtual table filtering, and safe index/UNION patterns without changing the intended business result.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: 1c-query-opt
Download link: https://github.com/Arman-Kudaibergenov/1c-ai-development-kit/archive/main.zip#1c-query-opt

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.