What database does this skill target?

This skill is specifically designed to query and manage the v3_metadata database within the Black Lake manufacturing software ecosystem.

Can I find the mapping between Chinese names and English object codes?

Yes, the skill includes a comprehensive built-in mapping list for objects like Warehouse (仓库), Material (物料), and Production Orders (生产工单).

Is the output provided as raw JSON?

No, the skill is configured to transform raw database responses into structured tables or lists, making the information much easier to read and act upon.

How are the SQL queries executed?

The skill generates the appropriate SQL based on your intent, prints the statement for transparency, and then uses the exec_sql tool to execute it.

Does it support organization-specific queries?

Yes, many templates include filters for org_id, allowing you to query custom fields and plugins for specific tenant environments.

Black Lake DB Metadata Helper

Name: Black Lake DB Metadata Helper
Author: SeSiTing

bySeSiTing

Database Management

Accesses and queries Black Lake v3_metadata database tables for object codes, events, custom fields, and system configurations.

About

This skill streamlines the process of navigating and querying the Black Lake v3_metadata database by providing specialized SQL templates. It helps developers quickly retrieve essential metadata such as object codes (e.g., Warehouse, Material, BOM), business event configurations, custom field definitions, and plugin center data. By automating the generation and execution of complex SQL queries through the exec_sql tool, it ensures consistency and speed when managing manufacturing execution system (MES) metadata, providing structured outputs instead of raw JSON data.

Key Features

0 GitHub stars
Query custom field metadata and tenant-specific field definitions
Format SQL query results into structured tables with key field highlighting
Lookup standard business objects by name or object_code
Retrieve business event (MQ) and message forwarding configurations
Monitor plugin center statistics, including tenant counts and workflows

Use Cases

Mapping human-readable manufacturing entity names to system-level object_codes
Auditing custom fields and plugin status across different tenant organizations
Generating SQL insertion templates for business event field configurations

About

Key Features

0 GitHub stars
Query custom field metadata and tenant-specific field definitions
Format SQL query results into structured tables with key field highlighting
Lookup standard business objects by name or object_code
Retrieve business event (MQ) and message forwarding configurations
Monitor plugin center statistics, including tenant counts and workflows

Use Cases

Mapping human-readable manufacturing entity names to system-level object_codes
Auditing custom fields and plugin status across different tenant organizations
Generating SQL insertion templates for business event field configurations