I_-_Backend_Endpoints_for_Real_Analytics_Data
OC Pipeline - Construction Project Management System
Install / Use
npx skills add ALPA-Const/oc-pipelineInstalls into whichever agent you are using.
Cursor Rules
Cursor IDE rules (v2)
Quality Score
Category
AutomationSupported Platforms
Tags
Our assessment of I_-_Backend_Endpoints_for_Real_Analytics_Data
I_-_Backend_Endpoints_for_Real_Analytics_Data scores 55/100 on our quality scale, 2684th of 2,769 Automation skills we index.
Its Cursor Rules is 20 KB long, split into 5 sections and no code examples: a thorough specification that gives an agent plenty to work with.
It has no GitHub stars yet, so there is no community track record; judge it on its content.
Maintenance, license and trust
- We could not determine when the repository was last updated.
- Our last check on 2026-11-12 found the source still online.
- No license is declared. By default that means all rights are reserved: you can read it, but reusing or redistributing it is not clearly permitted. Ask the author before building on it commercially.
- Its trust signals score 68/100, with 3 cautions from licensing, adoption, age or documentation. These come from repository metadata, not a code audit — read the skill file before letting an agent act on it.
Safety scan
No issues foundOur scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful.
AI review by kimi-k2.7-code on 2026-10-02. Automated pattern scan on 2026-10-02. It catches known dangerous patterns, not every risk — read a skill before letting an agent act on it.
I_-_Backend_Endpoints_for_Real_Analytics_Data compared with similar skills
All 4 of these similar skills score higher than I_-_Backend_Endpoints_for_Real_Analytics_Data; compare them before choosing.
| Skill | Score | Stars | Updated | Format |
|---|---|---|---|---|
| I_-_Backend_Endpoints_for_Real_Analytics_Data (this skill)by ALPA-Const | 55 | 0 | — | Cursor Rules |
| Agent-Reachby Panniantong | 100 | 112.7k | 9d ago | CLAUDE.md |
| rufloby ruvnet | 100 | 82.0k | today | CLAUDE.md |
| Claude-Code-Game-Studiosby Donchitos | 100 | 39.9k | 8d ago | CLAUDE.md |
| Scraplingby D4Vinci | 100 | 103.9k | today | MCP Server |
Frequently asked questions
- How do I install I_-_Backend_Endpoints_for_Real_Analytics_Data?
- Run
npx skills add ALPA-Const/oc-pipeline. The install tabs above show the steps for each supported agent. - Which AI agents does I_-_Backend_Endpoints_for_Real_Analytics_Data work with?
- It is written for Cursor, as a Cursor Rules file. Other agents that read the same format can often use it too.
- Is I_-_Backend_Endpoints_for_Real_Analytics_Data safe to use?
- Our scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful. It declares no license and scores 68/100 on trust signals. Skills are instructions an agent will follow, so read the file before installing it and do not approve commands you do not understand.
- Is I_-_Backend_Endpoints_for_Real_Analytics_Data still maintained?
- We could not determine when the repository was last updated.
Skill content
View source on GitHubBackend Endpoints for Real Analytics Data
1. Dashboard Analytics Routes
// backend/src/routes/dashboard.routes.ts
import { Router, Request, Response } from 'express';
import { authenticate } from '../middleware/auth';
import { requirePermission } from '../middleware/permissions';
import { DashboardController } from '../controllers/dashboard.controller';
const router = Router();
const dashboardController = new DashboardController();
// Metrics endpoints
router.get(
'/metrics',
authenticate,
requirePermission('view_dashboard'),
(req, res) => dashboardController.getMetrics(req, res)
);
router.get(
'/metrics/budget',
authenticate,
requirePermission('view_dashboard'),
(req, res) => dashboardController.getBudgetMetrics(req, res)
);
router.get(
'/metrics/schedule',
authenticate,
requirePermission('view_dashboard'),
(req, res) => dashboardController.getScheduleMetrics(req, res)
);
router.get(
'/metrics/risk',
authenticate,
requirePermission('view_dashboard'),
(req, res) => dashboardController.getRiskMetrics(req, res)
);
// Analytics endpoints
router.get(
'/analytics/budget-trend',
authenticate,
requirePermission('view_dashboard'),
(req, res) => dashboardController.getBudgetTrend(req, res)
);
router.get(
'/analytics/project-performance',
authenticate,
requirePermission('view_dashboard'),
(req, res) => dashboardController.getProjectPerformance(req, res)
);
router.get(
'/analytics/win-loss',
authenticate,
requirePermission('view_dashboard'),
(req, res) => dashboardController.getWinLossAnalytics(req, res)
);
// Alerts endpoint
router.get(
'/alerts',
authenticate,
requirePermission('view_dashboard'),
(req, res) => dashboardController.getAlerts(req, res)
);
// Projects endpoint
router.get(
'/projects',
authenticate,
requirePermission('view_projects'),
(req, res) => dashboardController.getProjects(req, res)
);
export default router;
2. Dashboard Controller
// backend/src/controllers/dashboard.controller.ts
import { Request, Response } from 'express';
import { supabase } from '../config/supabase';
import { calculateVariance, formatCurrency } from '../utils/calculations';
export class DashboardController {
async getMetrics(req: Request, res: Response) {
try {
const orgId = req.user?.org_id;
// Get budget metrics
const budgetResult = await supabase
.from('budgets')
.select('budget_amount, spent_amount')
.eq('org_id', orgId)
.eq('status', 'active');
// Get schedule metrics
const scheduleResult = await supabase
.from('schedules')
.select('baseline_duration, actual_duration, status')
.eq('org_id', orgId);
// Get risk metrics
const riskResult = await supabase
.from('risks')
.select('probability, impact, status')
.eq('org_id', orgId)
.eq('status', 'active');
// Get project count
const projectResult = await supabase
.from('projects')
.select('id')
.eq('org_id', orgId);
const budgets = budgetResult.data || [];
const schedules = scheduleResult.data || [];
const risks = riskResult.data || [];
const projects = projectResult.data || [];
// Calculate aggregates
const totalBudget = budgets.reduce((sum, b) => sum + (b.budget_amount || 0), 0);
const totalSpent = budgets.reduce((sum, b) => sum + (b.spent_amount || 0), 0);
const budgetVariance = calculateVariance(totalBudget, totalSpent);
const onTimeProjects = schedules.filter(
(s) => !s.actual_duration || s.actual_duration <= s.baseline_duration
).length;
const scheduleAdherence = schedules.length > 0
? (onTimeProjects / schedules.length) * 100
: 0;
const activeRisks = risks.filter((r) => r.status === 'active').length;
const avgRiskScore = risks.length > 0
? risks.reduce((sum, r) => sum + (r.probability * r.impact), 0) / risks.length
: 0;
res.json({
success: true,
data: {
budget: {
total: formatCurrency(totalBudget),
spent: formatCurrency(totalSpent),
variance: budgetVariance,
percentSpent: totalBudget > 0 ? (totalSpent / totalBudget) * 100 : 0,
},
schedule: {
onTimePercentage: scheduleAdherence,
totalProjects: projects.length,
atRiskProjects: schedules.filter((s) => s.actual_duration > s.baseline_duration).length,
},
risk: {
activeRisks,
averageScore: avgRiskScore,
highRisks: risks.filter((r) => r.probability * r.impact > 15).length,
},
projects: {
total: projects.length,
active: projects.length, // Adjust based on actual status field
},
},
});
} catch (error) {
res.status(500).json({ success: false, error: error.message });
}
}
async getBudgetMetrics(req: Request, res: Response) {
try {
const orgId = req.user?.org_id;
const { projectId } = req.query;
let query = supabase
.from('budgets')
.select('id, project_id, budget_amount, spent_amount, forecasted_amount, status')
.eq('org_id', orgId);
if (projectId) {
query = query.eq('project_id', projectId);
}
const result = await query;
const budgets = result.data || [];
const metrics = {
totalBudget: budgets.reduce((sum, b) => sum + (b.budget_amount || 0), 0),
totalSpent: budgets.reduce((sum, b) => sum + (b.spent_amount || 0), 0),
totalForecasted: budgets.reduce((sum, b) => sum + (b.forecasted_amount || 0), 0),
byProject: budgets.map((b) => ({
projectId: b.project_id,
budget: b.budget_amount,
spent: b.spent_amount,
forecasted: b.forecasted_amount,
variance: calculateVariance(b.budget_amount, b.spent_amount),
percentSpent: b.budget_amount > 0 ? (b.spent_amount / b.budget_amount) * 100 : 0,
})),
};
res.json({ success: true, data: metrics });
} catch (error) {
res.status(500).json({ success: false, error: error.message });
}
}
async getScheduleMetrics(req: Request, res: Response) {
try {
const orgId = req.user?.org_id;
const result = await supabase
.from('schedules')
.select(
'id, project_id, baseline_duration, actual_duration, status, start_date, end_date'
)
.eq('org_id', orgId);
const schedules = result.data || [];
const metrics = {
totalProjects: schedules.length,
onTimeProjects: schedules.filter(
(s) => !s.actual_duration || s.actual_duration <= s.baseline_duration
).length,
delayedProjects: schedules.filter(
(s) => s.actual_duration && s.actual_duration > s.baseline_duration
).length,
scheduleAdherence: schedules.length > 0
? (schedules.filter(
(s) => !s.actual_duration || s.actual_duration <= s.baseline_duration
).length / schedules.length) * 100
: 0,
byProject: schedules.map((s) => ({
projectId: s.project_id,
baseline: s.baseline_duration,
actual: s.actual_duration,
variance: s.actual_duration ? s.actual_duration - s.baseline_duration : 0,
status: s.status,
})),
};
res.json({ success: true, data: metrics });
} catch (error) {
res.status(500).json({ success: false, error: error.message });
}
}
async getRiskMetrics(req: Request, res: Response) {
try {
const orgId = req.user?.org_id;
const result = await supabase
.from('risks')
.select('id, project_id, probability, impact, status, mitigation_status')
.eq('org_id', orgId);
const risks = result.data || [];
const activeRisks = risks.filter((r) => r.status === 'active');
const mitigatedRisks = risks.filter((r) => r.mitigation_status === 'mitigated');
const metrics = {
totalRisks: risks.length,
activeRisks: activeRisks.length,
mitigatedRisks: mitigatedRisks.length,
highRisks: activeRisks.filter((r) => r.probability * r.impact > 15).length,
mediumRisks: activeRisks.filter(
(r) => r.probability * r.impact > 8 && r.probability * r.impact <= 15
).length,
lowRisks: activeRisks.filter((r) => r.probability * r.impact <= 8).length,
averageRiskScore: activeRisks.length > 0
? activeRisks.reduce((sum, r) => sum + r.probability * r.impact, 0) / activeRisks.length
: 0,
};
res.json({ success: true, data: metrics });
} catch (error) {
res.status(500).json({ success: false, error: error.message });
}
}
async getBudgetTrend(req: Request, res: Response) {
try {
const orgId = req.user?.org_id;
const { months = 12 } = req.query;
const result = await supabase
.from('budget_history')
.select('month, budget_amount, spent_amount, forecasted_amount')
.eq('org_id', orgId)
.order('month', { ascending: true })
.limit(parseInt(months as string));
const history = result.data || [];
const trendData = history.map((h) => ({
month: new Date(h.month).toLocaleDateString('en-US', { month: 'short' }),
budget: h.budget_amount,
actual: h.spent_amount,
forecast: h.forecasted_amount,
}));
res.json({ success: true, data: trendData });
} catch (error) {
res.status(500).json({ success: false, error: error.message });
}
}
async getProjectPerformance(req: Request, res: Response) {
try {
const orgId = req.user?.org_id;
const result = await supabase
.from('projects')
.select(
`
id,
name,
status,
budgets(budget_amount, spent_amount),
schedules(baseline_duration, actual_duration),
risks(id, status)
`
)
.eq('org_id', orgId);
const projects = result.data || [];
const performanceData = projects.map((p) => {
const budget = p.budgets?.[0];
const schedule = p.schedules?.[0];
const risks = p.risks || [];
return {
id: p.id,
name: p.name,
status: p.status,
budgetHealth:
budget && budget.budget_amount > 0
? ((budget.spent_amount / budget.budget_amount) * 100).toFixed(1)
: 'N/A',
scheduleHealth:
schedule && schedule.baseline_duration > 0
? ((schedule.actual_duration / schedule.baseline_duration) * 100).toFixed(1)
Truncated for display — read the full file on GitHub.
Related Skills
Agent-Reach
112.7kGive your AI agent eyes to see the entire internet. Read & search Twitter, Reddit, YouTube, GitHub, Bilibili, XiaoHongShu — one CLI, zero API fees.
ruflo
82.0k🌊 The original agent harness. Deploy intelligent multi-player swarms, coordinate autonomous workflows, and build conversational AI systems. Features adaptive memory, self-learning intelligence, federation, vector RAG integration, and native Claude Code / Codex / Hermes and many more Integrated
Claude-Code-Game-Studios
39.9kTurn Claude Code into a full game dev studio — 49 AI agents, 75 workflow skills, and a complete coordination system mirroring real studio hierarchy.
Scrapling
103.9k🕷️ The BEST Web Scraping framework that handles everything from a single request to a full-scale crawl! Don't be shy, join here: https://discord.gg/EMgGbDceNQ and follow here for daily tips and tricks: https://x.com/Scrapling_dev
Trust signals
From repository metadata: license, adoption, age and documentation. Not a code audit — see the Safety scan above for what the skill file itself contains.
