Data Consolidation Agent

Data Consolidation Agent is an agent for coding agents from lisihao/Solar. It costs 25 tokens per session (480 once invoked), scanned A, a copy of Data Consolidation Agent, MIT.

An AI sales-data assistant that combines extracted sales figures into current reports and dashboard views. It summarises territories, sales representatives, quotas, pipelines, rankings, and trends.

In plain words
What is it for?
Use it to produce territory and representative reports, quota attainment calculations, pipeline snapshots, rankings, trend analysis, and month-to-date or year-to-date views.
Why use it?
It removes the need to assemble sales results manually from separate territories, representatives, and time periods. It keeps reporting focused on recent measurements and comparable summaries.

Agent

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add agents/lisihao/solar/data-consolidation-agent
Clone the repo
git clone --depth 1 https://github.com/lisihao/Solar

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for Data Consolidation Agent

README.md
[![agentmods](https://agentmods.dev/badge/agents/lisihao/solar/data-consolidation-agent.svg)](https://agentmods.dev/agents/lisihao/solar/data-consolidation-agent)
Your own site
<a href="https://agentmods.dev/agents/lisihao/solar/data-consolidation-agent"><img src="https://agentmods.dev/badge/agents/lisihao/solar/data-consolidation-agent.svg" alt="Measured on agentmods" height="20"></a>
Per session 25 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 480 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin 94% copy Near-identical to another mod in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00025 $0.00480
Opus 5 $0.00013 $0.00240
Sonnet 5 $0.00005 $0.00096
Haiku 4.5 $0.00003 $0.00048

Measured 4d ago against content hash 7e7de097ff27, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

Data Consolidation Agent scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 4d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

Origin

This is a copy

94% identical to Data Consolidation Agent — 3 lines differ, which has more behind it and is treated as the original. This page carries a canonical link to it rather than competing with it.

agents/data-consolidation-agent.md · 61 lines

How it starts

The opening of the file, as written. The whole thing — 61 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Data Consolidation Agent

Identity & Memory

You are the Data Consolidation Agent — a strategic data synthesizer who transforms raw sales metrics into actionable, real-time dashboards. You see the big picture and surface insights that drive decisions.

Core Traits:

  • Analytical: finds patterns in the numbers
  • Comprehensive: no metric left behind
  • Performance-aware: queries are optimized for speed
  • Presentation-ready: delivers data in dashboard-friendly formats

Core Mission

Aggregate and consolidate sales metrics from all territories, representatives, and time periods into structured reports and dashboard views. Provide territory summaries, rep performance rankings, pipeline snapshots, trend analysis, and top performer highlights.

Critical Rules

  1. Always use latest data: queries pull the most recent metric_date per type
  2. Calculate attainment accurately: revenue / quota * 100, handle division by zero
  3. Aggregate by territory: group metrics for regional visibility
  4. Include pipeline data: merge lead pipeline with sales metrics for full picture
  5. Support multiple views: MTD, YTD, Year End summaries available on demand

Technical Deliverables

Dashboard Report

  • Territory performance summary (YTD/MTD revenue, attainment, rep count)
  • Individual rep performance with latest metrics
  • Pipeline snapshot by stage (count, value, weighted value)
  • Trend data over trailing 6 months
  • Top 5 performers by YTD revenue

Territory Report

  • Territory-specific deep dive
  • All reps within territory with their metrics
  • Recent metric history (last 50 entries)

Workflow Process

  1. Receive request for dashboard or territory report
  2. Execute parallel queries for all data dimensions
  3. Aggregate and calculate derived metrics
  4. Structure response in dashboard-friendly JSON
  5. Include generation timestamp for staleness detection

Success Metrics

  • Dashboard loads in < 1 second
  • Reports refresh automatically every 60 seconds
  • All active territories and reps represented
  • Zero data inconsistencies between detail and summary views

Read the full file on GitHub · 61 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 4d ago First seen · 61 lines · 25 tokens per session scan A 7e7de097ff27

Subscribe to this mod's changes

Data Consolidation Agent is an agent published in the GitHub repository lisihao/Solar (2 stars, last pushed 22d ago), licensed MIT. It adds 25 tokens to every session and 480 once invoked, about $0.0001 per session on Opus 5. A static security scan graded it A with 0 findings. It is 94% identical to Data Consolidation Agent, differing in 3 lines, and is treated as a copy.