โ Back to idea
Build: Practice app that helps business owners get confident on camera
Pre-filled prompts to build this idea from scratch to MVP. Copy directly or download as a standalone PROMPT.md blueprint.
Build Steps โ Idea to MVP
1๐Full MVP Build2๐๏ธDatabase Schema3โ๏ธBackend API4๐ปFrontend App5๐Landing Page6๐ขAd Creatives7๐จBrand Package8๐
Marketing Calendar
Prisma schema with all models and relations
๐๏ธ Database Schema
Pre-filled with market research, target audience, and competitive analysis
Design a complete PostgreSQL database schema for Practice app that helps business owners get confident on camera. ## REQUIREMENTS Small business owners know video sells. The problem shows up the second they hit record. Words disappear. Confidence collapses. The missing piece between understanding video works and being able to film it costs them customers and visibility every day. CameraPilot trains the camera-shy to stop freezing. Pick a goal, get a script tailored to your business, and record a private practice take. The app analyzes everything: unclear intro, pacing too fast, lighting washing out your face, missing call to action. ## ENTITIES TO MODEL 1. Users - authentication and profile 2. Subscriptions - billing tiers: $29/month, $49/month, $99/month 3. Core business entity based on: CameraPilot trains the camera-shy to stop freezing ## PRICING MODEL Start at $29 to $49 per month, with annual plans at $200 to $500. ## OUTPUT Provide a complete Prisma schema file with: - All models with proper relations - Enums for subscription tiers and status - Timestamps (createdAt, updatedAt) - Indexes on frequently queried fields - Proper cascading deletes ## BUSINESS CONTEXT ### Idea Overview **Product**: Practice app that helps business owners get confident on camera **Summary**: Small business owners know video sells. The problem shows up the second they hit record. Words disappear. Confidence collapses. The missing piece between understanding video works and being able to film it costs them customers and visibility every day. CameraPilot trains the camera-shy to stop freezing. Pick a goal, get a script tailored to your business, and record a private practice take. The app analyzes everything: unclear intro, pacing too fast, lighting washing out your face, missing call to action. **Why Now**: Short-form video dominates every platform. AI vision technology has matured enough to provide real-time feedback on lighting, pacing, and delivery. Small businesses are desperate for affordable video coaching. ### Target Audience - Small business owners - Freelancers and consultants - Coaches and course creators - Local service providers ### Key Pain Points - Camera anxiety causes 73% of small business owners to avoid video - Coaches delete 17+ takes before posting - Competitors get views while their phone stays in their pocket - No affordable tool addresses the comfort gap ### Market Evidence - Reddit r/Entrepreneur - Facebook groups for small business - YouTube creator communities - LinkedIn for B2B ### Competitive Landscape Competitors focus on editing and publishing. CameraPilot addresses the upstream problem of camera comfort. No dominant player in this niche. ### Pricing Strategy Start at $29 to $49 per month, with annual plans at $200 to $500. ### Value Ladder - Bait (Free): Free camera confidence assessment - Frontend: Basic practice sessions with limited analysis ($29/month) - Middle: Full analysis with script generation and progress tracking ($49/month) - Backend: Team licenses with agency dashboard and white-label ($99/month) ### Revenue Potential $1M-$10M ARR | Funding: Bootstrapped ### Execution Plan 1. Build web app with video upload 2. Integrate AI Vision for pacing/clarity/lighting analysis 3. Create script generator for common business scenarios 4. Ship to 10 founders manually 5. Refine feedback loop based on real usage --- Use this business context to inform all recommendations, ensuring they're specifically tailored to this opportunity and target market.
539 wordsยท3,537 chars
How to Build This Idea
1
Scaffold the Architecture
Copy or download the โFull MVP Buildโ prompt into your preferred AI agent or editor.
2
Iterate Layer by Layer
Use Database, Backend, and Frontend prompts to build each component step by step.
3
Ship with Marketing
Use Landing Page, Ads, and Brand prompts to go live and acquire first customers.