Parquet Explorer with Claude

\n DuckDB Query Tool\n

\n\n

\n \n

\n );\n}\n",[],[152,171],{"_104":181,"_95":182,"_153":183,"_155":154,"_156":138,"_157":184,"_159":160,"_106":185,"_100":186,"_162":176,"_164":187,"_165":22,"_166":-5,"_167":188,"_98":189},"5efdfe1a-430a-11f0-b8b8-76b3cceeab13","Chat.tsx","9ef76142-4309-11f0-8bca-76b3cceeab13",77,["D",1749237227026],2,"/** @jsxImportSource https://esm.sh/react@18.2.0?dev */\nimport React, { useState, useRef, useEffect } from \"npm:react\";\nimport { useChat } from \"npm:@ai-sdk/react\";\n\nexport function Chat() {\n const messagesEndRef = useRef(null);\n\n const {\n messages,\n input,\n handleInputChange,\n handleSubmit,\n isLoading,\n error\n } = useChat({\n api: \"/api/claude\",\n });\n\n // Scroll to bottom when messages change\n useEffect(() => {\n if (messagesEndRef.current) {\n messagesEndRef.current.scrollIntoView({ behavior: \"smooth\" });\n }\n }, [messages]);\n\n return (\n

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

{message.role === \"user\" ? \"You\" : \"Claude\"}

{message.content}

\n ))}\n {isLoading && (\n

Claude

Thinking...

\n )}\n {error && (\n

\n Error: {error.message || \"Something went wrong\"}\n

\n )}\n

\n\n

\n );\n}\n",[],[152,182],[152],{"_104":192,"_95":193,"_153":194,"_155":-5,"_156":138,"_157":195,"_159":160,"_106":196,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":197,"_98":198},"cbe42660-430c-11f0-994e-76b3cceeab13","pages","cbe42a16-430c-11f0-994e-76b3cceeab13",91,["D",1749238268779],[],[193],{"_104":200,"_95":201,"_153":202,"_155":-5,"_156":138,"_157":203,"_159":160,"_106":204,"_100":32,"_162":205,"_164":206,"_165":22,"_166":-5,"_167":207,"_98":208},"25df5592-42fc-11f0-8004-76b3cceeab13",".vtignore","25df5678-42fc-11f0-8004-76b3cceeab13",23,["D",1749231118224],"file",".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[],[201],{"_104":210,"_95":211,"_153":212,"_155":-5,"_156":138,"_157":213,"_159":22,"_106":214,"_100":186,"_162":176,"_164":215,"_165":22,"_166":-5,"_167":216,"_98":217},"30b1a2c2-430b-11f0-b72f-76b3cceeab13","claude.tsx","17681762-4309-11f0-9021-76b3cceeab13",84,["D",1749237578905],"import { createAnthropic } from \"npm:@ai-sdk/anthropic\";\nimport { streamText } from \"npm:ai\";\n\nconst apiKey = Deno.env.get(\"ANTHROPIC_API_KEY\");\n\nconst anthropic = createAnthropic({\n apiKey,\n});\n\nconst model = \"claude-3-7-sonnet-20250219\";\n\nexport default async (req: Request) => {\n if (req.method !== \"POST\") {\n return new Response(\"Method not allowed\", { status: 405 });\n }\n\n try {\n const body = await req.json();\n const { messages } = body;\n\n if (!messages || !Array.isArray(messages)) {\n return new Response(JSON.stringify({ error: \"Invalid messages format\" }), {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const result = await streamText({\n model: anthropic(model),\n messages: messages,\n system: `You are a helpful assistant that provides clear and concise answers.`,\n maxTokens: 4096,\n });\n\n return result.toDataStreamResponse({\n experimental_sendFinish: true,\n getErrorMessage: (error) => {\n console.log(\"Error in toDataStreamResponse:\", error);\n if (error == null) {\n return \"unknown error\";\n }\n\n if (typeof error === \"string\") {\n return error;\n }\n\n if (error instanceof Error) {\n return error.message;\n }\n\n return JSON.stringify(error);\n },\n });\n } catch (error) {\n console.error(\"Error processing request:\", error);\n return new Response(JSON.stringify({ error: \"Failed to process request\" }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n};\n",[],[211],{"_104":219,"_95":220,"_153":221,"_155":-5,"_156":138,"_157":222,"_159":160,"_106":223,"_100":32,"_162":205,"_164":224,"_165":22,"_166":-5,"_167":225,"_98":226},"25d3da50-42fc-11f0-94e1-76b3cceeab13","deno.json","25d3dafa-42fc-11f0-94e1-76b3cceeab13",21,["D",1749231118222],"{\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}",[],[220],{"_104":228,"_95":229,"_153":230,"_155":-5,"_156":138,"_157":231,"_159":22,"_106":232,"_100":32,"_162":205,"_164":233,"_165":22,"_166":-5,"_167":234,"_98":235},"5c9704a8-430c-11f0-83b6-76b3cceeab13","duckdb.html","5c97055c-430c-11f0-83b6-76b3cceeab13",87,["D",1749238082050],"\n\n \n DuckDB Parquet Explorer\n \n \n \n \n

