[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_407":408,"_409":410},"routes/_app.x.$handle.$name",{"_105":104,"_33":46,"_114":91,"_28":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_20":-5,"_126":127,"_128":129,"_130":27,"_131":132,"_133":25,"_134":-5,"_135":-5,"_136":137},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":25,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":27},"version",41,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":29,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":27},"previous",{"_31":32,"_33":29,"_34":35,"_36":37},"deleted",true,"deletedHere",false,"path","card-test.http.ts","latestPath","fileId","330a25c0-7efc-11f1-8acc-1607ee4eb77e","name","fileType","http","content","// TEST RIG (isolated): github handle + activity context in → lead card out.\n// Clay-only enrichment (no PDL, no email-lookup — Clay waterfalls email itself),\n// gpt-5 + web_search composes the card. No db, no Slack.\n// For the future Slack sender: npm:slackify-markdown converts md → Slack mrkdwn.\n//\n// POST / with header x-debug-token: $DEBUG_TOKEN\n// body: { github_username: string, activity: [{ type, repo, when?, title? }] }\n\nimport OpenAI from \"npm:openai\";\n\nconst openai = new OpenAI({ apiKey: Deno.env.get(\"OPENAI_API_KEY\") });\n\nconst CARD_PROMPT = `You are a lead-qualification researcher for Mira (miracode.ai) and DB Pro (dbpro.app), sold by the same small company.\n\nMira is a self-hosted, BYOK (bring-your-own-key) AI code reviewer: code never leaves your infra, you pick the model, no per-seat/ACU billing — you just pay LLM costs. It's a different bet than managed platforms like Devin. DB Pro is a modern database client for software teams.\n\nIdeal customer signals (in rough priority order):\n1. Works somewhere with data-sovereignty pressure — regulated industries, European enterprises, on-prem/self-hosted infrastructure\n2. Professional engineer or engineering leader at a company with a real team (not student/hobbyist); company size matters — find it\n3. In a position to buy or champion dev tools (senior, staff, lead, manager, founder)\n4. Their activity suggests real usage (issues, PRs, config questions) rather than curiosity (lone star)\n\nYou receive JSON: the person's GitHub username, their activity on our repos (type, repo, dates, issue/PR titles), and enrichment data from Clay (name, LinkedIn, company, employee count, funding) when available. Research them further on the live web: GitHub profile/repos, LinkedIn, personal sites, their company.\n\nProduce a lead card as JSON only (no markdown fences):\n{\n \"verdict\": \"MESSAGE\" | \"WATCH\" | \"IGNORE\" | \"NEEDS_ID\",\n \"name\": string | null, // real name, or null if unidentified\n \"title\": string | null,\n \"company\": string | null,\n \"company_size\": string | null, // e.g. \"~22,000 employees\" or \"1 person (own LLC)\"\n \"why\": string, // 2-3 sentences, use their name, cite the concrete evidence\n \"opener\": string, // suggested first DM line, references their specific activity\n \"links\": { \"github\": string, \"linkedin\": string | null, \"company\": string | null }\n}\n\nVerdict guide: MESSAGE = worth James's time this week. WATCH = real person, weak buying signal today. IGNORE = bot/student/no fit. NEEDS_ID = activity signal is hot but identity unresolved even after research.\nBe honest: never invent a company or title. If Clay and your research disagree, say so in \"why\".`;\n\nasync function clay(github_username: string) {\n const res = await fetch(\"https://clay-proxy.val.run/enrich\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${Deno.env.get(\"VAL_TOWN_API_KEY\")}`,\n },\n body: JSON.stringify({ source: \"dbpro-leads card-test\", github_username }),\n });\n if (!res.ok) throw new Error(`Clay ${res.status}: ${await res.text()}`);\n return res.json();\n}\n\nexport default async function (req: Request): Promise {\n if (req.method !== \"POST\") {\n return Response.json({ usage: \"POST { github_username, activity }\" }, { status: 405 });\n }\n if (req.headers.get(\"x-debug-token\") !== Deno.env.get(\"DEBUG_TOKEN\")) {\n return Response.json({ error: \"bad token\" }, { status: 401 });\n }\n\n const { github_username, activity } = await req.json();\n const t0 = Date.now();\n\n let enrichment: unknown, clayError: string | undefined;\n try {\n enrichment = await clay(github_username);\n } catch (e) {\n clayError = String(e);\n }\n const tClay = Date.now() - t0;\n\n const response = await openai.responses.create({\n model: \"gpt-5\",\n tools: [{ type: \"web_search\" }],\n instructions: CARD_PROMPT,\n input: JSON.stringify({ github_username, activity, clay: enrichment ?? null }),\n });\n if (response.status !== \"completed\") {\n return Response.json({ error: `model ${response.status}`, clay: enrichment }, { status: 502 });\n }\n const json = response.output_text.replace(/^\\s*```(?:json)?\\s*|\\s*```\\s*$/g, \"\");\n\n return Response.json({\n card: JSON.parse(json),\n clay: enrichment ?? null,\n clay_error: clayError,\n timing_ms: { clay: tClay, total: Date.now() - t0 },\n });\n}\n","// Card endpoint: github handle + activity (+ optional email) in → markdown lead card out.\n// gpt-5 + web_search does research and writes the card. No db, no Slack.\n// For the future Slack sender: npm:slackify-markdown converts md → Slack mrkdwn.\n//\n// POST / with header x-debug-token: $DEBUG_TOKEN\n// body: { github_username: string, activity: [{ type, repo, when?, title? }], email?: string }\n\nimport OpenAI from \"npm:openai\";\n\nconst openai = new OpenAI({ apiKey: Deno.env.get(\"OPENAI_API_KEY\") });\n\nconst PROMPT = `You do lead enrichment and qualification for people who interact with Mira's GitHub repos. Mira (miracode.ai) is a self-hosted, BYOK AI code reviewer — code never leaves your infra, you pick the model, no per-seat pricing.\n\nInput: a GitHub username, their activity on our repos (dates, issue/PR titles), sometimes an email. Research them: GitHub, LinkedIn, personal sites, their company.\n\nThe best leads work at companies where self-hosting matters (regulated, European, on-prem), with a real engineering team, and personally are senior enough to champion tools, and show real usage (issues/PRs > stars). Students, bots, drive-by stars are not leads.\n\nNever invent a company, title, or email — null out and downgrade the verdict instead.\n\nReply in markdown as follows:\n\nVerdict: MESSAGE | WATCH | IGNORE | NEEDS_ID (MESSAGE = a founder should DM them this week; NEEDS_ID = hot activity, unknown person)\nName — title, company (~size)\nWhy: 2–3 sentences, concrete evidence, where facts came from.\nOpener: one line, founder-to-user: reference their specific activity, thank contributors, ask a real question about their setup. Never salesy, never flattery.\nLinks: github · linkedin · company · email`;\n\n// Models sometimes wrap output in ``` fences — strip them if present, pass through if not.\nexport function stripFences(text: string): string {\n const m = text.trim().match(/^```(?:markdown|md)?\\s*\\n([\\s\\S]*?)\\n?```$/);\n return (m ? m[1] : text).trim();\n}\n\nexport function parseVerdict(markdown: string): string | null {\n return markdown.match(/^Verdict:\\s*(MESSAGE|WATCH|IGNORE|NEEDS_ID)/im)?.[1] ?? null;\n}\n\nexport default async function (req: Request): Promise {\n if (req.method !== \"POST\") {\n return Response.json({ usage: \"POST { github_username, activity, email? }\" }, { status: 405 });\n }\n if (req.headers.get(\"x-debug-token\") !== Deno.env.get(\"DEBUG_TOKEN\")) {\n return Response.json({ error: \"bad token\" }, { status: 401 });\n }\n\n const { github_username, activity, email } = await req.json();\n const t0 = Date.now();\n\n const response = await openai.responses.create({\n model: \"gpt-5\",\n tools: [{ type: \"web_search\" }],\n instructions: PROMPT,\n input: JSON.stringify({ github_username, activity, ...(email && { email }) }),\n });\n if (response.status !== \"completed\") {\n return Response.json({ error: `model ${response.status}` }, { status: 502 });\n }\n\n const card = stripFences(response.output_text);\n return Response.json({\n verdict: parseVerdict(card),\n card,\n timing_ms: Date.now() - t0,\n });\n}\n","createdAt",["D",1783979628389],"branchVersion","branchId","3707f499-097d-4e07-a507-b21e0bcfbbb0","id","1248533c-8cdc-4f42-9610-73e9cbc5e37d","dbpro-leads",["D",1783725503703],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","GitHub lead qualification for DB Pro / Mira","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/aeec28de-dccc-49ab-3dcc-66b67afd7700/square512?exp=1789574399&sig=b9ae568b961d59fc40e936baf203f5ffe8ed51fd154144f1f7629137a63feee1","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","019f4e53-354b-724f-878e-e9177d5c065a","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","ba7bb5fb-1abb-4ffb-8f3d-7c244782e5f7","tursoName","1248533c8cdc4f42961073e9cbc5e37d","tursoHostname","1248533c8cdc4f42961073e9cbc5e37d-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789526460011],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_18":-5,"_110":111,"_112":25},"branch",{"_13":90,"_33":91,"_44":43,"_92":45,"_93":94,"_95":96,"_97":51,"_98":99,"_100":101,"_102":46,"_103":104},"isOwned",166,"main","projectId","forkedBranchId","2beae49c-ed74-11f0-997b-42dde27851f2","forkedBranchVersion",144,"forkedProjectPrivacy","forkedProjectId","2be6e306-ed74-11f0-997b-42dde27851f2","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","valdottown","handle","displayName","Val Town ","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJyWnQ5cFE0c3pleVRCSEVTWmxzaXJsTUlGciJ9","tier","business","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_33":46,"_39":402,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":25,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":403,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":404,"_85":405,"_87":406,"_89":27},"tree",[239,245,254,257,258,259,260,261,262,263],"files",[239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263],"counts",{"_229":64,"_230":175,"_231":64,"_232":233,"_234":235},"contents",[151,152,153,154,155,156,157,158,159,160],"upstreamProject",{"_44":99,"_33":147,"_53":148,"_55":56,"_50":51,"_83":149},"upstreamBranch",{"_44":94,"_39":138,"_139":140,"_33":91,"_92":99,"_13":141,"_93":142,"_95":143,"_144":145,"_48":-5,"_89":27,"_50":51,"_103":146,"_65":101,"_102":147},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1767974365657],"updatedAt",["D",1783726173324],146,"6b736e3c-daf9-11f0-9e58-42dde27851f2",138,"lockfileKey","1783726173402-esm.town_v_templates_github-leads@146-main","templates","github-leads","Find customers to sell to from GitHub activity",{"_105":146,"_113":150},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789574399&sig=3d6a0be010e77940e58f104bd06b986c1fe4f3a57bc9d85e134d5d62fe89a483",{"_44":224,"_33":225,"_31":226,"_164":-5,"_42":43,"_41":175,"_166":27,"_39":227,"_13":64,"_34":217,"_36":-5,"_24":27,"_171":-5,"_28":228},{"_44":219,"_33":220,"_31":221,"_164":-5,"_42":43,"_41":175,"_166":27,"_39":222,"_13":64,"_34":217,"_36":-5,"_24":27,"_171":-5,"_28":223},{"_44":213,"_33":214,"_31":215,"_164":-5,"_42":43,"_41":175,"_166":27,"_39":216,"_13":64,"_34":217,"_36":-5,"_24":27,"_171":-5,"_28":218},{"_44":206,"_33":207,"_31":208,"_164":-5,"_42":43,"_41":209,"_166":27,"_39":210,"_13":175,"_34":20,"_36":211,"_24":27,"_171":-5,"_28":212},{"_44":199,"_33":200,"_31":201,"_164":-5,"_42":43,"_41":202,"_166":27,"_39":203,"_13":189,"_34":20,"_36":204,"_24":27,"_171":-5,"_28":205},{"_44":191,"_33":192,"_31":193,"_164":-5,"_42":43,"_41":194,"_166":27,"_39":195,"_13":196,"_34":184,"_36":197,"_24":27,"_171":-5,"_28":198},{"_44":187,"_33":29,"_31":32,"_164":-5,"_42":43,"_41":14,"_166":27,"_39":188,"_13":189,"_34":35,"_36":38,"_24":27,"_171":-5,"_28":190},{"_44":179,"_33":180,"_31":181,"_164":-5,"_42":43,"_41":182,"_166":27,"_39":183,"_13":64,"_34":184,"_36":185,"_24":27,"_171":-5,"_28":186},{"_44":173,"_33":174,"_31":59,"_164":-5,"_42":43,"_41":175,"_166":27,"_39":176,"_13":64,"_34":35,"_36":177,"_24":27,"_171":-5,"_28":178},{"_44":161,"_33":162,"_31":163,"_164":-5,"_42":43,"_41":165,"_166":27,"_39":167,"_13":168,"_34":169,"_36":170,"_24":27,"_171":-5,"_28":172},"4c85709f-0aa5-4aec-8c37-70a953056ad9","scratch-nycjay.ts","8b3f585a-7ef7-11f1-8ff8-1607ee4eb77e","parentId",40,"latest",["D",1783975946821],5,"script","// Scratch: recover emails, then Clay WITH email for the 3 test people. DELETE WHEN DONE.\nimport { emailsFromGitHubUsername } from \"https://esm.town/v/stevekrouse/github-user-email/index.ts\";\n\nconst token = Deno.env.get(\"VAL_TOWN_API_KEY\");\nconst USERS = [\"micahnz\", \"kylewelsby\", \"gonzaloraknarok88\"];\n\nconst results = await Promise.all(USERS.map(async (login) => {\n const out: Record = { login };\n try {\n const emails = await emailsFromGitHubUsername(login);\n out.emails = emails;\n const email = emails.find((e: string) => !e.includes(\"noreply.github.com\"));\n out.email_used = email ?? null;\n if (!email) return out;\n\n const t0 = Date.now();\n const res = await fetch(\"https://clay-proxy.val.run/enrich\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${token}`,\n },\n body: JSON.stringify({ source: \"dbpro-leads email test\", github_username: login, email }),\n });\n out.clay = await res.json();\n out.clay_ms = Date.now() - t0;\n } catch (e) {\n out.error = String(e);\n }\n return out;\n}));\n\nconsole.log(JSON.stringify(results, null, 2));\n","label",[162],"41a0d3f5-966c-4e12-b74d-193179c6bf51","main.ts",1,["D",1783725503703],"import { oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport app from \"./backend/index.ts\";\n\nexport default oauthMiddleware(app.fetch);\n",[174],"a89db194-f4eb-45eb-adbf-031e09a2b7fc","github.cron.ts","fd4fa288-7ee8-11f1-8177-1607ee4eb77e",31,["D",1783967457164],"interval","import { Octokit } from \"npm:octokit@5.0.5\";\nimport { processLead } from \"./backend/agent.ts\";\nimport { appendFollowup, createProcessingLead, findLeadByGithubUsername } from \"./backend/db.ts\";\nimport { EXCLUDE_USERS, WATCHED } from \"./shared/config.ts\";\n\n// Hourly sweep of each watched org's public events (stars, forks, issues,\n// PRs). Each new person becomes a lead run through the same scoring pipeline\n// as webhook submissions; repeat activity appends to their existing lead.\n// Note: GitHub's Events API only returns the ~300 most recent events per org.\nexport default async function (interval: Interval) {\n // First run: only look back an hour (history is the backfill's job) —\n // otherwise we'd score all ~300 events GitHub returns in one burst.\n const lastChecked = interval.lastRunAt ?? new Date(Date.now() - 60 * 60 * 1000);\n const octokit = new Octokit({ auth: Deno.env.get(\"GITHUB_TOKEN\") });\n // Lets the agent (and a human reading the lead) see how we relate to each org.\n const watched = Object.fromEntries(WATCHED.map((w) => [w.org, w.relationship]));\n\n const newEvents = (await Promise.all(\n WATCHED.map(({ org }) =>\n octokit.paginate(octokit.rest.activity.listPublicOrgEvents, { org, per_page: 100 })\n ),\n ))\n .flat()\n .filter((e: any) => new Date(e.created_at) > lastChecked)\n .filter((e: any) => e.actor?.login && !e.actor.login.includes(\"[bot]\") && !EXCLUDE_USERS.has(e.actor.login));\n\n const actorEvents = Map.groupBy(newEvents, (e: any) => e.actor.login);\n console.log(`${newEvents.length} new events from ${actorEvents.size} users`);\n\n // Process serially so a burst of new people doesn't blow past the interval\n // time budget / OpenAI rate limits.\n for (const [login, events] of actorEvents) {\n const existing = await findLeadByGithubUsername(login);\n if (existing) {\n await appendFollowup(existing.id, events);\n continue;\n }\n // github_username keys Clay enrichment and dedupe on later sweeps;\n // events carry the GitHub activity for the agent to research.\n const inputData = { github_username: login, events, watched };\n const leadId = await createProcessingLead(inputData);\n await processLead(leadId, inputData);\n }\n}\n",[180],"4c89a1ac-e364-48c0-acd5-7cc645c0a4c8",["D",1783979628389],2,[29],"216106b8-785f-4fe8-bf1c-f24d1e5489b1","backfill.cron.ts","d3e24782-7cb5-11f1-8fae-1607ee4eb77e",28,["D",1783967446687],8,"import sqlite from \"https://esm.town/v/std/db/main.ts\";\nimport { Octokit } from \"npm:octokit@5.0.5\";\nimport { processLead } from \"./backend/agent.ts\";\nimport { createProcessingLead, findLeadByGithubUsername } from \"./backend/db.ts\";\nimport { EXCLUDE_USERS, WATCHED } from \"./shared/config.ts\";\n\n// ── One-time backfill ──\n// Everyone who has ever starred, forked, or opened an issue/PR on our repos.\n// The first run builds the queue; each run after scores a few people until\n// the queue is empty. DELETE THIS FILE once it logs \"backfill done\".\nconst REPOS = [\"dbprohq/db-pro\", \"dbprohq/hypership\", \"miracodeai/mira\"];\nconst BATCH = 2; // scored in parallel each run (kept small so a tick fits the interval time budget)\n\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS backfill_queue (login TEXT PRIMARY KEY, activity TEXT NOT NULL)`,\n);\n\nfunction rowField(row: unknown, index: number, name: string): unknown {\n if (Array.isArray(row)) return row[index];\n if (row && typeof row === \"object\") {\n const obj = row as Record;\n return obj[name] ?? obj[String(index)];\n }\n return undefined;\n}\n\nasync function seedQueue() {\n const octokit = new Octokit({ auth: Deno.env.get(\"GITHUB_TOKEN\") });\n const byLogin: Record = {};\n const add = (login: string | undefined, type: string, repo: string) => {\n if (!login || login.includes(\"[bot]\") || EXCLUDE_USERS.has(login)) return;\n (byLogin[login] ??= []).push({ type, repo });\n };\n // GitHub blocks some listings per-repo (their stargazer lists 404/403 even\n // authenticated) — take what each repo gives us and log what it doesn't.\n const tryList = async (label: string, repo: string, fn: () => Promise) => {\n try {\n await fn();\n } catch (err) {\n console.log(`${repo} ${label} unavailable: ${err.message ?? err}`);\n }\n };\n\n for (const repo of REPOS) {\n const [owner, name] = repo.split(\"/\");\n const opts = { owner, repo: name, per_page: 100 };\n await tryList(\"stargazers\", repo, async () => {\n for (const s of await octokit.paginate(octokit.rest.activity.listStargazersForRepo, opts)) {\n add(s.login, \"starred\", repo);\n }\n });\n await tryList(\"forks\", repo, async () => {\n for (const f of await octokit.paginate(octokit.rest.repos.listForks, opts)) {\n add(f.owner?.login, \"forked\", repo);\n }\n });\n await tryList(\"issues\", repo, async () => {\n for (const i of await octokit.paginate(octokit.rest.issues.listForRepo, { ...opts, state: \"all\" })) {\n add(i.user?.login, i.pull_request ? \"opened PR\" : \"opened issue\", repo);\n }\n });\n }\n\n for (const [login, activity] of Object.entries(byLogin)) {\n await sqlite.execute(\n `INSERT OR REPLACE INTO backfill_queue (login, activity) VALUES (?, ?)`,\n [login, JSON.stringify(activity)],\n );\n }\n await sqlite.execute(\n `INSERT OR REPLACE INTO backfill_queue (login, activity) VALUES ('__seeded__', '[]')`,\n );\n console.log(`backfill queue seeded: ${Object.keys(byLogin).length} people`);\n}\n\nexport default async function (interval: Interval) {\n const seeded = await sqlite.execute(\n `SELECT 1 FROM backfill_queue WHERE login = '__seeded__'`,\n );\n // Seeding paginates GitHub across every repo — on its own that can eat most\n // of a tick's time budget, so seed and return. The next tick starts scoring.\n if (seeded.rows.length === 0) {\n await seedQueue();\n return { seeded: true };\n }\n\n const next = await sqlite.execute(\n `SELECT login, activity FROM backfill_queue WHERE login != '__seeded__' LIMIT ?`,\n [BATCH],\n );\n if (next.rows.length === 0) {\n console.log(\"backfill done — this file can be deleted\");\n return { done: true };\n }\n\n const watched = Object.fromEntries(WATCHED.map((w) => [w.org, w.relationship]));\n const results = await Promise.all(\n next.rows.map(async (row) => {\n const login = String(rowField(row, 0, \"login\") ?? \"\");\n const activityJson = String(rowField(row, 1, \"activity\") ?? \"[]\");\n if (!login) return { login: \"(missing)\", error: \"empty login from queue row\" };\n // Dequeue first: if scoring fails, the lead row records the error and\n // one bad entry can never wedge the queue.\n await sqlite.execute(`DELETE FROM backfill_queue WHERE login = ?`, [login]);\n if (await findLeadByGithubUsername(login)) return { login, skipped: true };\n const inputData = { github_username: login, backfill: JSON.parse(activityJson), watched };\n const leadId = await createProcessingLead(inputData);\n try {\n await processLead(leadId, inputData);\n return { login, leadId, ok: true };\n } catch (err) {\n return { login, leadId, error: String(err) };\n }\n }),\n );\n\n const remaining = await sqlite.execute(\n `SELECT COUNT(*) AS n FROM backfill_queue WHERE login != '__seeded__'`,\n );\n const remainingCount = Number(rowField(remaining.rows[0], 0, \"n\") ?? 0);\n console.log(`backfilled ${results.length}, ${remainingCount} remaining`, JSON.stringify(results));\n return { results, remaining: remainingCount };\n}\n",[192],"79b0c4c0-a3fa-49b5-a5d5-c182a0bb8afa","README.md","019f4e53-354b-724f-878e-e330fea73434",32,["D",1783967468877],"# GitHub Leads (DB Pro / Mira)\n\nFind potential customers from GitHub activity. A cron watches the public\nevents (stars, forks, issues, PRs) on GitHub orgs you choose — yours and your\ncompetitors' — and AI researches every new person on the live web and scores\nthem against [your ideal customer profile](./PROMPT.md). Qualified leads ping\nSlack the moment they're scored.\n\nThis is the [github-leads](https://www.val.town/x/templates/github-leads)\ntemplate, customized for DB Pro and Mira. The engine never needs editing;\nevery optional piece is one file you can add or delete:\n\n| | file | what it does |\n|---|---|---|\n| source | [`github.cron.ts`](./github.cron.ts) | hourly sweep of your watched orgs |\n| source | [`backfill.cron.ts`](./backfill.cron.ts) | one-time drain of historical activity |\n| source | `POST` to this val's URL | any form, signup webhook, or CRM |\n| config | [`shared/config.ts`](./shared/config.ts) | `WATCHED` orgs + `EXCLUDE_USERS` |\n| sink | [`backend/notify.ts`](./backend/notify.ts) | Slack ping when a lead scores 80+ |\n| brain | [`PROMPT.md`](./PROMPT.md) | your ideal customer profile — edit this |\n| engine | `backend/`, `frontend/`, `shared/` | webhook, agent, enrichment, dashboard |\n\n## Current setup\n\n- **Orgs watched:** `dbprohq` (DB Pro), `miracodeai` (Mira)\n- **Repos backfill:** `dbprohq/db-pro`, `dbprohq/hypership`, `miracodeai/mira`\n- **Exclude team handles:** in `shared/config.ts`\n- **Schedules:**\n - `github.cron.ts` — every hour at `:05` UTC\n - `backfill.cron.ts` — every 15 minutes until the queue is empty (then delete it)\n\n## Env vars\n\n| var | required | purpose |\n|---|---|---|\n| `GITHUB_TOKEN` | yes | GitHub Events / repo listing (public, no scopes needed) |\n| `OPENAI_API_KEY` | yes* | scoring (or use Val Town's built-in OpenAI proxy if set) |\n| `SLACK_WEBHOOK_URL` | no | instant ping for score ≥ 80 |\n| `PDL_API_KEY` | no | People Data Labs enrichment beyond free quota |\n\n\\*At least one of family-owned key or VT proxy.\n\n## Dashboard\n\n[Open the dashboard](https://stevekrouse--019f4e53354b724f878ee9177d5c065a.web.val.run/) — gated to members of this org. Type a GitHub username into the box to score someone on demand.\n\n## Notes / known gaps\n\n- Stargazer listing returns 403 for some repos even with a PAT; forks / issues / PRs still seed the queue.\n- Enrichment occasionally returns a soft note when PDL rejects a github-only lookup; scoring still works via web search.\n- Delete `backfill.cron.ts` once its logs say `backfill done`.\n",[200],"4d658ea4-8dd9-4dad-8bb9-f6d6db235f56","PROMPT.md","019f4e53-354b-724f-878e-de4d1c0aa32b",3,["D",1783725556679],"You are a lead qualification researcher for DB Pro (dbpro.app) and Mira (miracode.ai).\n\nDB Pro is a modern database client — desktop app, collaborative web platform, and built-in AI. Mira is a self-hosted, BYOK AI code reviewer. Both are sold to software teams.\n\nI'm sending you data about a lead — usually a GitHub user and their activity (stars, forks, issues, PRs) on our repos. Exhaustively research the person: their GitHub profile and repos, linked personal and company sites, LinkedIn, blogs. We especially care how big their company is — find the company name, domain, and rough size or funding, and include them in your reasoning.\n\nThe lead may include a `watched` field describing our relationship to each org they were active in (e.g. \"our repos\" vs \"competitor's repos\"). Activity on our own repos is a much hotter signal than activity on a competitor's — weigh it accordingly, and say in your reasoning where the lead came from.\n\nIdeal customer profile:\n\n1. Professional software engineer, data engineer, or engineering leader — not a student or hobbyist\n2. Works at a company with a real engineering team; the bigger the company, the better\n3. In a position to buy or champion developer tools (senior, lead, manager, or founder)\n4. Works with databases day-to-day, or owns code review / PR workflows\n\nHow to score:\n\n- 80-100: strong fit, meets nearly all of the criteria\n- 50-79: partial fit, meets some of the criteria\n- 0-49: weak fit, meets few or none of the criteria\n\nReturn your final response in JSON only with the following schema. Keep these exact fields even after you change the criteria above:\n\n{\n \"name\": string,\n \"company\": string,\n \"score\": integer from 0 to 100,\n \"reasoning\": string\n}\n",[207],"63665ad5-7dc7-479b-b2fe-d8168e44182b","shared","019f4e53-354b-724f-878e-d9f9de0d3c67",["D",1783725503703],"directory",[214],"40906d12-a9ec-4c9a-9826-65891e5764da","frontend","019f4e53-354b-724f-878e-d1b873bb8e72",["D",1783725503703],[220],"21e2f7d9-0c78-407f-bbdf-972ab523f472","backend","019f4e53-354b-724f-878e-acd986d56452",["D",1783725503703],[225],"pulls","branches","forks","envVars",{"_236":209,"_238":64},"connections",{"_236":175,"_237":64},"count","unfilledCount","emptyCount",{"_44":224,"_33":225,"_31":226,"_164":-5,"_42":43,"_41":175,"_166":27,"_39":399,"_13":64,"_34":217,"_36":-5,"_24":27,"_171":-5,"_265":400,"_28":401},{"_44":392,"_33":393,"_31":394,"_164":226,"_42":43,"_41":175,"_166":27,"_39":395,"_13":64,"_34":169,"_36":396,"_24":27,"_171":-5,"_265":397,"_28":398},{"_44":384,"_33":385,"_31":386,"_164":226,"_42":43,"_41":387,"_166":27,"_39":388,"_13":189,"_34":169,"_36":389,"_24":27,"_171":-5,"_265":390,"_28":391},{"_44":377,"_33":378,"_31":379,"_164":226,"_42":43,"_41":175,"_166":27,"_39":380,"_13":64,"_34":169,"_36":381,"_24":27,"_171":-5,"_265":382,"_28":383},{"_44":369,"_33":370,"_31":371,"_164":226,"_42":43,"_41":372,"_166":27,"_39":373,"_13":209,"_34":169,"_36":374,"_24":27,"_171":-5,"_265":375,"_28":376},{"_44":362,"_33":363,"_31":364,"_164":226,"_42":43,"_41":175,"_166":27,"_39":365,"_13":64,"_34":169,"_36":366,"_24":27,"_171":-5,"_265":367,"_28":368},{"_44":219,"_33":220,"_31":221,"_164":-5,"_42":43,"_41":175,"_166":27,"_39":359,"_13":64,"_34":217,"_36":-5,"_24":27,"_171":-5,"_265":360,"_28":361},{"_44":355,"_33":326,"_31":321,"_164":221,"_42":43,"_41":175,"_166":27,"_39":356,"_13":64,"_34":217,"_36":-5,"_24":27,"_171":-5,"_265":357,"_28":358},{"_44":348,"_33":349,"_31":350,"_164":321,"_42":43,"_41":175,"_166":27,"_39":351,"_13":64,"_34":169,"_36":352,"_24":27,"_171":-5,"_265":353,"_28":354},{"_44":341,"_33":342,"_31":343,"_164":321,"_42":43,"_41":175,"_166":27,"_39":344,"_13":64,"_34":169,"_36":345,"_24":27,"_171":-5,"_265":346,"_28":347},{"_44":334,"_33":335,"_31":336,"_164":321,"_42":43,"_41":175,"_166":27,"_39":337,"_13":64,"_34":169,"_36":338,"_24":27,"_171":-5,"_265":339,"_28":340},{"_44":327,"_33":328,"_31":329,"_164":321,"_42":43,"_41":175,"_166":27,"_39":330,"_13":64,"_34":169,"_36":331,"_24":27,"_171":-5,"_265":332,"_28":333},{"_44":318,"_33":319,"_31":320,"_164":321,"_42":43,"_41":175,"_166":27,"_39":322,"_13":64,"_34":169,"_36":323,"_24":27,"_171":-5,"_265":324,"_28":325},{"_44":311,"_33":312,"_31":313,"_164":221,"_42":43,"_41":175,"_166":27,"_39":314,"_13":64,"_34":20,"_36":315,"_24":27,"_171":-5,"_265":316,"_28":317},{"_44":304,"_33":305,"_31":306,"_164":221,"_42":43,"_41":175,"_166":27,"_39":307,"_13":64,"_34":169,"_36":308,"_24":27,"_171":-5,"_265":309,"_28":310},{"_44":213,"_33":214,"_31":215,"_164":-5,"_42":43,"_41":175,"_166":27,"_39":301,"_13":64,"_34":217,"_36":-5,"_24":27,"_171":-5,"_265":302,"_28":303},{"_44":293,"_33":294,"_31":295,"_164":215,"_42":43,"_41":296,"_166":27,"_39":297,"_13":64,"_34":169,"_36":298,"_24":27,"_171":-5,"_265":299,"_28":300},{"_44":286,"_33":287,"_31":288,"_164":215,"_42":43,"_41":175,"_166":27,"_39":289,"_13":64,"_34":169,"_36":290,"_24":27,"_171":-5,"_265":291,"_28":292},{"_44":206,"_33":207,"_31":208,"_164":-5,"_42":43,"_41":209,"_166":27,"_39":283,"_13":175,"_34":20,"_36":211,"_24":27,"_171":-5,"_265":284,"_28":285},{"_44":199,"_33":200,"_31":201,"_164":-5,"_42":43,"_41":202,"_166":27,"_39":280,"_13":189,"_34":20,"_36":204,"_24":27,"_171":-5,"_265":281,"_28":282},{"_44":191,"_33":192,"_31":193,"_164":-5,"_42":43,"_41":194,"_166":27,"_39":277,"_13":196,"_34":184,"_36":197,"_24":27,"_171":-5,"_265":278,"_28":279},{"_44":187,"_33":29,"_31":32,"_164":-5,"_42":43,"_41":14,"_166":27,"_39":274,"_13":189,"_34":35,"_36":38,"_24":27,"_171":-5,"_265":275,"_28":276},{"_44":179,"_33":180,"_31":181,"_164":-5,"_42":43,"_41":182,"_166":27,"_39":271,"_13":64,"_34":184,"_36":185,"_24":27,"_171":-5,"_265":272,"_28":273},{"_44":173,"_33":174,"_31":59,"_164":-5,"_42":43,"_41":175,"_166":27,"_39":268,"_13":64,"_34":35,"_36":177,"_24":27,"_171":-5,"_265":269,"_28":270},{"_44":161,"_33":162,"_31":163,"_164":-5,"_42":43,"_41":165,"_166":27,"_39":264,"_13":168,"_34":169,"_36":170,"_24":27,"_171":-5,"_265":266,"_28":267},["D",1783975946821],"children",[],[162],["D",1783725503703],[],[174],["D",1783967457164],[],[180],["D",1783979628389],[],[29],["D",1783967446687],[],[192],["D",1783967468877],[],[200],["D",1783725556679],[],[207],"9292886e-9385-4aa1-9f93-0bc8b908694f","types.ts","019f4e53-354b-724f-878e-d51fcce433a7",["D",1783725503703],"// Types shared between the Hono backend and the React frontend.\n\nexport interface LeadOutput {\n name?: string;\n company?: string;\n score?: number;\n reasoning?: string;\n error?: string;\n [key: string]: unknown;\n}\n\nexport type LeadStatus = \"processing\" | \"done\" | \"failed\";\n\nexport interface Lead {\n id: number;\n timestamp: number;\n input: Record;\n output: LeadOutput | null;\n status: LeadStatus;\n score: number | null;\n}\n\n// A lead still \"processing\" after this long almost certainly crashed.\nexport const PROCESSING_TIMEOUT_MS = 3 * 60 * 1000;\n\n// A lead is qualified at or above this score: green in the UI, and the bar\n// any notification (email digest, Slack, etc.) should trigger on.\nexport const QUALIFIED_SCORE = 80;\n\n// Sentinel the backend writes into output_data when it claims a lead for\n// scoring, so concurrent /process calls can't double-score it. Both \"\" (just\n// created) and this sentinel mean \"still processing\".\nexport const CLAIMED_OUTPUT = \"claimed\";\n\ninterface LeadRow {\n id: number;\n timestamp: number;\n input_data: string;\n output_data: string;\n}\n\n// Turn a raw DB row (input_data/output_data as JSON strings) into the shape the\n// frontend consumes: parsed fields plus a single computed status. Keeping this\n// one function as the source of truth means the server and client never disagree\n// about whether a lead is processing, done, or failed.\nexport function toClientLead(row: LeadRow, now: number): Lead {\n let input: Record = {};\n try {\n input = JSON.parse(row.input_data);\n } catch { /* leave as {} */ }\n\n const base = { id: row.id, timestamp: row.timestamp, input };\n\n // Empty or claimed output = the agent hasn't written a result yet.\n if (row.output_data === \"\" || row.output_data === CLAIMED_OUTPUT) {\n const timedOut = now - row.timestamp > PROCESSING_TIMEOUT_MS;\n return { ...base, output: null, status: timedOut ? \"failed\" : \"processing\", score: null };\n }\n\n let output: LeadOutput;\n try {\n output = JSON.parse(row.output_data);\n } catch {\n return { ...base, output: { error: \"Malformed output\" }, status: \"failed\", score: null };\n }\n\n if (output.error) return { ...base, output, status: \"failed\", score: null };\n\n return {\n ...base,\n output,\n status: \"done\",\n score: typeof output.score === \"number\" ? output.score : 0,\n };\n}\n",[],[214,287],"b46bf358-083d-451b-a1ff-3399cfc77b1c","config.ts","f8dc0c82-7ee8-11f1-8177-1607ee4eb77e",29,["D",1783967449755],"// Shared configuration for GitHub lead intake (cron + backfill).\n\n// GitHub orgs to watch. The relationship label gives the scoring agent\n// context: activity on your own repos is a much hotter signal than activity\n// on a competitor's.\nexport const WATCHED = [\n { org: \"dbprohq\", relationship: \"our repos (DB Pro)\" },\n { org: \"miracodeai\", relationship: \"our repos (Mira)\" },\n // { org: \"some-competitor\", relationship: \"competitor's repos\" },\n];\n\n// Your own team — never lead-scored. Add/remove GitHub usernames freely.\nexport const EXCLUDE_USERS = new Set([\n \"JSMira\",\n \"jayhyp\",\n \"JackHyp\",\n \"coolio85\",\n \"modrink\",\n \"JDSmith97\",\n]);\n",[],[214,294],["D",1783725503703],[255,256],[214],"6b150dc6-91ea-4eba-b53e-78d5d280fa0e","index.tsx","019f4e53-354b-724f-878e-cd7717fc9ea8",["D",1783725503703],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { type Lead } from \"../shared/types.ts\";\nimport { App } from \"./components/App.tsx\";\n\ndeclare global {\n interface Window {\n __INITIAL_DATA__: {\n initialLeads: Lead[];\n webhookUrl: string;\n username: string | null;\n };\n }\n}\n\nconst root = document.getElementById(\"root\");\nif (!root) throw new Error(\"No root element found\");\n\ncreateRoot(root).render();\n",[],[220,305],"04192299-aee4-4b15-b315-bf2fbb18dd0b","index.html","019f4e53-354b-724f-878e-c988e759ea01",["D",1783725503703],"\n\n \n \n \n GitHub Leads\n \n \n \n

