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",[],[167,255],"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",[],[167,271,263],"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",[],[167,271,273],"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",[],[167,271,281],"182d3b1a-a5d7-11f0-927d-0224a6c84d84","45792f88-a5d3-11f0-80bc-0224a6c84d84",82,["D",1760100368717],"\n\n \n \n \n Widget\n \n \n \n \n

\n \n \n\n",[],[167,271,255],"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",[],[167,271,296],"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",[],[167,271,304],"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",[],[167,271,320,312],"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",[],[167,271,320,322],"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",[],[167,271,320,330],"396a40e2-a5d3-11f0-9f65-0224a6c84d84",46,["D",1760098706836],[200,201,202],[167,271,320],"394c40a6-a5d3-11f0-967a-0224a6c84d84",45,["D",1760098706637],[199,203,204,205,206,207,208],[167,271],["D",1760090574500],[198,209],[167],"44f54632-a817-11f0-9ba7-0224a6c84d84","index.ts",["D",1760347834299],10,"http","import { 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 the deployed web URL from the request\n const url = new URL(c.req.url);\n const deployedURL = `${url.protocol}//${url.host}`;\n\n // Inject the deployed 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;",[],[172,351],"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",[],[172,148],"69f2d25c-a834-11f0-b5ad-0224a6c84d84","server.ts","e639b350-a5c6-11f0-b39d-0224a6c84d84","e5bb5ac8-a5c6-11f0-9a0f-0224a6c84d84",103,["D",1760360351768],12,"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\n// Add logging middleware to inspect JSON-RPC payloads\nmcp.use(async (ctx, next) => {\n const start = Date.now();\n\n // Log incoming request with full structure\n console.log(\"\\n→ MCP Request:\");\n console.log(` Method: ${ctx.request.method}`);\n console.log(` Full request: ${JSON.stringify(ctx.request, null, 2)}`);\n\n await next();\n\n const duration = Date.now() - start;\n\n // Log outgoing response\n console.log(`\\n← MCP Response (${duration}ms):`);\n console.log(` Method: ${ctx.request.method}`);\n\n if (ctx.response?.result) {\n const resultStr = JSON.stringify(ctx.response.result, null, 2);\n // Truncate long responses for readability\n if (resultStr.length > 500) {\n console.log(` Result: ${resultStr.substring(0, 500)}... (truncated)`);\n } else {\n console.log(` Result: ${resultStr}`);\n }\n }\n\n if (ctx.response?.error) {\n console.log(` Error: ${JSON.stringify(ctx.response.error, null, 2)}`);\n }\n\n console.log(\"\"); // Empty line for readability\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 (args, ctx) => {\n const subject = ctx.request.params._meta?.[\"openai/subject\"];\n if (!subject) {\n throw new Error(\"Missing openai/subject in request metadata\");\n }\n\n const messages = await getMessages(subject);\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 }, ctx) => {\n const subject = ctx.request.params._meta?.[\"openai/subject\"];\n if (!subject) {\n throw new Error(\"Missing openai/subject in request metadata\");\n }\n\n const messages = await getMessages(subject);\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 }, ctx) => {\n if (!content || content.trim() === \"\") {\n throw new Error(\"Message content cannot be empty\");\n }\n\n const subject = ctx.request.params._meta?.[\"openai/subject\"];\n if (!subject) {\n throw new Error(\"Missing openai/subject in request metadata\");\n }\n\n await insertMessage(subject, content);\n\n // Return updated message list\n const messages = await getMessages(subject);\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",[],[172,375,366],"mcp","e5bb5a1e-a5c6-11f0-9a0f-0224a6c84d84",4,["D",1760093412477],[194],[172,375],"3644d08c-a833-11f0-ad00-0224a6c84d84","schema.ts","0199cd92-ced6-71e8-a8db-850ab1185000","0199cd92-ced6-71e8-a8db-8890d3b47b22",101,["D",1760359835565],"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 subject: text(\"subject\").notNull(),\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;",[],[172,390,382],"database","36317a1e-a833-11f0-bda3-0224a6c84d84","queries.ts","0199cd92-ced6-71e8-a8db-822272cd45fd",100,["D",1760359835356],"import { desc, eq } 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(subject: string, limit = MESSAGE_LIMIT) {\n const messages = await db\n .select()\n .from(schema.messages)\n .where(eq(schema.messages.subject, subject))\n .orderBy(desc(schema.messages.timestamp))\n .limit(limit)\n .all();\n\n return messages;\n}\n\nexport async function insertMessage(subject: string, content: string) {\n await db\n .insert(schema.messages)\n .values({\n subject,\n content,\n timestamp: new Date().toISOString(),\n })\n .run();\n}",[],[172,390,392],"362492e0-a833-11f0-b342-0224a6c84d84","migrations.ts","0199cd92-ced6-71e8-a8db-7d5d2a4bb2ae",98,["D",1760359835353],"import { sql } from \"npm:drizzle-orm\";\nimport { db } from \"./db.ts\";\n\nexport async function createTables() {\n // Drop and recreate table with new schema\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 subject TEXT NOT NULL,\n content TEXT NOT NULL,\n timestamp TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n}\n",[],[172,390,400],"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 };",[],[172,390,408],"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",[],[172,390,148],"4a337546-a5c0-11f0-a261-0224a6c84d84",["D",1760090574500],[188,189,190,191,192],[172,390],["D",1760090574500],[187,193,195,196],[172],["D",1760090574500],{"_11":12,"_91":87},{"_11":12,"_85":-5,"_86":87,"_47":48,"_88":89,"_90":40},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":32,"_33":34,"_79":42,"_80":81,"_82":58,"_83":14,"_84":12},"ctx",{"_72":-5,"_115":465,"_466":467,"_468":469,"_470":40,"_471":40,"_472":40,"_473":52,"_474":-5,"_475":-7,"_476":-7,"_477":140,"_478":40,"_479":40,"_480":-5,"_481":40,"_482":40,"_483":40,"_484":-5},"ENV",{"_436":437,"_438":439,"_440":26,"_441":442,"_443":444,"_445":446,"_447":448,"_449":450,"_451":452,"_453":454,"_455":456,"_457":458,"_459":460,"_461":462,"_463":464},"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"]

Branches1

Branches
1