[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_438":439,"_440":441},"routes/_app.x.$handle.$name",{"_99":98,"_32":44,"_107":86,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":120,"_121":122,"_123":25,"_124":125,"_126":58,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",95,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",false,"deletedHere","path","README.md","latestPath","fileId","0199cd92-ced6-71e8-a8db-d4f2aafd9864","name","fileType","content","# Val Town ChatGPT App SDK Starter\n\nFull-stack message board with **ChatGPT widget integration** built for Val Town.\n\n## Tech Stack\n\n### Backend\n- Hono web framework\n- MCP Lite server (Model Context Protocol)\n- Drizzle ORM with SQLite\n- Deno runtime\n\n### Frontend (Message Board)\n- React 19\n- TanStack Router (code-first routing)\n- TanStack Query (server state management)\n- Tailwind CSS\n- TypeScript\n\n### ChatGPT Widget\n- React 19 with runtime transpilation\n- TanStack Router for widget navigation\n- OpenAI App SDK integration\n- No build step required\n\n## Features\n\n- Message board with persistent storage\n- **ChatGPT integration via MCP server**\n- **Interactive widgets in ChatGPT conversations**\n- Client-side routing\n- Optimistic updates\n- Server-side data injection\n- Type-safe database operations\n\n## Project Structure\n\n```\n├── backend/ # Hono server running on Val Town\n│ ├── database/ # Drizzle schema, migrations, and queries\n│ ├── mcp/ # MCP server with ChatGPT tools and widgets\n│ └── index.ts # Main Hono application\n├── frontend/ # Message board React app\n│ ├── components/ # React components\n│ ├── lib/ # Utilities and hooks\n│ └── router.tsx # TanStack Router configuration\n├── widget/ # ChatGPT widget (runtime transpilation)\n│ ├── components/ # Widget React components\n│ ├── routes.tsx # Widget router configuration\n│ └── index.tsx # Widget entry point\n└── shared/ # Code shared between all parts\n```\n\n## API Endpoints\n\n### Message Board\n- `GET /` - Serves the React application with initial data\n- `GET /api/messages` - Fetch all messages (JSON)\n- `POST /api/messages` - Create a new message\n- `GET /public/**` - Static assets (CSS, JS, etc.)\n\n### ChatGPT Integration\n- `POST /mcp` - MCP server endpoint for ChatGPT\n- `GET /widget-assets/**` - Widget assets (auto-transpiled TSX → JS)\n\n## Val Town Constraints\n\n- Read-only filesystem after deployment\n- ESM imports via esm.sh for npm packages\n- Code-first routing (no file-based routing)\n- Runtime transpilation for TypeScript/TSX (no build step)\n\n## Implementation\n\n### Router\n```tsx\nconst homeRoute = new Route({\n getParentRoute: () => rootRoute,\n path: \"/\",\n component: () => \n});\n```\n\n### Query\n```tsx\nexport function usePostMessage() {\n return useMutation({\n mutationFn: (content: string) => postMessage(content),\n onSuccess: () => {\n queryClient.invalidateQueries({ queryKey: [\"messages\"] });\n },\n });\n}\n```\n\n### Schema\n```tsx\nexport const messages = sqliteTable(\"messages\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n content: text(\"content\").notNull(),\n timestamp: text(\"timestamp\").notNull().default(new Date().toISOString()),\n});\n```\n\n## ChatGPT Integration\n\n### Quick Start\n\n1. **Deploy to Val Town:**\n ```bash\n vt push\n ```\n\n2. **Get your Val URL:**\n ```\n https://yourname-projectname.val.run\n ```\n\n3. **Add MCP server to ChatGPT:**\n - Go to ChatGPT settings\n - Add MCP server: `https://yourname-projectname.val.run/mcp`\n\n4. **Use in ChatGPT:**\n ```\n User: \"List all messages\"\n ChatGPT: [Calls list_messages tool]\n [Interactive widget appears showing messages]\n ```\n\n### Available Tools\n\n- **`list_messages`** - Shows interactive message list widget\n- **`add_message`** - Adds a message and shows updated list\n- **`greet`** - Personalized greeting widget\n\n### Widget Architecture\n\nThe widget uses **runtime transpilation** - no build step required:\n\n1. MCP server returns HTML widget resource\n2. ChatGPT iframe loads widget HTML\n3. Browser requests TSX files from `/widget-assets/*`\n4. Val Town's `serveFile` transpiles TSX → JS automatically\n5. React app hydrates with tool output\n6. TanStack Router navigates based on output `kind`\n\nSee [`widget/README.md`](widget/README.md) for detailed documentation.\n\n## Development\n\n### Local Development with vt CLI\n\n```bash\n# Pull from Val Town\nvt pull\n\n# Watch for changes and auto-deploy\nvt watch\n\n# Edit files locally - changes deploy in ~100ms\n```\n\n### Web IDE\n\nAlternatively, edit directly on val.town with instant deployment.","# Val Town ChatGPT App SDK Starter\n\nA starter template for building ChatGPT apps with interactive widgets using MCP (Model Context Protocol) on Val Town.\n\n## Tech Stack\n\n- **Backend**: Hono + MCP Lite + Drizzle ORM + SQLite\n- **Widget**: React 19 + TanStack Router + OpenAI App SDK\n\n## Quick Start\n\n\n1. Visit your deployment URL to get the MCP endpoint\n\n2. Add to ChatGPT:\n - Open ChatGPT settings → Apps & Connectors -> Create (you will need developer mode enabled)\n - Add MCP server with your endpoint URL\n\n4. Test in ChatGPT:\n - \"List all messages\"\n - \"Add a message: Hello!\"\n - \"Show me message #1\"\n\n## Available Tools\n\n- `list_messages` - Shows all messages in an interactive widget\n- `add_message` - Adds a new message and shows updated list\n- `get_message` - Shows details for a specific message\n\n## How It Works\n\nTools return discriminated unions that drive widget navigation:\n\n```typescript\n{ kind: \"message_list\", messages: [...] } // → /list route\n{ kind: \"message_detail\", id: 1, ... } // → /detail/:id route\n```\n\nThe widget automatically navigates based on the `kind` field.\n\n## Where do I go from here?\n\n1. Add tool in `backend/mcp/server.ts`\n2. Define output schema in `shared/types.ts`\n3. Create widget route in `frontend/widgets/routes.tsx`\n4. Update `NavigationSync.tsx` to handle new `kind`\n\n","createdAt",["D",1760101404571],"branchVersion","branchId","4a2ee7a6-a5c0-11f0-a261-0224a6c84d84","id","4a2abed8-a5c0-11f0-a261-0224a6c84d84","ChatAppSDKStarter",["D",1760090574500],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","A starter val for building ChatGPT Apps powered by React","imageUrl","70598581-74a1-4b7d-8194-a74d34e1c959","pinnedFileId","0199cd92-ced6-71e8-a8db-90fbd3a88d30","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","ee726368-7b53-4ccf-9454-dc28b139ac2d","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":54,"_103":104,"_105":25},"branch",{"_13":85,"_32":86,"_42":41,"_87":43,"_88":89,"_90":91,"_92":49,"_93":94,"_95":64,"_96":44,"_97":98},"isOwned",104,"main","projectId","forkedBranchId","00bc9cf2-488d-11f0-8815-76b3cceeab13","forkedBranchVersion",96,"forkedProjectPrivacy","forkedProjectId","00b957d6-488d-11f0-8815-76b3cceeab13","forkedProjectOrgId","projectName","userHandle","laurynas","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJzeDdZM2RjbFBvQ1NTM2tWdXRNbjBEaER0dCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_32":44,"_37":434,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":435,"_80":436,"_82":437,"_84":25},"tree",[193,204,217,221,222,223],"files",[193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223],"counts",{"_182":152,"_183":62,"_184":185,"_186":187,"_188":189},"contents",[140,141,142,143,144,145],"upstreamProject",{"_42":94,"_32":138,"_51":-5,"_53":-5,"_48":49,"_78":139},"upstreamBranch",{"_42":89,"_37":131,"_132":133,"_32":86,"_87":94,"_13":91,"_88":134,"_90":135,"_136":137,"_46":-5,"_84":25,"_48":49,"_97":98,"_63":64,"_96":138},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1749843088792],"updatedAt",["D",1750934304558],"41ef5540-f2f5-11ef-891c-569c3dd06744",228,"lockfileKey","1755566635826-esm.town_v_laurynas_tanstackReactHonoExample@96-main","tanstackReactHonoExample",{"_99":98,"_106":102},{"_42":177,"_32":178,"_30":179,"_149":-5,"_40":41,"_39":62,"_150":58,"_37":180,"_13":152,"_33":170,"_34":-5,"_24":25,"_154":-5,"_27":181},{"_42":172,"_32":173,"_30":174,"_149":-5,"_40":41,"_39":62,"_150":58,"_37":175,"_13":152,"_33":170,"_34":-5,"_24":25,"_154":-5,"_27":176},{"_42":166,"_32":167,"_30":168,"_149":-5,"_40":41,"_39":62,"_150":58,"_37":169,"_13":152,"_33":170,"_34":-5,"_24":25,"_154":-5,"_27":171},{"_42":160,"_32":161,"_30":162,"_149":-5,"_40":41,"_39":62,"_150":58,"_37":163,"_13":152,"_33":20,"_34":164,"_24":25,"_154":-5,"_27":165},{"_42":156,"_32":28,"_30":31,"_149":-5,"_40":41,"_39":14,"_150":25,"_37":157,"_13":158,"_33":20,"_34":36,"_24":25,"_154":-5,"_27":159},{"_42":146,"_32":147,"_30":148,"_149":-5,"_40":41,"_39":62,"_150":58,"_37":151,"_13":152,"_33":20,"_34":153,"_24":25,"_154":-5,"_27":155},"4a3394c2-a5c0-11f0-a261-0224a6c84d84","deno.json","0199cd92-ced6-71e8-a8db-db837674d5db","parentId","latest",["D",1760090574500],0,"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\n \"https://www.val.town/types/valtown.d.ts\"\n ],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"files\": {\n \"include\": [\n \"deno:/https/esm.town/**/*\"\n ]\n },\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\"\n ]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}","label",[147],"817d1cd2-a5d9-11f0-9ec3-0224a6c84d84",["D",1760101404571],2,[28],"4a3391d4-a5c0-11f0-a261-0224a6c84d84",".vtignore","0199cd92-ced6-71e8-a8db-d09800f4c479",["D",1760090574500],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[161],"4a3390da-a5c0-11f0-a261-0224a6c84d84","shared","0199cd92-ced6-71e8-a8db-cf40b0fa17d8",["D",1760090574500],"directory",[167],"4a338d60-a5c0-11f0-a261-0224a6c84d84","frontend","0199cd92-ced6-71e8-a8db-c34ad08bf163",["D",1760090574500],[173],"4a337f50-a5c0-11f0-a261-0224a6c84d84","backend","0199cd92-ced6-71e8-a8db-970fdcba0196",["D",1760090574500],[178],"pulls","branches","forks",5,"envVars",{"_190":152,"_192":152},"connections",{"_190":152,"_191":152},"count","unfilledCount","emptyCount",{"_42":177,"_32":178,"_30":179,"_149":-5,"_40":41,"_39":62,"_150":58,"_37":431,"_13":152,"_33":170,"_34":-5,"_24":25,"_154":-5,"_225":432,"_27":433},{"_42":427,"_32":397,"_30":392,"_149":179,"_40":41,"_39":62,"_150":58,"_37":428,"_13":152,"_33":170,"_34":-5,"_24":25,"_154":-5,"_225":429,"_27":430},{"_42":420,"_32":28,"_30":421,"_149":392,"_40":41,"_39":422,"_150":58,"_37":423,"_13":62,"_33":20,"_34":424,"_24":25,"_154":-5,"_225":425,"_27":426},{"_42":413,"_32":414,"_30":415,"_149":392,"_40":41,"_39":62,"_150":58,"_37":416,"_13":152,"_33":239,"_34":417,"_24":25,"_154":-5,"_225":418,"_27":419},{"_42":405,"_32":406,"_30":407,"_149":392,"_40":41,"_39":408,"_150":25,"_37":409,"_13":158,"_33":239,"_34":410,"_24":25,"_154":-5,"_225":411,"_27":412},{"_42":398,"_32":399,"_30":400,"_149":392,"_40":41,"_39":62,"_150":25,"_37":401,"_13":152,"_33":239,"_34":402,"_24":25,"_154":-5,"_225":403,"_27":404},{"_42":389,"_32":390,"_30":391,"_149":392,"_40":41,"_39":62,"_150":25,"_37":393,"_13":152,"_33":239,"_34":394,"_24":25,"_154":-5,"_225":395,"_27":396},{"_42":384,"_32":383,"_30":376,"_149":179,"_40":41,"_39":385,"_150":58,"_37":386,"_13":152,"_33":170,"_34":-5,"_24":25,"_154":-5,"_225":387,"_27":388},{"_42":373,"_32":374,"_30":375,"_149":376,"_40":41,"_39":377,"_150":25,"_37":378,"_13":379,"_33":239,"_34":380,"_24":25,"_154":-5,"_225":381,"_27":382},{"_42":366,"_32":28,"_30":367,"_149":179,"_40":41,"_39":368,"_150":58,"_37":369,"_13":62,"_33":20,"_34":370,"_24":25,"_154":-5,"_225":371,"_27":372},{"_42":357,"_32":358,"_30":56,"_149":179,"_40":41,"_39":359,"_150":25,"_37":360,"_13":361,"_33":362,"_34":363,"_24":25,"_154":-5,"_225":364,"_27":365},{"_42":172,"_32":173,"_30":174,"_149":-5,"_40":41,"_39":62,"_150":58,"_37":354,"_13":152,"_33":170,"_34":-5,"_24":25,"_154":-5,"_225":355,"_27":356},{"_42":349,"_32":277,"_30":271,"_149":174,"_40":41,"_39":350,"_150":58,"_37":351,"_13":152,"_33":170,"_34":-5,"_24":25,"_154":-5,"_225":352,"_27":353},{"_42":344,"_32":327,"_30":321,"_149":271,"_40":41,"_39":345,"_150":58,"_37":346,"_13":152,"_33":170,"_34":-5,"_24":25,"_154":-5,"_225":347,"_27":348},{"_42":336,"_32":337,"_30":338,"_149":321,"_40":41,"_39":339,"_150":58,"_37":340,"_13":158,"_33":239,"_34":341,"_24":25,"_154":-5,"_225":342,"_27":343},{"_42":328,"_32":329,"_30":330,"_149":321,"_40":41,"_39":331,"_150":58,"_37":332,"_13":158,"_33":239,"_34":333,"_24":25,"_154":-5,"_225":334,"_27":335},{"_42":318,"_32":319,"_30":320,"_149":321,"_40":41,"_39":322,"_150":58,"_37":323,"_13":158,"_33":239,"_34":324,"_24":25,"_154":-5,"_225":325,"_27":326},{"_42":310,"_32":311,"_30":312,"_149":271,"_40":41,"_39":313,"_150":58,"_37":314,"_13":158,"_33":239,"_34":315,"_24":25,"_154":-5,"_225":316,"_27":317},{"_42":302,"_32":303,"_30":304,"_149":271,"_40":41,"_39":305,"_150":58,"_37":306,"_13":62,"_33":239,"_34":307,"_24":25,"_154":-5,"_225":308,"_27":309},{"_42":294,"_32":261,"_30":295,"_149":271,"_40":41,"_39":296,"_150":58,"_37":297,"_13":298,"_33":20,"_34":299,"_24":25,"_154":-5,"_225":300,"_27":301},{"_42":286,"_32":287,"_30":288,"_149":271,"_40":41,"_39":289,"_150":58,"_37":290,"_13":158,"_33":239,"_34":291,"_24":25,"_154":-5,"_225":292,"_27":293},{"_42":278,"_32":279,"_30":280,"_149":271,"_40":41,"_39":281,"_150":58,"_37":282,"_13":158,"_33":239,"_34":283,"_24":25,"_154":-5,"_225":284,"_27":285},{"_42":268,"_32":269,"_30":270,"_149":271,"_40":41,"_39":272,"_150":58,"_37":273,"_13":158,"_33":239,"_34":274,"_24":25,"_154":-5,"_225":275,"_27":276},{"_42":260,"_32":261,"_30":262,"_149":174,"_40":41,"_39":263,"_150":58,"_37":264,"_13":158,"_33":20,"_34":265,"_24":25,"_154":-5,"_225":266,"_27":267},{"_42":166,"_32":167,"_30":168,"_149":-5,"_40":41,"_39":62,"_150":58,"_37":257,"_13":152,"_33":170,"_34":-5,"_24":25,"_154":-5,"_225":258,"_27":259},{"_42":251,"_32":28,"_30":252,"_149":168,"_40":41,"_39":62,"_150":58,"_37":253,"_13":152,"_33":20,"_34":254,"_24":25,"_154":-5,"_225":255,"_27":256},{"_42":243,"_32":244,"_30":245,"_149":168,"_40":41,"_39":246,"_150":58,"_37":247,"_13":158,"_33":239,"_34":248,"_24":25,"_154":-5,"_225":249,"_27":250},{"_42":234,"_32":235,"_30":236,"_149":168,"_40":41,"_39":237,"_150":58,"_37":238,"_13":62,"_33":239,"_34":240,"_24":25,"_154":-5,"_225":241,"_27":242},{"_42":160,"_32":161,"_30":162,"_149":-5,"_40":41,"_39":62,"_150":58,"_37":231,"_13":152,"_33":20,"_34":164,"_24":25,"_154":-5,"_225":232,"_27":233},{"_42":156,"_32":28,"_30":31,"_149":-5,"_40":41,"_39":14,"_150":25,"_37":228,"_13":158,"_33":20,"_34":36,"_24":25,"_154":-5,"_225":229,"_27":230},{"_42":146,"_32":147,"_30":148,"_149":-5,"_40":41,"_39":62,"_150":58,"_37":224,"_13":152,"_33":20,"_34":153,"_24":25,"_154":-5,"_225":226,"_27":227},["D",1760090574500],"children",[],[147],["D",1760101404571],[],[28],["D",1760090574500],[],[161],"2bc24bac-a5c8-11f0-9d67-0224a6c84d84","utils.ts","0199cd92-ced6-71e8-a8db-cb925ef7126e",37,["D",1760093959460],"script","export type { Message } from \"./types.ts\";\n\nexport const MESSAGE_LIMIT = 5;",[],[167,235],"617eaef6-a5d3-11f0-b0b7-0224a6c84d84","types.ts","e635c9ac-a5c6-11f0-957a-0224a6c84d84",60,["D",1760098774076],"import { z } from \"https://esm.sh/zod@4\";\n\n// Message schema\nexport const MessageSchema = z.object({\n id: z.number(),\n content: z.string(),\n timestamp: z.string(),\n});\n\n// Widget output schemas with discriminators\nexport const MessageListOutputSchema = z.object({\n kind: z.literal(\"message_list\"),\n messages: z.array(MessageSchema),\n});\n\nexport const MessageDetailOutputSchema = MessageSchema.extend({\n kind: z.literal(\"message_detail\"),\n});\n\n// Inferred TypeScript types\nexport type Message = z.infer;\nexport type MessageListOutput = z.infer;\nexport type MessageDetailOutput = z.infer;\n\n// Discriminated union for all widget states\nexport type WidgetState = MessageListOutput | MessageDetailOutput;\n",[],[167,244],"4a338e5a-a5c0-11f0-a261-0224a6c84d84","0199cd92-ced6-71e8-a8db-c55b5ac92619",["D",1760090574500],"# Shared\n\nIt's common to have code and types that are needed on both the frontend and the backend. It's important that you write this code in a particularly defensive way because it's limited by what both environments support:\n\n![shapes at 25-02-25 11.57.13.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/75db1d51-d9b3-45e0-d178-25d886c10700/public)\n\nFor example, you *cannot* use the `Deno` keyword. For imports, you can't use `npm:` specifiers, so we reccomend `https://esm.sh` because it works on the server & client. You *can* use TypeScript because that is transpiled in `/backend/index.ts` for the frontend. Most code that works on the frontend tends to work in Deno, because Deno is designed to support \"web-standards\", but there are definitely edge cases to look out for.",[],[167,28],["D",1760090574500],[218,219,220],[167],"a507ceba-a5d7-11f0-9e39-0224a6c84d84","index.html","0199cd92-ced6-71e8-a8db-b7f39d7bbf71",90,["D",1760100605332],"\n\n\n \n \n Val Town ChatGPT App SDK Starter\n \n\n\n