\n \n \n \n\n",[],[220,312],"0d28e93f-09fd-498f-88d9-fc6dc68f1efd","LeadRow.tsx","019f4e53-354b-724f-878e-c0691c6334bc","019f4e53-354b-724f-878e-c6777cad123e",["D",1783725503703],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { type Lead, QUALIFIED_SCORE } from \"../../shared/types.ts\";\n\n// Relative dates keep the feed scannable: \"2h ago\" matters, exact dates don't.\nexport function timeAgo(ts: number): string {\n const mins = Math.floor((Date.now() - ts) / 60_000);\n if (mins < 1) return \"just now\";\n if (mins < 60) return `${mins}m ago`;\n const hours = Math.floor(mins / 60);\n if (hours < 24) return `${hours}h ago`;\n const days = Math.floor(hours / 24);\n if (days < 30) return `${days}d ago`;\n return new Date(ts).toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\", year: \"numeric\" });\n}\n\n// Fixed-width score column; green is reserved for qualified,\n// red for failed. Everything else stays quiet.\nfunction Score({ lead }: { lead: Lead }) {\n if (lead.status === \"processing\") {\n return ··;\n }\n if (lead.status === \"failed\") {\n return ✗;\n }\n const score = lead.score ?? 0;\n return (\n = QUALIFIED_SCORE ? \"text-green-700 font-semibold\" : \"text-gray-400\"}>\n {score}\n \n );\n}\n\nconst ROW = \"w-full text-left py-2.5 border-b border-gray-100 grid grid-cols-[2.5rem_1fr_auto] items-baseline gap-3\";\n\nexport function LeadRow({ lead, onSelect }: { lead: Lead; onSelect: (id: number) => void }) {\n const displayName = lead.output?.name || (lead.input.name as string) ||\n (lead.input.github_username as string) || (lead.input.company as string) || \"Unknown\";\n\n return (\n onSelect(lead.id)}\n className={`${ROW} hover:bg-gray-50 cursor-pointer`}\n >\n \n \n {displayName}\n {lead.output?.company && · {lead.output.company}}\n {lead.status === \"processing\" && · scoring…}\n {lead.status === \"failed\" && · failed}\n \n {timeAgo(lead.timestamp)}\n \n );\n}\n\nexport function SampleRow(\n { name, company, score }: { name: string; company: string; score: number },\n) {\n return (\n