DuckDB Queries

\n\n \n \n",[],[229],{"_104":237,"_95":238,"_153":239,"_155":-5,"_156":138,"_157":240,"_159":160,"_106":241,"_100":242,"_162":176,"_164":243,"_165":22,"_166":-5,"_167":244,"_98":245},"626d2ecc-430a-11f0-b026-76b3cceeab13","frontend.tsx","3a597662-4309-11f0-89c4-76b3cceeab13",78,["D",1749237232842],6,"/** @jsxImportSource https://esm.sh/react@18.2.0?dev */\nimport { createRoot } from \"npm:react-dom\";\nimport React from \"npm:react\";\nimport { App } from \"./components/App.tsx\";\n\ncreateRoot(document.getElementById(\"root\")).render();\n",[],[238],{"_104":247,"_95":248,"_153":249,"_155":-5,"_156":138,"_157":250,"_159":160,"_106":251,"_100":252,"_162":205,"_164":253,"_165":22,"_166":-5,"_167":254,"_98":255},"83ba5be8-430c-11f0-9d24-76b3cceeab13","index.html","82b52afe-42ec-11f0-beb8-76b3cceeab13",88,["D",1749238147705],40,"\n\n \n Chat with Claude\n \n \n \n \n \n

\n \n\n",[],[248],{"_104":257,"_95":258,"_153":259,"_155":-5,"_156":138,"_157":101,"_159":22,"_106":260,"_100":261,"_162":262,"_164":263,"_165":22,"_166":264,"_167":265,"_98":266},"d722ae1a-430d-11f0-bd5a-76b3cceeab13","main.tsx","71eb1152-42ec-11f0-9771-76b3cceeab13",["D",1749238717131],33,"http","import claudeRoute from \"./claude.tsx\";\nimport ValTown from \"jsr:@valtown/sdk@1.3.0\"\nconst vt = new ValTown();\n\nexport default async function (req: Request): Promise {\n // Get URL info\n const url = new URL(req.url);\n const path = url.pathname;\n\n // Handle Claude API route\n if (path === \"/api/claude\") {\n return await claudeRoute(req);\n }\n\n if (path === \"/pages\") {\n const val = await vt.alias.username.valName.retrieve(\"maxm\", \"parquet\");\n const branch = await vt.vals.branches.list(val.id, {})\n return new Response(Deno.inspect(branch))\n }\n\n // For all routes, check Basic Auth header\n const authHeader = req.headers.get(\"Authorization\");\n\n // Define credentials (in a real app, these should be environment variables)\n const username = \"\";\n const password = Deno.env.get(\"SHARED_SECRET\");\n const expectedAuth = `Basic ${btoa(`${username}:${password}`)}`;\n\n // If authorization is missing or invalid, return 401 with WWW-Authenticate header\n if (!authHeader || authHeader !== expectedAuth) {\n return new Response(\"Unauthorized\", {\n status: 401,\n headers: {\n \"WWW-Authenticate\": 'Basic realm=\"Parquet Explorer\", charset=\"UTF-8\"',\n },\n });\n }\n\n // Handle proxy requests to parquet files\n if (path.startsWith(\"/data/\")) {\n return await handleProxyRequest(req, path);\n }\n\n // Handle DuckDB route\n if (path === \"/db\") {\n const resp = await fetch(import.meta.resolve(\"./duckdb.html\"));\n const htmlTemplate = await resp.text();\n const injectedHtml = htmlTemplate.replace(\"__SECRET_API_KEY__\", password || \"\");\n\n return new Response(injectedHtml, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n\n // Default route - serve the chat interface\n const resp = await fetch(import.meta.resolve(\"./index.html\"));\n const htmlTemplate = await resp.text();\n const importUrl = import.meta.resolve(\"./frontend.tsx\");\n const injectedHtml = htmlTemplate.replace(\"__IMPORT_URL__\", importUrl);\n\n // Return the modified HTML\n return new Response(injectedHtml, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n}\n\n/**\n * Handle proxy requests to the parquet host\n */\nasync function handleProxyRequest(\n req: Request,\n path: string,\n): Promise {\n // Build the target URL\n const targetUrl = new URL(path, `https://parquet-host.onrender.com/`);\n\n // Get API key from environment (using the same shared secret)\n const apiKey = Deno.env.get(\"SHARED_SECRET\") || \"\";\n\n // Create headers for the proxied request\n const headers = new Headers(req.headers);\n headers.set(\"Authorization\", `Bearer ${apiKey}`);\n return fetch(targetUrl, {\n headers,\n });\n}\n","ducket",[],[258],{"_104":268,"_95":99,"_153":269,"_155":-5,"_156":138,"_157":270,"_159":160,"_106":271,"_100":32,"_162":176,"_164":272,"_165":22,"_166":-5,"_167":273,"_98":274},"243a326e-430d-11f0-9eae-76b3cceeab13","243a3322-430d-11f0-9eae-76b3cceeab13",92,["D",1749238416986],"console.log(Deno.env.toObject())\n",[],[99],"files",[150,169,180,191,199,209,218,227,236,246,256,267],"counts",{"_279":32,"_280":281,"_282":32,"_283":175},"pulls","branches",1,"forks","envVars","contents",[],{"_104":268,"_95":99,"_153":269,"_155":-5,"_156":138,"_157":270,"_159":160,"_106":287,"_100":32,"_162":176,"_164":272,"_165":22,"_166":-5,"_98":288},["D",1749238416986],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":43,"_100":101,"_98":99,"_102":297,"_148":302,"_275":339,"_205":340,"_284":342,"_343":-5,"_344":22,"_345":-5,"_346":-5,"_347":-5,"_348":349},{"_104":105,"_95":96,"_106":298,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":32,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":299,"_132":300,"_135":301,"_147":22},["D",1749224373918],{"_93":94,"_130":131},{"_93":94,"_134":131},{"_100":137,"_95":43,"_104":138,"_139":105,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},[303,312,315,318,321,324,327,330,333,336],{"_104":151,"_95":152,"_153":154,"_155":-5,"_156":138,"_157":158,"_159":160,"_106":161,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":304,"_98":311},[305,308],{"_104":170,"_95":171,"_153":172,"_155":154,"_156":138,"_157":173,"_159":22,"_106":174,"_100":175,"_162":176,"_164":177,"_165":22,"_166":-5,"_167":306,"_98":307},[],[152,171],{"_104":181,"_95":182,"_153":183,"_155":154,"_156":138,"_157":184,"_159":160,"_106":185,"_100":186,"_162":176,"_164":187,"_165":22,"_166":-5,"_167":309,"_98":310},[],[152,182],[152],{"_104":192,"_95":193,"_153":194,"_155":-5,"_156":138,"_157":195,"_159":160,"_106":196,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":313,"_98":314},[],[193],{"_104":200,"_95":201,"_153":202,"_155":-5,"_156":138,"_157":203,"_159":160,"_106":204,"_100":32,"_162":205,"_164":206,"_165":22,"_166":-5,"_167":316,"_98":317},[],[201],{"_104":210,"_95":211,"_153":212,"_155":-5,"_156":138,"_157":213,"_159":22,"_106":214,"_100":186,"_162":176,"_164":215,"_165":22,"_166":-5,"_167":319,"_98":320},[],[211],{"_104":219,"_95":220,"_153":221,"_155":-5,"_156":138,"_157":222,"_159":160,"_106":223,"_100":32,"_162":205,"_164":224,"_165":22,"_166":-5,"_167":322,"_98":323},[],[220],{"_104":228,"_95":229,"_153":230,"_155":-5,"_156":138,"_157":231,"_159":22,"_106":232,"_100":32,"_162":205,"_164":233,"_165":22,"_166":-5,"_167":325,"_98":326},[],[229],{"_104":237,"_95":238,"_153":239,"_155":-5,"_156":138,"_157":240,"_159":160,"_106":241,"_100":242,"_162":176,"_164":243,"_165":22,"_166":-5,"_167":328,"_98":329},[],[238],{"_104":247,"_95":248,"_153":249,"_155":-5,"_156":138,"_157":250,"_159":160,"_106":251,"_100":252,"_162":205,"_164":253,"_165":22,"_166":-5,"_167":331,"_98":332},[],[248],{"_104":257,"_95":258,"_153":259,"_155":-5,"_156":138,"_157":101,"_159":22,"_106":260,"_100":261,"_162":262,"_164":263,"_165":22,"_166":264,"_167":334,"_98":335},[],[258],{"_104":268,"_95":99,"_153":269,"_155":-5,"_156":138,"_157":270,"_159":160,"_106":271,"_100":32,"_162":176,"_164":272,"_165":22,"_166":-5,"_167":337,"_98":338},[],[99],[303,305,308,312,315,318,321,324,327,330,333,336],{"_104":268,"_95":99,"_153":269,"_155":-5,"_156":138,"_157":270,"_159":160,"_106":287,"_100":32,"_162":176,"_164":272,"_165":22,"_166":-5,"_98":341},[99],[],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]