{"apiVersion":"v1","directorySlug":"wbkjgr-mcp-3bb1a36e6a","title":"Wbkjgr","description":null,"pageUrl":"https://www.mcpbundles.com/skills/wbkjgr-mcp-3bb1a36e6a","connectPath":"importable","connectAction":"import_server","catalogListing":false,"bundleSlug":null,"listingKind":"remote_mcp","kind":"provider","transportUrl":"https://mcp.wbkjgr.com/mcp","hostedMcpUrl":null,"toolCount":22,"toolInventoryStatus":"observed","refreshedAt":"2026-11-03T13:26:00.516172+00:00","registryName":"com.wbkjgr/wbkjgr-mcp-3bb1a36e6a","registryVersion":"2026.11.3","registryEligible":true,"tools":[{"name":"dw_skill_guide","description":"Return the data warehouse MCP usage guide.\n    Call this first for Doris/table/schema questions to learn the read-only rules and the recommended\n    list -> describe -> query workflow before using live Doris tools.","inputSchema":{"type":"object","properties":{}},"logicalName":"dw_skill_guide","displayName":"dw_skill_guide","title":"dw_skill_guide","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"dw_search_schema_docs","description":"Search local data warehouse schema markdown docs.\n    Prefer this before live Doris queries when the user asks about table meaning, fields, schemas, or examples.","inputSchema":{"type":"object","properties":{"layer":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"limit":{"type":"integer","default":10},"query":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"table":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"topic":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"database":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null}}},"logicalName":"dw_search_schema_docs","displayName":"dw_search_schema_docs","title":"dw_search_schema_docs","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"dw_search_sample_sql","description":"Search curated sample SQL snippets by business question.\n    Use this after dw_search_schema_docs when the user needs a safer starting SQL pattern for SCM BI questions.","inputSchema":{"type":"object","required":["query"],"properties":{"limit":{"type":"integer","default":8},"query":{"type":"string"},"max_rows":{"type":"integer","default":20}}},"logicalName":"dw_search_sample_sql","displayName":"dw_search_sample_sql","title":"dw_search_sample_sql","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"dw_get_table_doc","description":"Read one local static schema markdown document by database and table.\n    Use this after dw_search_schema_docs when the model needs the complete table doc or one named section.","inputSchema":{"type":"object","required":["database","table"],"properties":{"table":{"type":"string"},"section":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"database":{"type":"string"},"max_chars":{"type":"integer","default":12000}}},"logicalName":"dw_get_table_doc","displayName":"dw_get_table_doc","title":"dw_get_table_doc","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"list_tools","description":"List all available tools on this MCP server, including their descriptions and arguments.\n    Use this tool to discover what capabilities the AI has.","inputSchema":{"type":"object","properties":{}},"logicalName":"list_tools","displayName":"list_tools","title":"list_tools","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"dw_list_tables","description":"List or search data warehouse tables by database, layer, or keyword.\n    This is read-only and combines live Doris information_schema.TABLES metadata with local static schema docs.\n    Rows with has_doc=true include doc_topic, doc_summary, and doc_source_path for table selection.\n    For deeper schema meaning and field definitions, call dw_search_schema_docs or dw_get_table_doc.","inputSchema":{"type":"object","properties":{"layer":{"anyOf":[{"enum":["ods","dwd","dws","ads","dim","ling_xing"],"type":"string"},{"type":"null"}],"default":null},"limit":{"type":"integer","default":500},"keyword":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"database":{"anyOf":[{"enum":["ods","dwd","dws","ads","dim","ling_xing"],"type":"string"},{"type":"null"}],"default":null},"return_format":{"enum":["markdown","json"],"type":"string","default":"markdown"}}},"logicalName":"dw_list_tables","displayName":"dw_list_tables","title":"dw_list_tables","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"dw_describe_table","description":"Describe a Doris table, including columns, stats, distribution, partition metadata, and optional DDL.\n    This is read-only.\n    Prefer dw_get_table_doc first when static schema documentation is enough; use this for live Doris metadata.","inputSchema":{"type":"object","required":["database","table"],"properties":{"table":{"type":"string"},"database":{"enum":["ods","dwd","dws","ads","dim","ling_xing"],"type":"string"},"show_ddl":{"type":"boolean","default":false},"return_format":{"enum":["markdown","json"],"type":"string","default":"markdown"}}},"logicalName":"dw_describe_table","displayName":"dw_describe_table","title":"dw_describe_table","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"dw_query_doris","description":"Execute one read-only Doris SQL statement.\n    Allowed statements: SELECT, WITH, SHOW, DESCRIBE/DESC, EXPLAIN.\n    Write, DDL, session, load, and file export/import statements are rejected.\n    For table and field discovery, call dw_search_schema_docs before writing live SQL.","inputSchema":{"type":"object","required":["sql"],"properties":{"sql":{"type":"string"},"limit":{"type":"integer","default":1000},"database":{"anyOf":[{"enum":["ods","dwd","dws","ads","dim","ling_xing"],"type":"string"},{"type":"null"}],"default":null},"return_format":{"enum":["markdown","json"],"type":"string","default":"markdown"}}},"logicalName":"dw_query_doris","displayName":"dw_query_doris","title":"dw_query_doris","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"query_inventory_detail","description":"Query detailed inventory data with multi-dimension filtering.\n    Excludes transfer_num and transfer_cost.","inputSchema":{"type":"object","$defs":{"InventoryDetailArgs":{"type":"object","required":["ym"],"properties":{"ym":{"type":"string"},"sku":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"limit":{"type":"integer","default":100},"w_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"channel":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"seller_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null}}}},"required":["args"],"properties":{"args":{"$ref":"#/$defs/InventoryDetailArgs"}}},"logicalName":"query_inventory_detail","displayName":"query_inventory_detail","title":"query_inventory_detail","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"query_inventory_by_sku","description":"Query inventory distribution for a specific SKU across all channels and warehouses.","inputSchema":{"type":"object","$defs":{"InventorySkuArgs":{"type":"object","required":["ym","sku"],"properties":{"ym":{"type":"string"},"sku":{"type":"string"}}}},"required":["args"],"properties":{"args":{"$ref":"#/$defs/InventorySkuArgs"}}},"logicalName":"query_inventory_by_sku","displayName":"query_inventory_by_sku","title":"query_inventory_by_sku","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"query_inventory_summary","description":"Query total inventory summary for a specific month.","inputSchema":{"type":"object","$defs":{"InventoryAggArgs":{"type":"object","required":["ym"],"properties":{"ym":{"type":"string"},"channel":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"seller_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null}}}},"required":["args"],"properties":{"args":{"$ref":"#/$defs/InventoryAggArgs"}}},"logicalName":"query_inventory_summary","displayName":"query_inventory_summary","title":"query_inventory_summary","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"query_inventory_by_channel","description":"Aggregate inventory data by channel.","inputSchema":{"type":"object","$defs":{"InventoryAggArgs":{"type":"object","required":["ym"],"properties":{"ym":{"type":"string"},"channel":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"seller_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null}}}},"required":["args"],"properties":{"args":{"$ref":"#/$defs/InventoryAggArgs"}}},"logicalName":"query_inventory_by_channel","displayName":"query_inventory_by_channel","title":"query_inventory_by_channel","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"query_inventory_by_seller","description":"Aggregate inventory data by seller (store).","inputSchema":{"type":"object","$defs":{"InventoryAggArgs":{"type":"object","required":["ym"],"properties":{"ym":{"type":"string"},"channel":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"seller_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null}}}},"required":["args"],"properties":{"args":{"$ref":"#/$defs/InventoryAggArgs"}}},"logicalName":"query_inventory_by_seller","displayName":"query_inventory_by_seller","title":"query_inventory_by_seller","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"query_inventory_by_warehouse","description":"Aggregate inventory data by warehouse.","inputSchema":{"type":"object","$defs":{"InventoryWarehouseAggArgs":{"type":"object","required":["ym"],"properties":{"ym":{"type":"string"},"channel":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"seller_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null}}}},"required":["args"],"properties":{"args":{"$ref":"#/$defs/InventoryWarehouseAggArgs"}}},"logicalName":"query_inventory_by_warehouse","displayName":"query_inventory_by_warehouse","title":"query_inventory_by_warehouse","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"query_inventory_aging","description":"Analyze inventory aging distribution.","inputSchema":{"type":"object","$defs":{"InventoryAgingArgs":{"type":"object","required":["ym"],"properties":{"ym":{"type":"string"},"channel":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"group_by":{"enum":["total","channel","seller","warehouse"],"type":"string","default":"total"},"seller_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null}}}},"required":["args"],"properties":{"args":{"$ref":"#/$defs/InventoryAgingArgs"}}},"logicalName":"query_inventory_aging","displayName":"query_inventory_aging","title":"query_inventory_aging","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"query_inventory_cost","description":"Analyze inventory cost structure.","inputSchema":{"type":"object","$defs":{"InventoryAgingArgs":{"type":"object","required":["ym"],"properties":{"ym":{"type":"string"},"channel":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"group_by":{"enum":["total","channel","seller","warehouse"],"type":"string","default":"total"},"seller_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null}}}},"required":["args"],"properties":{"args":{"$ref":"#/$defs/InventoryAgingArgs"}}},"logicalName":"query_inventory_cost","displayName":"query_inventory_cost","title":"query_inventory_cost","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"query_inventory_trend","description":"Compare inventory trends across months.","inputSchema":{"type":"object","$defs":{"InventoryTrendArgs":{"type":"object","required":["start_ym","end_ym"],"properties":{"end_ym":{"type":"string"},"channel":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"group_by":{"enum":["total","channel","seller"],"type":"string","default":"total"},"start_ym":{"type":"string"}}}},"required":["args"],"properties":{"args":{"$ref":"#/$defs/InventoryTrendArgs"}}},"logicalName":"query_inventory_trend","displayName":"query_inventory_trend","title":"query_inventory_trend","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"query_inventory_aging_detail","description":"Query detailed SKU list for a specific aging segment (e.g., to find slow-moving stock).","inputSchema":{"type":"object","$defs":{"InventoryAgingDetailArgs":{"type":"object","required":["ym","aging_segment"],"properties":{"ym":{"type":"string"},"limit":{"type":"integer","default":100},"channel":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"min_qty":{"type":"integer","default":0},"aging_segment":{"enum":["age_0_30","age_31_60","age_61_90","age_91_180","age_181_270","age_271_365","age_366"],"type":"string"}}}},"required":["args"],"properties":{"args":{"$ref":"#/$defs/InventoryAgingDetailArgs"}}},"logicalName":"query_inventory_aging_detail","displayName":"query_inventory_aging_detail","title":"query_inventory_aging_detail","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"query_product_data","description":"Query product data from dim.dim_product.\n    Mandatory filter: org_id = 1.\n    Supports filtering by SKU (fuzzy match), product name, category, brand, and status.","inputSchema":{"type":"object","$defs":{"ProductQueryArgs":{"type":"object","properties":{"sku":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"limit":{"type":"integer","default":100},"status":{"anyOf":[{"type":"integer"},{"type":"null"}],"default":null},"brand_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"product_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"category_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null}}}},"required":["args"],"properties":{"args":{"$ref":"#/$defs/ProductQueryArgs"}}},"logicalName":"query_product_data","displayName":"query_product_data","title":"query_product_data","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"query_order_detail","description":"查询订单明细数据，支持多维度过滤（SKU、国家、平台、店铺、仓库等）、字段选择、排序和分页。","inputSchema":{"type":"object","required":["start_date","end_date"],"properties":{"sku":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"spu":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"msku":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"limit":{"type":"integer","default":100},"fields":{"anyOf":[{"type":"array","items":{"type":"string"}},{"type":"null"}],"default":null},"offset":{"type":"integer","default":0},"w_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"channel":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"end_date":{"type":"string"},"order_by":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"store_id":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"start_date":{"type":"string"},"store_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"country_code":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"order_status":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"product_line":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"delivery_type":{"anyOf":[{"type":"integer"},{"type":"null"}],"default":null},"platform_code":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"product_level":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"order_direction":{"enum":["ASC","DESC"],"type":"string","default":"DESC"}}},"logicalName":"query_order_detail","displayName":"query_order_detail","title":"query_order_detail","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"query_order_summary","description":"按指定维度汇总统计销量和销售额数据。用于分析销售表现、找出热销产品、按地区/平台/店铺等维度进行销售分析。","inputSchema":{"type":"object","required":["start_date","end_date"],"properties":{"sku":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"spu":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"msku":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"limit":{"anyOf":[{"type":"integer"},{"type":"null"}],"default":100},"fields":{"anyOf":[{"type":"array","items":{"type":"string"}},{"type":"null"}],"default":null},"offset":{"type":"integer","default":0},"w_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"channel":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"agg_type":{"anyOf":[{"enum":["sum","avg","max","min","count","count_distinct","stddev","variance","stddev_samp","var_samp","stddev_pop","var_pop","any_value","quartile_25","median","quartile_75"],"type":"string"},{"type":"null"}],"default":null},"end_date":{"type":"string"},"order_by":{"anyOf":[{"type":"string"},{"type":"null"}],"default":"volume"},"store_id":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"start_date":{"type":"string"},"store_name":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"country_code":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"order_status":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"product_line":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"delivery_type":{"anyOf":[{"type":"integer"},{"type":"null"}],"default":null},"platform_code":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"product_level":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"group_by_fields":{"anyOf":[{"type":"array","items":{"type":"string"}},{"type":"null"}],"default":[]},"order_direction":{"enum":["ASC","DESC"],"type":"string","default":"DESC"}}},"logicalName":"query_order_summary","displayName":"query_order_summary","title":"query_order_summary","annotations":{"untrustedContentHint":true,"readOnlyHint":true}},{"name":"dw_search_context","description":"Unified data-warehouse context entry point.\n    Maps a natural-language question to candidate tables, columns, curated SQL fragments and\n    evidence, using OpenMetadata (semantic + keyword + entity details) as an enrichment source on\n    top of local schema-doc retrieval. OpenMetadata failures degrade gracefully into warnings.","inputSchema":{"type":"object","required":["question"],"properties":{"domain":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"question":{"type":"string"},"user_role":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null},"max_tables":{"type":"integer","default":8},"return_format":{"enum":["json","markdown"],"type":"string","default":"json"},"include_lineage":{"type":"boolean","default":false},"include_sql_fragments":{"type":"boolean","default":true}}},"logicalName":"dw_search_context","displayName":"dw_search_context","title":"dw_search_context","annotations":{"untrustedContentHint":true,"readOnlyHint":true}}],"toolSource":"directory_preview","agentAction":"both","installLinks":[{"id":"cursor","label":"Cursor","href":"cursor://anysphere.cursor-deeplink/mcp/install?name=Wbkjgr&config=eyJ1cmwiOiAiaHR0cHM6Ly9tY3Aud2JramdyLmNvbS9tY3AifQ%3D%3D"},{"id":"vscode","label":"VS Code","href":"vscode:mcp/install?%7B%22name%22%3A%22Wbkjgr%22%2C%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.wbkjgr.com%2Fmcp%22%7D"},{"id":"vscode-insiders","label":"VS Code Insiders","href":"vscode-insiders:mcp/install?%7B%22name%22%3A%22Wbkjgr%22%2C%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.wbkjgr.com%2Fmcp%22%7D"},{"id":"claude-web","label":"Claude.ai","href":"https://claude.ai/customize/connectors?modal=add-custom-connector&connectorName=Wbkjgr&connectorUrl=https%3A%2F%2Fmcp.wbkjgr.com%2Fmcp"},{"id":"codex","label":"Codex","copyText":"codex mcp add \"Wbkjgr\" --url \"https://mcp.wbkjgr.com/mcp\""},{"id":"chatgpt","label":"ChatGPT","href":"https://www.mcpbundles.com/docs/integrations/chatgpt"}],"catalogUrl":"https://www.mcpbundles.com/api/directory/v1/servers/wbkjgr-mcp-3bb1a36e6a","callUrl":"https://www.mcpbundles.com/api/directory/v1/servers/wbkjgr-mcp-3bb1a36e6a/tools/{tool}","mcpServerUrl":"https://mcp.wbkjgr.com/mcp","liveCatalogUrl":"https://www.mcpbundles.com/api/directory/v1/servers/wbkjgr-mcp-3bb1a36e6a?live=1"}