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",[],[163,171],"b36218ea-a5e5-11f0-8f15-0224a6c84d84","widgets","0199ce87-fbda-7524-96e6-ee0ed769666d",["D",1760106642287],[183,184,185,186,187,188,189],[163,178],{"_36":231,"_13":232,"_67":233,"_69":179,"_71":72,"_73":74,"_75":76,"_38":234,"_17":32,"_78":95,"_80":-5,"_82":53,"_83":-5,"_116":235,"_18":236},{"_36":224,"_13":225,"_67":226,"_69":179,"_71":72,"_73":74,"_75":76,"_38":227,"_17":32,"_78":145,"_80":228,"_82":53,"_83":-5,"_116":229,"_18":230},{"_36":217,"_13":218,"_67":219,"_69":179,"_71":72,"_73":74,"_75":76,"_38":220,"_17":32,"_78":145,"_80":221,"_82":53,"_83":-5,"_116":222,"_18":223},{"_36":211,"_13":171,"_67":212,"_69":179,"_71":72,"_73":74,"_75":76,"_38":213,"_17":32,"_78":24,"_80":214,"_82":53,"_83":-5,"_116":215,"_18":216},{"_36":204,"_13":205,"_67":206,"_69":179,"_71":72,"_73":74,"_75":76,"_38":207,"_17":32,"_78":145,"_80":208,"_82":53,"_83":-5,"_116":209,"_18":210},{"_36":197,"_13":198,"_67":199,"_69":179,"_71":72,"_73":74,"_75":76,"_38":200,"_17":32,"_78":145,"_80":201,"_82":53,"_83":-5,"_116":202,"_18":203},{"_36":190,"_13":191,"_67":192,"_69":179,"_71":72,"_73":74,"_75":76,"_38":193,"_17":32,"_78":145,"_80":194,"_82":53,"_83":-5,"_116":195,"_18":196},"b36217d2-a5e5-11f0-8f15-0224a6c84d84","widget.tsx","0199ce87-fbda-7524-96e6-e96b6839065a",["D",1760106642287],"/** @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",[],[163,178,191],"b36215ca-a5e5-11f0-8f15-0224a6c84d84","routes.tsx","0199ce87-fbda-7524-96e6-e6ef2e2f2b95",["D",1760106642287],"/** @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",[],[163,178,198],"b3620fb2-a5e5-11f0-8f15-0224a6c84d84","openai-types.ts","0199ce87-fbda-7524-96e6-e271439a3c20",["D",1760106642287],"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",[],[163,178,205],"b3620e2c-a5e5-11f0-8f15-0224a6c84d84","0199ce87-fbda-7524-96e6-dc9bc3ae9175",["D",1760106642287],"\n\n \n \n \n Widget\n \n \n \n \n

\n \n \n\n",[],[163,178,171],"b3620b34-a5e5-11f0-8f15-0224a6c84d84","hooks.ts","0199ce87-fbda-7524-96e6-d968a01fcb12",["D",1760106642287],"/** @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",[],[163,178,218],"b3620a1c-a5e5-11f0-8f15-0224a6c84d84","NavigationSync.tsx","0199ce87-fbda-7524-96e6-d537a3c73e32",["D",1760106642287],"/** @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",[],[163,178,225],"b36208fa-a5e5-11f0-8f15-0224a6c84d84","components","0199ce87-fbda-7524-96e6-d2efb46d2afe",["D",1760106642287],[237,238,239],[163,178,232],{"_36":254,"_13":255,"_67":256,"_69":233,"_71":72,"_73":74,"_75":76,"_38":257,"_17":32,"_78":145,"_80":258,"_82":53,"_83":-5,"_116":259,"_18":260},{"_36":247,"_13":248,"_67":249,"_69":233,"_71":72,"_73":74,"_75":76,"_38":250,"_17":32,"_78":145,"_80":251,"_82":53,"_83":-5,"_116":252,"_18":253},{"_36":240,"_13":241,"_67":242,"_69":233,"_71":72,"_73":74,"_75":76,"_38":243,"_17":32,"_78":145,"_80":244,"_82":53,"_83":-5,"_116":245,"_18":246},"b36203d2-a5e5-11f0-8f15-0224a6c84d84","MessageListWidget.tsx","0199ce87-fbda-7524-96e6-cc527981c238",["D",1760106642287],"/** @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",[],[163,178,232,241],"b3620166-a5e5-11f0-8f15-0224a6c84d84","MessageDetailWidget.tsx","0199ce87-fbda-7524-96e6-c966a47f993e",["D",1760106642287],"/** @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",[],[163,178,232,248],"b361ffae-a5e5-11f0-8f15-0224a6c84d84","LoadingWidget.tsx","0199ce87-fbda-7524-96e6-c6ef23c8b0ba",["D",1760106642287],"/** @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",[],[163,178,232,255],["D",1760106642287],[264,265,266,267],[19],{"_36":97,"_13":98,"_67":99,"_69":70,"_71":72,"_73":74,"_75":76,"_38":285,"_17":32,"_78":95,"_80":-5,"_82":53,"_83":-5,"_116":286,"_18":287},{"_36":91,"_13":92,"_67":93,"_69":70,"_71":72,"_73":74,"_75":76,"_38":274,"_17":32,"_78":95,"_80":-5,"_82":53,"_83":-5,"_116":275,"_18":276},{"_36":85,"_13":86,"_67":87,"_69":70,"_71":72,"_73":74,"_75":76,"_38":271,"_17":32,"_78":24,"_80":89,"_82":53,"_83":-5,"_116":272,"_18":273},{"_36":65,"_13":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_38":268,"_17":32,"_78":79,"_80":81,"_82":53,"_83":-5,"_116":269,"_18":270},["D",1760106642287],[],[19,66],["D",1760106642287],[],[19,86],["D",1760106642287],[277],[19,92],{"_36":278,"_13":279,"_67":280,"_69":93,"_71":72,"_73":74,"_75":76,"_38":281,"_17":32,"_78":145,"_80":282,"_82":53,"_83":-5,"_116":283,"_18":284},"b361e7ee-a5e5-11f0-8f15-0224a6c84d84","server.ts","0199ce87-fbda-7524-96e6-b20af7dad923",["D",1760106642287],"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",[],[19,92,279],["D",1760106642287],[288,289,290,291,292],[19,98],{"_36":321,"_13":86,"_67":322,"_69":99,"_71":72,"_73":74,"_75":76,"_38":323,"_17":32,"_78":24,"_80":324,"_82":53,"_83":-5,"_116":325,"_18":326},{"_36":314,"_13":315,"_67":316,"_69":99,"_71":72,"_73":74,"_75":76,"_38":317,"_17":32,"_78":145,"_80":318,"_82":53,"_83":-5,"_116":319,"_18":320},{"_36":307,"_13":308,"_67":309,"_69":99,"_71":72,"_73":74,"_75":76,"_38":310,"_17":32,"_78":145,"_80":311,"_82":53,"_83":-5,"_116":312,"_18":313},{"_36":300,"_13":301,"_67":302,"_69":99,"_71":72,"_73":74,"_75":76,"_38":303,"_17":32,"_78":145,"_80":304,"_82":53,"_83":-5,"_116":305,"_18":306},{"_36":293,"_13":294,"_67":295,"_69":99,"_71":72,"_73":74,"_75":76,"_38":296,"_17":32,"_78":145,"_80":297,"_82":53,"_83":-5,"_116":298,"_18":299},"b361e3fc-a5e5-11f0-8f15-0224a6c84d84","schema.ts","0199ce87-fbda-7524-96e6-ab4d7e3f4c83",["D",1760106642287],"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;",[],[19,98,294],"b361e2bc-a5e5-11f0-8f15-0224a6c84d84","queries.ts","0199ce87-fbda-7524-96e6-a70a239e6683",["D",1760106642287],"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}",[],[19,98,301],"b361e172-a5e5-11f0-8f15-0224a6c84d84","migrations.ts","0199ce87-fbda-7524-96e6-a01c85e80bd1",["D",1760106642287],"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}",[],[19,98,308],"b361de48-a5e5-11f0-8f15-0224a6c84d84","db.ts","0199ce87-fbda-7524-96e6-9de157aeec5d",["D",1760106642287],"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 };",[],[19,98,315],"b361d48e-a5e5-11f0-8f15-0224a6c84d84","0199ce87-fbda-7524-96e6-9b65d6f0ebb5",["D",1760106642287],"# 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",[],[19,98,86],"b3556302-a5e5-11f0-8f15-0224a6c84d84",["D",1760106642287],"legacyEnvVars","httpPrivacy","description","imageUrl","userId","5d1042a9-7b0b-499d-8a72-3a8ac7a4e185","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","5f80108f-7ca4-4327-b77b-089dbe4b5a82","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_370":366},"org",{"_11":12,"_364":-5,"_365":366,"_333":334,"_367":368,"_369":53},"branch",{"_17":74,"_13":16,"_36":72,"_42":327,"_45":37,"_47":360,"_361":55,"_362":43,"_363":59,"_60":14,"_56":12},95,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://secure.gravatar.com/avatar/0129a541b7b3574e92c4afd06c5e32da&d=identicon","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":327,"_13":14,"_38":508,"_51":-5,"_329":53,"_54":55,"_330":55,"_331":-5,"_332":-5,"_333":334,"_335":68,"_336":76,"_337":76,"_338":-5,"_339":32,"_58":340,"_341":-5,"_342":-5,"_343":-5,"_344":-5,"_345":346,"_347":346,"_348":349,"_350":349,"_351":349,"_352":346,"_353":346,"_354":509,"_356":510,"_358":511,"_52":53},[415,426,439,443,444,445],"files",[415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445],"counts",{"_406":32,"_407":74,"_408":32,"_35":409,"_410":411},[398,399,400,401],{"_36":102,"_13":19,"_67":70,"_69":-5,"_71":72,"_73":74,"_75":76,"_38":103,"_17":32,"_78":95,"_80":-5,"_82":53,"_83":-5,"_18":397},"upstreamProject",{"_36":43,"_13":14,"_331":394,"_332":-5,"_54":55,"_354":395},"upstreamBranch",{"_36":37,"_38":392,"_40":393,"_13":16,"_42":43,"_17":44,"_45":46,"_47":48,"_49":50,"_51":-5,"_52":53,"_54":55,"_56":57,"_58":59,"_60":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1760090574500],["D",1760360744579],"A starter val for building ChatGPT Apps powered by React",{"_11":57,"_370":396},"https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJzeDdZM2RjbFBvQ1NTM2tWdXRNbjBEaER0dCJ9",[19],{"_36":97,"_13":98,"_67":99,"_69":70,"_71":72,"_73":74,"_75":76,"_38":100,"_17":32,"_78":95,"_80":-5,"_82":53,"_83":-5,"_18":405},{"_36":91,"_13":92,"_67":93,"_69":70,"_71":72,"_73":74,"_75":76,"_38":94,"_17":32,"_78":95,"_80":-5,"_82":53,"_83":-5,"_18":404},{"_36":85,"_13":86,"_67":87,"_69":70,"_71":72,"_73":74,"_75":76,"_38":88,"_17":32,"_78":24,"_80":89,"_82":53,"_83":-5,"_18":403},{"_36":65,"_13":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_38":77,"_17":32,"_78":79,"_80":81,"_82":53,"_83":-5,"_18":402},[19,66],[19,86],[19,92],[19,98],"pulls","branches","forks",{"_412":32,"_414":32},"connections",{"_412":32,"_413":32},"count","unfilledCount","emptyCount",{"_36":102,"_13":19,"_67":70,"_69":-5,"_71":72,"_73":74,"_75":76,"_38":261,"_17":32,"_78":95,"_80":-5,"_82":53,"_83":-5,"_116":506,"_18":507},{"_36":97,"_13":98,"_67":99,"_69":70,"_71":72,"_73":74,"_75":76,"_38":285,"_17":32,"_78":95,"_80":-5,"_82":53,"_83":-5,"_116":504,"_18":505},{"_36":321,"_13":86,"_67":322,"_69":99,"_71":72,"_73":74,"_75":76,"_38":323,"_17":32,"_78":24,"_80":324,"_82":53,"_83":-5,"_116":502,"_18":503},{"_36":314,"_13":315,"_67":316,"_69":99,"_71":72,"_73":74,"_75":76,"_38":317,"_17":32,"_78":145,"_80":318,"_82":53,"_83":-5,"_116":500,"_18":501},{"_36":307,"_13":308,"_67":309,"_69":99,"_71":72,"_73":74,"_75":76,"_38":310,"_17":32,"_78":145,"_80":311,"_82":53,"_83":-5,"_116":498,"_18":499},{"_36":300,"_13":301,"_67":302,"_69":99,"_71":72,"_73":74,"_75":76,"_38":303,"_17":32,"_78":145,"_80":304,"_82":53,"_83":-5,"_116":496,"_18":497},{"_36":293,"_13":294,"_67":295,"_69":99,"_71":72,"_73":74,"_75":76,"_38":296,"_17":32,"_78":145,"_80":297,"_82":53,"_83":-5,"_116":494,"_18":495},{"_36":91,"_13":92,"_67":93,"_69":70,"_71":72,"_73":74,"_75":76,"_38":274,"_17":32,"_78":95,"_80":-5,"_82":53,"_83":-5,"_116":492,"_18":493},{"_36":278,"_13":279,"_67":280,"_69":93,"_71":72,"_73":74,"_75":76,"_38":281,"_17":32,"_78":145,"_80":282,"_82":53,"_83":-5,"_116":490,"_18":491},{"_36":85,"_13":86,"_67":87,"_69":70,"_71":72,"_73":74,"_75":76,"_38":271,"_17":32,"_78":24,"_80":89,"_82":53,"_83":-5,"_116":488,"_18":489},{"_36":65,"_13":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_38":268,"_17":32,"_78":79,"_80":81,"_82":53,"_83":-5,"_116":486,"_18":487},{"_36":162,"_13":163,"_67":164,"_69":-5,"_71":72,"_73":74,"_75":76,"_38":165,"_17":32,"_78":95,"_80":-5,"_82":53,"_83":-5,"_116":484,"_18":485},{"_36":177,"_13":178,"_67":179,"_69":164,"_71":72,"_73":74,"_75":76,"_38":180,"_17":32,"_78":95,"_80":-5,"_82":53,"_83":-5,"_116":482,"_18":483},{"_36":231,"_13":232,"_67":233,"_69":179,"_71":72,"_73":74,"_75":76,"_38":234,"_17":32,"_78":95,"_80":-5,"_82":53,"_83":-5,"_116":480,"_18":481},{"_36":254,"_13":255,"_67":256,"_69":233,"_71":72,"_73":74,"_75":76,"_38":257,"_17":32,"_78":145,"_80":258,"_82":53,"_83":-5,"_116":478,"_18":479},{"_36":247,"_13":248,"_67":249,"_69":233,"_71":72,"_73":74,"_75":76,"_38":250,"_17":32,"_78":145,"_80":251,"_82":53,"_83":-5,"_116":476,"_18":477},{"_36":240,"_13":241,"_67":242,"_69":233,"_71":72,"_73":74,"_75":76,"_38":243,"_17":32,"_78":145,"_80":244,"_82":53,"_83":-5,"_116":474,"_18":475},{"_36":224,"_13":225,"_67":226,"_69":179,"_71":72,"_73":74,"_75":76,"_38":227,"_17":32,"_78":145,"_80":228,"_82":53,"_83":-5,"_116":472,"_18":473},{"_36":217,"_13":218,"_67":219,"_69":179,"_71":72,"_73":74,"_75":76,"_38":220,"_17":32,"_78":145,"_80":221,"_82":53,"_83":-5,"_116":470,"_18":471},{"_36":211,"_13":171,"_67":212,"_69":179,"_71":72,"_73":74,"_75":76,"_38":213,"_17":32,"_78":24,"_80":214,"_82":53,"_83":-5,"_116":468,"_18":469},{"_36":204,"_13":205,"_67":206,"_69":179,"_71":72,"_73":74,"_75":76,"_38":207,"_17":32,"_78":145,"_80":208,"_82":53,"_83":-5,"_116":466,"_18":467},{"_36":197,"_13":198,"_67":199,"_69":179,"_71":72,"_73":74,"_75":76,"_38":200,"_17":32,"_78":145,"_80":201,"_82":53,"_83":-5,"_116":464,"_18":465},{"_36":190,"_13":191,"_67":192,"_69":179,"_71":72,"_73":74,"_75":76,"_38":193,"_17":32,"_78":145,"_80":194,"_82":53,"_83":-5,"_116":462,"_18":463},{"_36":170,"_13":171,"_67":172,"_69":164,"_71":72,"_73":74,"_75":76,"_38":173,"_17":32,"_78":24,"_80":174,"_82":53,"_83":-5,"_116":460,"_18":461},{"_36":132,"_13":133,"_67":134,"_69":-5,"_71":72,"_73":74,"_75":76,"_38":135,"_17":32,"_78":95,"_80":-5,"_82":53,"_83":-5,"_116":458,"_18":459},{"_36":156,"_13":86,"_67":157,"_69":134,"_71":72,"_73":74,"_75":76,"_38":158,"_17":32,"_78":24,"_80":159,"_82":53,"_83":-5,"_116":456,"_18":457},{"_36":149,"_13":150,"_67":151,"_69":134,"_71":72,"_73":74,"_75":76,"_38":152,"_17":32,"_78":145,"_80":153,"_82":53,"_83":-5,"_116":454,"_18":455},{"_36":141,"_13":142,"_67":143,"_69":134,"_71":72,"_73":74,"_75":76,"_38":144,"_17":32,"_78":145,"_80":146,"_82":53,"_83":-5,"_116":452,"_18":453},{"_36":125,"_13":126,"_67":127,"_69":-5,"_71":72,"_73":74,"_75":76,"_38":128,"_17":32,"_78":24,"_80":129,"_82":53,"_83":-5,"_116":450,"_18":451},{"_36":119,"_13":86,"_67":120,"_69":-5,"_71":72,"_73":74,"_75":76,"_38":121,"_17":32,"_78":24,"_80":122,"_82":53,"_83":-5,"_116":448,"_18":449},{"_36":111,"_13":112,"_67":113,"_69":-5,"_71":72,"_73":74,"_75":76,"_38":114,"_17":32,"_78":24,"_80":115,"_82":53,"_83":-5,"_116":446,"_18":447},[],[112],[],[86],[],[126],[],[133,142],[],[133,150],[],[133,86],[440,441,442],[133],[],[163,171],[],[163,178,191],[],[163,178,198],[],[163,178,205],[],[163,178,171],[],[163,178,218],[],[163,178,225],[],[163,178,232,241],[],[163,178,232,248],[],[163,178,232,255],[429,430,431],[163,178,232],[428,432,433,434,435,436,437],[163,178],[427,438],[163],[],[19,66],[],[19,86],[],[19,92,279],[423],[19,92],[],[19,98,294],[],[19,98,301],[],[19,98,308],[],[19,98,315],[],[19,98,86],[417,418,419,420,421],[19,98],[416,422,424,425],[19],["D",1760106642287],{"_11":12,"_370":366},{"_11":12,"_364":-5,"_365":366,"_333":334,"_367":368,"_369":53},{"_17":74,"_13":16,"_36":72,"_42":327,"_45":37,"_47":360,"_361":55,"_362":43,"_363":59,"_60":14,"_56":12},"ctx",{"_354":-5,"_389":545,"_546":547,"_548":549,"_550":53,"_551":53,"_552":53,"_553":76,"_554":-5,"_555":-7,"_556":-7,"_557":32,"_558":53,"_559":53,"_560":-5,"_561":53,"_562":53,"_563":53,"_564":-5},"ENV",{"_516":517,"_518":519,"_520":16,"_521":522,"_523":524,"_525":526,"_527":528,"_529":530,"_531":532,"_533":534,"_535":536,"_537":538,"_539":540,"_541":542,"_543":544},"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"]