biz-schema-exploration

Routes schema metadata questions to catalog tools for listing tables and describing columns.

1|Updated Mar 4, 2026
One-click install
npx skills add https://github.com/MJ-AgentLab/mj-agent --skill biz-schema-exploration-mj-agentlab
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: biz-schema-exploration
Source: https://github.com/MJ-AgentLab/mj-agent/tree/main/src/mj_agent/skills/biz-schema-exploration
Command: npx skills add https://github.com/MJ-AgentLab/mj-agent --skill biz-schema-exploration-mj-agentlab

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Analysts new to the data catalog often ask meta-questions like "what tables exist in biz_dws" or "what columns does table X have". Without guidance, the agent may prematurely write SQL instead of navigating the catalog. This Skill routes such exploratory questions to the catalog recall, table listing, and column description tools so users get structured answers without executing queries. ## Core Features & Use Cases - Table inventory queries: Answers "what tables are in biz_dws" by calling list_biz_tables and summarizing results by table family instead of dumping 60+ raw names. - Single-table column inspection: Answers "what fields does table X have" via describe_biz_table, returning name, type, nullable, and comment per column. - QCM concept overview: Answers "what is QCM and what does it contain" via find_biz_context, summarizing metrics, periods, dimensions, and signal tables with starter question suggestions. - Use Case: A new analyst asks "what can I query in biz_dws?" The Skill lists table families (total tables, per-dimension tables, signal and dimension tables), then invites a follow-up metric question that routes to the analysis skills. ## Quick Start Ask the agent "what tables are available in biz_dws and what columns does the QCM total table have" to get a guided catalog overview.

Frequently Asked Questions about biz-schema-exploration

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I list all tables in a data warehouse schema?▼

Use the list_biz_tables tool to enumerate tables in the biz_dws and biz_dwd schemas. Results are grouped by table family with short comments rather than a raw dump, so large catalogs of 60+ tables stay readable.

How to see column names and types of a database table?▼

Call describe_biz_table with the fully qualified table name such as biz_dws.dws_qcm_day_total. It returns each column's name, data type, nullability, and comment, plus a note on the business concept the table represents.

When should catalog exploration be used instead of writing SQL?▼

Use catalog exploration when the question is about what data exists, such as available tables, columns, or metrics. Once a specific table and metric are identified, switch to the metric-oriented analysis skills that generate and execute SQL.

What is the difference between schema exploration and domain context recall?▼

Schema exploration answers meta-questions about what the catalog contains, driven by curiosity or onboarding. Domain context recall runs before a concrete metric question to fetch the catalog entries needed to write correct SQL.

Why does the agent avoid listing all tables at once?▼

Dumping 60+ table names in one reply is unreadable and wastes tokens. The Skill instead summarizes by table family, such as period-by-metric totals and per-dimension breakdowns, then asks which family or table to expand.