O*NET Agent Prompt Repository

Refined Agent Prompt

\n \n \n \n `;\n}\n\n// --- BACKEND (API) ---\nconst app = new Hono();\n\napp.get(\"/\", (c) => {\n return c.html(generateHtml(c.req.url));\n});\n\napp.get(\"/clusters\", async (c) => {\n await initializeDatabase();\n const { results } = await sqlite.execute(\"SELECT id, cluster_name as name FROM career_clusters\");\n return c.json(results);\n});\n\napp.get(\"/occupations/:cluster_id\", async (c) => {\n const { cluster_id } = c.req.param();\n const { results } = await sqlite.execute({\n sql: \"SELECT onet_soc_code, title FROM occupations WHERE cluster_id = ?\",\n args: [cluster_id],\n });\n return c.json(results);\n});\n\napp.get(\"/tasks/:onet_soc_code\", async (c) => {\n const { onet_soc_code } = c.req.param();\n const { results } = await sqlite.execute({\n sql: \"SELECT id as task_id, task FROM tasks WHERE onet_soc_code = ?\",\n args: [onet_soc_code],\n });\n return c.json(results);\n});\n\napp.get(\"/prompt/:onet_soc_code/:task_id\", async (c) => {\n const { onet_soc_code, task_id } = c.req.param();\n\n const { results: taskResults } = await sqlite.execute({\n sql: \"SELECT task FROM tasks WHERE id = ?\",\n args: [task_id],\n });\n const task = taskResults[0].task;\n\n const { results: occupationResults } = await sqlite.execute({\n sql: \"SELECT title FROM occupations WHERE onet_soc_code = ?\",\n args: [onet_soc_code],\n });\n const occupationTitle = occupationResults[0].title;\n\n const { results: skillResults } = await sqlite.execute({\n sql: \"SELECT skill_name FROM skills WHERE onet_soc_code = ?\",\n args: [onet_soc_code],\n });\n const skills = skillResults.map((r) => r.skill_name).join(\", \");\n\n const { results: knowledgeResults } = await sqlite.execute({\n sql: \"SELECT knowledge_name FROM knowledge WHERE onet_soc_code = ?\",\n args: [onet_soc_code],\n });\n const knowledge = knowledgeResults.map((r) => r.knowledge_name).join(\", \");\n\n const { results: toolResults } = await sqlite.execute({\n sql: \"SELECT tool_name FROM tools WHERE onet_soc_code = ?\",\n args: [onet_soc_code],\n });\n const tools = toolResults.map((r) => r.tool_name).join(\", \");\n\n const initialPrompt = `\n Occupation: ${occupationTitle}\n Task: ${task}\n Relevant Skills: ${skills}\n Relevant Knowledge: ${knowledge}\n Common Tools & Technology: ${tools}\n `;\n\n const openai = new OpenAI();\n const completion = await openai.chat.completions.create({\n model: \"gpt-4o\",\n messages: [\n { role: \"system\", content: PROMPT_REFINER_SYSTEM_PROMPT },\n { role: \"user\", content: initialPrompt },\n ],\n response_format: { type: \"json_object\" },\n });\n\n const refinedPrompt = JSON.parse(completion.choices[0].message.content);\n return c.json(refinedPrompt);\n});\n\nexport default app.fetch;","deleted","label",[98],"permalink","https://www.val.town/x/join/untitled-8765/code/main.tsx","extension","actionData","errors"]