Copilot Insights

Enterprise analytics dashboard for GitHub Copilot usage, adoption, licensing, and AI model activity. Built with Next.js 16, React 19, TypeScript 6, and PostgreSQL.

Features

Page	Route	Description
Copilot Usage	/metrics	Daily/weekly active users, code completions, chat mode breakdown, model & language analytics
Code Generation	/code-generation	LOC added/deleted by user vs agent, breakdowns by feature, model, and language
Agent Impact	/agents	Agent adoption rate, acceptance rate, code generation comparison, top agent users
Copilot Licensing	/seats	Seat assignments, license utilization, plan distribution (live from GitHub API)
Premium Requests	/premium-requests	Premium model request consumption and budget tracking (live from GitHub API)
Users	/users	Individual user activity, engagement patterns, and feature adoption
Models	/models	AI model enablement status, usage volume, and feature breakdown
Metrics Reference	/reference	Complete metric definitions, calculation formulas, and data sources

Screenshots

Copilot Usage

Daily and weekly active users, code completions, chat requests, and model usage trends.

Code Generation

Lines of code added and deleted across modes, models, and languages.

CLI Impact

GitHub Copilot CLI adoption, session and request volumes, and token consumption.

Copilot Licensing

License utilization, seat costs, and savings opportunities — live from GitHub API.

Premium Requests

Premium model request consumption, quota allocation, and per-user breakdown.

Settings — Configuration

Manage your GitHub connection and enterprise slug.

Settings — Data Sync

Schedule automatic syncs, trigger manual pulls, or upload NDJSON exports.

Architecture

• Frontend: Next.js 16.2 App Router, React 19.2, Tailwind CSS 4.2, Chart.js 4.5
• Backend: Next.js API routes, Drizzle ORM 0.45
• Database: PostgreSQL 18 (star schema — dimensions + fact tables)
• ETL: Custom ingest pipeline with GitHub Copilot Usage Metrics API (v2026-03-10)
• Infrastructure: Azure Container Apps, Azure Database for PostgreSQL, Azure Container Registry, Key Vault

See docs/architecture.md for detailed architecture documentation.

Prerequisites

• Node.js 24+ and npm
• PostgreSQL 18+ (local or cloud)
• GitHub Enterprise Cloud with Copilot enabled
• GitHub Personal Access Token with manage_billing:copilot, read:enterprise, read:org scopes

Quick Start

# 1. Clone the repository
git clone https://github.com/your-org/ghcp-dashboard.git
cd ghcp-dashboard

# 2. Install dependencies
cd app
npm install

# 3. Configure environment
cp .env.example .env
# Edit .env with your database URL and admin password

# 4. Run database migrations
npx drizzle-kit migrate

# 5. Start the development server
npm run dev

Open http://localhost:3000 and navigate to Settings to configure your GitHub token and sync schedule.

Environment Variables

Variable	Required	Description
DATABASE_URL	Yes	PostgreSQL connection string
ADMIN_PASSWORD	Yes	Password for Settings page access (min 8 chars)

The GitHub token, Enterprise slug, and sync interval are configured via the Settings UI and stored in the database.

Deploy to Azure

This project includes Infrastructure as Code (Bicep) for Azure deployment via the Azure Developer CLI.

# Install Azure Developer CLI if needed
# https://learn.microsoft.com/azure/developer/azure-developer-cli/install-azd

# Deploy everything (infrastructure + app)
azd up

# Subsequent deploys (app only)
azd deploy

Resources provisioned:

• Azure Container Apps (0.5 vCPU, 1 GiB, scale 0–3)
• Azure Database for PostgreSQL Flexible Server (B1ms, 32 GB)
• Azure Container Registry (Basic)
• Azure Key Vault (secrets for DB URL, GitHub token, admin password)
• Application Insights + Log Analytics

Project Structure

ghcp-dashboard/
├── app/                          # Next.js application
│   ├── src/
│   │   ├── app/                  # Pages and API routes
│   │   │   ├── api/              # REST API endpoints
│   │   │   ├── metrics/          # Copilot Usage dashboard
│   │   │   ├── code-generation/  # Code generation report
│   │   │   ├── agents/           # Agent impact report
│   │   │   ├── seats/            # Licensing page
│   │   │   ├── premium-requests/ # Premium requests page
│   │   │   ├── users/            # User explorer
│   │   │   ├── models/           # Models & policies
│   │   │   ├── reference/        # Metrics reference
│   │   │   └── settings/         # Configuration & data sync
│   │   ├── components/           # Shared React components
│   │   ├── lib/                  # Database, ETL, utilities
│   │   └── types/                # TypeScript type definitions
│   ├── drizzle/                  # Database migrations
│   ├── public/                   # Static assets
│   ├── Dockerfile                # Multi-stage production build
│   └── package.json
├── infra/                        # Azure Bicep IaC
├── docs/                         # Documentation
└── azure.yaml                    # Azure Developer CLI config

Scripts

npm run dev          # Start dev server
npm run build        # Production build
npm run start        # Start production server
npm run lint         # ESLint check
npm run db:generate  # Generate Drizzle migrations
npm run db:migrate   # Run migrations
npm run db:push      # Push schema to DB
npm run ingest       # Manual data ingest

Data Sync

The dashboard supports two sync modes:

1. Auto-sync: Background sync on a configurable interval (default: every 6 hours). Runs via instrumentation.ts on server startup.
2. Manual sync: Trigger from the Settings → Data Sync page via SSE streaming.

Both modes call the GitHub Copilot Usage Metrics API (v2026-03-10) and transform the data into a star schema for analytics queries.

License

MIT