SerpBear is an open-source application designed for marketers, SEO professionals, and content creators who need to monitor their website’s keyword rankings on Google without relying on expensive SaaS tools. Built with Next.js and SQLite, it provides a self-hosted solution for tracking unlimited keywords across multiple domains. By integrating with third-party SERP scraping services like ScrapingRobot or SerpApi, it retrieves real search engine results and reports position changes. The app also enhances its value by connecting to Google Search Console for actual visit data and integrating with Google Ads test accounts to generate keyword ideas and monthly search volume insights. This makes SerpBear ideal for teams looking for full control over their SEO data without recurring subscription costs.
What You Get
- Unlimited Keywords and Domains - Track an unlimited number of keywords across multiple websites without restrictions, enabling comprehensive SEO monitoring at scale.
- Email Notifications for Position Changes - Receive daily, weekly, or monthly email alerts when keyword rankings move up or down, helping you react to SEO trends in real time.
- Built-in SERP API - Expose keyword ranking data via a RESTful API for integration with internal dashboards, reporting tools, or automation workflows.
- Google Search Console Integration - Pull actual search data including impressions, clicks, and average position for tracked keywords directly from Google Search Console.
- Keyword Research with Google Ads Integration - Auto-generate keyword ideas and view monthly search volumes by connecting your Google Ads test account to the app.
- PWA Mobile Experience - Install SerpBear as a progressive web app on mobile devices for on-the-go keyword tracking and monitoring.
- Zero-Cost Deployment Options - Run SerpBear for free on platforms like mogenius.com or Fly.io with no mandatory paid infrastructure requirements.
Common Use Cases
- Building a client SEO reporting dashboard - Agencies track hundreds of client keywords across domains and export position trends via the built-in API to generate automated PDF reports.
- E-commerce store optimization with 10k+ product keywords - Monitor ranking fluctuations for high-value product terms and correlate changes with traffic drops using Google Search Console data.
- Problem: Manual SERP checks are time-consuming → Solution: SerpBear automates daily ranking checks with email alerts, reducing manual labor by 90% - A content marketer sets up tracking for 200 target keywords and receives daily summaries instead of manually searching Google.
- Team workflow for growth hackers - A 5-person marketing team shares a single SerpBear instance to track campaign performance, with each member adding keywords and viewing aggregated data via the web interface.
Under The Hood
SerpBear is a comprehensive SEO research and keyword tracking platform built with Next.js, offering a unified dashboard for managing domains, keywords, and search console insights. It integrates multiple scraping services and analytics tools into a cohesive interface, making it a powerful solution for SEO professionals.
Architecture
This codebase follows a monolithic architecture with clear separation of concerns, leveraging Next.js as its core framework. It adopts a layered structure that organizes components, API routes, and database interactions in a well-defined manner.
- Modular design principles with distinct sections for UI, services, and data handling
- Layered structure that separates concerns between frontend components and backend logic
- Use of API routes to manage server-side operations and data fetching
Tech Stack
Built with a modern web stack centered around TypeScript and React, the system leverages Next.js for full-stack functionality. It integrates with cloud services and database operations through a variety of well-chosen tools.
- TypeScript and React with Next.js for server-side rendering, API routes, and static site generation
- Extensive use of react-query for data fetching and chart.js for visualization
- Tailwind CSS, PostCSS, and MSW for styling, build tools, and mocking capabilities
- Jest and next-router-mock for testing and routing simulation
Code Quality
Code quality is moderate, with a component-driven development approach and consistent error handling in key modules. While tests are present, they are primarily focused on UI components and basic functionality.
- UI-focused testing with Jest and MSW for mocking external services
- Consistent error handling in asynchronous operations and data fetching
- Type safety enforced through TypeScript with a clear structure for components
- Some inconsistencies in code style and modularity that could be improved
What Makes It Unique
SerpBear stands out through its innovative integration of multiple SEO tools and unique UI components that adapt to different contexts. It introduces creative solutions for data visualization, icon handling, and version management.
- Dual-chart component system that dynamically adapts between full and slim display modes
- SVG icon system with embedded animations and dynamic color handling for consistent UI
- Changelog and version management integrated into the application flow with CSS transitions
- Extensible scraper service architecture that enables easy integration of third-party SEO tools