platformapidatabase
Keyword research pipeline foundations landed this week
Shipped22 commits+36194−2343
- Keyword jobs now run through a background pipeline — We added the first end-to-end job flow for Supr Keywords, covering persona generation, seed keywords, expansion, clustering, and webhook delivery.
- The product now has a real app, database, cache, and API foundation — This week established the monorepo, Supabase storage, Redis caching, and Express API structure needed for the product to grow.
- Live keyword data and dual opportunity scores are now in place — Keyword research now pulls live DataForSEO data, and keywords are scored separately for organic and paid opportunity.
- platformSet up the Supr Keywords workspace with app stubs for the web app, API, and docs site, plus shared packages for the core product areas.
- databaseAdded Supabase-backed storage for keyword jobs, personas, keywords, clusters, and keyword lineage.
- jobsBuilt the Inngest-powered pipeline for persona generation, seed keywords, expansion, clustering, and webhook delivery.
- integrationsConnected DataForSEO for keyword overview, related keywords, keyword ideas, and keyword suggestions.
- databaseAdded separate organic and paid opportunity scores to better compare SEO and PPC potential.
- apiMoved the API service to Express and added quick health checks for uptime monitoring.
- cacheAdded Redis caching and automatic local startup so repeated work is faster and local development is easier.
- jobsImproved keyword expansion with deduplication, volume-based filtering, and automatic cleanup of low-value keywords.
- jobsMade the pipeline more reliable with better job tracking, safer startup handling, and more resilient retries.
- docsUpdated the development rules, project layout, and test guidance to match the new monorepo setup.
- databaseFixed cluster embeddings so similarity matching works correctly.
- jobsFixed duplicate keyword inserts and edge cases that could stall expansion runs.
- integrationsFixed TypeScript and startup issues in the DataForSEO and pipeline code.
- cacheChanged `pnpm dev` to require Docker so Redis can start automatically.
- databaseRenamed `opportunity_score` to `organic_opportunity_score` in the database and related queries.
- apiUpdated the API route structure as part of the move from Next.js to Express.
- databaseSwitched database commands to the Supabase CLI workflow.
- securityAdded a password to the development Redis connection for a safer local setup.
- performanceReduced DataForSEO usage by filtering keyword ideas and related keywords earlier, which lowers API costs.
- docsAdded the first product requirements document, onboarding notes, and milestone plans for Supr Keywords.
- docsExpanded setup guides for Supabase, Redis, DataForSEO, and Inngest.
- docsUpdated the README, backlog, and changelog to reflect the new product workflow.