Val Town ChatGPT App SDK Starter

A starter template for building ChatGPT apps with MCP (Model Context Protocol) widgets on Val Town.

\n\n

Setup Instructions

\n Copy your MCP endpoint URL:\n
\n
\n Add to ChatGPT:\n
- Open ChatGPT settings
- Navigate to \"Apps\" or \"Integrations\"
- Click \"Add MCP Server\"
- Paste your MCP endpoint URL
\n
\n Test the integration:\n
- Ask ChatGPT: \"List all messages\"
- The widget should appear with the message board interface
\n

\n\n

Available Tools

list_messages - Shows all messages in a widget
get_message - Shows details for a specific message
add_message - Adds a new message to the board

\n\n

Development

Edit the code in backend/ and frontend/widgets/ to customize your app. Changes deploy instantly to Val Town.

\n\n \n\n\n",[],[173,261],"39c53362-a5d3-11f0-970b-0224a6c84d84","widget.tsx","e5d97ba2-a5c6-11f0-9a0f-0224a6c84d84","394c4182-a5d3-11f0-967a-0224a6c84d84",52,["D",1760098707102],"/** @jsxImportSource https://esm.sh/react@19 */\nimport { createRoot } from \"https://esm.sh/react-dom@19/client?deps=react@19\";\nimport { RouterProvider } from \"https://esm.sh/@tanstack/react-router@1?deps=react@19\";\nimport { router } from \"./routes.tsx\";\n\nconst appElement = document.getElementById(\"app\");\nif (!appElement) {\n throw new Error(\"App element not found\");\n}\n\nconst root = createRoot(appElement);\nroot.render();\n",[],[173,277,269],"widgets","39ba6fb8-a5d3-11f0-a38e-0224a6c84d84","routes.tsx","e61b5824-a5c6-11f0-8fd8-0224a6c84d84",51,["D",1760098707358],"/** @jsxImportSource https://esm.sh/react@19 */\nimport {\n createRootRoute,\n createRoute,\n createRouter,\n Outlet,\n} from \"https://esm.sh/@tanstack/react-router@1?deps=react@19\";\nimport { LoadingWidget } from \"./components/LoadingWidget.tsx\";\nimport { MessageListWidget } from \"./components/MessageListWidget.tsx\";\nimport { MessageDetailWidget } from \"./components/MessageDetailWidget.tsx\";\nimport { NavigationSync } from \"./NavigationSync.tsx\";\n\nfunction RootComponent() {\n return (\n <>\n \n \n \n );\n}\n\nconst rootRoute = createRootRoute({\n component: RootComponent,\n});\n\nconst loadingRoute = createRoute({\n getParentRoute: () => rootRoute,\n path: \"/\",\n component: LoadingWidget,\n});\n\nconst listRoute = createRoute({\n getParentRoute: () => rootRoute,\n path: \"/list\",\n component: MessageListWidget,\n});\n\nconst detailRoute = createRoute({\n getParentRoute: () => rootRoute,\n path: \"/detail/$messageId\",\n component: MessageDetailWidget,\n});\n\nconst routeTree = rootRoute.addChildren([\n loadingRoute,\n listRoute,\n detailRoute,\n]);\n\nexport const router = createRouter({ routeTree });\n\ndeclare module \"https://esm.sh/@tanstack/react-router@1?deps=react@19\" {\n interface Register {\n router: typeof router;\n }\n}\n",[],[173,277,279],"39dd663a-a5d3-11f0-b75f-0224a6c84d84","openai-types.ts","e6a3256a-a5c6-11f0-bf4c-0224a6c84d84",55,["D",1760098707587],"type UnknownObject = Record;\n\nexport interface OpenAiGlobals<\n ToolInput extends UnknownObject = UnknownObject,\n ToolOutput extends UnknownObject = UnknownObject,\n ToolResponseMetadata extends UnknownObject = UnknownObject,\n WidgetState extends UnknownObject = UnknownObject,\n> {\n theme: \"light\" | \"dark\";\n userAgent: {\n device: { type: \"mobile\" | \"tablet\" | \"desktop\" | \"unknown\" };\n capabilities: {\n hover: boolean;\n touch: boolean;\n };\n };\n locale: string;\n maxHeight: number;\n displayMode: \"pip\" | \"inline\" | \"fullscreen\";\n safeArea: {\n insets: {\n top: number;\n bottom: number;\n left: number;\n right: number;\n };\n };\n toolInput: ToolInput;\n toolOutput: ToolOutput | null;\n toolResponseMetadata: ToolResponseMetadata | null;\n widgetState: WidgetState | null;\n}\n\nexport interface OpenAIWidgetAPI<\n ToolInput extends UnknownObject = UnknownObject,\n ToolOutput extends UnknownObject = UnknownObject,\n ToolResponseMetadata extends UnknownObject = UnknownObject,\n WidgetState extends UnknownObject = UnknownObject,\n> extends OpenAiGlobals<\n ToolInput,\n ToolOutput,\n ToolResponseMetadata,\n WidgetState\n > {\n setWidgetState: (state: WidgetState) => Promise;\n callTool: (name: string, args: unknown) => Promise;\n sendFollowUpMessage: (params: { prompt: string }) => Promise;\n requestDisplayMode: (mode: \"pip\" | \"inline\" | \"fullscreen\") => Promise;\n}\n\nexport const SET_GLOBALS_EVENT_TYPE = \"openai:set_globals\";\n\nexport interface SetGlobalsEvent\n extends CustomEvent<{ globals: Partial }> {\n type: typeof SET_GLOBALS_EVENT_TYPE;\n}\n\ndeclare global {\n interface Window {\n openai: OpenAIWidgetAPI;\n }\n\n interface WindowEventMap {\n [SET_GLOBALS_EVENT_TYPE]: SetGlobalsEvent;\n }\n}\n\nexport function getOpenAI(): OpenAIWidgetAPI | undefined {\n return window.openai;\n}\n",[],[173,277,287],"182d3b1a-a5d7-11f0-927d-0224a6c84d84","45792f88-a5d3-11f0-80bc-0224a6c84d84",82,["D",1760100368717],3,"\n\n \n \n \n Widget\n \n \n \n \n

