**π€ GITHUB COPILOT: CRITICA### FabrikamMcp - AI Integration Server
- Natural Language Interface: Query business data conversationally
- 10 Consolidated Tools: Optimized for Copilot Studio's 15-tool limit
- Intelligent Defaults: Works without parameters for robust AI interactions
- Real-time Data: Connects to live API for current business information
What is MCP? Think of MCP like a USB-C port for AI applications. Just as USB-C provides a standardized way to connect your devices to various peripherals and accessories, MCP provides a standardized way to connect AI models to different data sources and tools.
The Problem: Traditional AI integrations require:
- Custom development for each AI platform
- Proprietary APIs that lock you into specific vendors
- Complex integration layers that are expensive to maintain
- Starting over when switching AI applications
The MCP Solution: A universal standard that enables:
- β Build once, use everywhere: Your integrations work across different AI platforms
- β Own your context: Switch between AI applications while keeping your business logic
- β Standardized development: Use proven patterns instead of reinventing integration layers
- β Future-proof investments: Open protocol that evolves with the AI ecosystem
MCP servers provide three main types of functionality:
- Examples: API responses, file contents, database queries, document repositories
- In Fabrikam: Customer profiles, order summaries, product catalogs, support ticket details
- Examples: Execute business actions, perform calculations, trigger workflows, update systems
- In Fabrikam: "Get sales analytics", "Check inventory levels", "Find customer orders", "Create support tickets"
- Examples: Business intelligence queries, report generation, customer service scripts
- In Fabrikam: "Analyze quarterly sales performance", "Generate customer summary report", "Draft customer service response"
Our FabrikamMcp service showcases Tools - the most powerful MCP capability for business scenarios:
π Real Business Flow Example:
Executive: "What were our sales last month by region?"
β
Copilot Studio β MCP Protocol β FabrikamMcp β FabrikamApi β Business Database
β
Real business data flows back through standardized protocol
β
AI formats intelligent response: "Last month you generated $67,340 in revenue:
North Region: $34,200 (51%), South Region: $33,140 (49%).
This represents 12% growth vs. previous month..."
Key Business Benefits You'll Experience:
- π Zero custom integration code - MCP handles all the AI connectivity complexity
- π Always current data - Real-time connections to your live business systems
- π― Business-focused tools - Operations teams can query data using natural language
- π Scalable architecture - Add new business capabilities without changing AI configuration
- π Platform flexibility - Same tools work with Copilot Studio, ChatGPT, Claude, and future AI platforms
During demonstrations, you'll experience MCP's business value:
- Ask natural business questions: "Which customer has spent the most?" or "What products are low in stock?"
- Get real-time answers: Data comes directly from your live business systems
- See the AI reasoning: Watch how the AI chooses the right tools and formats business-friendly responses
- Experience the flexibility: Same questions work whether you're using Copilot Studio, web chat, or mobile apps
The Magic: You maintain one MCP integration, but it works across all AI platforms. As new AI technologies emerge, your business logic travels with you.
π Learn More: For complete technical documentation, see the official MCP specification from Anthropic.
ALWAYS use VS Code tasks for servers:
run_task(id: "π Start Both Servers")
NEVER use run_in_terminal for servers:dotnet runcommands break server management
Use separate terminals for commands:run_in_terminal(command: "curl...", isBackground: false)
π Full Rules:COPILOT-SERVER-RULES.mdand.copilot/instructions.md
π¨ MONOREPO STRUCTURE: This is a multi-project .NET solution. See
.github/MONOREPO-GUIDE.mdfor complete development guidance.
π€ GitHub Copilot Notice: This project uses automated CI/CD with GitHub Actions. Every code change triggers testing and deployment. See
.github/copilot-cicd-context.mdfor full pipeline details.
A comprehensive .NET-based business simulation platform designed for Microsoft Copilot demonstrations, partner training, and AI business value showcases. This project simulates Fabrikam, a fictional modular home builder, with realistic business operations and AI-powered tools.
- Accelerate Copilot adoption with realistic SME&C business scenarios
- Enable hands-on AI labs demonstrating tangible business value
- Support partner training with ready-to-deploy environments
- Showcase Model Context Protocol (MCP) integration patterns
β
Live Deployment: https://fabrikam-api-dev-y32g.azurewebsites.net
β
Authentication Complete: 100% success rate with Azure Key Vault RBAC
β
Demo Ready: 7 working demo users across all roles
β
Fully Tested: Automated testing with CI/CD integration
| Resource | Purpose | Status |
|---|---|---|
| π Deploy to Azure | One-click Azure deployment | β Production Ready |
| οΏ½ Workflow Fix | Auto-fix Azure workflows | β Automated Script |
| οΏ½π Documentation Index | Complete documentation guide | β Organized |
| π Authentication Complete | Implementation results | β 100% Success |
| π§ͺ Testing Guide | Automated testing | β Local + Production |
Watch the complete Fabrikam Project demonstration showcasing:
- Customer management and business analytics
- Product catalog and inventory tracking
- Order processing and timeline management
- MCP tool integration with AI assistants
- Real-time business dashboard functionality
πΉ View Demo Video (11 minutes - comprehensive walkthrough)
# π Start both servers from workspace root
.\test.ps1 start
# π§ͺ Test everything (convenient shortcuts available!)
.\test.ps1 -Quick # Root shortcut
# π Check status
.\test.ps1 statusTesting Shortcuts: For convenience, you can use the root-level shortcuts:
.\test.ps1- PowerShell wrapper for the main testing script (Recommended).\test.bat- Batch file wrapper for command prompt users
- API: https://fabrikam-api-dev-y32g.azurewebsites.net
- MCP: wss://fabrikam-mcp-dev-y32g.azurewebsites.net
- Copilot Studio: See Setup Guide
# Run API locally
cd FabrikamApi/src
dotnet run
# Run MCP server locally
cd FabrikamMcp/src
dotnet runTwo integrated services providing complete business functionality:
- Sales Analytics: Order management and revenue tracking ($829K+ in sample data)
- Product Catalog: Modular homes with specifications and inventory tracking
- Customer Management: CRM with order history and support integration
- Asset Management: Images, blueprints, and marketing materials
- Natural Language Interface: Query business data conversationally
- 10 Consolidated Tools: Optimized for Copilot Studio's 15-tool limit
- Intelligent Defaults: Works without parameters for robust AI interactions
- Real-time Data: Connects to live API for current business information
Complete ASP.NET Core Identity implementation with Azure integration:
- JWT Token Management: Secure authentication with access/refresh token lifecycle
- Role-Based Access Control: Admin, Sales, Customer service roles with appropriate permissions
- Azure Key Vault Integration: RBAC-based secrets management with managed identity
- Demo User System: 7 pre-configured users for immediate testing and demonstrations
- Production Deployment: Fully tested in Azure App Service with 100% authentication success rate
π View Authentication Details
Comprehensive sample data for realistic demonstrations:
- 8 Customers: Business and individual buyers across regions
- 45 Products: Modular homes, ADUs, materials with specifications
- 15 Orders: $829,482.50 in sample revenue with regional breakdowns
- 20 Support Tickets: Customer service cases with realistic workflows
- Asset Library: House images, blueprints, and marketing materials
# Health check
curl https://fabrikam-api-dev-y32g.azurewebsites.net/health
# Sales analytics
curl https://fabrikam-api-dev-y32g.azurewebsites.net/api/orders/analytics
# Product inventory
curl https://fabrikam-api-dev-y32g.azurewebsites.net/api/products/inventory# Server status
curl https://fabrikam-mcp-dev-y32g.azurewebsites.net/status
# List available tools
curl https://fabrikam-mcp-dev-y32g.azurewebsites.net/mcp- Copilot Studio Setup - Create your business AI assistant
- Asset Management - Add images, blueprints, and files
- Authentication Implementation - Development workflow and methodology
- Deployment Guide - Azure deployment instructions
Comprehensive documentation is organized in the docs/ directory:
- Demo Ready Summary - Complete 3-minute demo guide
- Copilot Demo Prompts - Business intelligence scenarios
- Quick Demo Prompts - Copy-paste ready prompts
- Deployment Guide - Azure deployment instructions
- Release Guide - Release process and versioning
- Production Testing - Production validation
- Development Workflow - Daily development process
- Testing Strategy - Comprehensive testing approach
- Commit Checklist - Pre-commit validation
- Utility Scripts - Development and testing utilities
- Future Enhancements - Planned features and roadmap
- Visual Assets - Branding and Copilot Studio assets
π Full Navigation: See
docs/README.mdfor complete documentation index
- β API Controllers: All business endpoints implemented and tested
- β MCP Tools: 10 consolidated tools optimized for Copilot Studio
- β Azure Deployment: Both services deployed and accessible
- β Asset Structure: Directory structure ready for house designs and blueprints
- π Content Expansion: Adding product images and architectural drawings
Perfect for demonstrating AI value through natural language business intelligence:
- Sales Performance: "What are our sales numbers this quarter?" β Real revenue data with regional breakdowns and trend analysis
- Business Growth: "Which customers are driving the most revenue?" β Customer ranking with order history and value analysis
- Market Analysis: "How are our different product lines performing?" β Product category revenue and inventory insights
- Inventory Management: "What products need restocking?" β Live stock levels with automated reorder recommendations
- Order Fulfillment: "Show me all pending orders" β Order pipeline with delivery timelines and priority sorting
- Customer Service: "Any urgent support tickets today?" β Priority ticket management with customer context
- Product Information: "Show me our ADU options with specifications" β Complete product catalogs with pricing and availability
- Customer Profiles: "Tell me about our top customers" β Customer analysis with order history and preferences
- Regional Performance: "How are sales performing by region?" β Geographic analysis with market penetration data
The key difference: Instead of learning complex dashboards or SQL queries, users ask business questions in plain English and get real-time answers from live data:
Traditional Approach:
Login β Navigate to Reports β Select Parameters β Run Query β Interpret Results
MCP + AI Approach:
"What were our best-selling products last month?" β Instant intelligent answer
Business Value: Operations teams, executives, and customer service can access business intelligence through conversation, dramatically reducing training time and increasing data accessibility.
This project is designed for demonstrations and training. To extend functionality:
- Fork the repository for your own customizations
- Follow our Development Workflow for daily development
- Add your business scenarios by extending the sample data
- Test with our comprehensive tools - see Testing Strategy
- Follow deployment best practices - see Deployment Guide
For detailed contributing guidelines, see CONTRIBUTING.md.
Fabrikam Modular Homes - Showcasing AI-powered business operations
