composing-1c-queries

What problem does it solve?

This Skill addresses the complexity and potential errors in writing 1C:Enterprise query language (язык запросов 1С), ensuring accurate and optimized data retrieval from 1C databases.

Core Features & Use Cases

• Query Composition: Generates correct 1C queries based on specified requirements, including structure, table/field naming, joins, grouping, and parameter usage.
• Metadata Verification: Emphasizes the critical need to use get_metadata to confirm object and field names, preventing runtime errors.
• Performance Optimization: Provides guidance on using virtual tables correctly, indexing, and avoiding common pitfalls for efficient query execution.
• Use Case: When an agent needs to retrieve a list of all customers from the 'Customers' catalog who made purchases over $1000 in the last month, this Skill will compose the appropriate ВЫБРАТЬ/ИЗ/ГДЕ query, ensuring correct table and field names are used.

Quick Start

Use the composing-1c-queries skill to generate a 1C query that selects the 'Name' and 'Code' fields from the 'Catalog.Customers' table, filtering for entries where the 'City' field is 'Moscow'.