\n \n \n\n",[],[173,277,261],"3990cfe6-a5d3-11f0-9f65-0224a6c84d84","hooks.ts","2ba96e48-a5c8-11f0-85d6-0224a6c84d84",47,["D",1760098707085],"/** @jsxImportSource https://esm.sh/react@19 */\nimport { useCallback, useEffect, useState, useSyncExternalStore } from \"https://esm.sh/react@19\";\nimport type { OpenAiGlobals, SetGlobalsEvent } from \"./openai-types.ts\";\nimport { getOpenAI, SET_GLOBALS_EVENT_TYPE } from \"./openai-types.ts\";\n\ntype UnknownObject = Record;\n\nexport function useOpenAiGlobal(\n key: K,\n): OpenAiGlobals[K] {\n return useSyncExternalStore(\n (onChange) => {\n function handleSetGlobal(event: Event) {\n const setGlobalsEvent = event as SetGlobalsEvent;\n const value = setGlobalsEvent.detail?.globals[key];\n\n if (value === undefined) return;\n onChange();\n }\n\n window.addEventListener(SET_GLOBALS_EVENT_TYPE, handleSetGlobal, {\n passive: true,\n });\n\n return () => {\n window.removeEventListener(SET_GLOBALS_EVENT_TYPE, handleSetGlobal);\n };\n },\n () => window.openai[key],\n );\n}\n\nexport function useToolOutput(): T | null {\n return useOpenAiGlobal(\"toolOutput\") as T | null;\n}\n\nexport function useTheme(): \"light\" | \"dark\" {\n return useOpenAiGlobal(\"theme\");\n}\n\nexport function useWidgetState(\n defaultState: T | (() => T),\n): readonly [T, (state: React.SetStateAction) => void] {\n const widgetStateFromWindow = useOpenAiGlobal(\"widgetState\") as T | null;\n\n const [widgetState, _setWidgetState] = useState(() => {\n return (\n widgetStateFromWindow ??\n (typeof defaultState === \"function\" ? defaultState() : defaultState)\n );\n });\n\n useEffect(() => {\n if (widgetStateFromWindow) {\n _setWidgetState(widgetStateFromWindow);\n }\n }, [widgetStateFromWindow]);\n\n const setWidgetState = useCallback(\n (stateOrUpdater: React.SetStateAction) => {\n _setWidgetState((prevState) => {\n const newState =\n typeof stateOrUpdater === \"function\"\n ? (stateOrUpdater as (prev: T) => T)(prevState)\n : stateOrUpdater;\n\n getOpenAI()?.setWidgetState(newState);\n return newState;\n });\n },\n [],\n );\n\n return [widgetState, setWidgetState] as const;\n}\n",[],[173,277,303],"39c9e5ec-a5d3-11f0-a38e-0224a6c84d84","NavigationSync.tsx","e5e8a2d0-a5c6-11f0-89f6-0224a6c84d84",53,["D",1760098707426],"/** @jsxImportSource https://esm.sh/react@19 */\nimport { useEffect } from \"https://esm.sh/react@19\";\nimport { useNavigate } from \"https://esm.sh/@tanstack/react-router@1?deps=react@19\";\nimport { useToolOutput } from \"./hooks.ts\";\nimport type { WidgetState } from \"../../shared/types.ts\";\n\nexport function NavigationSync() {\n const data = useToolOutput();\n const navigate = useNavigate();\n\n useEffect(() => {\n if (!data) {\n navigate({ to: \"/\" });\n return;\n }\n\n switch (data.kind) {\n case \"message_list\":\n navigate({ to: \"/list\" });\n break;\n\n case \"message_detail\":\n navigate({\n to: \"/detail/$messageId\",\n params: { messageId: String(data.id) },\n });\n break;\n }\n }, [data, navigate]);\n\n return null;\n}\n",[],[173,277,311],"099926f0-a5d6-11f0-a7b5-0224a6c84d84","MessageListWidget.tsx","2ba23c54-a5c8-11f0-85d6-0224a6c84d84","396a41aa-a5d3-11f0-9f65-0224a6c84d84",75,["D",1760099915065],"/** @jsxImportSource https://esm.sh/react@19 */\nimport type { MessageListOutput } from \"../../../shared/types.ts\";\nimport { useTheme, useToolOutput } from \"../hooks.ts\";\nimport { getOpenAI } from \"../openai-types.ts\";\n\nexport function MessageListWidget() {\n const data = useToolOutput();\n const theme = useTheme();\n const isDark = theme === \"dark\";\n\n if (!data || data.kind !== \"message_list\") {\n return (\n \n

