Back to case studies

Bunny: A Supabase-Backed Opportunity Management System

An evolving internal application for organizing employment opportunities, freelance leads, outreach drafts, marketing tasks, and human-reviewed workflows.

Bunny opportunity-management dashboard shown in desktop and mobile layouts

Bunny is an evolving internal opportunity-management application conceived and built by End Everything Studios to organize employment opportunities, freelance prospects, outreach preparation, follow-ups, internal marketing work, and daily business workload.

The product is not a client project or a public SaaS platform. It is a working internal system shaped around the studio owner’s real process: different kinds of work need different fields, qualification rules, statuses, and review steps, but they still need to live in one place where the next useful action is visible.

Employment applications, freelance leads, outreach drafts, follow-ups, and studio marketing tasks were difficult to manage consistently when they were spread across separate tools, conversations, and scheduled research runs.

Early broad automation could produce weak, repetitive, or insufficiently verified recommendations. Bunny’s engineering challenge became less about automating everything and more about narrowing responsibilities: separating record types, requiring evidence, preserving manual decisions, making status history visible, and keeping external actions under human control.

Unified Supabase Data Layer

Bunny uses Supabase as its central data layer, connecting opportunities, contacts, drafts, pipeline activity, settings, daily plans, tasks, projects, calendar events, and qualification details in one system. Row-level security helps protect that information at the database level.

Separated Opportunity Workflows

Opportunity records are typed as employment, freelance, or marketing records so job applications, outreach leads, and internal studio work can share a system without pretending they follow the same process.

Qualification and Prioritization

The schema and interface support fit status, application status, lead status, display and review dates, priority scoring, effort estimates, score notes, and qualification detail records. That gives Bunny room to hold uncertain work in review instead of pushing it straight into action.

Drafting and Human Review

Cover letters and freelance outreach emails are stored as drafts or reviewable records. The application supports copying, opening draft flows, queueing tasks, and updating statuses, but the owner still decides when to send an email or submit an application.

Pipeline History and Follow-Up

Pipeline events record activity from manual, assistant, scraper, Gmail, and calendar sources so follow-ups and previous decisions can be considered before repeated outreach or duplicated work.

Daily Targets and Workload Planning

Daily targets are configurable planning limits, not quotas that justify weak records. The daily plan tables and UI connect capacity, tasks, opportunity reviews, calendar commitments, and internal work into one planning surface.

Evidence-Based Marketing Tasks

Marketing work is treated as a reviewable backlog. Completion-review behavior asks for page-specific evidence, a concrete problem, and a business consequence before a recommendation is treated as useful.

Current State and Roadmap

The current milestone is stabilizing Bunny’s business workflow foundation across employment, freelance, drafting, follow-up, marketing, and daily visibility. Qualification quality, task quality, and output relevance are still being refined through continued use.

The next planned milestone is a notification layer for completed scheduled work, failures, and records ready for review. Later phases include installable desktop/mobile access, mobile notifications, a stronger Bunny-specific personality, and a longer-term expansion into personal operations planning.

  • Product and workflow design for an internal opportunity-management system
  • Supabase schema review and relationship modeling across opportunities, contacts, drafts, events, plans, tasks, and projects
  • Frontend interface development with static HTML, CSS, JavaScript, and jQuery
  • Status, review-state, and human-approval boundary design
  • Filtering, scheduled visibility, daily planning, and workload-surface implementation
  • Draft-generation workflow integration without automatic sending or application submission
  • Pipeline-event and follow-up visibility across manual and scheduled sources
  • Marketing-task review flow focused on evidence, problem, consequence, and owner approval
  • Iterative refinement based on real employment search, freelance prospecting, and studio operations work
Typed opportunity records Employment, freelance, and marketing records share a system while keeping separate statuses and decision paths.
Supabase-backed review queues Browser screens read and update structured records through Supabase REST and Auth.
Configurable daily targets App settings store planning limits and rules for employment applications, freelance pitches, and marketing work.
Fit, status, and priority tracking Records support fit status, application status, lead status, display dates, review dates, scores, notes, and effort estimates.
Draft storage and review Cover letters and outreach emails are stored for review instead of being automatically sent.
Pipeline-event history Manual, assistant, scraper, Gmail, and calendar activity can be represented in a shared event timeline.
Daily planning surfaces Daily plans and daily plan items connect capacity, tasks, opportunities, calendar commitments, and internal work.
Human-controlled external action Bunny can prepare research and drafts, but the owner still applies, sends, approves, skips, or follows up manually.
Roadmap clarity Notifications, installable/mobile access, stronger personality, and personal operations are labeled as planned phases, not completed features.
Centralized employment, freelance, marketing, drafting, follow-up, and daily workload records into one internal product foundation.
Made different opportunity types distinguishable instead of forcing every record through one generic workflow.
Added traceability through explicit statuses, pipeline events, qualification details, and saved draft records.
Made daily workload and planning rules configurable through Supabase-backed settings.
Preserved human approval for external communication, job applications, outreach, and marketing completion decisions.
Turned lessons from broad automation into narrower, more auditable processes with clearer evidence requirements.
Created a practical foundation that can be refined before notifications, installable access, visual identity, and personal-operations features are added.

Have a project that needs a thoughtful technical solution?

I build and improve websites, applications, ecommerce systems, and custom workflows around real business needs.