skills.rest
IngvarConsulting
IngvarConsultingOFFICIAL
Explore all skills by this author →
WebsiteGitHub

query-optimize

Analyzes and optimizes 1C database queries and SKD schemas for improved performance.

140|16|Updated May 2, 2026
Search Tags:#performance#optimization#sql#query#SKD
One-click install
npx skills add https://github.com/IngvarConsulting/unica --skill query-optimize-ingvarconsulting
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: query-optimize
Source: https://github.com/IngvarConsulting/unica/tree/main/plugins/unica/skills/query-optimize
Command: npx skills add https://github.com/IngvarConsulting/unica --skill query-optimize-ingvarconsulting

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill improves the speed and efficiency of 1C:Enterprise queries by optimizing SQL and SKD configurations, reducing bottlenecks and slowdowns.

Core Features & Use Cases

  • Query Inspection and Analysis: Analyze existing queries and suggest improvements to execution plans.
  • Standards and Best Practice Checks: Search for platform-specific query optimization rules.
  • Use Case: A developer wants to accelerate a complex report query. They use this Skill to analyze and fine-tune the SQL statement to reduce execution time.

Quick Start

Use the query optimize to analyze a slow-running 1C query or SKD data schema, then follow the suggestions for improvements.

Frequently Asked Questions about query-optimize

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow SQL queries in 1C:Enterprise?▼

To optimize slow 1C:Enterprise SQL queries, analyze the execution plans and metadata to identify bottlenecks, then apply platform-specific standards to improve performance and accuracy.

How do I tune an SKD schema for faster report generation?▼

Tune an SKD schema by analyzing the data schema configuration for complex virtual tables and temporary data, then applying optimization suggestions to reduce report execution time.

Can I use this to fix performance issues with complex virtual tables in 1C?▼

Yes, it analyzes complex queries involving virtual tables and temporary data in 1C, identifying performance bottlenecks and suggesting improvements based on platform-specific standards.

What is the best way to handle temporary data bottlenecks in 1C database queries?▼

The best way to handle temporary data bottlenecks is to inspect detailed query metadata and review the execution plan to fine-tune the SQL statements and improve data load speeds.

Why does my 1C report query take so long to execute?▼

Your 1C report query may take long due to unoptimized SQL statements or inefficient SKD schemas, requiring detailed execution plan review to identify and resolve performance slowdowns.

Are there limitations when tuning queries that use platform-specific standards in 1C?▼

Limitations arise if the query deviates from 1C platform-specific standards, as optimization relies on inspecting detailed metadata and execution plans to properly handle complex SQL and virtual tables.

Related Skills

Explore More Software Engineering Skills→
EanLeeEanLee

sql-optimization-patterns

Analyze EXPLAIN output and implement indexing strategies for SQL query optimization.

Community
Advanced
nimadorostkarnimadorostkar
25

database-performance

Analyze execution plans and query logs to resolve database latency and throughput issues.

Community
Advanced
kivo360kivo360
1

moai-cc-agents

Create and manage Claude Code sub-agents with structured agent files.

Community
Advanced
GDSDNGDSDN
3

db-explain

Analyze PostgreSQL query plans with EXPLAIN ANALYZE to identify bottlenecks.

Community
Advanced