\n = QUALIFIED_SCORE ? \"text-green-700 font-semibold\" : \"text-gray-400\"}`}>\n {score}\n \n \n {name}\n · {company}\n \n example\n

\n );\n}\n",[],[220,326,319],"components","01907a44-82d6-488c-b9d9-ed3563f41c5b","LeadDetail.tsx","019f4e53-354b-724f-878e-bd193267b39f",["D",1783725503703],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { type Lead, QUALIFIED_SCORE } from \"../../shared/types.ts\";\nimport { timeAgo } from \"./LeadRow.tsx\";\n\nexport function LeadDetail({ lead, onBack }: { lead: Lead; onBack: () => void }) {\n const output = lead.output;\n const score = lead.score ?? 0;\n const displayName = output?.name || (lead.input.name as string) ||\n (lead.input.github_username as string) || (lead.input.company as string) || \"Unknown\";\n\n return (\n

\n \n ← All leads\n \n\n

{displayName}

\n {output?.company && `${output.company} · `}\n {timeAgo(lead.timestamp)}\n

\n\n {lead.status === \"failed\"\n ? (\n

\n {output?.error ||\n \"This lead has been processing for over 3 minutes and likely failed. Try resubmitting it.\"}\n

\n )\n : lead.status === \"processing\"\n ? (\n

\n Scoring — the AI is researching this lead. Usually takes a minute or two.\n

\n )\n : (\n

= QUALIFIED_SCORE ? \"text-green-700\" : \"\"}`}>\n {score}\n / 100\n

\n {output?.reasoning || \"No reasoning provided\"}\n

\n )}\n\n \n {output && lead.status !== \"processing\" && }\n

\n );\n}\n\nfunction DataList({ title, data }: { title: string; data: Record }) {\n const entries = Object.entries(data);\n if (entries.length === 0) return null;\n\n return (\n

{title}

\n {entries.map(([key, value]) => (\n

\n {key}\n \n {typeof value === \"object\" ? JSON.stringify(value) : String(value ?? \"\")}\n \n

\n ))}\n

\n );\n}\n",[],[220,326,328],"c8ad1a15-a309-426a-94c7-5162ab3eb4a2","GithubTester.tsx","019f4e53-354b-724f-878e-baa772436726",["D",1783725503703],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\n// One quiet line under the title: score any GitHub username on demand, plus\n// the webhook URL for wiring up other sources (forms, signups, CRMs).\nexport function GithubTester({ webhookUrl, onSent }: { webhookUrl: string; onSent: () => void }) {\n const [handle, setHandle] = React.useState(\"\");\n const [sending, setSending] = React.useState(false);\n const [error, setError] = React.useState(null);\n const [copied, setCopied] = React.useState(false);\n\n const copy = async () => {\n try {\n await navigator.clipboard.writeText(webhookUrl);\n } catch {\n // Clipboard API is blocked by permissions policy inside iframes (like\n // the Val Town preview); fall back to the legacy selection approach.\n const ta = document.createElement(\"textarea\");\n ta.value = webhookUrl;\n ta.style.position = \"fixed\";\n ta.style.opacity = \"0\";\n document.body.appendChild(ta);\n ta.select();\n document.execCommand(\"copy\");\n ta.remove();\n }\n setCopied(true);\n setTimeout(() => setCopied(false), 2000);\n };\n\n const send = async () => {\n const username = handle.trim().replace(/^@/, \"\");\n if (!username || sending) return;\n setSending(true);\n setError(null);\n try {\n const res = await fetch(`${webhookUrl}?source=manual`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ github_username: username }),\n });\n const data = await res.json();\n if (data.error) {\n setError(data.error);\n } else {\n setHandle(\"\");\n onSent();\n }\n } catch (err) {\n setError(err instanceof Error ? err.message : String(err));\n } finally {\n setSending(false);\n }\n };\n\n return (\n

\n setHandle(e.target.value)}\n onKeyDown={(e) => e.key === \"Enter\" && send()}\n placeholder=\"Score a GitHub username…\"\n spellCheck={false}\n className=\"border border-gray-200 px-2.5 py-1.5 w-56 focus:outline-none focus:border-gray-400\"\n />\n \n {sending ? \"sending…\" : \"score\"}\n \n \n or POST JSON to{\" \"}\n this URL{\" \"}\n \n {copied ? \"copied\" : \"copy\"}\n \n \n

\n {error &&

{error}

}\n

\n );\n}\n",[],[220,326,335],"3cfb95f3-3fb1-4031-96bc-f90c717e46a8","Dashboard.tsx","019f4e53-354b-724f-878e-b7ce11d2bf8f",["D",1783725503703],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { type Lead, QUALIFIED_SCORE } from \"../../shared/types.ts\";\nimport { LeadRow, SampleRow } from \"./LeadRow.tsx\";\n\nconst WEEK_MS = 7 * 24 * 60 * 60 * 1000;\n\n// Shown only when there are no leads yet, so the dashboard demonstrates what\n// scored leads look like before the first real one arrives.\nconst SAMPLE_LEADS = [\n { name: \"Maya Chen\", company: \"Parabolic Systems\", score: 92 },\n { name: \"Diego Alvarez\", company: \"Kestrel Analytics\", score: 61 },\n { name: \"Sam Hobbyist\", company: \"Personal blog\", score: 14 },\n];\n\n// Best leads first, but only within the last week — an old high score\n// shouldn't outrank this morning's lead forever. Still-processing leads pin\n// to the top; leads older than a week collapse under \"Earlier\".\nfunction byScoreThenNewest(a: Lead, b: Lead): number {\n if ((a.status === \"processing\") !== (b.status === \"processing\")) {\n return a.status === \"processing\" ? -1 : 1;\n }\n return (b.score ?? 0) - (a.score ?? 0) || b.timestamp - a.timestamp;\n}\n\nexport function Dashboard(\n { leads, onSelect }: { leads: Lead[]; onSelect: (id: number) => void },\n) {\n const sorted = [...leads].sort(byScoreThenNewest);\n const cutoff = Date.now() - WEEK_MS;\n const recent = sorted.filter((l) => l.timestamp >= cutoff);\n const earlier = sorted.filter((l) => l.timestamp < cutoff);\n const qualified = recent.filter(\n (l) => l.status === \"done\" && (l.score ?? 0) >= QUALIFIED_SCORE,\n );\n\n if (leads.length === 0) {\n return (\n

