npm package: @luquimbo/bi-superpowers
Description: Plugin-first Claude Code toolkit for Power BI, Microsoft Fabric, and Excel workflows powered by official Microsoft MCP servers.
Author: Lucas Sanchez
Latest version: 1.2.1

# BI Agent Superpowers

[![npm version](https://img.shields.io/npm/v/@luquimbo/bi-superpowers)](https://www.npmjs.com/package/@luquimbo/bi-superpowers)
[![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://opensource.org/licenses/MIT)
[![Node.js Version](https://img.shields.io/badge/node-%3E%3D18.0.0-brightgreen)](https://nodejs.org)
[![Power BI](https://img.shields.io/badge/Power%20BI-Ready-F2C811?logo=powerbi)](https://powerbi.microsoft.com)
[![Claude Code](https://img.shields.io/badge/Claude%20Code-plugin-191919)](https://docs.anthropic.com/en/docs/claude-code)

AI-powered toolkit for Power BI, Microsoft Fabric & Excel development. Ships as a native Claude Code plugin with 24 skills, 11 interactive commands, and MCP integration with official Microsoft servers.

**Cross-platform**: Windows + macOS (Power BI Desktop and Excel MCP require Windows).

## Works with

| Platform | How | Status |
|----------|-----|--------|
| **Claude Code** | Native plugin (`--plugin-dir .`) | Full support |
| **[1code.dev](https://1code.dev)** | Uses Claude Code SDK — plugins work automatically | Full support |
| **Claude Desktop** | MCPB extension (`super build-desktop`) | Skills as MCP prompts |

## Quick Start

```bash
# Install globally
npm install -g @luquimbo/bi-superpowers

# Activate your license
super unlock

# Initialize in your project
cd your-bi-project
super kickoff

# Run with the plugin
claude --plugin-dir .
```

### Claude Desktop

```bash
super build-desktop
# Double-click bi-superpowers.mcpb to install in Claude Desktop
# 24 skills available as MCP prompts
```

### Free models via OpenRouter

Using [1code.dev](https://1code.dev) with free AI models? See [docs/openrouter-free-models.md](./docs/openrouter-free-models.md) for setup instructions.

## Plugin Structure

`super kickoff` generates the following in your project:

```
your-project/
├── .claude-plugin/plugin.json    # Plugin manifest
├── .mcp.json                     # Power BI + Fabric MCPs
├── commands/                     # 11 slash commands (interactive wizards)
├── skills/                       # 24 skills (SKILL.md files)
├── config.json                   # User preferences (experience level, language, domain)
└── library/ → symlink            # Snippets, templates, themes
```

## Skills (24)

### Command Skills — 11 Interactive Wizards

| Skill | Purpose | Trigger |
|-------|---------|---------|
| `/project-kickoff` | Analyze and plan BI projects | "new project", "analyze" |
| `/data-model-design` | Interactive star schema builder | "design model" |
| `/dax-doctor` | DAX debugging and optimization | "debug DAX", "fix measure" |
| `/theme-tweaker` | Customize Power BI themes | "customize theme", "colors" |
| `/pbi-connect` | Connect to Power BI Desktop | "connect Power BI" |
| `/rls-design` | Row-level security design | "RLS", "security" |
| `/fabric-scripts` | Microsoft Fabric automation | "Fabric scripts" |
| `/model-documenter` | Semantic model documentation | "document model" |
| `/migration-assistant` | Migration and upgrade wizard | "migrate", "move to Fabric" |
| `/report-layout` | Report page layout planner | "report layout" |
| `/contributions` | Contribution guidelines | "contribute", "PR" |

### Reference Skills — 13 Background Knowledge

| Skill | Purpose | Trigger |
|-------|---------|---------|
| `/dax` | DAX writing best practices | "DAX", "measure" |
| `/power-query` | Power Query / M language | "Power Query", "M code" |
| `/data-modeling` | Star schema theory and patterns | "star schema" |
| `/excel-formulas` | Modern Excel formulas | "XLOOKUP", "Excel formula" |
| `/fast-standard` | FP&A financial modeling (FAST) | "FAST standard" |
| `/query-performance` | Performance optimization | "optimize", "slow" |
| `/data-quality` | Data profiling and validation | "data quality" |
| `/testing-validation` | DAX and data testing workflows | "testing", "test cases" |
| `/governance` | Naming conventions and standards | "naming convention" |
| `/semantic-model` | Semantic model best practices | "TMDL", "DirectLake" |
| `/report-design` | Report design and visualization | "chart type", "IBCS" |
| `/deployment` | CI/CD and deployment patterns | "CI/CD", "pipeline" |
| `/dax-udf` | DAX user-defined functions | "UDF", "DEFINE FUNCTION" |

## MCP Integration

4 official Microsoft MCP servers configured automatically via `.mcp.json`:

| MCP Server | Transport | Platform | Description |
|------------|-----------|----------|-------------|
| `powerbi-remote` | HTTP | Windows, macOS, Linux | Power BI remote operations via Fabric API |
| `fabric-mcp-server` | stdio (`npx`) | Windows, macOS, Linux | Microsoft Fabric automation |
| `powerbi-modeling-mcp` | stdio (local) | Windows only | Local Power BI Desktop modeling |
| `microsoft-learn` | HTTP | Windows, macOS, Linux | Search Microsoft docs, code samples |

> **Note**: `powerbi-modeling-mcp` requires Power BI Desktop (Windows only). `microsoft-learn` is free, requires no authentication, and provides access to the full Microsoft Learn documentation library.

## CLI Commands

| Command | Description |
|---------|-------------|
| `super kickoff` | Generate the Claude Code plugin in your project |
| `super recharge` | Regenerate plugin after editing source skills |
| `super build-desktop` | Build MCPB extension for Claude Desktop |
| `super mcp-setup` | Configure MCP servers |
| `super powers` | Show available skills, snippets, and themes |
| `super unlock` | Activate your license key |
| `super upgrade` | Update to the latest version |
| `super xray <query>` | Search snippets and library content |
| `super checkup [file]` | Validate skill files |
| `super scan` | Show diff between source and generated configs |
| `super sentinel` | Watch for changes and auto-regenerate |
| `super help` | Show help menu |

## Library

The `library/` folder contains reusable assets accessible from your prompts:

```
library/
├── snippets/           # Code patterns
│   ├── dax/            # Time intelligence, CALCULATE, rankings, UDFs
│   ├── power-query/    # Transformations, error handling, API integration
│   ├── excel-formulas/ # Dynamic arrays, lookups, text functions
│   ├── report-design/  # Chart selection, accessibility, layouts
│   └── governance/     # Naming conventions, review checklists
├── templates/          # Project starters (Power BI, Excel, data models)
├── themes/             # Power BI JSON themes (6 themes included)
└── examples/           # Reference implementations
    ├── finance-reporting/
    ├── hr-analytics/
    ├── retail-analytics/
    ├── supply-chain/
    └── marketing-analytics/
```

Use in prompts: *"Using patterns from library/snippets/dax/time-intelligence.md, create a rolling 12-month average measure"*

## Configuration

`config.json` provides context to the AI about your experience level and domain:

```json
{
  "experienceLevel": "intermediate",
  "language": "en",
  "workArea": "finance",
  "powerBIConnection": "desktop"
}
```

## Project Types

| Feature | Desktop (.pbix) | PBIP | Fabric |
|---------|-----------------|------|--------|
| Single file | Yes | No | N/A (cloud) |
| Git-friendly | No | Yes | Yes |
| Code reviews | No | Yes | Yes |
| Works offline | Yes | Yes | No |
| Team collaboration | Limited | Excellent | Excellent |
| AI file access | Via running PBI | Direct file access | Via API |
| CI/CD ready | No | Yes | Yes |

## Repository Structure

```
bi-superpowers/
├── bin/                        # CLI tool and commands
├── src/content/                # Source content (single source of truth)
│   ├── base.md                 # Core AI identity
│   ├── routing.md              # Skill activation logic
│   └── skills/                 # 24 skill definitions
├── library/                    # Reusable assets (snippets, templates, themes)
├── desktop-extension/          # Claude Desktop MCPB template
├── docs/                       # Additional documentation
├── commands/                   # Generated slash commands
├── skills/                     # Generated SKILL.md files
├── .claude-plugin/             # Plugin manifest
├── .mcp.json                   # MCP server configuration
├── config.json                 # AI preferences
└── AGENTS.md                   # AI context and documentation
```

## Development

```bash
npm install
npm run build:plugin    # Generate 11 commands + 24 skills
npm test                # 77 tests
npm run check           # ESLint + Prettier
```

## Resources

- [Claude Code plugins](https://docs.anthropic.com/en/docs/claude-code)
- [Power BI MCP overview](https://learn.microsoft.com/en-us/power-bi/developer/mcp/mcp-servers-overview)
- [Microsoft Fabric MCP](https://github.com/microsoft/mcp/tree/main/servers/Fabric.Mcp.Server)
- [DAX Guide](https://dax.guide)
- [OpenRouter free models](./docs/openrouter-free-models.md)

## Author

**Lucas Sánchez** — BI Consultant with 10+ years delivering Power BI, Excel, and data analytics projects.

Creator of **[Acadevor.com](https://acadevor.com)**, the leading Spanish-speaking community for Business Intelligence professionals.

- [LinkedIn](https://www.linkedin.com/in/luquimbo/)
- [GitHub](https://github.com/luquimbo)
- [Acadevor](https://acadevor.com)

## License

[MIT](./LICENSE)

---

**BI Agent Superpowers** v1.0.0 — AI-powered toolkit for Business Intelligence.