Can I vibe code DataDive?

Build an internal Amazon keyword research and optimization tool that mimics the core Master Keyword List (MKL) logic of DataDive. The application must consist of a Python FastAPI backend and a Next.js spreadsheet frontend.

1. DATA INGESTION & MODELS
- Create database models for Workspaces, Competitor Matrix (ASIN lists), and Master Keyword Lists.
- Implement an endpoint to accept a list of 5-10 competitor ASINs.
- Integrate with Keepa API (using user-provided API key) to fetch historical BSR, price, title, and reverse-ASIN keywords for each product.
- Implement a CSV importer to manually upload Amazon Search Query Performance (SQP) and Amazon Brand Analytics (ABA) reports.

2. KEYWORD NORMALIZATION & CLUSTERING
- Normalize raw search terms (lowercase, strip special characters, stem words).
- Calculate exact metric aggregations: Total Combined Search Volume, Average BSR, Competitor Keyword Rank Index (count of competitors ranking in top 10/50/100).
- Build a root extraction algorithm that extracts common word phrases (1-gram, 2-gram, 3-gram) and ranks them by combined search volume.
- Allow users to manually assign or auto-group keywords into semantic clusters (e.g., 'size', 'material', 'use-case').

3. FRONTEND SPREADSHEET UI
- Render a high-performance grid UI (using AG Grid React or TanStack Table) capable of handling 5,000+ rows without latency.
- Provide columns for Keyword, Search Volume, Rank Position per competitor ASIN, Root Tags, and Optimization Priority Score.
- Implement real-time filtering by root phrase, minimum search volume, and competitor rank density.

4. AI LISTING OPTIMIZER
- Add a dedicated listing builder view with input fields for Title (200 char max), 5 Bullet Points (500 char max each), Description (2000 char max), and Backend Search Terms (249 bytes max).
- Connect to Claude 3.5 Sonnet API via function calling. Pass the MKL keyword targets and instruct the LLM to draft listing copy that incorporates high-priority keywords while strictly adhering to Amazon character limits.
- Show live keyword validation: cross out target keywords from the MKL in real-time as they are typed into the listing builder.

5. ERROR HANDLING & OUT OF SCOPE
- Gracefully handle Keepa API rate limits via exponential backoff queues.
- Validate byte length specifically for backend terms (handling multi-byte UTF-8 characters).
- Out of scope: Chrome extension development, automated Amazon PPC bid optimization, live web scraping without APIs.

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs