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

0•

数据库管理

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

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.

主要功能

010 GitHub stars

02Query custom field metadata and tenant-specific field definitions

03Format SQL query results into structured tables with key field highlighting

04Lookup standard business objects by name or object_code

05Retrieve business event (MQ) and message forwarding configurations

06Monitor plugin center statistics, including tenant counts and workflows

使用场景

01Mapping human-readable manufacturing entity names to system-level object_codes

02Auditing custom fields and plugin status across different tenant organizations

03Generating SQL insertion templates for business event field configurations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill