Generate Test Data — Генерация тестовых данных

Generate deterministic PostgreSQL INSERT statements from Directum RX .mtd entity definitions.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/dunaevdmitriys-dev/directum-mcp-server --skill generate-test-data-dunaevdmitriys-dev
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Generate Test Data — Генерация тестовых данных
Source: https://github.com/dunaevdmitriys-dev/directum-mcp-server/tree/main/skills/generate-test-data
Command: npx skills add https://github.com/dunaevdmitriys-dev/directum-mcp-server --skill generate-test-data-dunaevdmitriys-dev

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Directum RX projects often require realistic database content for development and testing, but manually creating consistent entities and dependencies is slow and error-prone.

Core Features & Use Cases

  • Generates realistic entity records for any specified Directum RX entity by reading the entity’s .mtd metadata and translating it into PostgreSQL INSERT statements.
  • Resolves dependencies and FK relationships by discovering required related data (including employees by login) before inserting the main entities.
  • Ensures DB-safe insertion rules by using table-verified names, correct discriminator GUIDs, MAX(id)+offset ID allocation (no sequences), and PostgreSQL-correct typing for booleans/nulls.

Example use case: you need 50 Deals with valid discriminator/entityversion/status values and correct foreign keys to existing employees and related entities so you can run integration testing or validate business workflows without rebuilding data from scratch.

Quick Start

Ask the skill to generate 20 Deal records using your provided PostgreSQL connection string, employee login, module path, and distribution strategy.

Frequently Asked Questions about Generate Test Data — Генерация тестовых данных

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

FAQPage Schema
How do I generate test data for Directum RX entities in PostgreSQL?

Generate Directum RX test data by translating .mtd-defined entity structure into deterministic PostgreSQL INSERT statements. The process reads entity metadata and creates realistic records with correct discriminators, required fields, and foreign-key dependencies for QA scenarios.

How does metadata .mtd translation handle foreign keys and discriminators?

Metadata .mtd translation handles foreign keys by discovering required related data, such as employees by login, before inserting main entities. It extracts correct discriminator GUIDs from NameGuid and resolves dependencies to ensure PostgreSQL-safe relational integrity.

Can I populate Directum RX integration testing records without using database sequences?

Yes, you can populate Directum RX integration testing records without sequences by using a MAX(id)+offset ID allocation strategy. This approach generates deterministic PostgreSQL INSERT operations while maintaining correct discriminators and foreign-key dependencies.

What is needed to start inserting realistic Directum RX records into a PostgreSQL database?

To start inserting realistic Directum RX records, you need a PostgreSQL connection string, an employee login, a module path, and a distribution strategy. The generation process uses .mtd metadata to verify table names and ensure DB-safe insertion rules.

What PostgreSQL-specific formatting rules apply when generating Directum RX test data?

PostgreSQL-specific formatting rules for Directum RX test data include uuid casting, proper boolean casing, and correct null formatting. These DB-safe insertion rules ensure valid INSERT statements that respect .mtd-defined entity structures and foreign-key constraints.