query-execution

What problem does it solve?

This Skill enables agents to safely validate and execute queries against a 1C database, retrieving necessary data without risking syntax errors or performance issues.

Core Features & Use Cases

• Query Validation: Checks the syntax of 1C queries before execution to prevent errors.
• Data Retrieval: Executes validated queries to fetch data from the 1C database.
• Metadata Inspection: Allows agents to inspect database object structures (tables, fields) to build accurate queries.
• Use Case: An agent needs to find all customers in a specific region. It first uses get_metadata_structure to confirm the customer table and region field names, then validate_query to check the query syntax, and finally execute_query to retrieve the customer list.

Quick Start

Validate and execute the 1C query to select the first 100 documents of type 'SalesOrder'.