How are database queries executed using this skill?

Queries are executed via the exec_sql tool. The skill requires the full SQL statement to be printed before execution to ensure transparency and accuracy.

Which database tables are covered by this skill?

It includes templates for standard_business_object, mq_event, meta_field_config, button_config, custom_field, and plugin_center.

How does the skill format query results?

The skill mandates that results be presented in a structured format, such as a table or list, including a record count, to avoid overwhelming the user with raw JSON data.

What is the primary purpose of the op-db-metadata skill?

It provides Claude with specific SQL templates and logic to query and manage the v3_metadata database, specifically for business objects, custom fields, and system events.

Does it support multi-tenant environments?

Yes, it includes specific filters for org_id to distinguish between preset global objects (org_id = -1) and tenant-specific custom objects.

OP Database Metadata Manager

Name: OP Database Metadata Manager
Author: SeSiTing

bySeSiTing

Gestión de Bases de Datos

Provides specialized SQL query templates for managing and exploring v3_metadata database structures, including business objects and custom fields.

Acerca de

The op-db-metadata skill empowers Claude to interact intelligently with the v3_metadata database by providing pre-defined SQL templates and standardized execution protocols. It facilitates the discovery of object codes, event configurations, button setups, and custom field metadata, ensuring that developers can quickly retrieve and structure database information for multi-tenant environments. By enforcing strict formatting rules and using the exec_sql tool, it streamlines the process of auditing schema configurations and verifying tenant-specific metadata while maintaining clear, readable output.

Características Principales

Integrated validation for custom field and business object relationships
Standardized SQL templates for business objects, events, and button configurations
Built-in schema exploration tools using DESC and SHOW COLUMNS commands
Structured data presentation including record counts and key field extraction
0 GitHub stars
Multi-tenant support with organization-specific (org_id) filtering for custom objects

Casos de Uso

Mapping business object names to specific object codes for logic implementation
Analyzing plugin center deployments to track workflow counts and publishing status
Auditing custom field metadata and field type configurations across different tenants

Acerca de

Características Principales

Integrated validation for custom field and business object relationships
Standardized SQL templates for business objects, events, and button configurations
Built-in schema exploration tools using DESC and SHOW COLUMNS commands
Structured data presentation including record counts and key field extraction
0 GitHub stars
Multi-tenant support with organization-specific (org_id) filtering for custom objects

Casos de Uso

Mapping business object names to specific object codes for logic implementation
Analyzing plugin center deployments to track workflow counts and publishing status
Auditing custom field metadata and field type configurations across different tenants