\n \n \n Loading messages...\n

\n \n );\n }\n\n const { messages } = data;\n\n async function handleAddMessage() {\n await getOpenAI()?.sendFollowUpMessage({\n prompt: \"Add a new message\",\n });\n }\n\n return (\n \n

Messages

\n \n + Add Message\n \n

\n\n {messages.length === 0 ? (\n \n

No messages yet

Click \"Add Message\" to create one

\n \n ) : (\n

\n {messages.map((message) => (\n \n ))}\n

\n )}\n \n );\n}\n\nfunction MessageCard({ message, isDark }) {\n return (\n \n

{message.content}

\n \n {new Date(message.timestamp).toLocaleString()}\n \n \n #{message.id}\n \n

\n \n );\n}\n",[],[173,277,327,319],"components","0993a572-a5d6-11f0-9fc2-0224a6c84d84","MessageDetailWidget.tsx","2b98a41e-a5c8-11f0-afda-0224a6c84d84",74,["D",1760099915027],"/** @jsxImportSource https://esm.sh/react@19 */\nimport type { MessageDetailOutput } from \"../../../shared/types.ts\";\nimport { useTheme, useToolOutput } from \"../hooks.ts\";\nimport { getOpenAI } from \"../openai-types.ts\";\n\nexport function MessageDetailWidget() {\n const data = useToolOutput();\n const theme = useTheme();\n const isDark = theme === \"dark\";\n\n async function handleBackToList() {\n await getOpenAI()?.sendFollowUpMessage({\n prompt: \"Show me all messages\",\n });\n }\n\n if (!data || data.kind !== \"message_detail\") {\n return (\n \n

\n \n \n Loading message...\n

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

Message Details

\n\n \n

{data.content}

\n \n\n

\n \n ID\n

{data.id}

\n\n

\n \n CREATED\n

\n {new Date(data.timestamp).toLocaleString()}\n

\n \n \n\n \n ← Back to List\n \n \n );\n}\n",[],[173,277,327,329],"098e318c-a5d6-11f0-9400-0224a6c84d84","LoadingWidget.tsx","2b8dee70-a5c8-11f0-aace-0224a6c84d84",73,["D",1760099915027],"/** @jsxImportSource https://esm.sh/react@19 */\nimport { useTheme } from \"../hooks.ts\";\n\nexport function LoadingWidget() {\n const theme = useTheme();\n const isDark = theme === \"dark\";\n\n return (\n \n

