SEO Dashboard with Raw Data API Under $50/Month

SERP API ($30/mo)  -->  PostgreSQL/SQLite  -->  Chart frontend
  - Daily rank checks       - Historical data      - Recharts/Chart.js
  - AI Overview tracking    - Competitor data       - Next.js/Streamlit
  - Competitor monitoring   - Trend analysis        - Email alerts

import requests
import sqlite3
from datetime import date

DB = sqlite3.connect("seo_dashboard.db")
DB.execute("""CREATE TABLE IF NOT EXISTS rankings (
    keyword TEXT, domain TEXT, rank INTEGER,
    ai_cited INTEGER, date TEXT
)""")

def daily_rank_check(keywords: list, domain: str):
    today = str(date.today())
    for kw in keywords:
        resp = requests.post(
            "https://api.scavio.dev/api/v1/search",
            headers={"x-api-key": "YOUR_KEY"},
            json={
                "query": kw,
                "num_results": 20,
                "include_ai_overview": True
            }
        )
        data = resp.json()

        rank = None
        for r in data.get("organic_results", []):
            if domain in r.get("url", ""):
                rank = r["position"]
                break

        ai_cited = 0
        for c in data.get("ai_overview", {}).get("citations", []):
            if domain in c.get("url", ""):
                ai_cited = 1

        DB.execute(
            "INSERT INTO rankings VALUES (?, ?, ?, ?, ?)",
            (kw, domain, rank, ai_cited, today)
        )

    DB.commit()

# 200 keywords/day = 6,000/month = within $30 plan
keywords = ["best search api 2026", "serp api pricing"]
daily_rank_check(keywords, "mydomain.com")

Component        | Monthly cost | What you get
Scavio API       | $30          | 7,000 queries (rank + AI tracking)
PostgreSQL       | $0-5         | Neon free tier or Supabase
Frontend         | $0           | Vercel/Cloudflare Pages free
Total            | $30-35       | vs $500+ for Ahrefs/Semrush

// Next.js API route: fetch rank data
export async function GET(request) {
  const { searchParams } = new URL(request.url);
  const keyword = searchParams.get("keyword");

  const resp = await fetch("https://api.scavio.dev/api/v1/search", {
    method: "POST",
    headers: {
      "x-api-key": process.env.SCAVIO_KEY,
      "Content-Type": "application/json"
    },
    body: JSON.stringify({
      query: keyword,
      num_results: 20,
      include_ai_overview: true
    })
  });

  const data = await resp.json();

  return Response.json({
    keyword,
    organicResults: data.organic_results?.slice(0, 10),
    aiOverview: data.ai_overview,
    peopleAlsoAsk: data.people_also_ask
  });
}