Built an MCP server to find $1.5M/yr in leaking CRM value
michal_gil · reddit · 2026-08-25
The author built Melt, an MCP (Model Context Protocol) server for internal ops analysis. By cross-referencing headcount and labor cost data with Salesforce CRM activity, the tool helped a roughly 500-person B2B data company uncover approximately $1.5 million in annual value leakage, primarily from renewal risks.
Key Features & Results:
- Tools: meltanalyzevaluevectors and meltestimateannualleak.
- Findings: Flagged 20 high-risk accounts showing usage drop-off, support escalations, and upcoming renewals with no logged touchpoints.
- Impact: Each account was worth roughly $75K ACV but was lost due to lack of follow-up.
- Workflow: Runs directly inside Claude and Cursor, eliminating the need to build one-off spreadsheets.
The repository is open source for developers to inspect or adapt the methodology.
More from coding & agent
- 11 configurations of firm/worker/agent require different designs, shifting focus from automation to collaboration — random_walker · 2026-08-25
- Excalidraw Diagram Skill: Generate Visually Argumentative Diagrams via Claude — tom_doerr · 2026-08-25
- Visualized AI Agent workspace wrapped around OpenAI ChatGPT desktop — davidfromkansas · 2026-08-25
- Google used Gemini to rewrite giflib to Rust, fixing memory safety — JoshuaJBouw · 2026-08-25
- A Self-Improvement Loop for Agents: Daily Rubric Grading Auto-Opens Fix PRs — Roger_M_Taylor · 2026-08-25
- Developer complains: AI coding generates more code, more work, worse results — hbouammar · 2026-08-25