\n \n \n Loading...\n

\n \n );\n}\n",[],[173,277,327,337],"396a40e2-a5d3-11f0-9f65-0224a6c84d84",46,["D",1760098706836],[207,208,209],[173,277,327],"394c40a6-a5d3-11f0-967a-0224a6c84d84",45,["D",1760098706637],[206,210,211,212,213,214,215],[173,277],["D",1760090574500],[205,216],[173],"17fe5b60-a5d7-11f0-9d94-0224a6c84d84","index.ts",77,["D",1760100368702],9,"http","import { parseProject, readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { cors } from \"npm:hono/cors\";\nimport { mcpHandler, setBaseUrl } from \"./mcp/server.ts\";\n\nconst app = new Hono();\n\n// Enable CORS for widget assets (ChatGPT iframe needs this)\napp.use(\"/widget-assets/*\", cors({\n origin: \"*\",\n allowMethods: [\"GET\", \"HEAD\", \"OPTIONS\"],\n}));\n\n// Serve setup instructions at the root /\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Get this project's URL, in a way that works across forks and branches\n const projectVal = parseProject(import.meta.url);\n const thisProjectURL = projectVal.links.self.project;\n\n // Inject the project URL for the setup instructions\n const dataScript = ``;\n\n // Insert the script right before the closing tag\n html = html.replace(\"\", `${dataScript}`);\n\n return c.html(html);\n});\n\n// MCP endpoint for ChatGPT\napp.all(\"/mcp\", async (c) => {\n // Set base URL before handling MCP request\n const url = new URL(c.req.url);\n setBaseUrl(`${url.protocol}//${url.host}`);\n\n const response = await mcpHandler(c.req.raw);\n return response;\n});\n\n// Serve widget assets with automatic transpilation\napp.get(\"/widget-assets/**/*\", (c) => {\n return serveFile(c.req.path.replace(\"/widget-assets\", \"/frontend/widgets\"), import.meta.url);\n});\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err, c) => {\n throw err;\n});\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;",[],[178,358],"81666406-a5d9-11f0-ac74-0224a6c84d84","0199cd92-ced6-71e8-a8db-8f648d1afba4",93,["D",1760101404558],"# Backend\n\nThis folder contains all backend code for the MCP server and widget serving.\n\n## Structure\n\n* `index.ts` - Main Hono application entrypoint\n* `database/` - SQLite database schema and queries\n* `mcp/` - MCP server with ChatGPT tools and widget resources\n\n## Hono\n\nThis app uses [Hono](https://hono.dev/) as the web framework. Hono is designed for serverless environments like Val Town and Cloudflare Workers. If you're familiar with Express, Flask, or Sinatra, Hono follows similar patterns.\n\n## Routes\n\nThe backend serves three types of content:\n\n### 1. Root Route (`GET /`)\nServes the setup instructions page with the dynamically injected MCP endpoint URL.\n\n### 2. MCP Endpoint (`ALL /mcp`)\nThe Model Context Protocol server endpoint that ChatGPT connects to. This handles:\n- Tool discovery and execution\n- Widget resource serving\n- Streaming HTTP transport for MCP messages\n\n### 3. Widget Assets (`GET /widget-assets/**`)\nServes the React widget files with automatic TypeScript/TSX transpilation. The backend maps requests from `/widget-assets/*` to `/frontend/widgets/*` and uses Val Town's `serveFile` utility to:\n- Read project files across branches and forks\n- Automatically transpile TSX → JS\n- Set correct content-types\n\nExample: `GET /widget-assets/widget.tsx` → serves transpiled JS from `/frontend/widgets/widget.tsx`\n\n## MCP Server\n\nThe MCP server (`backend/mcp/server.ts`) defines:\n\n1. **Widget Resource** - The HTML template that ChatGPT loads in an iframe\n2. **Tools** - Functions that ChatGPT can call (list_messages, add_message, get_message)\n3. **Widget Metadata** - Configuration for widget behavior, CSP, loading states\n\nEach tool returns structured data with a `kind` discriminator that the widget router uses for navigation.\n\n## Serving Widget HTML\n\nThe widget HTML template (`frontend/widgets/index.html`) contains `__VAL_TOWN_URL__` placeholders that get replaced with the actual deployment URL when the widget resource is requested. This ensures widget assets load from the correct domain across forks and branches.\n\n## Error Handling\n\nBy default, Hono swallows errors and returns \"Internal Server Error\". We override this behavior to see full stack traces:\n\n```typescript\napp.onError((err, c) => {\n throw err;\n});\n```\n\nThis makes debugging easier during development. You can customize this for production.\n",[],[178,28],"a50e6a54-a5d7-11f0-838e-0224a6c84d84","server.ts","e639b350-a5c6-11f0-b39d-0224a6c84d84","e5bb5ac8-a5c6-11f0-9a0f-0224a6c84d84",91,["D",1760100605335],8,"import { McpServer, StreamableHttpTransport } from \"https://esm.sh/mcp-lite@0.8.1\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { z } from \"https://esm.sh/zod@4\";\nimport { getMessages, insertMessage } from \"../database/queries.ts\";\nimport {\n MessageListOutputSchema,\n MessageDetailOutputSchema,\n} from \"../../shared/types.ts\";\n\nconst WIDGET_URI = \"ui://widget/index.html\";\n\n// Store current base URL (set per request)\nlet currentBaseUrl = \"\";\n\nexport function setBaseUrl(url: string) {\n currentBaseUrl = url;\n}\n\nfunction getBaseUrl(): string {\n if (!currentBaseUrl) {\n throw new Error(\"Base URL not set - must call setBaseUrl before handling MCP requests\");\n }\n return currentBaseUrl;\n}\n\nfunction widgetMeta(invoking?: string, invoked?: string) {\n return {\n \"openai/outputTemplate\": WIDGET_URI,\n \"openai/toolInvocation/invoking\": invoking,\n \"openai/toolInvocation/invoked\": invoked,\n \"openai/widgetAccessible\": true,\n \"openai/resultCanProduceWidget\": true,\n } as const;\n}\n\nconst mcp = new McpServer({\n name: \"valtown-message-board\",\n version: \"1.0.0\",\n schemaAdapter: (schema) => z.toJSONSchema(schema as z.ZodType),\n});\n\nasync function loadWidgetHtml(baseUrl: string): Promise {\n let html = await readFile(\"/frontend/widgets/index.html\", import.meta.url);\n html = html.replaceAll(\"__VAL_TOWN_URL__\", baseUrl);\n return html;\n}\n\nmcp.resource(\n WIDGET_URI,\n {\n name: \"Message Board Widget\",\n description: \"Interactive message board widget\",\n mimeType: \"text/html+skybridge\",\n },\n async (uri) => {\n const baseUrl = getBaseUrl();\n const html = await loadWidgetHtml(baseUrl);\n\n return {\n contents: [\n {\n uri: uri.href,\n type: \"text\",\n text: html,\n mimeType: \"text/html+skybridge\",\n _meta: {\n ...widgetMeta(),\n \"openai/widgetCSP\": {\n connect_domains: [baseUrl, \"https://esm.sh\", \"https://cdn.jsdelivr.net\"],\n resource_domains: [baseUrl, \"https://esm.sh\", \"https://cdn.jsdelivr.net\"],\n },\n },\n },\n ],\n };\n },\n);\n\nmcp.tool(\"list_messages\", {\n description: \"List all messages from the message board\",\n inputSchema: z.object({}),\n outputSchema: MessageListOutputSchema,\n _meta: widgetMeta(\"Loading messages...\", \"Messages loaded\"),\n handler: async () => {\n const messages = await getMessages();\n\n return {\n structuredContent: {\n kind: \"message_list\",\n messages,\n },\n content: [\n {\n type: \"text\",\n text: `Found ${messages.length} message${messages.length === 1 ? \"\" : \"s\"}`,\n },\n ],\n _meta: widgetMeta(),\n };\n },\n});\n\nmcp.tool(\"get_message\", {\n description: \"Get a specific message by ID\",\n inputSchema: z.object({\n id: z.number().describe(\"Message ID\"),\n }),\n outputSchema: MessageDetailOutputSchema,\n _meta: widgetMeta(\"Loading message...\", \"Message loaded\"),\n handler: async ({ id }) => {\n const messages = await getMessages();\n const message = messages.find((m) => m.id === id);\n\n if (!message) {\n throw new Error(`Message with ID ${id} not found`);\n }\n\n return {\n structuredContent: {\n kind: \"message_detail\",\n ...message,\n },\n content: [\n {\n type: \"text\",\n text: `Message #${id}: ${message.content}`,\n },\n ],\n _meta: widgetMeta(),\n };\n },\n});\n\nmcp.tool(\"add_message\", {\n description: \"Add a new message to the message board\",\n inputSchema: z.object({\n content: z.string().describe(\"The message content\"),\n }),\n outputSchema: MessageListOutputSchema,\n _meta: widgetMeta(\"Adding message...\", \"Message added\"),\n handler: async ({ content }) => {\n if (!content || content.trim() === \"\") {\n throw new Error(\"Message content cannot be empty\");\n }\n\n await insertMessage(content);\n\n // Return updated message list\n const messages = await getMessages();\n\n return {\n structuredContent: {\n kind: \"message_list\",\n messages,\n },\n content: [\n {\n type: \"text\",\n text: `Added message: \"${content}\"`,\n },\n ],\n _meta: widgetMeta(),\n };\n },\n});\n\nconst transport = new StreamableHttpTransport();\nexport const mcpHandler = transport.bind(mcp);\n",[],[178,383,374],"mcp","e5bb5a1e-a5c6-11f0-9a0f-0224a6c84d84",4,["D",1760093412477],[201],[178,383],"4a337316-a5c0-11f0-a261-0224a6c84d84","schema.ts","0199cd92-ced6-71e8-a8db-850ab1185000","0199cd92-ced6-71e8-a8db-8890d3b47b22",["D",1760090574500],"import { sqliteTable, text, integer } from \"npm:drizzle-orm/sqlite-core\";\n\n// Messages table\nexport const messages = sqliteTable(\"messages\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n content: text(\"content\").notNull(),\n timestamp: text(\"timestamp\").notNull().default(new Date().toISOString()),\n});\n\n// Type exports\nexport type Message = typeof messages.$inferSelect;",[],[178,397,390],"database","4a3361aa-a5c0-11f0-a261-0224a6c84d84","queries.ts","0199cd92-ced6-71e8-a8db-822272cd45fd",["D",1760090574500],"import { desc } from \"npm:drizzle-orm\";\nimport { db, schema } from \"./db.ts\";\nimport { createTables } from \"./migrations.ts\";\nimport { MESSAGE_LIMIT } from \"../../shared/utils.ts\";\n\n// This will create the database table if it doesn't exist.\n// This will run every time the app starts up. You can\n// comment out this line for a modest (30ms) performance improvement\n// on cold starts. It's left in to ensure the database tables are\n// automatically set up correctly for users who fork this app.\nawait createTables();\n\nexport async function getMessages(limit = MESSAGE_LIMIT) {\n const messages = await db\n .select()\n .from(schema.messages)\n .orderBy(desc(schema.messages.timestamp))\n .limit(limit)\n .all();\n \n return messages;\n}\n\nexport async function insertMessage(content: string) {\n await db\n .insert(schema.messages)\n .values({\n content,\n timestamp: new Date().toISOString(),\n })\n .run();\n}",[],[178,397,399],"a5022906-a5d7-11f0-8432-0224a6c84d84","migrations.ts","0199cd92-ced6-71e8-a8db-7d5d2a4bb2ae",89,["D",1760100605330],"import { sql } from \"npm:drizzle-orm\";\nimport { db } from \"./db.ts\";\n\nexport async function createTables() {\n // Uncomment to reset database\n await db.run(sql`DROP TABLE IF EXISTS messages`);\n // Create messages table\n await db.run(sql`\n CREATE TABLE IF NOT EXISTS messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n content TEXT NOT NULL,\n timestamp TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n}",[],[178,397,406],"4a335e6c-a5c0-11f0-a261-0224a6c84d84","db.ts","0199cd92-ced6-71e8-a8db-797489caa3cc",["D",1760090574500],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { drizzle } from \"npm:drizzle-orm/libsql\";\nimport * as schema from \"./schema.ts\";\n\n// Create Drizzle instance with Val Town's sqlite\nexport const db = drizzle(sqlite as any);\n\n// Export schema for convenience\nexport { schema };",[],[178,397,414],"816fb6aa-a5d9-11f0-b868-0224a6c84d84","0199cd92-ced6-71e8-a8db-76bef76c0624",94,["D",1760101404564],"# Database\n\nThis app uses [Val Town SQLite](https://docs.val.town/std/sqlite/) to manage data. Every Val Town account comes with a free SQLite database, hosted on [Turso](https://turso.tech/).\n\n## Structure\n\n* `schema.ts` - Drizzle ORM schema definitions (tables, columns, types)\n* `migrations.ts` - Database table creation logic\n* `queries.ts` - Query functions used by MCP tools\n* `db.ts` - Database connection configuration\n\n## Tables\n\nThe starter includes a `messages` table for storing message board data:\n\n```typescript\nexport const messages = sqliteTable(\"messages\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n content: text(\"content\").notNull(),\n timestamp: text(\"timestamp\").notNull().default(new Date().toISOString()),\n});\n```\n\n## Migrations\n\nMigrations run automatically on startup via `createTables()` in `migrations.ts`, which is imported in `queries.ts`.\n\nThe migration logic uses `CREATE TABLE IF NOT EXISTS`, so it's safe to run on every startup. You can comment out the import in `queries.ts` for a slight (30ms) performance improvement on cold starts, but it's left in by default so forks work out of the box.\n\n## Queries\n\nThe `queries.ts` file exports typed functions for database operations:\n\n- `getMessages(limit?)` - Fetch messages with optional limit\n- `insertMessage(content)` - Insert a new message\n\nThese functions are imported and used by MCP tools in `backend/mcp/server.ts`.\n\n## Schema Changes\n\nSQLite has limited support for altering existing tables. When you need to modify a table schema:\n\n1. Create a new table with the updated schema\n2. Copy data from the old table to the new table\n3. Drop the old table\n4. Rename the new table\n\nAlternatively, you can just change the table name (e.g., `messages_v2`) to start fresh.\n\nFor help with database operations, reach out in the [Val Town Discord](https://discord.com/invite/dHv45uN5RY).\n",[],[178,397,28],"4a337546-a5c0-11f0-a261-0224a6c84d84",["D",1760090574500],[195,196,197,198,199],[178,397],["D",1760090574500],[194,200,202,203],[178],["D",1760090574500],{"_99":98,"_106":102},{"_99":98,"_100":-5,"_101":102,"_18":54,"_103":104,"_105":25},{"_13":85,"_32":86,"_42":41,"_87":43,"_88":89,"_90":91,"_92":49,"_93":94,"_95":64,"_96":44,"_97":98},"ctx",{"_78":-5,"_128":471,"_472":473,"_474":475,"_476":25,"_477":25,"_478":25,"_479":58,"_480":-5,"_481":-7,"_482":-7,"_483":152,"_484":25,"_485":25,"_486":-5,"_487":25,"_488":25,"_489":25,"_490":-5},"ENV",{"_442":443,"_444":445,"_446":86,"_447":448,"_449":450,"_451":452,"_453":454,"_455":456,"_457":458,"_459":460,"_461":462,"_463":464,"_465":466,"_467":468,"_469":470},"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 · v95