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

0•

Database Management

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

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.

Key Features

01Integrated validation for custom field and business object relationships

02Standardized SQL templates for business objects, events, and button configurations

03Built-in schema exploration tools using DESC and SHOW COLUMNS commands

04Structured data presentation including record counts and key field extraction

050 GitHub stars

06Multi-tenant support with organization-specific (org_id) filtering for custom objects

Use Cases

01Mapping business object names to specific object codes for logic implementation

02Analyzing plugin center deployments to track workflow counts and publishing status

03Auditing custom field metadata and field type configurations across different tenants

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sesiting/siti-claude-marketplace op-db-metadata

For use in Claude.ai and ChatGPT

Download Skill