[{"_1":2,"_171":-5,"_172":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","8a08d4a46a197c541e82d5fac862bafdcf40c111","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_149":150,"_168":169,"_170":-5},"handle","dcm31","name","mcpChat","path","db.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":111,"_112":-5,"_12":113,"_114":-5,"_115":20,"_116":-5,"_117":-5,"_118":32,"_14":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":129,"_132":133,"_135":136,"_148":20},"id","c0531f24-dccf-11f0-ad8e-42dde27851f2","createdAt",["D",1766144529147],"deletedAt","legacyEnvVars","privacy","public","description","ChatGPT-style chat with MCP tools","imageUrl","9319c175-2593-4f88-ba21-04f2ef7b1c28","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","d663a026-6449-42f6-9156-1d4a2d64d38c","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_130":131},"profileImageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/260ec866-bb5d-4641-4bfe-526cca896a00/square512","org",{"_94":95,"_134":131,"_12":113},"avatar","branch",{"_137":138,"_96":44,"_102":139,"_140":103,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":97,"_147":95},"version",8,"c053926a-dccf-11f0-ad8e-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":151,"_96":99,"_152":153,"_154":-5,"_155":139,"_156":138,"_157":158,"_104":159,"_137":160,"_161":162,"_163":164,"_165":20,"_166":-5,"_98":167},"2122cfba-dcd6-11f0-a9b6-42dde27851f2","fileId","cbfb218c-dccf-11f0-ad4b-42dde27851f2","parentId","branchId","branchVersion","latest",true,["D",1766147268544],1,"fileType","script","content","/**\n * Database operations for MCP Chat\n * Stores chats, messages, and MCP server configs\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// Initialize tables\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS mcp_chats (\n id TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )\n`);\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS mcp_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n chat_id TEXT NOT NULL,\n role TEXT NOT NULL,\n content TEXT NOT NULL,\n created_at TEXT NOT NULL,\n FOREIGN KEY (chat_id) REFERENCES mcp_chats(id)\n )\n`);\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS mcp_servers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n url TEXT NOT NULL,\n auth_env_key TEXT,\n enabled INTEGER DEFAULT 1,\n created_at TEXT NOT NULL\n )\n`);\n\n// Types\nexport interface Chat {\n id: string;\n title: string;\n created_at: string;\n updated_at: string;\n}\n\nexport interface Message {\n id: number;\n chat_id: string;\n role: \"user\" | \"assistant\";\n content: string;\n created_at: string;\n}\n\nexport interface McpServer {\n id: number;\n name: string;\n url: string;\n auth_env_key: string | null;\n enabled: boolean;\n created_at: string;\n}\n\n// Chat operations\nexport async function createChat(title: string = \"New Chat\"): Promise {\n const id = crypto.randomUUID();\n const now = new Date().toISOString();\n await sqlite.execute({\n sql: \"INSERT INTO mcp_chats (id, title, created_at, updated_at) VALUES (?, ?, ?, ?)\",\n args: [id, title, now, now],\n });\n return { id, title, created_at: now, updated_at: now };\n}\n\nexport async function getAllChats(): Promise {\n const result = await sqlite.execute(\n \"SELECT id, title, created_at, updated_at FROM mcp_chats ORDER BY updated_at DESC\"\n );\n return result.rows.map((row: any) => ({\n id: row[0],\n title: row[1],\n created_at: row[2],\n updated_at: row[3],\n }));\n}\n\nexport async function getChat(id: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT id, title, created_at, updated_at FROM mcp_chats WHERE id = ?\",\n args: [id],\n });\n if (result.rows.length === 0) return null;\n const row: any = result.rows[0];\n return {\n id: row[0],\n title: row[1],\n created_at: row[2],\n updated_at: row[3],\n };\n}\n\nexport async function updateChatTitle(id: string, title: string): Promise {\n await sqlite.execute({\n sql: \"UPDATE mcp_chats SET title = ?, updated_at = ? WHERE id = ?\",\n args: [title, new Date().toISOString(), id],\n });\n}\n\nexport async function touchChat(id: string): Promise {\n await sqlite.execute({\n sql: \"UPDATE mcp_chats SET updated_at = ? WHERE id = ?\",\n args: [new Date().toISOString(), id],\n });\n}\n\nexport async function deleteChat(id: string): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM mcp_messages WHERE chat_id = ?\",\n args: [id],\n });\n await sqlite.execute({\n sql: \"DELETE FROM mcp_chats WHERE id = ?\",\n args: [id],\n });\n}\n\n// Message operations\nexport async function addMessage(\n chatId: string,\n role: \"user\" | \"assistant\",\n content: string\n): Promise {\n const now = new Date().toISOString();\n const result = await sqlite.execute({\n sql: \"INSERT INTO mcp_messages (chat_id, role, content, created_at) VALUES (?, ?, ?, ?)\",\n args: [chatId, role, content, now],\n });\n await touchChat(chatId);\n return {\n id: Number(result.lastInsertRowid),\n chat_id: chatId,\n role,\n content,\n created_at: now,\n };\n}\n\nexport async function getMessages(chatId: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT id, chat_id, role, content, created_at FROM mcp_messages WHERE chat_id = ? ORDER BY id ASC\",\n args: [chatId],\n });\n return result.rows.map((row: any) => ({\n id: row[0],\n chat_id: row[1],\n role: row[2] as \"user\" | \"assistant\",\n content: row[3],\n created_at: row[4],\n }));\n}\n\n// MCP Server operations\nexport async function addMcpServer(\n name: string,\n url: string,\n authEnvKey?: string\n): Promise {\n const now = new Date().toISOString();\n const result = await sqlite.execute({\n sql: \"INSERT INTO mcp_servers (name, url, auth_env_key, created_at) VALUES (?, ?, ?, ?)\",\n args: [name, url, authEnvKey || null, now],\n });\n return {\n id: Number(result.lastInsertRowid),\n name,\n url,\n auth_env_key: authEnvKey || null,\n enabled: true,\n created_at: now,\n };\n}\n\nexport async function getAllMcpServers(): Promise {\n const result = await sqlite.execute(\n \"SELECT id, name, url, auth_env_key, enabled, created_at FROM mcp_servers ORDER BY name ASC\"\n );\n return result.rows.map((row: any) => ({\n id: row[0],\n name: row[1],\n url: row[2],\n auth_env_key: row[3],\n enabled: Boolean(row[4]),\n created_at: row[5],\n }));\n}\n\nexport async function getEnabledMcpServers(): Promise {\n const result = await sqlite.execute(\n \"SELECT id, name, url, auth_env_key, enabled, created_at FROM mcp_servers WHERE enabled = 1 ORDER BY name ASC\"\n );\n return result.rows.map((row: any) => ({\n id: row[0],\n name: row[1],\n url: row[2],\n auth_env_key: row[3],\n enabled: true,\n created_at: row[5],\n }));\n}\n\nexport async function toggleMcpServer(id: number, enabled: boolean): Promise {\n await sqlite.execute({\n sql: \"UPDATE mcp_servers SET enabled = ? WHERE id = ?\",\n args: [enabled ? 1 : 0, id],\n });\n}\n\nexport async function deleteMcpServer(id: number): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM mcp_servers WHERE id = ?\",\n args: [id],\n });\n}\n","deleted","label",[99],"permalink","https://www.val.town/x/dcm31/mcpChat/code/db.ts","extension","actionData","errors"]