\n No leads yet — here's what scored leads look like.\n

\n {SAMPLE_LEADS.map((s) => )}\n

\n );\n }\n\n return (\n

\n {recent.length} {recent.length === 1 ? \"lead\" : \"leads\"} this week\n {qualified.length > 0 && ` · ${qualified.length} qualified`}\n

\n\n {recent.map((l) => )}\n\n {earlier.length > 0 && (\n

\n Earlier · {earlier.length} {earlier.length === 1 ? \"lead\" : \"leads\"}\n

\n {earlier.map((l) => (\n \n ))}\n

\n )}\n

\n );\n}\n",[],[220,326,342],"74d298f7-5965-473c-bf13-c7ede3e5dc98","App.tsx","019f4e53-354b-724f-878e-b0d73fd10ebd",["D",1783725503703],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { type Lead } from \"../../shared/types.ts\";\nimport { Dashboard } from \"./Dashboard.tsx\";\nimport { LeadDetail } from \"./LeadDetail.tsx\";\nimport { GithubTester } from \"./GithubTester.tsx\";\n\nexport function App(\n { initialLeads = [], webhookUrl = \"\", username = null }: {\n initialLeads?: Lead[];\n webhookUrl?: string;\n username?: string | null;\n },\n) {\n const [leads, setLeads] = React.useState(initialLeads);\n const [selectedId, setSelectedId] = React.useState(null);\n\n const refresh = React.useCallback(async () => {\n try {\n const res = await fetch(\"/api/leads\");\n if (res.ok) setLeads(await res.json());\n } catch (err) {\n console.error(\"Failed to refresh leads\", err);\n }\n }, []);\n\n // Poll only while something is still being researched.\n const hasProcessing = leads.some((l) => l.status === \"processing\");\n React.useEffect(() => {\n if (!hasProcessing) return;\n const timer = setInterval(refresh, 3000);\n return () => clearInterval(timer);\n }, [hasProcessing, refresh]);\n\n const selected = leads.find((l) => l.id === selectedId) ?? null;\n\n return (\n

\n {selected\n ? setSelectedId(null)} />\n : (\n <>\n

GitHub Leads

\n {username && (\n \n {username} ·{\" \"}\n \n \n )}\n

\n \n \n \n )}\n \n

\n );\n}\n",[],[220,326,349],"6973058f-b53a-4c95-a698-a086c6c1e174",["D",1783725503703],[247,248,249,250,251],[220,326],["D",1783725503703],[246,252,253],[220],"ebd9a265-7888-4b76-a36c-8417fc945c5a","notify.ts","019f4e53-354b-724f-878e-a9de4c2b09e8",["D",1783725503703],"import { httpEndpoint } from \"https://esm.town/v/std/utils/index.ts\";\nimport { IncomingWebhook } from \"npm:@slack/webhook\";\nimport { LeadOutput, QUALIFIED_SCORE } from \"../shared/types.ts\";\n\n// Set the SLACK_WEBHOOK_URL env var to get a Slack message the moment a lead\n// scores as qualified. Without it, this is a no-op.\n// https://docs.val.town/guides/slack/send-messages-to-slack/\nexport async function notifySlack(output: LeadOutput) {\n const webhookUrl = Deno.env.get(\"SLACK_WEBHOOK_URL\");\n if (!webhookUrl) return;\n if (typeof output.score !== \"number\" || output.score < QUALIFIED_SCORE) return;\n\n // Best-effort: a Slack hiccup should never fail (or retry) the lead scoring.\n try {\n const dashboardUrl = await httpEndpoint(\"main.ts\", import.meta.url);\n const who = [output.name, output.company].filter(Boolean).join(\" · \");\n await new IncomingWebhook(webhookUrl).send({\n text: [\n `🎯 Qualified lead (${output.score}): *${who || \"Unknown\"}*`,\n output.reasoning,\n `<${dashboardUrl}|Open dashboard>`,\n ].filter(Boolean).join(\"\\n\"),\n });\n } catch (err) {\n console.error(\"Slack notification failed:\", err);\n }\n}\n",[],[225,363],"3b53b219-b858-453a-b957-b578ddc00678","index.ts","019f4e53-354b-724f-878e-a4f6b2670ec4",9,["D",1783726140509],"import { getOAuthUserData } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal, readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono@4\";\nimport { toClientLead } from \"../shared/types.ts\";\nimport { processLead } from \"./agent.ts\";\nimport { claimLead, createProcessingLead, getAllLeads, getLeadById } from \"./db.ts\";\nimport { requireOrgMember } from \"./auth.tsx\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors so the platform surfaces the real error, not \"Internal Server Error\"\napp.onError((err) => Promise.reject(err));\n\n// Serialize every lead the same way for both the initial page load and the API.\nasync function clientLeads() {\n const now = Date.now();\n const rows = await getAllLeads();\n return rows.map((row) => toClientLead(row, now));\n}\n\n// ── Public webhook endpoints (no auth) ──\n\napp.post(\"/\", async (c) => {\n let body: Record;\n try {\n body = await c.req.json();\n } catch {\n return c.json({ ok: false, error: \"Request body must be valid JSON\" }, 400);\n }\n const url = new URL(c.req.url);\n const query = Object.fromEntries(url.searchParams);\n const inputData = Object.keys(query).length ? { ...body, _query: query } : body;\n\n // Create the lead immediately in a processing state and respond fast.\n const leadId = await createProcessingLead(inputData);\n\n // Fire-and-forget the slow scoring in a separate request.\n // https://docs.val.town/vals/http/early-return/\n fetch(`${url.origin}/process`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ leadId }),\n });\n\n return c.json({ ok: true, leadId });\n});\n\napp.post(\"/process\", async (c) => {\n const { leadId } = await c.req.json();\n // This route is public (registered before the auth guard) so POST / can call\n // it fire-and-forget. The atomic claim means each lead is scored exactly\n // once, and the input comes from the DB row — not the request — so this\n // can't be used to re-score, overwrite, or feed the agent forged data.\n if (!(await claimLead(leadId))) return c.json({ ok: false }, 409);\n const lead = await getLeadById(leadId);\n await processLead(leadId, JSON.parse(lead!.input_data));\n return c.json({ ok: true });\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ── Everything below requires an org member (the template preview allows GET) ──\napp.use(\"/*\", requireOrgMember);\n\n// Serve the React dashboard, bootstrapping the leads into the HTML so the list\n// paints immediately instead of flashing empty while the first fetch runs.\napp.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\");\n const session = await getOAuthUserData(c.req.raw);\n const data = {\n initialLeads: await clientLeads(),\n webhookUrl: new URL(c.req.url).origin,\n username: session?.user?.username ?? null,\n };\n // Escape \"<\" so lead content containing \"\" can't terminate the tag\n // early (which dumps raw JSON into the page and breaks hydration).\n const json = JSON.stringify(data).replace(/window.__INITIAL_DATA__ = ${json}`;\n html = html.replace(\"\", `${script}`);\n return c.html(html);\n});\n\n// JSON endpoint the frontend polls while leads are still processing.\napp.get(\"/api/leads\", async (c) => c.json(await clientLeads()));\n\n// Serve the frontend modules (/public/**) and shared types (/shared/**).\napp.get(\"/public/**/*\", (c) => serveFile(c.req.path.replace(\"/public\", \"/frontend\")));\napp.get(\"/shared/**/*\", (c) => serveFile(c.req.path));\n\nexport default app;\n",[],[225,370],"15766874-4618-411b-9192-436337b241e1","db.ts","019f4e53-354b-724f-878e-a3cc99eb9dc9",["D",1783725503703],"import sqlite from \"https://esm.town/v/std/db/main.ts\";\nimport { CLAIMED_OUTPUT } from \"../shared/types.ts\";\n\nconst TABLE_NAME = \"leads\";\n\nawait createTable();\n\nexport interface Lead {\n id: number;\n timestamp: number;\n input_data: string;\n output_data: string;\n}\n\nexport async function createProcessingLead(\n inputData: Record,\n): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (timestamp, input_data, output_data)\n VALUES (?, ?, ?)`,\n [Date.now(), JSON.stringify(inputData), \"\"],\n );\n return Number(result.lastInsertRowid);\n}\n\n// Atomically claim a just-created lead for scoring. Returns false if the\n// lead doesn't exist or was already claimed/finished, so concurrent /process\n// calls can't double-score (and double-spend on) the same lead.\nexport async function claimLead(id: number): Promise {\n const result = await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET output_data = ? WHERE id = ? AND output_data = ''`,\n [CLAIMED_OUTPUT, id],\n );\n return result.rowsAffected > 0;\n}\n\nexport async function updateLeadOutput(\n id: number,\n outputData: Record,\n) {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET output_data = ? WHERE id = ?`,\n [JSON.stringify(outputData), id],\n );\n}\n\nexport async function getAllLeads(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY timestamp DESC`,\n );\n return rowsToLeads(result);\n}\n\nexport async function getLeadById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE id = ?`,\n [id],\n );\n const leads = rowsToLeads(result);\n return leads[0] || null;\n}\n\n// Find an existing lead by the github_username stored in its input, so the\n// GitHub cron appends new activity to the same person instead of creating a\n// duplicate lead.\nexport async function findLeadByGithubUsername(\n login: string,\n): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME}\n WHERE json_extract(input_data, '$.github_username') = ?`,\n [login],\n );\n const leads = rowsToLeads(result);\n return leads[0] || null;\n}\n\n// Append new GitHub events to an existing lead's input, deduplicated by\n// event id so repeat sweeps don't grow the lead unboundedly.\nexport async function appendFollowup(\n id: number,\n newEvents: Array<{ id?: string }>,\n) {\n const lead = await getLeadById(id);\n if (!lead) return;\n const input = JSON.parse(lead.input_data);\n const events: Array<{ id?: string }> = Array.isArray(input.events) ? input.events : [];\n const existingIds = new Set(events.map((e) => e.id).filter(Boolean));\n events.push(...newEvents.filter((e) => !e.id || !existingIds.has(e.id)));\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET input_data = ? WHERE id = ?`,\n [JSON.stringify({ ...input, events }), id],\n );\n}\n\nfunction rowsToLeads(result: { columns: string[]; rows: unknown[] }): Lead[] {\n return result.rows.map((row: any) => {\n const obj: Record = {};\n result.columns.forEach((col, idx) => {\n obj[col] = row[idx];\n });\n return obj as Lead;\n });\n}\n\nasync function createTable() {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp INTEGER NOT NULL,\n input_data TEXT NOT NULL,\n output_data TEXT NOT NULL\n )`,\n );\n}\n\nexport function isProcessing(lead: Lead): boolean {\n return lead.output_data === \"\" || lead.output_data === CLAIMED_OUTPUT;\n}\n\nexport function isFailed(lead: Lead): boolean {\n if (isProcessing(lead)) return false;\n try {\n return Boolean(JSON.parse(lead.output_data).error);\n } catch {\n return true;\n }\n}\n",[],[225,378],"8ad6ace0-eeaa-400c-a046-6e867dc473b7","auth.tsx","019f4e53-354b-724f-878e-9c93bf2de69c",10,["D",1783726169429],"/** @jsxImportSource npm:hono@4/jsx */\nimport { getOAuthUserData } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The template's own live preview (owned by the \"templates\" org) is publicly\n// viewable. Your remix is owned by your org, so it requires login.\nconst IS_TEMPLATE_PREVIEW = parseVal().username === \"templates\";\n\n// Auth guard for the dashboard routes. Register the public webhook routes\n// (POST / and /process) BEFORE this so external systems can submit leads\n// without logging in.\nexport async function requireOrgMember(c: any, next: any) {\n if (IS_TEMPLATE_PREVIEW && c.req.method === \"GET\") return next();\n const session = await getOAuthUserData(c.req.raw);\n if (!session) return c.html();\n if (!session.isOrgMember) {\n return c.html(, 403);\n }\n await next();\n}\n\nfunction Shell({ title, children }: { title: string; children: any }) {\n return (\n \n \n \n \n {title}\n \n \n \n

\n {children}\n

\n \n \n );\n}\n\nfunction LoginPage() {\n return (\n \n

🔒

GitHub Leads Dashboard

\n \n $\"\"$ \n Sign in with Val Town\n \n

\n \n );\n}\n\nfunction UnauthorizedPage({ username }: { username: string }) {\n return (\n \n

⛔

Access Denied

\n You must be a member of this val's organization to view the dashboard.\n

\n Logged in as {username}\n

\n \n );\n}\n",[],[225,385],"7a1f22d3-59af-4347-894b-4aa01e38dc0a","agent.ts","019f4e53-354b-724f-878e-9912b409b7f0",["D",1783725503703],"import { ValTownOpenAI } from \"https://esm.town/v/std/openai/main.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { enrich } from \"https://esm.town/v/valdottown/peopledatalabs/sdk.ts\";\nimport OpenAI from \"npm:openai\";\nimport { updateLeadOutput } from \"./db.ts\";\nimport { notifySlack } from \"./notify.ts\";\n\n// Uses Val Town's built-in OpenAI proxy, so no API key setup is needed.\n// If you hit its rate limits, set the OPENAI_API_KEY env var to use your\n// own OpenAI account instead.\nconst apiKey = Deno.env.get(\"OPENAI_API_KEY\");\nconst openai = apiKey ? new OpenAI({ apiKey }) : new ValTownOpenAI({});\n\nconst PROMPT = await readFile(\"/PROMPT.md\");\n\n// Enrichment (person, LinkedIn, company, work history) via Val Town's\n// People Data Labs proxy. Pro accounts get $10/month included; free accounts\n// get 2 ever, then fall back to web search alone.\nasync function enrichLead(inputData: Record) {\n if (!inputData.email && !inputData.github_username) return {};\n try {\n const { data } = await enrich({\n email: inputData.email as string | undefined,\n github_username: inputData.github_username as string | undefined,\n });\n return data ? { enrichment: data } : {};\n } catch (err) {\n if (err.status === 401 || err.status === 403 || err.status === 429) {\n return {\n enrichmentNote:\n \"Enrichment quota reached — Val Town Pro includes $10/month (https://www.val.town/pricing)\",\n };\n }\n console.error(\"Enrichment failed:\", err);\n return { enrichmentNote: `Enrichment failed: ${err.message}` };\n }\n}\n\nexport async function processLead(\n leadId: number,\n inputData: Record,\n) {\n try {\n const { enrichment, enrichmentNote } = await enrichLead(inputData);\n const response = await openai.responses.create({\n model: \"gpt-5\",\n tools: [{ type: \"web_search\" }],\n instructions: PROMPT,\n input: JSON.stringify(enrichment ? { ...inputData, enrichment } : inputData),\n });\n if (response.status !== \"completed\") {\n throw new Error(`Model response ${response.status}: ${JSON.stringify(response.incomplete_details)}`);\n }\n // The prompt asks for bare JSON, but models sometimes wrap it in ```json fences\n const json = response.output_text.replace(/^\\s*```(?:json)?\\s*|\\s*```\\s*$/g, \"\");\n const outputData = { ...JSON.parse(json), ...(enrichmentNote && { enrichmentNote }) };\n await updateLeadOutput(leadId, outputData);\n await notifySlack(outputData);\n return { outputData };\n } catch (err) {\n // Record the failure so the dashboard shows it immediately instead of\n // spinning until the timeout. Log first so the root cause survives even if\n // this DB write itself throws.\n console.error(`Lead ${leadId} failed:`, err);\n const error = err instanceof Error ? err.message : String(err);\n await updateLeadOutput(leadId, { error });\n throw err;\n }\n}\n",[],[225,393],["D",1783725503703],[240,241,242,243,244],[225],["D",1783725503703],["D",1789526460011],{"_105":104,"_113":109},{"_105":104,"_106":107,"_108":109,"_18":-5,"_110":111,"_112":25},{"_13":90,"_33":91,"_44":43,"_92":45,"_93":94,"_95":96,"_97":51,"_98":99,"_100":101,"_102":46,"_103":104},"ctx",{"_83":-5,"_135":440,"_441":442,"_443":444,"_445":27,"_446":27,"_447":27,"_448":25,"_449":-5,"_450":-7,"_451":-7,"_452":64,"_453":27,"_454":27,"_455":-5,"_456":27,"_457":27,"_458":27,"_459":-5},"ENV",{"_411":412,"_413":414,"_415":91,"_416":417,"_418":419,"_420":421,"_422":423,"_424":425,"_426":427,"_428":429,"_430":431,"_432":433,"_434":435,"_436":437,"_438":439},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v41