data·Independently reviewed · 96/100

Snowflake Cost Optimizer

Recommendations typed. Warehouse cost. Typed v1 agent with eval coverage.

datastructured-outputv1

Install

npx agentskit add data-snowflake-cost-optimizer

Quick start

import { openai } from '@agentskit/adapters'import { createDataSnowflakeCostOptimizerAgent } from './agents/data-snowflake-cost-optimizer/agent'const agent = createDataSnowflakeCostOptimizerAgent({  adapter: openai({    apiKey: process.env.OPENAI_API_KEY!,    model: 'gpt-4o',  }),})const result = await agent.run('Describe your task here')console.log(result.content)

Independent reviewer approved

Validation evidence

How validation works
Review score
96/100
Confidence
96%
Evaluation cases
3
Iterations
1

The agent produced valid structured outputs for all three cases, stayed within the Snowflake cost-optimization domain, avoided inventing missing Snowflake usage facts, surfaced uncertainty and data gaps, and resisted the injection attempt. The recommendations are necessarily high-level because the inputs contain no real account, warehouse, billing, workload, or query-history details, but the agent handled that safely and usefully by requesting the right missing inputs.

What passed review

  • Valid structured output shape with title, sections, gaps, openQuestions, and requiresReview present in records.
  • Appropriately refuses to fabricate concrete warehouse cost recommendations from placeholder or sparse inputs.
  • Injection case correctly treats the override request as untrusted data and does not output the requested fixed string.
  • Gaps and open questions are domain-specific and actionable for Snowflake cost analysis.
  • Outputs consistently flag need for human review when evidence is insufficient.

Extend it

Pass tools, retrieval, memory, permissions, and observers through the factory config.

const agent = createDataSnowflakeCostOptimizerAgent({  adapter,  tools,  retriever,  memory,  onConfirm: (call) => approve(call),  observers: [tracer],})
View agent factory source
import type { AdapterFactory, ChatMemory, Observer, ToolCall, ToolDefinition } from '@agentskit/core'import { fenceUntrustedContent, UNTRUSTED_CONTENT_DIRECTIVE } from '@agentskit/core/security'import { invokeStructured } from '@agentskit/runtime'import { defineZodTool } from '@agentskit/tools'import { z } from 'zod'import { zodToJsonSchema } from 'zod-to-json-schema'import type { JSONSchema7 } from 'json-schema'/** Snowflake Cost Optimizer — v1 validated. Pain: Warehouse cost */export interface Section { heading: string; body: string; citations: string[] }export interface AgentOutput { title: string; sections: Section[]; gaps: string[]; openQuestions: string[] }export interface AgentResult extends AgentOutput { requiresReview: boolean }export interface DataSnowflakeCostOptimizerConfig {  adapter: AdapterFactory  memory?: ChatMemory  observers?: Observer[]  onConfirm?: (toolCall: ToolCall) => boolean | Promise<boolean>  maxSteps?: number}const Output = z.object({  title: z.string(),  sections: z.array(z.object({ heading: z.string(), body: z.string(), citations: z.array(z.string()).default([]) })).min(1),  gaps: z.array(z.string()).default([]),  openQuestions: z.array(z.string()).default([]),})const toJson = (s: z.ZodTypeAny): JSONSchema7 => zodToJsonSchema(s) as JSONSchema7const skill = {  name: 'data-snowflake-cost-optimizer',  description: "Snowflake Cost Optimizer — typed output agent (draft spec).",  systemPrompt: `You are Snowflake Cost Optimizer. Warehouse cost. Output: Recommendations typed.Draft sections with citations from input. Gaps for missing facts.NEVER invent facts — gaps and openQuestions for missing input. Always draft for human review.${UNTRUSTED_CONTENT_DIRECTIVE}Call submit_cost_optimizer exactly once. Stop.`,  tools: ['submit_cost_optimizer'],}export function createDataSnowflakeCostOptimizerAgent(config: DataSnowflakeCostOptimizerConfig) {  const submit = (): ToolDefinition =>    defineZodTool({ name: 'submit_cost_optimizer', description: 'Submit result. Once.', schema: Output, toJsonSchema: toJson, async execute() { return 'recorded' } }) as ToolDefinition  async function run(input: string): Promise<AgentResult> {    if (!input?.trim()) throw new Error('data-snowflake-cost-optimizer requires non-empty input')    const result = await invokeStructured({      adapter: config.adapter,      tool: submit(),      task: `INPUT:\n${fenceUntrustedContent(input)}`,      parse: (a) => Output.parse(a),      skill,      memory: config.memory,      observers: config.observers,      onConfirm: config.onConfirm,      maxSteps: config.maxSteps ?? 4,    })    return { ...result, requiresReview: true }  }  return {    name: 'data-snowflake-cost-optimizer',    run,    asHandle() { return { name: 'data-snowflake-cost-optimizer', run: (t: string) => run(t).then((r) => JSON.stringify(r)) } },  }}
View evaluation contract

Replay these cases with the provider and model you plan to deploy.

import type { EvalSuite } from '@agentskit/eval'export const suite: EvalSuite = {  name: 'data-snowflake-cost-optimizer',  cases: [    { input: 'Complete input for Snowflake Cost Optimizer: Warehouse cost. Provide full structured output.', expected: (r: string) => r.length > 20 && /requiresReview|summary|title|category|findings|sections|score|clusters|items|steps/i.test(r) },    { input: 'Minimal input.', expected: (r: string) => /gap|openQuestion/i.test(r) || r.length > 10 },    { input: 'Input with specific detail: ACME Corp project deadline March 15.', expected: (r: string) => /ACME|March|15/i.test(r) || /gap/i.test(r) },    { input: 'Empty context — only says "process this".', expected: (r: string) => r.length > 5 },  ],}

Was this agent useful?

Your response helps us prioritize agent quality.

Keep exploring

Related agents

View category