[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_390":391,"_392":393},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_76":252,"_47":-7,"_253":-5,"_17":254,"_255":256,"_257":258,"_259":260,"_261":262,"_114":-5,"_263":-5,"_264":265,"_266":55,"_267":268,"_269":26,"_270":-5,"_271":-5,"_272":273},"routes/_app.x.$handle.$name.compare.$branch",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":30,"_31":32},"handle","std","name","openai","branchName","dollar-rate-limiting","project",{"_33":46,"_13":14,"_40":212,"_53":-5,"_213":26,"_56":57,"_214":57,"_35":-5,"_215":-5,"_216":217,"_218":-5,"_219":26,"_220":-5,"_221":-5,"_222":223,"_59":60,"_224":225,"_226":227,"_228":229,"_230":-5,"_231":232,"_233":234,"_235":234,"_236":234,"_237":234,"_238":232,"_239":232,"_240":241,"_242":243,"_244":28,"_54":55},"ahead",24,"behind",0,"diff",{"_67":68,"_69":70,"_71":72},"hasChanges",true,"sourceBranch",{"_47":62,"_13":16,"_33":63,"_45":46,"_49":39,"_50":48,"_64":57,"_65":46,"_66":60,"_61":14,"_58":12},"targetBranch",{"_33":39,"_40":41,"_42":43,"_13":44,"_45":46,"_47":48,"_49":-5,"_50":-5,"_51":52,"_53":-5,"_54":55,"_56":57,"_58":12,"_59":60,"_61":14},"pull",{"_33":34,"_35":36,"_37":38},"id","cc31261a-1fb7-4d1b-908c-18bed8ea57c2","description","Move from a rough heuristic (# of api calls per day) to actual dollar limits, so:\n\n1. It's more legible to users\n2. More legible to us\n3. Clearer that we're not losing money on this\n\n## TODOs\n\n1. Merge branch to main — merge_branch on dollar-rate-limiting\n2. Set custom subdomain — set_custom_subdomain on proxy/main.ts with subdomain std-openaiproxy and force: true (this is the actual cutover — every existing SDK import instantly hits the new proxy)\n3. Update main.ts SDK baseURL — Change back to https://std-openaiproxy.web.val.run/v1 (currently points at the branch's file-hash URL for testing)\n4. Confirm we're not seeing lots of errors on std/openaiproxy or the new proxy\n5. Archive std/openaiproxy ","state","pending","be1ce31c-25fe-11f0-b0b8-569c3dd06744","createdAt",["D",1746043648993],"updatedAt",["D",1785445784006],"main","projectId","be1ca424-25fe-11f0-b0b8-569c3dd06744","version",38,"forkedBranchId","forkedBranchVersion","lockfileKey","1785445784166-esm.town_v_std_openai@38-main","deletedAt","isOwned",false,"privacy","public","userHandle","orgId","c606f87f-4d7e-48c8-9c39-ef5ab94aec49","projectName",25,"a80aaeda-02f0-4886-bd9d-87ed4b354904","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","added",[142,143,144,145,146,147,148],"deleted",[],"modified",[73,74,75],{"_76":125,"_78":126,"_80":127},{"_76":108,"_78":109,"_80":110},{"_76":77,"_78":79,"_80":81},"path","main.ts","targetFile",{"_33":101,"_13":77,"_83":102,"_85":-5,"_86":39,"_87":62,"_89":26,"_40":103,"_47":104,"_92":93,"_94":105,"_69":55,"_96":-5,"_97":-7,"_76":106,"_99":107},"sourceFile",{"_33":82,"_13":77,"_83":84,"_85":-5,"_86":63,"_87":88,"_89":26,"_40":90,"_47":91,"_92":93,"_94":95,"_69":55,"_96":-5,"_97":-7,"_76":98,"_99":100},"f369695a-840d-4985-9bb2-58015fee4c7b","fileId","019fb4ea-df76-7108-899d-571b7c4b5996","parentId","branchId","branchVersion",5,"latest",["D",1785446871390],1,"fileType","script","content","import { type ClientOptions, OpenAI as RawOpenAI } from \"npm:openai\";\n\nexport class ValTownOpenAI extends RawOpenAI {\n constructor(options: ClientOptions) {\n super({\n ...options,\n // TODO: When we cut over, set the custom subdomain on proxy/main.ts\n // For now this points at the branch endpoint for testing.\n baseURL: \"https://std--7fb4e69e8c5d11f188fd1607ee4eb77e.web.val.run/v1\",\n apiKey: Deno.env.get(\"valtown\"),\n organization: null,\n });\n }\n}\n\nexport const OpenAI = ValTownOpenAI;","label","children",[77],"contentHash","f1264d15fb7fa2ba53eaad81139ab40a3e439b21a98aa97de6ffa3eb0f3f674c","ca588d84-3cf0-11f1-aa98-42b51c65c3df","74725d92-3cef-11f1-acc2-42b51c65c3df",["D",1776714030964],8,"import { type ClientOptions, OpenAI as RawOpenAI } from \"npm:openai\";\n\nexport class ValTownOpenAI extends RawOpenAI {\n constructor(options: ClientOptions) {\n super({\n ...options,\n baseURL: \"https://std-openaiproxy.web.val.run/v1\",\n apiKey: Deno.env.get(\"valtown\"),\n organization: null,\n });\n }\n}\n\nexport const OpenAI = ValTownOpenAI;",[77],"990389c3bdbd687a8aa6f14dc15e922df5373530ab04dbe8f5b56d8577c91a08","README.md",{"_33":118,"_13":108,"_83":119,"_85":-5,"_86":39,"_87":48,"_89":26,"_40":120,"_47":121,"_92":114,"_94":122,"_69":55,"_96":-5,"_97":-7,"_76":123,"_99":124},{"_33":111,"_13":108,"_83":112,"_85":-5,"_86":63,"_87":20,"_89":26,"_40":113,"_47":91,"_92":114,"_94":115,"_69":55,"_96":-5,"_97":-7,"_76":116,"_99":117},"ec92ad01-966e-4a1e-8e73-306ab025f4a6","019fb4ea-df76-7108-899d-52a56e2a413c",["D",1785449814411],"file","# std/openai - [Docs ↗](https://docs.val.town/std/openai)\n\nUse OpenAI's API with [`std/openai`](https://www.val.town/v/std/openai) — no API\nkey needed. The SDK wraps the OpenAI client and routes requests through Val\nTown's proxy, which tracks spend in real dollars.\n\n## Budgets\n\n| Tier | Monthly Budget |\n|------|---------------|\n| Free | $1 |\n| Pro | $10 |\n| Business | $40 |\n\nBudgets follow the val's owning org and reset on the 1st of each month (UTC).\nWhen you exceed your budget, the proxy returns `402` with your spend details.\n\nAny model in the pricing table is available to all users — the dollar budget is\nthe only limit. Streaming is not supported.\n\n## Basic Usage\n\n```ts title=\"Example\" val\nimport { OpenAI } from \"https://esm.town/v/std/openai/main.ts\";\n\nconst openai = new OpenAI();\n\nconst completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: \"Say hello in a creative way\" },\n ],\n model: \"gpt-5.6-luna\",\n max_completion_tokens: 100,\n});\n\nconsole.log(completion.choices[0].message.content);\n```\n\n## Bring Your Own API Key\n\nThe free proxy is great for getting started, but you may outgrow the budget.\nThe easiest upgrade path is to bring your own OpenAI API key — just set\n`OPENAI_API_KEY` and use the `npm:openai` client directly when it's available,\nfalling back to `ValTownOpenAI` otherwise. This way your val works with or\nwithout a key.\n\n```ts title=\"Bring Your Own Key\" val\nimport { ValTownOpenAI } from \"https://esm.town/v/std/openai/main.ts\";\nimport OpenAI from \"npm:openai\";\n\n// Use your own key if available, otherwise the Val Town proxy.\nconst apiKey = Deno.env.get(\"OPENAI_API_KEY\");\nconst openai = apiKey ? new OpenAI({ apiKey }) : new ValTownOpenAI({});\n\nconst completion = await openai.chat.completions.create({\n model: \"gpt-5.6-luna\",\n messages: [{ role: \"user\", content: \"Say hello in one word.\" }],\n});\n\nconsole.log(completion.choices[0].message.content);\n```\n\nSee the runnable example:\n[`examples/bring-your-own-key.ts`](https://www.val.town/x/std/openai/code/examples/bring-your-own-key.ts)\n\n## Responses API & Web Search\n\nThe Responses API (`responses.create`) is fully supported through the Val Town\nproxy. It enables the **web_search** tool, which lets the model browse the web\nin real time — incredibly effective for enrichment, research, and anything where\nfresh data beats stale training knowledge.\n\n```ts title=\"Web Search\" val\nimport { ValTownOpenAI } from \"https://esm.town/v/std/openai/main.ts\";\n\nconst openai = new ValTownOpenAI({});\n\nconst response = await openai.responses.create({\n model: \"gpt-5.6-luna\",\n tools: [{ type: \"web_search\" }],\n instructions:\n \"You research companies. Given a company name, reply in 2-3 short plain-text lines: what they do, their stage, and why a developer might care. No markdown.\",\n input: \"Val Town\",\n});\n\nconsole.log(response.output_text);\n```\n\nSee the runnable example:\n[`examples/web-search.ts`](https://www.val.town/x/std/openai/code/examples/web-search.ts)\n\n## Structured Outputs\n\nInstead of asking the model to \"return JSON\" and manually parsing the response,\npass a JSON schema in `text.format`. The model is constrained to output JSON\nthat matches your schema exactly — no fence stripping, no regex, no try/catch on\nmalformed JSON. This is the idiomatic approach for classification, scoring,\nextraction, routing, or any task where you need typed data back.\n\n```ts title=\"Structured Outputs\" val\nimport { ValTownOpenAI } from \"https://esm.town/v/std/openai/main.ts\";\n\nconst openai = new ValTownOpenAI({});\n\nconst response = await openai.responses.create({\n model: \"gpt-5.6-luna\",\n instructions:\n \"You classify user feedback. Given a piece of feedback, classify it and write a one-sentence summary.\",\n input:\n \"The app keeps logging me out every 5 minutes, it's really frustrating.\",\n text: {\n format: {\n type: \"json_schema\",\n name: \"classification\",\n schema: {\n type: \"object\",\n properties: {\n category: {\n type: \"string\",\n enum: [\"bug\", \"feature_request\", \"praise\", \"question\"],\n },\n priority: {\n type: \"string\",\n enum: [\"low\", \"medium\", \"high\"],\n },\n summary: { type: \"string\" },\n },\n required: [\"category\", \"priority\", \"summary\"],\n additionalProperties: false,\n },\n },\n },\n});\n\n// output_text is guaranteed valid JSON matching the schema.\nconst result = JSON.parse(response.output_text);\nconsole.log(result);\n```\n\nSee the runnable example:\n[`examples/structured-outputs.ts`](https://www.val.town/x/std/openai/code/examples/structured-outputs.ts)\n\n## Images\n\nTo send an image to ChatGPT, the easiest way is by converting it to a data URL,\nwhich is easiest to do with\n[@stevekrouse/fileToDataURL](https://www.val.town/v/stevekrouse/fileToDataURL).\n\n## OpenAI Agents SDK\n\nThe [OpenAI Agents SDK](https://openai.github.io/openai-agents-js/) works with\n`std/openai` too, including hosted tools like web search:\n\n```ts title=\"Agents Example\" val\nimport { ValTownOpenAI } from \"https://esm.town/v/std/openai/main.ts\";\nimport {\n Agent,\n run,\n setDefaultOpenAIClient,\n setTracingDisabled,\n webSearchTool,\n} from \"npm:@openai/agents\";\n\nsetTracingDisabled(true); // tracing requires your own OpenAI key\nsetDefaultOpenAIClient(new ValTownOpenAI({}));\n\nconst agent = new Agent({\n name: \"Researcher\",\n tools: [webSearchTool()],\n});\n\nconst result = await run(agent, \"What's new in Val Town?\");\nconsole.log(result.finalOutput);\n```\n\n## Available Models\n\nPricing per 1M tokens (Standard tier). See the full table in\n[`pricing.ts`](https://www.val.town/x/std/openai/code/pricing.ts).\n\n| Model | Input | Cached Input | Output |\n|-------|-------|-------------|--------|\n| gpt-5.6-luna | $0.20 | $0.02 | $1.20 |\n| gpt-5.4-nano | $0.20 | $0.02 | $1.25 |\n| gpt-5.4-mini | $0.75 | $0.075 | $4.50 |\n| gpt-5.6-terra | $2.00 | $0.20 | $12.00 |\n| gpt-5.4 | $2.50 | $0.25 | $15.00 |\n| gpt-5.6-sol | $5.00 | $0.50 | $30.00 |\n| gpt-5.5 | $5.00 | $0.50 | $30.00 |\n| gpt-5.4-pro | $30.00 | — | $180.00 |\n| gpt-5.5-pro | $30.00 | — | $180.00 |\n\nIf these limits are too low, you can [bring your own API key](#bring-your-own-api-key).\n\n[📝 Edit docs](https://github.com/val-town/val-town-docs/edit/main/src/content/docs/std/openai.mdx)\n",[108],"91df345b1e40e137fa90dc74852e2a4786378b2dcd58054b31b672007dce72b1","c1106d88-28ea-4344-8d69-c128f2f21ecb","be1ee658-25fe-11f0-b0b8-569c3dd06744",["D",1785445784006],16,"# std/openai - [Docs ↗](https://docs.val.town/std/openai)\n\nUse OpenAI's chat completion API with\n[`std/openai`](https://www.val.town/v/std/openai). This integration enables\naccess to OpenAI's language models without needing to acquire API keys.\n\nVal Town free users can use any affordable model – such as `gpt-5.6-luna`. Val\nTown Pro users can make 10 expensive requests (e.g. `gpt-5.6-sol`) per rolling\n24-hour window, and are then bumped down to `gpt-5.6-luna`.\n\nThis SDK is powered by\n[our openapiproxy](https://www.val.town/x/std/openaiproxy).\n\n## Basic Usage\n\n```ts title=\"Example\" val\nimport { OpenAI } from \"https://esm.town/v/std/openai/main.ts\";\n\nconst openai = new OpenAI();\n\nconst completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: \"Say hello in a creative way\" },\n ],\n model: \"gpt-5.6-luna\",\n max_completion_tokens: 100,\n});\n\nconsole.log(completion.choices[0].message.content);\n```\n\n## Bring Your Own API Key\n\nThe free proxy is great for getting started, but you may outgrow the rate\nlimits. The easiest upgrade path is to bring your own OpenAI API key — just set\n`OPENAI_API_KEY` and use the `npm:openai` client directly when it's available,\nfalling back to `ValTownOpenAI` otherwise. This way your val works with or\nwithout a key.\n\n```ts title=\"Bring Your Own Key\" val\nimport { ValTownOpenAI } from \"https://esm.town/v/std/openai/main.ts\";\nimport OpenAI from \"npm:openai\";\n\n// Use your own key if available, otherwise the Val Town proxy.\nconst apiKey = Deno.env.get(\"OPENAI_API_KEY\");\nconst openai = apiKey ? new OpenAI({ apiKey }) : new ValTownOpenAI({});\n\nconst completion = await openai.chat.completions.create({\n model: \"gpt-5.6-luna\",\n messages: [{ role: \"user\", content: \"Say hello in one word.\" }],\n});\n\nconsole.log(completion.choices[0].message.content);\n```\n\nSee the runnable example:\n[`examples/bring-your-own-key.ts`](https://www.val.town/x/std/openai/code/examples/bring-your-own-key.ts)\n\n## Responses API & Web Search\n\nThe Responses API (`responses.create`) is fully supported through the Val Town\nproxy. It enables the **web_search** tool, which lets the model browse the web\nin real time — incredibly effective for enrichment, research, and anything where\nfresh data beats stale training knowledge.\n\n```ts title=\"Web Search\" val\nimport { ValTownOpenAI } from \"https://esm.town/v/std/openai/main.ts\";\n\nconst openai = new ValTownOpenAI({});\n\nconst response = await openai.responses.create({\n model: \"gpt-5.6-luna\",\n tools: [{ type: \"web_search\" }],\n instructions:\n \"You research companies. Given a company name, reply in 2-3 short plain-text lines: what they do, their stage, and why a developer might care. No markdown.\",\n input: \"Val Town\",\n});\n\nconsole.log(response.output_text);\n```\n\nSee the runnable example:\n[`examples/web-search.ts`](https://www.val.town/x/std/openai/code/examples/web-search.ts)\n\n## Structured Outputs\n\nInstead of asking the model to \"return JSON\" and manually parsing the response,\npass a JSON schema in `text.format`. The model is constrained to output JSON\nthat matches your schema exactly — no fence stripping, no regex, no try/catch on\nmalformed JSON. This is the idiomatic approach for classification, scoring,\nextraction, routing, or any task where you need typed data back.\n\n```ts title=\"Structured Outputs\" val\nimport { ValTownOpenAI } from \"https://esm.town/v/std/openai/main.ts\";\n\nconst openai = new ValTownOpenAI({});\n\nconst response = await openai.responses.create({\n model: \"gpt-5.6-luna\",\n instructions:\n \"You classify user feedback. Given a piece of feedback, classify it and write a one-sentence summary.\",\n input:\n \"The app keeps logging me out every 5 minutes, it's really frustrating.\",\n text: {\n format: {\n type: \"json_schema\",\n name: \"classification\",\n schema: {\n type: \"object\",\n properties: {\n category: {\n type: \"string\",\n enum: [\"bug\", \"feature_request\", \"praise\", \"question\"],\n },\n priority: {\n type: \"string\",\n enum: [\"low\", \"medium\", \"high\"],\n },\n summary: { type: \"string\" },\n },\n required: [\"category\", \"priority\", \"summary\"],\n additionalProperties: false,\n },\n },\n },\n});\n\n// output_text is guaranteed valid JSON matching the schema.\nconst result = JSON.parse(response.output_text);\nconsole.log(result);\n```\n\nSee the runnable example:\n[`examples/structured-outputs.ts`](https://www.val.town/x/std/openai/code/examples/structured-outputs.ts)\n\n## Images\n\nTo send an image to ChatGPT, the easiest way is by converting it to a data URL,\nwhich is easiest to do with\n[@stevekrouse/fileToDataURL](https://www.val.town/v/stevekrouse/fileToDataURL).\n\n```ts title=\"Image Example\" val\nimport { fileToDataURL } from \"https://esm.town/v/stevekrouse/fileToDataURL\";\n\nconst dataURL = await fileToDataURL(file);\nconst response = await chat([\n {\n role: \"system\",\n content: `You are an nutritionist. \n Estimate the calories.\n We only need a VERY ROUGH estimate.\n Respond ONLY in a JSON array with values conforming to: {ingredient: string, calories: number}\n `,\n },\n {\n role: \"user\",\n content: [{\n type: \"image_url\",\n image_url: {\n url: dataURL,\n },\n }],\n },\n], {\n model: \"gpt-5.6-luna\",\n max_completion_tokens: 200,\n});\n```\n\n## OpenAI Agents SDK\n\nThe [OpenAI Agents SDK](https://openai.github.io/openai-agents-js/) works with\n`std/openai` too, including hosted tools like web search:\n\n```ts title=\"Agents Example\" val\nimport { ValTownOpenAI } from \"https://esm.town/v/std/openai/main.ts\";\nimport {\n Agent,\n run,\n setDefaultOpenAIClient,\n setTracingDisabled,\n webSearchTool,\n} from \"npm:@openai/agents\";\n\nsetTracingDisabled(true); // tracing requires your own OpenAI key\nsetDefaultOpenAIClient(new ValTownOpenAI({}));\n\nconst agent = new Agent({\n name: \"Researcher\",\n tools: [webSearchTool()],\n});\n\nconst result = await run(agent, \"What's new in Val Town?\");\nconsole.log(result.finalOutput);\n```\n\n## Limits\n\nWhile our wrapper simplifies the integration of OpenAI, there are a few\nlimitations to keep in mind:\n\n- **Usage Quota**: We limit each user to 100 requests per day.\n- **Features**: Chat completions and the Responses API are the only endpoints\n available. The Responses API supports the `web_search` tool and structured\n outputs (`text.format` with `json_schema`).\n\nIf these limits are too low, let us know! You can also get around the limitation\nby [bringing your own API key](#bring-your-own-api-key).\n\n[📝 Edit docs](https://github.com/val-town/val-town-docs/edit/main/src/content/docs/std/openai.mdx)",[108],"68db104f364704ea85c1bf61ab866e3c096401f8ae0837d2f2a787c75681e3f1","AGENTS.md",{"_33":135,"_13":125,"_83":136,"_85":-5,"_86":39,"_87":137,"_89":26,"_40":138,"_47":91,"_92":114,"_94":139,"_69":55,"_96":-5,"_97":-7,"_76":140,"_99":141},{"_33":128,"_13":125,"_83":129,"_85":-5,"_86":63,"_87":62,"_89":26,"_40":130,"_47":131,"_92":114,"_94":132,"_69":55,"_96":-5,"_97":-7,"_76":133,"_99":134},"8f07f093-d16a-43e0-b337-331c5d9c71df","019fb4ea-df76-7108-899d-4c0be1bf7963",["D",1785449822893],2,"# std/openai\n\nClient SDK for using OpenAI's API through Val Town's proxy. No API key needed.\n\n## File Map\n\n| File | Type | Description |\n|------|------|-------------|\n| `main.ts` | script | `ValTownOpenAI` class — extends OpenAI SDK to use Val Town's proxy automatically |\n| `main.tsx` | script | Backward compatibility re-export from `main.ts` |\n| `pricing.ts` | script | Model pricing table ($/1M tokens) + budget tiers + cost calculation |\n| `ledger.ts` | script | Dollar-based spend tracking in project-scoped SQLite (openai_spend + openai_monthly_budget tables) |\n| `proxy/main.ts` | http | **New proxy** — authenticates users, enforces dollar budgets, records actual spend |\n| `dashboard.tsx` | http | Spend dashboard — per-subject monthly spend vs budget |\n| `tests/integration.ts` | script | Integration tests (run on demand with `run_file`) |\n| `examples/web-search.ts` | script | Example: web search via Responses API |\n| `examples/structured-outputs.ts` | script | Example: structured outputs with JSON schema |\n| `examples/bring-your-own-key.ts` | script | Example: using your own OpenAI API key with fallback to proxy |\n| `README.md` | file | User-facing documentation |\n| `AGENTS.md` | file | This file |\n\n## Architecture (dollar-rate-limiting branch)\n\nThe proxy has been moved from `std/openaiproxy` into this val (`proxy/main.ts`) to use project-scoped SQLite.\n\n### How rate limiting works now\n\n1. User's val calls OpenAI via the SDK → proxy authenticates via `/v1/me` → identifies the val's owning org + tier\n2. Pre-flight check: has this subject (user or org) exceeded their monthly dollar budget?\n3. Budgets (per calendar month, UTC):\n - free: $1/month\n - pro: $10/month\n - business: $40/month\n4. If over budget → 402 with remaining-budget info\n5. Proxy to OpenAI, parse response usage, calculate cost in microdollars\n6. Record spend (fire-and-forget, doesn't add to request latency)\n\n### What was removed (vs old openaiproxy)\n\n- ❌ Request count limits (was 100/day) — dollars are the only guard now\n- ❌ Model gating (was: free users forced to cheap models, pro users get 10 expensive requests) — any priced model is allowed, budget is the guard\n- ❌ Streaming support — rejected with 400 (simplifies usage extraction)\n- ❌ Unknown models allowed — now rejected with 400 (never free-by-accident)\n\n### Cost calculation\n\n- Prices stored as USD per 1M tokens in `pricing.ts` (readable, easy to update)\n- Cost calculated in **microdollars** (integer) to avoid floating-point issues\n- Formula: `cost_microdollars = round(tokens × price_per_1M)` (works because $/1M × tokens = microdollars directly)\n\n### SQLite tables\n\n- `openai_spend` — append-only ledger: subject, model, token counts, cost, timestamp\n- `openai_monthly_budget` — aggregate: subject_id × month → spent_microdollars (for fast pre-flight checks)\n\nBoth use project-scoped SQLite (`std/sqlite/main.ts`), not the deprecated global DB.\n\n## Environment Variables\n\n- `OPENAI_API_KEY` — OpenAI API key (needs to be added to this val before cutover)\n- `OPENAI_API_ORG` — OpenAI organization ID (needs to be added to this val before cutover)\n\n## Cutover plan\n\n1. ✅ Build proxy on `dollar-rate-limiting` branch\n2. ⬜ Add `OPENAI_API_KEY` + `OPENAI_API_ORG` env vars to this val\n3. ⬜ Merge branch to main\n4. ⬜ Set custom subdomain `std-openaiproxy` on `proxy/main.ts` (with `force: true`)\n5. ⬜ Archive `std/openaiproxy`\n\n## Related Vals\n\n- [std/openaiproxy](https://www.val.town/x/std/openaiproxy) — Old proxy (to be archived after cutover)\n",[125],"72c0fb24b6abcb0de173cbd93f92955e099c147823f897f72fc9efd8426fd962","b998350b-bdc8-4910-bee9-7ae24c226dc3","43955404-8c59-11f1-a4eb-1607ee4eb77e",32,["D",1785445508044],"# std/openai\n\nClient SDK for using OpenAI's API through Val Town's proxy (std/openaiproxy). No API key needed.\n\n## File Map\n\n| File | Type | Description |\n|------|------|-------------|\n| `main.ts` | script | `ValTownOpenAI` class — extends OpenAI SDK to use Val Town's proxy automatically |\n| `main.tsx` | script | Backward compatibility re-export from `main.ts` |\n| `examples/web-search.ts` | script | Example: web search via Responses API |\n| `examples/structured-outputs.ts` | script | Example: structured outputs with JSON schema |\n| `examples/bring-your-own-key.ts` | script | Example: using your own OpenAI API key with fallback to proxy |\n| `README.md` | file | User-facing documentation |\n| `AGENTS.md` | file | This file |\n\n## Architecture\n\n- `main.ts` exports `ValTownOpenAI` (aliased as `OpenAI`) which extends the `npm:openai` client, overriding `baseURL` to point at the proxy and `apiKey` to use the Val Town session token.\n- All requests go through `std/openaiproxy`, which injects the real OpenAI API key and enforces rate limits / model restrictions.\n- Free users: limited to cheap models (`gpt-5.4-nano`, `gpt-5.6-luna`).\n- Pro users: 10 expensive model requests per rolling 24h, then bumped down to `gpt-5.6-luna`.\n- Rate limit: 100 requests per day per user.\n\n## Related Vals\n\n- [std/openaiproxy](https://www.val.town/x/std/openaiproxy) — The proxy backend that this SDK connects to\n",[125],"cccdf2b6bafcd563268ef2826ab39abd5b169730489bec5bbb33c026c09dc18f",{"_76":203,"_78":-7,"_80":204},{"_76":194,"_78":-7,"_80":195},{"_76":185,"_78":-7,"_80":186},{"_76":179,"_78":-7,"_80":180},{"_76":168,"_78":-7,"_80":169},{"_76":161,"_78":-7,"_80":162},{"_76":149,"_78":-7,"_80":150},"tests/integration.ts",{"_33":151,"_13":152,"_83":153,"_85":154,"_86":63,"_87":155,"_89":26,"_40":156,"_47":157,"_92":93,"_94":158,"_69":55,"_96":-5,"_97":-7,"_76":159,"_99":160},"10a5dd82-9daf-46d5-bc45-6c5059055f00","integration.ts","56cdfbe8-8c5e-11f1-a52a-1607ee4eb77e","622d9d61-914e-4390-9281-9d8b62dbb1a3",18,["D",1785449381929],3,"import { httpEndpoint } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst endpoint = await httpEndpoint(\"proxy/main.ts\");\nconst token = Deno.env.get(\"valtown\");\n\ntype TestResult = { name: string; passed: boolean; error?: string };\nconst results: TestResult[] = [];\n\nasync function test(name: string, fn: () => Promise) {\n try {\n await fn();\n results.push({ name, passed: true });\n console.log(`✅ ${name}`);\n } catch (e) {\n const msg = e instanceof Error ? e.message : String(e);\n results.push({ name, passed: false, error: msg });\n console.log(`❌ ${name}: ${msg}`);\n }\n}\n\nfunction assert(condition: boolean, message: string) {\n if (!condition) throw new Error(message);\n}\n\n// --- Backward compatibility tests (same API surface as old proxy) ---\n\n// 1. Unsupported path returns 404\nawait test(\"unsupported path returns 404\", async () => {\n const res = await fetch(`${endpoint}/v1/foo`);\n assert(res.status === 404, `Expected 404, got ${res.status}`);\n});\n\n// 2. No auth returns 401\nawait test(\"no auth returns 401\", async () => {\n const res = await fetch(`${endpoint}/v1/chat/completions`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ model: \"gpt-5.6-luna\", messages: [] }),\n });\n assert(res.status === 401, `Expected 401, got ${res.status}`);\n});\n\n// 3. Invalid auth returns 401\nawait test(\"invalid auth returns 401\", async () => {\n const res = await fetch(`${endpoint}/v1/chat/completions`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": \"Bearer invalid-token\",\n },\n body: JSON.stringify({ model: \"gpt-5.6-luna\", messages: [] }),\n });\n assert(res.status === 401, `Expected 401, got ${res.status}`);\n});\n\n// 4. Chat completions succeeds (backward compat: same API surface)\nawait test(\"chat completions succeeds\", async () => {\n const res = await fetch(`${endpoint}/v1/chat/completions`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${token}`,\n },\n body: JSON.stringify({\n model: \"gpt-5.6-luna\",\n messages: [{ role: \"user\", content: \"Say hello in one word\" }],\n max_completion_tokens: 10,\n }),\n });\n const body = await res.text();\n assert(res.status === 200, `Expected 200, got ${res.status}: ${body}`);\n const data = JSON.parse(body);\n assert(data.choices?.[0]?.message?.content, \"No message content in response\");\n // Verify spend header is present\n const remaining = res.headers.get(\"x-vt-openai-spend-remaining\");\n assert(remaining !== null, \"Missing x-vt-openai-spend-remaining header\");\n});\n\n// 5. Responses API succeeds (backward compat: same API surface)\nawait test(\"responses API succeeds\", async () => {\n const res = await fetch(`${endpoint}/v1/responses`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${token}`,\n },\n body: JSON.stringify({\n model: \"gpt-5.6-luna\",\n input: \"Say hello in one word\",\n }),\n });\n const body = await res.text();\n assert(res.status === 200, `Expected 200, got ${res.status}: ${body}`);\n const data = JSON.parse(body);\n const outputMsg = data.output?.find((o: { type: string }) => o.type === \"message\");\n const text = outputMsg?.content?.find((c: { type: string }) => c.type === \"output_text\")?.text;\n assert(text, `No output text in response. Body: ${body.slice(0, 500)}`);\n});\n\n// 6. SDK backward compatibility — ValTownOpenAI works end-to-end\nawait test(\"ValTownOpenAI SDK works end-to-end\", async () => {\n const { ValTownOpenAI } = await import(\"../main.ts\");\n const client = new ValTownOpenAI({});\n const response = await client.chat.completions.create({\n model: \"gpt-5.6-luna\",\n messages: [{ role: \"user\", content: \"Say hello in one word\" }],\n max_completion_tokens: 10,\n });\n assert(\n response.choices[0].message.content,\n \"No message content from SDK response\",\n );\n});\n\n// --- New behavior tests ---\n\n// 7. Streaming rejected with 400\nawait test(\"streaming rejected with 400\", async () => {\n const res = await fetch(`${endpoint}/v1/chat/completions`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${token}`,\n },\n body: JSON.stringify({\n model: \"gpt-5.6-luna\",\n messages: [{ role: \"user\", content: \"Hi\" }],\n stream: true,\n }),\n });\n assert(res.status === 400, `Expected 400, got ${res.status}`);\n const data = await res.json();\n assert(\n data.error?.toLowerCase().includes(\"stream\"),\n `Expected streaming error, got: ${data.error}`,\n );\n});\n\n// 8. Unknown model rejected with 400\nawait test(\"unknown model rejected with 400\", async () => {\n const res = await fetch(`${endpoint}/v1/chat/completions`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${token}`,\n },\n body: JSON.stringify({\n model: \"gpt-999-turbo\",\n messages: [{ role: \"user\", content: \"Hi\" }],\n }),\n });\n assert(res.status === 400, `Expected 400, got ${res.status}`);\n const data = await res.json();\n assert(\n data.error?.includes(\"pricing table\"),\n `Expected pricing error, got: ${data.error}`,\n );\n assert(\n Array.isArray(data.available) && data.available.length > 0,\n \"Expected available models list\",\n );\n});\n\n// 9. Spend recorded in SQLite after successful request\nawait test(\"spend recorded in SQLite\", async () => {\n // Give the fire-and-forget write time to complete\n await new Promise((r) => setTimeout(r, 2000));\n\n const result = await sqlite.execute({\n sql: `SELECT COUNT(*) as count, SUM(cost) as total\n FROM openai_spend\n WHERE timestamp > datetime('now', '-5 minutes')`,\n args: [],\n });\n const count = Number(result.rows[0][0]);\n const total = Number(result.rows[0][1] ?? 0);\n assert(count > 0, \"No spend records found in the last 5 minutes\");\n assert(total > 0, \"Spend total is zero — cost was not recorded\");\n console.log(` Found ${count} spend records, total cost: ${total.toFixed(8)}`);\n});\n\n// Summary\nconst passed = results.filter((r) => r.passed).length;\nconst failed = results.length - passed;\nconsole.log(\n `\\n${passed}/${results.length} tests passed${failed ? `, ${failed} failed` : \"\"}`,\n);\n",[161,152],"3e5b7c8c4db29a4e79a3c88859b0b9ee7edf3dae6335b8ee398efae6d8346253","tests",{"_33":163,"_13":161,"_83":154,"_85":-5,"_86":63,"_87":164,"_89":26,"_40":165,"_47":22,"_92":166,"_94":-5,"_69":55,"_96":-5,"_97":-7,"_76":167,"_99":-5},"df6180ff-2070-4390-aa62-b2d7df767d75",7,["D",1785447223616],"directory",[161],"proxy/main.ts",{"_33":170,"_13":77,"_83":171,"_85":172,"_86":63,"_87":173,"_89":26,"_40":174,"_47":164,"_92":175,"_94":176,"_69":55,"_96":-5,"_97":-7,"_76":177,"_99":178},"d5598d81-9b81-47d0-8120-d3f895fead29","7fb4e69e-8c5d-11f1-88fd-1607ee4eb77e","95bed124-9bf3-479e-9c36-fdd2f6dcc960",22,["D",1785449814395],"http","import { parseBearerString } from \"https://esm.town/v/andreterron/parseBearerString\";\nimport { API_URL } from \"https://esm.town/v/std/API_URL?v=5\";\nimport { hasPricing, PRICING, calculateCost } from \"../pricing.ts\";\nimport {\n initSchema,\n checkBudget,\n recordSpend,\n type Subject,\n} from \"../ledger.ts\";\n\n/**\n * OpenAI API proxy with dollar-based rate limiting.\n *\n * Replaces std/openaiproxy. Moved into std/openai to use project-scoped SQLite.\n *\n * Simplifications vs old proxy:\n * - No streaming (rejected with 400)\n * - No model gating — any priced model is allowed, budget is the guard\n * - No request count limits — dollars are the only limit\n * - Unknown models rejected (400) — never free-by-accident\n *\n * Budgets (per calendar month, UTC):\n * - free: $1\n * - pro: $10\n * - business: $40\n *\n * Budget follows the val's owning org (from /v1/me).\n *\n * Env vars (add to std/openai before cutover):\n * - OPENAI_API_KEY\n * - OPENAI_API_ORG\n */\n\nconst allowedPathnames = [\n \"/\",\n \"/v1/chat/completions\",\n \"/v1/responses\",\n \"/v1/embeddings\",\n];\n\nlet schemaInitialized = false;\n\nexport default async function(req: Request): Promise {\n if (!schemaInitialized) {\n await initSchema();\n schemaInitialized = true;\n }\n\n const { pathname, search } = new URL(req.url);\n\n if (pathname === \"/\") {\n return new Response(\"OK\");\n }\n\n if (!allowedPathnames.includes(pathname)) {\n return new Response(\"Path not supported\", { status: 404 });\n }\n\n // --- Authenticate ---\n const authHeader = req.headers.get(\"Proxy-Authorization\") ||\n req.headers.get(\"Authorization\");\n const token = authHeader ? parseBearerString(authHeader) : undefined;\n const meRes = await fetch(`${API_URL}/v1/me`, {\n headers: { Authorization: `Bearer ${token}` },\n });\n if (!meRes.ok) {\n return new Response(\"Unauthorized\", { status: 401 });\n }\n const me = await meRes.json();\n\n // --- Determine budget subject (the val's owning org) ---\n // /v1/me returns the org directly when the token belongs to an org-owned val:\n // { id, type: \"org\", username: \"std\", tier: \"pro\", ... }\n // For personal vals, type is \"user\".\n const subject: Subject = me.type === \"org\"\n ? {\n id: me.id,\n type: \"org\",\n handle: me.username,\n tier: me.tier ?? \"free\",\n }\n : {\n id: me.id,\n type: \"user\",\n handle: me.username,\n tier: me.tier ?? \"free\",\n };\n\n // --- Pre-flight budget check ---\n const budget = await checkBudget(subject);\n if (budget.exceeded) {\n return jsonResponse(\n {\n error: \"Monthly budget exceeded\",\n spent: formatUSD(budget.spent),\n budget: formatUSD(budget.budget),\n resets: \"next calendar month (UTC)\",\n },\n 402,\n { \"x-vt-openai-spend-remaining\": \"0\" },\n );\n }\n\n // --- Parse request body ---\n let body: Record;\n try {\n body = await req.json();\n } catch {\n return jsonResponse({ error: \"Invalid JSON body\" }, 400);\n }\n\n // --- Reject streaming ---\n if (body.stream === true) {\n return jsonResponse(\n { error: \"Streaming is not supported. Set stream: false or omit it.\" },\n 400,\n );\n }\n\n // --- Reject unknown models ---\n const model = body.model as string | undefined;\n if (!model || !hasPricing(model)) {\n return jsonResponse(\n {\n error: `Model '${model}' is not in the pricing table.`,\n available: Object.keys(PRICING),\n },\n 400,\n );\n }\n\n // --- Proxy to OpenAI ---\n const url = new URL(\".\" + pathname, \"https://api.openai.com\");\n url.search = search;\n\n const headers = new Headers(req.headers);\n headers.set(\"Host\", url.hostname);\n headers.set(\"Authorization\", `Bearer ${Deno.env.get(\"OPENAI_API_KEY\")}`);\n headers.set(\"OpenAI-Organization\", Deno.env.get(\"OPENAI_API_ORG\") ?? \"\");\n headers.delete(\"Proxy-Authorization\");\n\n const openAIRes = await fetch(url, {\n method: req.method,\n headers,\n body: JSON.stringify(body),\n redirect: \"manual\",\n });\n\n // Copy response headers (fetch response headers are immutable in Deno)\n const responseHeaders = new Headers(openAIRes.headers);\n responseHeaders.delete(\"openai-organization\");\n\n // --- Pass through non-200 responses without recording spend ---\n if (openAIRes.status !== 200) {\n return new Response(openAIRes.body, {\n status: openAIRes.status,\n headers: responseHeaders,\n });\n }\n\n // --- Parse response to extract usage ---\n const responseText = await openAIRes.text();\n let responseData: Record;\n try {\n responseData = JSON.parse(responseText);\n } catch {\n // Can't parse — return as-is\n return new Response(responseText, {\n status: openAIRes.status,\n headers: responseHeaders,\n });\n }\n\n // --- Extract usage and record spend ---\n const usage = extractUsage(pathname, responseData);\n let cost = 0;\n if (usage) {\n cost = calculateCost(\n model,\n usage.input,\n usage.cached,\n usage.output,\n );\n // Fire-and-forget — don't add to request latency\n recordSpend(subject, model, usage.input, usage.cached, usage.output)\n .catch((e) => console.error(\"Failed to record spend:\", e));\n }\n\n // --- Return response with spend header ---\n const remainingAfter = Math.max(\n 0,\n budget.remaining - cost,\n );\n const res = new Response(responseText, {\n status: openAIRes.status,\n headers: responseHeaders,\n });\n res.headers.set(\"x-vt-openai-spend-remaining\", String(remainingAfter));\n return res;\n}\n\n/**\n * Extract token usage from different OpenAI API response formats.\n *\n * Chat completions: usage.prompt_tokens, usage.completion_tokens,\n * usage.prompt_tokens_details.cached_tokens\n * Responses API: usage.input_tokens, usage.output_tokens,\n * usage.input_tokens_details.cached_tokens\n * Embeddings: usage.prompt_tokens (output is always 0)\n */\nfunction extractUsage(\n pathname: string,\n data: Record,\n): { input: number; cached: number; output: number } | null {\n const usage = data.usage as Record | undefined;\n if (!usage) return null;\n\n if (pathname === \"/v1/responses\") {\n const inputDetails = usage.input_tokens_details as\n | Record\n | undefined;\n return {\n input: Number(usage.input_tokens) || 0,\n cached: Number(inputDetails?.cached_tokens) || 0,\n output: Number(usage.output_tokens) || 0,\n };\n }\n\n // Chat completions + embeddings share the same shape\n const promptDetails = usage.prompt_tokens_details as\n | Record\n | undefined;\n return {\n input: Number(usage.prompt_tokens) || 0,\n cached: Number(promptDetails?.cached_tokens) || 0,\n output: Number(usage.completion_tokens) || 0,\n };\n}\n\nfunction jsonResponse(\n body: unknown,\n status: number,\n extraHeaders?: Record,\n): Response {\n const headers: Record = {\n \"Content-Type\": \"application/json\",\n ...extraHeaders,\n };\n return new Response(JSON.stringify(body), { status, headers });\n}\n\nfunction formatUSD(amount: number): string {\n return `${amount.toFixed(2)}`;\n}\n",[179,77],"a4b5e581176e4eb91e8118ff08f844e5bf67f3dd98e1906b87b264e36eec2050","proxy",{"_33":181,"_13":179,"_83":172,"_85":-5,"_86":63,"_87":182,"_89":26,"_40":183,"_47":22,"_92":166,"_94":-5,"_69":55,"_96":-5,"_97":-7,"_76":184,"_99":-5},"1743ee63-eb5b-464e-86fa-568997e2f840",4,["D",1785446862743],[179],"pricing.ts",{"_33":187,"_13":185,"_83":188,"_85":-5,"_86":63,"_87":189,"_89":26,"_40":190,"_47":131,"_92":93,"_94":191,"_69":55,"_96":-5,"_97":-7,"_76":192,"_99":193},"fb9d05aa-b531-467d-a480-b1b9d80b1f52","371fabe4-8c5d-11f1-82b4-1607ee4eb77e",21,["D",1785449741596],"/**\n * ┌──────────────────┬────────────┬────────────┬─────────────┐\n * │ Model │ Input $/1M │ Cached $/1M│ Output $/1M │\n * ├──────────────────┼────────────┼────────────┼─────────────┤\n * │ gpt-5.6-sol │ 5.00 │ 0.50 │ 30.00 │\n * │ gpt-5.6-terra │ 2.00 │ 0.20 │ 12.00 │\n * │ gpt-5.6-luna │ 0.20 │ 0.02 │ 1.20 │\n * │ gpt-5.5 │ 5.00 │ 0.50 │ 30.00 │\n * │ gpt-5.5-pro │ 30.00 │ — │ 180.00 │\n * │ gpt-5.4 │ 2.50 │ 0.25 │ 15.00 │\n * │ gpt-5.4-mini │ 0.75 │ 0.075 │ 4.50 │\n * │ gpt-5.4-nano │ 0.20 │ 0.02 │ 1.25 │\n * │ gpt-5.4-pro │ 30.00 │ — │ 180.00 │\n * └──────────────────┴────────────┴────────────┴─────────────┘\n *\n * Prices are in USD per 1 million tokens (Standard tier).\n * Source: https://developers.openai.com/api/docs/pricing\n * Update this table when OpenAI changes prices or adds new models.\n *\n * Unknown models are REJECTED (400) rather than allowed for free.\n * If a model is missing, add it here.\n *\n * Costs and budgets are stored as REAL (dollar amounts) in SQLite.\n * No integer unit conversion needed — just normal decimals.\n */\n\nexport type ModelPricing = {\n input: number; // $ per 1M input tokens\n cachedInput: number; // $ per 1M cached input tokens (prompt cache)\n output: number; // $ per 1M output tokens\n};\n\nexport const PRICING: Record = {\n \"gpt-5.6-sol\": { input: 5.00, cachedInput: 0.50, output: 30.00 },\n \"gpt-5.6-terra\": { input: 2.00, cachedInput: 0.20, output: 12.00 },\n \"gpt-5.6-luna\": { input: 0.20, cachedInput: 0.02, output: 1.20 },\n \"gpt-5.5\": { input: 5.00, cachedInput: 0.50, output: 30.00 },\n \"gpt-5.5-pro\": { input: 30.00, cachedInput: 0, output: 180.00 },\n \"gpt-5.4\": { input: 2.50, cachedInput: 0.25, output: 15.00 },\n \"gpt-5.4-mini\": { input: 0.75, cachedInput: 0.075, output: 4.50 },\n \"gpt-5.4-nano\": { input: 0.20, cachedInput: 0.02, output: 1.25 },\n \"gpt-5.4-pro\": { input: 30.00, cachedInput: 0, output: 180.00 },\n};\n\n/** Monthly budget in USD per calendar month, by tier. */\nexport const MONTHLY_BUDGET: Record = {\n free: 1, // $1\n pro: 10, // $10\n business: 40, // $40\n};\n\n/** Get the monthly budget for a tier, defaulting to the free tier. */\nexport function getBudget(tier: string): number {\n return MONTHLY_BUDGET[tier] ?? MONTHLY_BUDGET.free;\n}\n\n/**\n * Calculate cost in USD for a single request.\n *\n * cost = ((input - cached) × inputPrice + cached × cachedPrice + output × outputPrice) / 1,000,000\n *\n * Returns a normal decimal dollar amount (e.g., 0.0000062).\n */\nexport function calculateCost(\n model: string,\n inputTokens: number,\n cachedTokens: number,\n outputTokens: number,\n): number {\n const p = PRICING[model];\n if (!p) throw new Error(`No pricing for model: ${model}`);\n\n const inputCost = (inputTokens - cachedTokens) * p.input;\n const cachedCost = cachedTokens * p.cachedInput;\n const outputCost = outputTokens * p.output;\n\n return (inputCost + cachedCost + outputCost) / 1_000_000;\n}\n\n/** Check if a model is in our pricing table. */\nexport function hasPricing(model: string): boolean {\n return model in PRICING;\n}\n",[185],"c05b90d3a6bba0761a81e8d0cc596a9b464b68f8e92790c23f322e15a7f11e55","ledger.ts",{"_33":196,"_13":194,"_83":197,"_85":-5,"_86":63,"_87":198,"_89":26,"_40":199,"_47":91,"_92":93,"_94":200,"_69":55,"_96":-5,"_97":-7,"_76":201,"_99":202},"dc96188c-3a39-4d98-a4d2-c6d59d29342a","42357f90-8c5d-11f1-a3bd-1607ee4eb77e",12,["D",1785449330437],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { calculateCost, getBudget } from \"./pricing.ts\";\n\n/**\n * Dollar-based spend tracking.\n *\n * Two tables:\n * - openai_spend: append-only ledger of every request with token counts and cost\n * - openai_monthly_budget: aggregate spend per subject per month (for fast pre-flight checks)\n *\n * All monetary values are stored as REAL (dollar amounts) in SQLite.\n *\n * \"Subject\" is the budget owner: either a user (personal val) or an org (team val).\n * The budget follows the val's owning org tier.\n */\n\nexport async function initSchema(): Promise {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS openai_spend (\n id INTEGER PRIMARY KEY,\n subject_id TEXT NOT NULL,\n subject_type TEXT NOT NULL,\n handle TEXT NOT NULL,\n tier TEXT NOT NULL,\n month TEXT NOT NULL,\n model TEXT NOT NULL,\n input_tokens INTEGER NOT NULL DEFAULT 0,\n cached_tokens INTEGER NOT NULL DEFAULT 0,\n output_tokens INTEGER NOT NULL DEFAULT 0,\n cost REAL NOT NULL,\n timestamp TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS openai_monthly_budget (\n subject_id TEXT NOT NULL,\n month TEXT NOT NULL,\n spent REAL NOT NULL DEFAULT 0,\n PRIMARY KEY (subject_id, month)\n )`,\n args: [],\n },\n {\n sql: `CREATE INDEX IF NOT EXISTS idx_spend_subject ON openai_spend(subject_id, month)`,\n args: [],\n },\n {\n sql: `CREATE INDEX IF NOT EXISTS idx_spend_timestamp ON openai_spend(timestamp)`,\n args: [],\n },\n ]);\n}\n\n/** Returns the current month as 'YYYY-MM' (UTC calendar month). */\nexport function getCurrentMonth(): string {\n return new Date().toISOString().slice(0, 7); // \"2026-07\"\n}\n\nexport type Subject = {\n id: string;\n type: \"user\" | \"org\";\n handle: string;\n tier: string;\n};\n\nexport type BudgetCheck = {\n exceeded: boolean;\n spent: number; // USD\n budget: number; // USD\n remaining: number; // USD\n};\n\n/**\n * Check if a subject has exceeded their monthly budget.\n * Does NOT write — safe to call as a pre-flight check.\n */\nexport async function checkBudget(subject: Subject): Promise {\n const month = getCurrentMonth();\n const budget = getBudget(subject.tier);\n\n const result = await sqlite.execute({\n sql: `SELECT spent FROM openai_monthly_budget\n WHERE subject_id = ? AND month = ?`,\n args: [subject.id, month],\n });\n\n const spent = result.rows.length > 0\n ? Number(result.rows[0][0])\n : 0;\n\n return {\n exceeded: spent >= budget,\n spent,\n budget,\n remaining: Math.max(0, budget - spent),\n };\n}\n\n/**\n * Record a completed request's cost in the ledger.\n * Writes to both openai_spend (detail) and openai_monthly_budget (aggregate).\n * Called fire-and-forget after the OpenAI response is returned.\n */\nexport async function recordSpend(\n subject: Subject,\n model: string,\n inputTokens: number,\n cachedTokens: number,\n outputTokens: number,\n): Promise {\n const month = getCurrentMonth();\n const cost = calculateCost(\n model,\n inputTokens,\n cachedTokens,\n outputTokens,\n );\n\n await sqlite.batch([\n {\n sql: `INSERT INTO openai_spend\n (subject_id, subject_type, handle, tier, month, model,\n input_tokens, cached_tokens, output_tokens, cost)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n subject.id,\n subject.type,\n subject.handle,\n subject.tier,\n month,\n model,\n inputTokens,\n cachedTokens,\n outputTokens,\n cost,\n ],\n },\n {\n sql: `INSERT INTO openai_monthly_budget (subject_id, month, spent)\n VALUES (?, ?, ?)\n ON CONFLICT (subject_id, month) DO UPDATE SET\n spent = spent + ?`,\n args: [subject.id, month, cost, cost],\n },\n ]);\n\n return cost;\n}\n\n/**\n * Get spend stats for the dashboard.\n * Returns per-subject totals for the current month.\n */\nexport type SpendStat = {\n subject_id: string;\n handle: string;\n tier: string;\n spent: number;\n budget: number;\n request_count: number;\n};\n\nexport async function getMonthlySpendStats(limit = 100): Promise {\n const month = getCurrentMonth();\n const result = await sqlite.execute({\n sql: `SELECT\n s.subject_id, s.handle, s.tier,\n SUM(s.cost) as spent,\n COUNT(*) as count\n FROM openai_spend s\n WHERE s.month = ?\n GROUP BY s.subject_id, s.handle, s.tier\n ORDER BY spent DESC\n LIMIT ?`,\n args: [month, limit],\n });\n\n return result.rows.map((row) => ({\n subject_id: String(row[0]),\n handle: String(row[1]),\n tier: String(row[2]),\n spent: Number(row[3]),\n budget: getBudget(String(row[2])),\n request_count: Number(row[4]),\n }));\n}\n",[194],"dce81eb3c1c11014f78f181185fcf0185cc87cd14db7b853e13e6c6cbadbbe08","dashboard.tsx",{"_33":205,"_13":203,"_83":206,"_85":-5,"_86":63,"_87":207,"_89":26,"_40":208,"_47":22,"_92":175,"_94":209,"_69":55,"_96":-5,"_97":-7,"_76":210,"_99":211},"0a267f59-3eae-44c4-9778-bdbf9ea98d8b","5f0e8934-8c64-11f1-bff4-1607ee4eb77e",23,["D",1785449814401],"/** @jsxImportSource https://esm.sh/hono/jsx */\nimport { Hono } from \"https://esm.sh/hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { getMonthlySpendStats } from \"./ledger.ts\";\nimport {\n getOAuthUserData,\n oauthMiddleware,\n} from \"https://esm.town/v/std/oauth/middleware.ts\";\n\nconst app = new Hono();\n\napp.get(\"/\", async (c) => {\n const session = await getOAuthUserData(c.req.raw);\n const user = session?.user?.username;\n\n if (!user) return c.html(Login);\n if (![\"stevekrouse\", \"tmcw\"].includes(user)) {\n return c.text(\"Forbidden\", 403);\n }\n\n const stats = await getMonthlySpendStats(50);\n\n return c.html(\n \n \n \n \n \n

OpenAI Spend — Current Month

\n \n \n \n \n \n \n \n \n \n \n \n \n {stats.map((row) => (\n \n \n \n \n \n \n \n \n ))}\n \n

Handle	Tier	Requests	Spent	Budget	Remaining
{row.handle}	{row.tier}	{row.request_count}	${row.spent.toFixed(4)}	${row.budget.toFixed(2)}	${(row.budget - row.spent).toFixed(4)}

\n \n ,\n );\n});\n\nexport default oauthMiddleware(app.fetch);\n",[203],"31d97abea6cd59c798b97cb98fe189fd605d929d131a3575e1d7458f6a90010d",["D",1746043648993],"legacyEnvVars","httpPrivacy","imageUrl","userId","c9143560-63b6-444f-8f9f-e2647fabe09f","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",10,"tursoName","be1ca42425fe11f0b0b8569c3dd06744","tursoHostname","be1ca42425fe11f0b0b8569c3dd06744-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789474235934],"pinned","userPerm","r","valPerm","rw","blobPerm","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_251":247},"org",{"_11":12,"_245":-5,"_246":247,"_216":-5,"_248":249,"_250":55},"branch","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJVaVhpQ1BId3dscVpBbkdZVWlMNjJtcjkxWS5wbmcifQ","tier","pro","canRestrictVals","profileImageUrl","","adoptOrgId",{"_33":46,"_13":14,"_40":385,"_53":-5,"_213":26,"_56":57,"_214":57,"_35":-5,"_215":-5,"_216":217,"_218":-5,"_219":26,"_220":-5,"_221":-5,"_222":223,"_59":60,"_224":225,"_226":227,"_228":386,"_230":-5,"_231":232,"_233":234,"_235":234,"_236":234,"_237":234,"_238":232,"_239":232,"_240":387,"_242":388,"_244":389,"_54":55},"tree",[323,327,329,331,332,333,334,335,336,337],"files",[323,324,325,326,327,328,329,330,331,332,333,334,335,336,337],"counts",{"_313":91,"_314":131,"_315":223,"_316":317,"_318":319},"contents",[276,277,278,279,280,281,282,283,284,285],"upstreamProject","upstreamBranch",{"_33":39,"_40":274,"_42":275,"_13":44,"_45":46,"_47":48,"_49":-5,"_50":-5,"_51":52,"_53":-5,"_54":55,"_56":57,"_58":12,"_59":60,"_61":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1746043648993],["D",1785445784006],{"_33":308,"_13":309,"_83":310,"_85":-5,"_86":63,"_87":91,"_89":26,"_40":311,"_47":22,"_92":166,"_94":-5,"_69":55,"_96":-5,"_76":312},{"_33":181,"_13":179,"_83":172,"_85":-5,"_86":63,"_87":182,"_89":26,"_40":306,"_47":22,"_92":166,"_94":-5,"_69":55,"_96":-5,"_76":307},{"_33":163,"_13":161,"_83":154,"_85":-5,"_86":63,"_87":164,"_89":26,"_40":304,"_47":22,"_92":166,"_94":-5,"_69":55,"_96":-5,"_76":305},{"_33":128,"_13":125,"_83":129,"_85":-5,"_86":63,"_87":62,"_89":26,"_40":302,"_47":131,"_92":114,"_94":132,"_69":55,"_96":-5,"_76":303},{"_33":111,"_13":108,"_83":112,"_85":-5,"_86":63,"_87":20,"_89":26,"_40":300,"_47":91,"_92":114,"_94":115,"_69":55,"_96":-5,"_76":301},{"_33":205,"_13":203,"_83":206,"_85":-5,"_86":63,"_87":207,"_89":26,"_40":298,"_47":22,"_92":175,"_94":209,"_69":55,"_96":-5,"_76":299},{"_33":196,"_13":194,"_83":197,"_85":-5,"_86":63,"_87":198,"_89":26,"_40":296,"_47":91,"_92":93,"_94":200,"_69":55,"_96":-5,"_76":297},{"_33":82,"_13":77,"_83":84,"_85":-5,"_86":63,"_87":88,"_89":26,"_40":294,"_47":91,"_92":93,"_94":95,"_69":55,"_96":-5,"_76":295},{"_33":288,"_13":289,"_83":290,"_85":-5,"_86":63,"_87":91,"_89":26,"_40":291,"_47":22,"_92":93,"_94":292,"_69":55,"_96":-5,"_76":293},{"_33":187,"_13":185,"_83":188,"_85":-5,"_86":63,"_87":189,"_89":26,"_40":286,"_47":131,"_92":93,"_94":191,"_69":55,"_96":-5,"_76":287},["D",1785449741596],[185],"a8dd130e-eecd-4c74-a550-65b3988f149a","main.tsx","019fb4ea-df76-7108-899d-58059457a360",["D",1785446719355],"// For backward compatibility\nexport { OpenAI } from \"./main.ts\";",[289],["D",1785446871390],[77],["D",1785449330437],[194],["D",1785449814401],[203],["D",1785449814411],[108],["D",1785449822893],[125],["D",1785447223616],[161],["D",1785446862743],[179],"f1080d92-5fb2-424f-b9c2-d33b4de7414e","examples","019fb4ea-df76-7108-899d-48c5ac28bf1c",["D",1785446719355],[309],"pulls","branches","forks","envVars",{"_320":131,"_322":22},"connections",{"_320":22,"_321":22},"count","unfilledCount","emptyCount",{"_33":308,"_13":309,"_83":310,"_85":-5,"_86":63,"_87":91,"_89":26,"_40":382,"_47":22,"_92":166,"_94":-5,"_69":55,"_96":-5,"_97":383,"_76":384},{"_33":375,"_13":376,"_83":377,"_85":310,"_86":63,"_87":91,"_89":26,"_40":378,"_47":22,"_92":93,"_94":379,"_69":55,"_96":-5,"_97":380,"_76":381},{"_33":368,"_13":369,"_83":370,"_85":310,"_86":63,"_87":91,"_89":26,"_40":371,"_47":22,"_92":93,"_94":372,"_69":55,"_96":-5,"_97":373,"_76":374},{"_33":361,"_13":362,"_83":363,"_85":310,"_86":63,"_87":91,"_89":26,"_40":364,"_47":22,"_92":93,"_94":365,"_69":55,"_96":-5,"_97":366,"_76":367},{"_33":181,"_13":179,"_83":172,"_85":-5,"_86":63,"_87":182,"_89":26,"_40":183,"_47":22,"_92":166,"_94":-5,"_69":55,"_96":-5,"_97":359,"_76":360},{"_33":170,"_13":77,"_83":171,"_85":172,"_86":63,"_87":173,"_89":26,"_40":174,"_47":164,"_92":175,"_94":176,"_69":55,"_96":-5,"_97":357,"_76":358},{"_33":163,"_13":161,"_83":154,"_85":-5,"_86":63,"_87":164,"_89":26,"_40":165,"_47":22,"_92":166,"_94":-5,"_69":55,"_96":-5,"_97":355,"_76":356},{"_33":151,"_13":152,"_83":153,"_85":154,"_86":63,"_87":155,"_89":26,"_40":156,"_47":157,"_92":93,"_94":158,"_69":55,"_96":-5,"_97":353,"_76":354},{"_33":128,"_13":125,"_83":129,"_85":-5,"_86":63,"_87":62,"_89":26,"_40":130,"_47":131,"_92":114,"_94":132,"_69":55,"_96":-5,"_97":351,"_76":352},{"_33":111,"_13":108,"_83":112,"_85":-5,"_86":63,"_87":20,"_89":26,"_40":113,"_47":91,"_92":114,"_94":115,"_69":55,"_96":-5,"_97":349,"_76":350},{"_33":205,"_13":203,"_83":206,"_85":-5,"_86":63,"_87":207,"_89":26,"_40":208,"_47":22,"_92":175,"_94":209,"_69":55,"_96":-5,"_97":347,"_76":348},{"_33":196,"_13":194,"_83":197,"_85":-5,"_86":63,"_87":198,"_89":26,"_40":199,"_47":91,"_92":93,"_94":200,"_69":55,"_96":-5,"_97":345,"_76":346},{"_33":82,"_13":77,"_83":84,"_85":-5,"_86":63,"_87":88,"_89":26,"_40":90,"_47":91,"_92":93,"_94":95,"_69":55,"_96":-5,"_97":343,"_76":344},{"_33":288,"_13":289,"_83":290,"_85":-5,"_86":63,"_87":91,"_89":26,"_40":340,"_47":22,"_92":93,"_94":292,"_69":55,"_96":-5,"_97":341,"_76":342},{"_33":187,"_13":185,"_83":188,"_85":-5,"_86":63,"_87":189,"_89":26,"_40":190,"_47":131,"_92":93,"_94":191,"_69":55,"_96":-5,"_97":338,"_76":339},[],[185],["D",1785446719355],[],[289],[],[77],[],[194],[],[203],[],[108],[],[125],[],[161,152],[330],[161],[],[179,77],[328],[179],"24f4c05a-6867-497e-95f6-1413499358d7","web-search.ts","019fb4ea-df76-7108-899d-476b76b86df2",["D",1785446719355],"// Web search via the Responses API — incredibly effective for enrichment.\n//\n// The Responses API (responses.create) supports the web_search tool, which lets\n// the model browse the web in real time. This is dramatically more effective than\n// passing static text — the model can look up people, companies, products, and\n// current events on its own.\n//\n// Great use cases: lead enrichment, company research, summarizing a topic,\n// fact-checking, or anything where fresh data beats stale training knowledge.\n\nimport { ValTownOpenAI } from \"../main.ts\";\n\nconst openai = new ValTownOpenAI({});\n\nconst response = await openai.responses.create({\n model: \"gpt-5.6-luna\",\n tools: [{ type: \"web_search\" }],\n instructions:\n \"You research companies. Given a company name, reply in 2-3 short plain-text lines: what they do, their stage, and why a developer might care. No markdown.\",\n input: \"Val Town\",\n});\n\nconsole.log(response.output_text);\n",[],[309,362],"c9a57e15-5ed3-4b2e-8e25-1e0d4fff5aef","structured-outputs.ts","019fb4ea-df76-7108-899d-43a30fa43e51",["D",1785446719355],"// Structured outputs via the Responses API — reliable, typed JSON.\n//\n// Instead of asking the model to \"return JSON\" and manually parsing/free-text\n// cleaning the response, pass a JSON schema in `text.format`. The model is\n// constrained to output JSON that matches your schema exactly — no fence\n// stripping, no regex, no try/catch on malformed JSON.\n//\n// This is the idiomatic approach for any task where you need the model's answer\n// as structured data: classification, scoring, extraction, routing decisions, etc.\n\nimport { ValTownOpenAI } from \"../main.ts\";\n\nconst openai = new ValTownOpenAI({});\n\nconst response = await openai.responses.create({\n model: \"gpt-5.6-luna\",\n instructions:\n \"You classify user feedback. Given a piece of feedback, classify it and write a one-sentence summary.\",\n input: \"The app keeps logging me out every 5 minutes, it's really frustrating.\",\n text: {\n format: {\n type: \"json_schema\",\n name: \"classification\",\n schema: {\n type: \"object\",\n properties: {\n category: {\n type: \"string\",\n enum: [\"bug\", \"feature_request\", \"praise\", \"question\"],\n },\n priority: {\n type: \"string\",\n enum: [\"low\", \"medium\", \"high\"],\n },\n summary: { type: \"string\" },\n },\n required: [\"category\", \"priority\", \"summary\"],\n additionalProperties: false,\n },\n },\n },\n});\n\n// output_text is guaranteed valid JSON matching the schema.\nconst result = JSON.parse(response.output_text);\nconsole.log(result);\n",[],[309,369],"cc3de97b-e809-46ab-b4f5-ada6b8808bb2","bring-your-own-key.ts","019fb4ea-df75-7236-add3-8098418c5d6a",["D",1785446719355],"// Bring your own OpenAI API key — or use the built-in Val Town proxy.\n//\n// If you set the OPENAI_API_KEY environment variable, all requests go directly\n// to OpenAI with no rate limits or proxy restrictions. If you don't, requests\n// fall back to ValTownOpenAI, which routes through our proxy (no key needed,\n// subject to free-tier quotas).\n//\n// This is the recommended pattern for production vals: start on the free proxy,\n// then add an API key when you outgrow the limits.\n\nimport { ValTownOpenAI } from \"../main.ts\";\nimport OpenAI from \"npm:openai\";\n\n// Use your own key if available, otherwise the Val Town proxy.\nconst apiKey = Deno.env.get(\"OPENAI_API_KEY\");\nconst openai = apiKey ? new OpenAI({ apiKey }) : new ValTownOpenAI({});\n\nconst completion = await openai.chat.completions.create({\n model: \"gpt-5.6-luna\",\n messages: [{ role: \"user\", content: \"Say hello in one word.\" }],\n});\n\nconsole.log(completion.choices[0].message.content);\n",[],[309,376],["D",1785446719355],[324,325,326],[309],["D",1746043648993],["D",1789474235934],{"_11":12,"_251":247},{"_11":12,"_245":-5,"_246":247,"_216":-5,"_248":249,"_250":55},{"_47":62,"_13":16,"_33":63,"_45":46,"_49":39,"_50":48,"_64":57,"_65":46,"_66":60,"_61":14,"_58":12},"ctx",{"_240":-5,"_271":423,"_424":425,"_426":427,"_428":55,"_429":55,"_430":55,"_431":26,"_432":-5,"_433":-7,"_434":-7,"_435":22,"_436":55,"_437":55,"_438":-5,"_439":55,"_440":55,"_441":55,"_442":-5},"ENV",{"_394":395,"_396":397,"_398":44,"_399":400,"_401":402,"_403":404,"_405":406,"_407":408,"_409":410,"_411":412,"_413":414,"_415":416,"_417":418,"_419":420,"_421":422},"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"]

Compare

Mergedollar-rate-limitingintomain

AGENTS.md+54-8

README.md+33-48

main.ts+3-1

Hdashboard.tsx+62-0

ledger.ts+188-0

pricing.ts+83-0

proxy

Hproxy/main.ts+254-0

tests

tests/integration.ts+188-0