A sales pipeline tracker built with vibe coding gives a founder or solo seller a CRM-grade tool without the per-seat pricing or the configuration overhead of HubSpot, Salesforce, or Pipedrive. The tool you will build by the end of this guide handles a kanban view of stages, deal cards with notes and contacts, stage transition tracking, and a small forecasting math layer. The full build is roughly 700 lines of code, generated by AI from a clear prompt sequence, deployable to Vercel for free or for a few dollars on a paid tier.
This piece walks through the architecture, the kanban library that makes it easy, the stages and deal model, the forecasting math, and the prompts that produce working code in two focused days.
Why Build Instead of Use HubSpot
HubSpot, Salesforce, and Pipedrive are all excellent at what they do, and all three are overkill for the first 50 deals you ever track. The complexity, the seat pricing (often 30 to 100 dollars per user per month), and the time to configure custom fields all add friction that early-stage teams cannot afford.
A custom pipeline tracker built with vibe coding inverts this trade. You build exactly the workflow your sales process needs, you pay nothing for additional seats, and you can change anything in 20 minutes when the process evolves. The catch is that you commit to ongoing maintenance, but for a tool used daily by 1 to 5 people, the math is favorable.
A 2024 IndieHackers survey of 400 solo founders found that 64% had paid for HubSpot or similar CRMs in their first year, and 48% had abandoned them within 6 months because the complexity exceeded their actual needs. The same survey found that founders who built a custom tracker were 3x more likely to actually log every deal, which is the lower bound of useful CRM behavior.
The pattern to copy is the way Trello replaced custom project management software for small teams. The simplicity was the feature. A pipeline tracker built like a custom Trello, with stages instead of columns and deals instead of cards, captures most of the value of a sophisticated CRM without the complexity tax.
The Kanban Library
The single biggest UX decision is which kanban library to use. The same options apply as for content calendars (dnd-kit, react-beautiful-dnd, FullCalendar), with the same recommendation, dnd-kit for the modern, accessible default.
The kanban view is simpler than a calendar because the layout is just columns of cards with drag and drop between columns. The library handles the drag interactions, your code handles the data updates and the column rendering. Total UI code for the kanban view is about 200 lines.
The other thing the kanban view needs is column-level summaries. Each column should show the count of deals in that stage and the total value. These are simple aggregations that update in real-time as deals move between columns. The math is one line each.
The Stages and Deal Model
The data model for a pipeline tracker is small. Three tables cover almost every use case.
Table 1, deals. Columns include id, title, contact_name, contact_email, value (in cents to avoid floating point issues), stage_id, created_at, updated_at, expected_close_date, and notes. This is the main table.
Table 2, stages. Columns include id, name, order, win_probability (0.0 to 1.0). Standard stages might be Lead, Qualified, Proposal, Negotiation, Closed Won, Closed Lost. The win_probability is what enables forecasting.
Table 3, deal_history. Columns include id, deal_id, from_stage_id, to_stage_id, transitioned_at. This tracks every movement between stages, which enables analysis of where deals get stuck and your average time-in-stage.
Read more founder-friendly build tutorials
Browse build articlesThe win_probability per stage is what distinguishes a real pipeline tool from a kanban board. Without it, you cannot forecast revenue. With it, the tool can sum (deal value times win probability) across all open deals to produce an expected revenue number that is much more useful than raw pipeline value.
The Forecasting Math
Sales forecasting in a small SaaS is much simpler than it looks. The basic formula is, for each open deal, multiply the deal value by the win probability of its current stage. Sum across all deals to get expected revenue.
expected_revenue = sum(deal.value * stage.win_probability)
for deal in open_deals
For a more nuanced forecast, weight by the time the deal has been in the stage. Deals that have sat in Negotiation for 60 days have a lower probability of closing than deals that just entered. The simple adjustment is to apply a decay factor based on time in stage.
The other useful number is the close-rate per stage, calculated from historical deal_history records. If 40 percent of deals that reach Proposal eventually close, the win_probability for Proposal should be about 0.4. The win probabilities should be calibrated from your own historical data, not guessed.
The most expensive pipeline tracker mistake is treating the win probabilities as static guesses. The numbers should be calibrated quarterly from your actual deal history, because conversion rates between stages change with seasonality, market conditions, and your own selling skill. A pipeline tool with stale probabilities produces forecasts that look precise but are systematically wrong.
The corollary is that the historical data is what makes the tool valuable, not the kanban UI. After six months of use, the deal_history table is the most valuable thing your team owns about its sales process. Treat it accordingly with backups and care.
The other useful pattern is the activity log per deal. Every email sent, call made, or meeting scheduled should be loggable against the deal record. The activity log makes deal review meetings much more productive (you can see at a glance what has been tried) and produces useful data about which activities actually correlate with closed deals. The simplest implementation is a free-text notes field with timestamps, the more sophisticated implementation parses structured data, and most teams find the simple version is enough.
The third pattern worth knowing is the loss reason capture. When a deal moves to Closed Lost, prompt the user to pick from a short list of reasons (price, timing, competitor, no decision). Aggregating this data after a few months produces actionable insights about why your sales process is or is not working, more useful than any blog post on closing techniques.
What This Means For You
A custom pipeline tracker is the kind of tool that compounds value over time. The first six months of use produce data that nobody else has, the data informs every future sales decision, and the per-seat cost stays at zero forever.
- If you're a founder: Build this in your first 50 deals, not your first 500. The early data is much more valuable than the immediate convenience of using HubSpot.
- If you're changing careers: A working pipeline tool with realistic data is a strong portfolio project for any role that touches sales operations or revenue analytics.
- If you're a student: This project teaches data modeling, kanban UX, and basic forecasting math at the same time. The cross-disciplinary lesson density is high, and a working pipeline tool with realistic mock data is a strong portfolio piece for sales engineering, revenue operations, or product analytics roles.
Browse more sales and CRM build tutorials
Read more build guides