chat-bi

Use when Codex or another agent needs to summarize the currently connected ChatBI business database, list queryable tables or views, explain what each table contains, show row counts, fields, semantic metrics, dimensions, aliases, or answer questions like 当前数据库有哪些表可以查, 数据库概览, 业务库结构, 表清单, schema 概述.

Use when Codex or another agent needs to answer Chinese natural-language data questions against the local ChatBI demo MySQL database, map business terms to governed metrics and dimensions, generate safe read-only SQL, execute metric queries, or return JSON/table results for sales, revenue, gross margin, target achievement, customer, retention, region, channel, product, and monthly trend analysis.

Use when Codex or another agent needs to add missing Chinese synonyms, aliases, or business phrasing to the local ChatBI semantic layer, especially when a natural-language query uses a new word that should map to an existing metric or dimension in alias_mapping. Supports safely inserting aliases for governed metrics and dimensions such as 销售额, 毛利, 目标完成率, 客户留存率, 区域, 时间, 部门, 产品类别, 产品名称, 渠道, and 客户类型.

Auto-analysis middleware for uploaded tables. It profiles table rows, proposes metrics for user confirmation, executes accepted metrics with deterministic calculations, and emits frontend-ready analysis proposal/dashboard JSON for charts and dashboards.

BI chart recommendation for ChatBI and analytics workflows. Use when Codex needs to choose chart types and emit frontend-ready chart recommendation JSON from a user's analysis intent, Query Intent JSON, SQL result metadata, or tabular data, especially after natural language to SQL to data pipelines.

Use when the user asks for month-over-month (环比) comparison of business metrics such as sales, gross margin, order count, or customer count. Triggers on phrases like "环比", "上月对比", "月度对比", "和上个月比", "比上月", "月环比". Returns a comparison table with absolute change and percentage change, plus a grouped bar chart plan.

Dashboard auto-orchestration for ChatBI and analytics workflows. Use when Codex needs to generate a dashboard layout and frontend-ready dashboard JSON from multiple chart recommendations, Query Intent JSON objects, SQL result summaries, or BI analysis goals, especially when turning generated charts into a coherent dashboard.

Use when Codex or another agent needs to generate rule-based decision recommendations from the local ChatBI demo database by computing sales, target achievement, gross margin, region, channel, product, and customer retention metrics first, then deriving structured business advice, actions, priorities, and evidence. Use for 决策意见, 经营建议, 管理建议, 下一步动作, and recommendation generation from existing ChatBI data.

Use when Codex or another agent needs to read a user-uploaded CSV or Excel file for ChatBI, validate whether it matches the existing sales_order or customer_profile schema, and return a compact table structure profile for downstream analysis.

Use when Codex or another agent needs to explain a governed metric's business meaning, formula, source table, default dimensions, related fields, or口径 in ChatBI. Trigger for requests such as 指标解释, 口径说明, 销售额怎么算, 毛利率是什么意思, 目标完成率定义, and 指标来源.

Banking ChatBI semantic processing for intelligent BI questions. Use when Codex needs to normalize ambiguous Chinese or bilingual banking business questions into a standard Query Intent JSON by resolving metric synonyms, dimension synonyms, time expressions, missing slots, ambiguity, and downstream Text-to-SQL readiness.