Data Inspect

# Skill: Data Inspect

## Purpose
Show the active dataset's schema — tables, columns, row counts, and relationships. Optionally drill into a specific table.

## When to Use
Invoke as `/data` to see the full schema summary, or `/data {table}` to see column details for a specific table.

## Instructions

### Mode 1: `/data` (full schema overview)

1. Read `.knowledge/active.yaml` to get the active dataset
2. Read `.knowledge/datasets/{active}/schema.md`
3. Display a condensed summary:

```
Active Dataset: {display_name}
Connection: {type} ({database}.{schema})

Tables:
  users          ~50,000 rows   8 columns   user_id (PK)
  products           500 rows   7 columns   product_id (PK)
  events        ~6.5M rows     9 columns   event_id (PK)
  sessions       ~1.4M rows    8 columns   session_id (PK)
  orders        ~30-50K rows   6 columns   order_id (PK)
  order_items         — rows   4 columns   order_id + product_id
  memberships         — rows   4 columns   user_id
  support_tickets ~20K rows    7 columns   ticket_id (PK)
  nps_responses   ~8K rows     5 columns   user_id
  experiment_assignments ~20K  4 columns   user_id + experiment_id
  promotions          5 rows   7 columns   promo_id (PK)
  experiments         2 rows   8 columns   experiment_id (PK)
  calendar          366 rows   4 columns   date (PK)

Use `/data {table}` for column details.
```

### Mode 2: `/data {table}` (table detail)

1. Read `.knowledge/datasets/{active}/schema.md`
2. Find the section for the requested table
3. Display the full column listing with types and descriptions
4. Show key relationships (FKs to/from this table)

### Mode 3: No active dataset

If `.knowledge/active.yaml` has no `active_dataset` or the brain doesn't exist:
- Display: "No active dataset. Run `/connect-data` to connect one, or `/datasets` to see available options."

## Anti-Patterns

1. **Never query the database just to show schema** — read from the cached schema.md file for speed
2. **Never show the full schema.md raw** — always format into the condensed table view