{"jtbd":{"id":"sql-warehouse-agent-context","slug":"sql-warehouse-agent-context","name":"SQL warehouse as agent context","shortName":"SQL warehouse as agent context","problemStatement":"Let agents query production analytics (SQL, Iceberg/DuckLake, shared semantic Guides) rather than dumping a warehouse into a vector DB."},"pick":{"id":"motherduck","slug":"motherduck","name":"MotherDuck","tagline":"Depot pick when the agent needs SQL warehouse context (analytics, DuckLake/Iceberg, shared Guides). Snowflake…","website":"https://motherduck.com","overall":8.44,"scoreBand":{"low":7.8,"mid":8.4,"high":9,"halfWidth":0.6,"basis":"editorial_prior","display":"7.8–9.0 (editorial prior)"},"scoreLayers":{"editorialPrior":8.44,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-10-19","pricingNotes":"As of 2026-10-24 (motherduck.com/product/pricing, fetched 2026-10-24): Lite $0 — 3 users, 2 service accounts, 10 GB, 10 Pulse hrs/mo. Business $250/org/mo + usage — 10 users, unlimited service accounts, 99.9% SLA. Enterprise custom (PrivateLink, HIPAA BAA, capacity). Storage $0.04/GB-mo. Compute: Pulse $0.60/CU-hr (per query, 1 CU-sec min); Standard $2.40/hr; Jumbo $4.80; Mega $12; Giga $24 (per-second). Flights (agent-native pipelines), 'billed per second at the rate for the Flight's size': F4 '$0.15 per hour' ('Lite without a credit card includes 30 minutes per day at no charge.'), F16 '$0.60 per hour' (on Lite with a credit card), F32 '$1.20 per hour'; SQL a Flight runs is billed at the compute rate. AI functions $1.00/AI Unit. MCP + Guides for agent context. Regions: us-east-1, us-west-2, eu-central-1, eu-west-1, ap-northeast-1, ap-southeast-2 (one region per org).","scores":{"capabilityFit":8.8,"pricePerformance":8.6,"latencyReliability":8.6,"developerDx":9,"privacyPosture":8.5,"lockInRisk":4.5,"maturity":8.2,"overall":8.44,"kind":"curated_estimate","confidence":"high","asOf":"2026-10-19"}},"runnersUp":[{"id":"snowflake-cortex","slug":"snowflake-cortex","name":"Snowflake Cortex","tagline":"Use when Snowflake already holds the data. Don't drag agent backends into Snowflake just for Cortex.","website":"https://www.snowflake.com/en/data-cloud/cortex/","overall":7.1,"scoreBand":{"low":6.5,"mid":7.1,"high":7.7,"halfWidth":0.6,"basis":"editorial_prior","display":"6.5–7.7 (editorial prior)"},"scoreLayers":{"editorialPrior":7.1,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-09-14","pricingNotes":"As of 2026-09-14: SQL-first AI functions (COMPLETE, EMBED, SEARCH, etc.) priced in Snowflake AI credits (secondary sources cite ~$2.00 per AI credit — confirm account rate card). Attractive when data already in Snowflake; not a general agent LLM default.","scores":{"capabilityFit":7.8,"pricePerformance":5.5,"latencyReliability":8.4,"developerDx":7,"privacyPosture":8.5,"lockInRisk":8,"maturity":8.6,"overall":7.1,"kind":"curated_estimate","confidence":"medium","asOf":"2026-09-14"}},{"id":"databricks-mosaic","slug":"databricks-mosaic","name":"Databricks Mosaic AI","tagline":"Pick only when your data/platform already is Databricks. Otherwise Bedrock/Vertex or direct APIs.","website":"https://www.databricks.com/product/machine-learning","overall":7.11,"scoreBand":{"low":6.5,"mid":7.1,"high":7.7,"halfWidth":0.6,"basis":"editorial_prior","display":"6.5–7.7 (editorial prior)"},"scoreLayers":{"editorialPrior":7.11,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-09-14","pricingNotes":"As of 2026-09-14: Lakehouse-native model training/serving billed via Databricks DBUs + cloud compute. Foundation Model Serving and Mosaic tooling sit inside Databricks contracts — not indie per-token pricing. Strong if data already lives in Databricks.","scores":{"capabilityFit":8.4,"pricePerformance":4.8,"latencyReliability":8.5,"developerDx":6.8,"privacyPosture":8.2,"lockInRisk":7.8,"maturity":8.8,"overall":7.11,"kind":"curated_estimate","confidence":"medium","asOf":"2026-09-14"}},{"id":"duckdb","slug":"duckdb","name":"DuckDB (vector/extensions)","tagline":"Use for local analytics + light vector experiments. Production agent memory → pgvector/Qdrant/Mem0.","website":"https://duckdb.org","overall":8,"scoreBand":{"low":7.4,"mid":8,"high":8.6,"halfWidth":0.6,"basis":"editorial_prior","display":"7.4–8.6 (editorial prior)"},"scoreLayers":{"editorialPrior":8,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-09-14","pricingNotes":"As of 2026-09-14: DuckDB is free MIT/open-source (local/embedded). Vector similarity via VSS + community extensions — not a hosted vector SaaS. MotherDuck is the hosted DuckDB warehouse (Lite $0 with 10 GB + 10 Pulse hrs; Business $250/org/mo + usage). Treat DuckDB as local OLAP + light vector for agent analytics, not a Pinecone replacement.","scores":{"capabilityFit":6,"pricePerformance":9.5,"latencyReliability":7.5,"developerDx":8.5,"privacyPosture":9.5,"lockInRisk":2,"maturity":8.8,"overall":8,"kind":"curated_estimate","confidence":"high","asOf":"2026-09-14"}},{"id":"clickhouse-cloud","slug":"clickhouse-cloud","name":"ClickHouse Cloud","tagline":"Depot pick for agent-analytics-warehouse (event/log OLAP). MotherDuck remains sql-warehouse-agent-context for…","website":"https://clickhouse.com","overall":8.38,"scoreBand":{"low":7.8,"mid":8.4,"high":9,"halfWidth":0.6,"basis":"editorial_prior","display":"7.8–9.0 (editorial prior)"},"scoreLayers":{"editorialPrior":8.38,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-10-19","pricingNotes":"As of 2026-10-24 (clickhouse.com/pricing, fetched 2026-10-24; list rates shown for 'N. Virginia (us-east-1)'): 'Pay only for the compute and storage you use, metered separately and scaled to zero when idle.' Basic: Storage '$25.30 Per 1TB / mo', Compute '$0.2181 Per unit / hr', 'Up to 1 TB storage', '8-12 GiB total memory'. Scale: Storage '$25.30 Per 1TB / mo', Compute '$0.2985 Per unit / hr', 'Unlimited storage'. Enterprise: Storage '$25.30 Per 1TB / mo', Compute '$0.3903 Per unit / hr'. 'One compute unit is 8 GiB of RAM and 2 vCPUs.' 'Compute is metered per minute and billed per compute-unit-hour at the rate for your plan, cloud provider and region shown above.' 'Storage is metered on the compressed size of your data in object storage, plus backups.' 'Storage rates are the same across plans and vary only by cloud provider and region.' Data transfer: 'public internet egress starting at $0.1152 / GB', 'inter region egress starting at $0.0312 / GB'; 'Ingress is free.' 'ClickPipes pricing depends on the connector type.' 'Start free with $300 in credits for 30 days.' 'Pricing is identical whether you buy through a marketplace or directly from ClickHouse, and self-service customers pay monthly by credit card in USD.' No monthly plan totals are stated in the page text (the calculator needs inputs), so none are quoted.","scores":{"capabilityFit":9,"pricePerformance":8,"latencyReliability":8.8,"developerDx":8.4,"privacyPosture":8.2,"lockInRisk":4.5,"maturity":9,"overall":8.38,"kind":"curated_estimate","confidence":"high","asOf":"2026-10-19"}}],"scoreBand":{"low":7.8,"mid":8.4,"high":9,"halfWidth":0.6,"basis":"editorial_prior","display":"7.8–9.0 (editorial prior)"},"scoreLayers":{"editorialPrior":8.44,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"whyPickOverHigherScore":{"pickId":"motherduck","pickName":"MotherDuck","pickScore":8.44,"highestScoredCandidateId":"motherduck","highestScoredCandidateName":"MotherDuck","highestScore":8.44,"pickHasLowerCompositeScore":false,"delta":0,"pickLeadsOnDimensions":[],"explanation":"MotherDuck (8.44) holds both the highest composite score among ranked candidates and the editorial pick for SQL warehouse as agent context: DX for programmatic SQL + pricePerf of bursty agent queries. MotherDuck Lite/Pulse is the agent-native default; hyperscaler warehouses when the data already lives there."},"cheapest":null,"recommendedWorkloadQuote":{"providerId":"motherduck","providerName":"MotherDuck","skuId":"motherduck-lite","item":"Lite","plan":"Lite — Up to 3 users, 10 GB, 10 Pulse hours/mo included","unit":"usd_per_month","amountUsd":0,"outputSkuId":null,"outputItem":null,"outputAmountUsd":null,"outputUnit":null,"sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03","pricingLastVerifiedAt":"2026-10-27","isFlagshipForJob":true,"differsFromFloorCheapest":false,"representativeQuote":{"skuId":"motherduck-lite","item":"Lite","plan":"Lite — Up to 3 users, 10 GB, 10 Pulse hours/mo included","amountUsd":0,"inputOrUnitUsd":0,"unit":"usd_per_month","outputUsd":null,"outputUnit":null,"sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03"},"estimatedTaskCost":{"tasks":1000,"retryAndToolOverheadMultiplier":1.15,"retryToolOverheadMultiplier":1.15,"unitsPerTask":1,"baseCostPer1kTasksUsd":0,"totalUsd":0,"estimatedTotalUsd":0,"perTaskUsd":0,"estimatedCostPerTaskUsd":0,"formula":"Monthly base plan $0/mo covering 1,000 tasks (1.15x overhead buffer)","assumptions":"Monthly subscription plan amortized over 1,000 tasks/month."}},"representativeQuote":{"skuId":"motherduck-lite","item":"Lite","plan":"Lite — Up to 3 users, 10 GB, 10 Pulse hours/mo included","amountUsd":0,"inputOrUnitUsd":0,"unit":"usd_per_month","outputUsd":null,"outputUnit":null,"sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03"},"estimatedTaskCost":{"tasks":1000,"retryAndToolOverheadMultiplier":1.15,"retryToolOverheadMultiplier":1.15,"unitsPerTask":1,"baseCostPer1kTasksUsd":0,"totalUsd":0,"estimatedTotalUsd":0,"perTaskUsd":0,"estimatedCostPerTaskUsd":0,"formula":"Monthly base plan $0/mo covering 1,000 tasks (1.15x overhead buffer)","assumptions":"Monthly subscription plan amortized over 1,000 tasks/month."},"freeAlternatives":[{"id":"duckdb","name":"DuckDB","kind":"dev_tool","jtbdIds":["sql-warehouse-agent-context","agent-analytics-warehouse"],"whatYouGet":"In-process analytical SQL database.","cost":"oss","license":"MIT","sourceUrl":"https://github.com/duckdb/duckdb/blob/main/LICENSE","notes":"Copyright line fetched: 2018-2026 Stichting DuckDB Foundation. Re-fetched twice 2026-10-25 (~10 s apart, plain curl, no login): GitHub blob page HTTP 200, no redirect (page chrome differs between fetches); raw LICENSE fetched twice too, HTTP 200, byte-identical: 'Copyright 2018-2026 Stichting DuckDB Foundation' / 'Permission is hereby granted, free of charge'. License unchanged.","providerId":null,"limits":null,"asOf":"2026-10-25","freeType":"dev_tool","substitutable":true}],"referenceDocs":[],"falsification":{"jtbdId":"sql-warehouse-agent-context","jtbdName":"SQL warehouse as agent context","currentPickId":"motherduck","currentPickScore":8.44,"challengerId":"snowflake-cortex","challengerScore":7.1,"currentScoreGap":1.34,"minVerifiedOutcomes":10,"requiredOutcomeMargin":1.49,"requiredSuccessRateDelta":0.15,"maxPickPriceIncreasePct":25,"whatWouldChangePick":["Snowflake Cortex (snowflake-cortex) outperforms MotherDuck (motherduck) by >= 1.49 outcome points (or >= 15% worked-rate delta) across >= 10 Countersign-verified production outcomes.","A verified price increase > 25% on MotherDuck's representative SKU for sql-warehouse-agent-context without a corresponding capability gain.","Live caller rail exhaustion (?exhausted=motherduck) or sustained >= 30% degraded/failed rate in verified production outcomes."],"frozenHoldoutPolicy":{"holdoutSplit":"20% frozen benchmark holdout tasks + 80% live production outcome receipts","requireCountersignReceipt":true,"requiredEvidenceTiers":["outcome_verified","reference_checked"],"minDistinctContributors":2,"antiGamingRule":"Unverified self-reports and seed/editorial rows never mutate picks or scores."},"triggers":[{"kind":"verified_outcomes_outperformance","challengerId":"snowflake-cortex","minVerifiedOutcomes":10,"requiredOutcomeMargin":1.49,"requiredWorkedRateDelta":0.15},{"kind":"verified_price_increase","providerId":"motherduck","maxPriceIncreasePct":25},{"kind":"live_rail_exhaustion_or_degradation","providerId":"motherduck","immediateOverrideUrl":"/api/decide?jtbd=sql-warehouse-agent-context&exhausted=motherduck"}],"submissionSpec":{"falsifyEndpoint":"/api/falsify?jtbd=sql-warehouse-agent-context","outcomesEndpoint":"POST /api/feedback","correctionsEndpoint":"POST /api/corrections","payloadTemplate":{"agentIdentity":"agent:<your-agent-id>","jtbdId":"sql-warehouse-agent-context","providerId":"snowflake-cortex","outcome":"worked","detail":"Comparative production evaluation on sql-warehouse-agent-context (n>=10 tasks) with Countersign receipt.","confidence":"high","receipt":{"countersign":{"claim_id":"cs-00000000","status":"verified","evidence_tier":"outcome_verified","counts_as_verified":true}}}}},"whatWouldChangePick":["Snowflake Cortex (snowflake-cortex) outperforms MotherDuck (motherduck) by >= 1.49 outcome points (or >= 15% worked-rate delta) across >= 10 Countersign-verified production outcomes.","A verified price increase > 25% on MotherDuck's representative SKU for sql-warehouse-agent-context without a corresponding capability gain.","Live caller rail exhaustion (?exhausted=motherduck) or sustained >= 30% degraded/failed rate in verified production outcomes."],"routePlan":{"jtbdId":"sql-warehouse-agent-context","primary":{"providerId":"motherduck","name":"MotherDuck","overall":8.44,"scoreBand":{"low":7.8,"mid":8.4,"high":9,"halfWidth":0.6,"basis":"editorial_prior","display":"7.8–9.0 (editorial prior)"},"scoreLayers":{"editorialPrior":8.44,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-10-19","role":"primary","reason":"Editorial Depot Pick for SQL warehouse as agent context; healthy/eligible under caller constraints."},"fallback":[{"providerId":"snowflake-cortex","name":"Snowflake Cortex","overall":7.1,"scoreBand":{"low":6.5,"mid":7.1,"high":7.7,"halfWidth":0.6,"basis":"editorial_prior","display":"6.5–7.7 (editorial prior)"},"scoreLayers":{"editorialPrior":7.1,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-09-14","role":"fallback","reason":"Ranked fallback route for SQL warehouse as agent context."},{"providerId":"databricks-mosaic","name":"Databricks Mosaic AI","overall":7.11,"scoreBand":{"low":6.5,"mid":7.1,"high":7.7,"halfWidth":0.6,"basis":"editorial_prior","display":"6.5–7.7 (editorial prior)"},"scoreLayers":{"editorialPrior":7.11,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-09-14","role":"fallback","reason":"Ranked fallback route for SQL warehouse as agent context."},{"providerId":"duckdb","name":"DuckDB (vector/extensions)","overall":8,"scoreBand":{"low":7.4,"mid":8,"high":8.6,"halfWidth":0.6,"basis":"editorial_prior","display":"7.4–8.6 (editorial prior)"},"scoreLayers":{"editorialPrior":8,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-09-14","role":"fallback","reason":"Ranked fallback route for SQL warehouse as agent context."},{"providerId":"clickhouse-cloud","name":"ClickHouse Cloud","overall":8.38,"scoreBand":{"low":7.8,"mid":8.4,"high":9,"halfWidth":0.6,"basis":"editorial_prior","display":"7.8–9.0 (editorial prior)"},"scoreLayers":{"editorialPrior":8.38,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-10-19","role":"fallback","reason":"Ranked fallback route for SQL warehouse as agent context."}],"disqualified":[],"expectedRegret":{"scoreDeltaVsUnconstrainedPick":0,"unconstrainedPickId":"motherduck","activePrimaryId":"motherduck","summary":"0.00 score regret: unconstrained editorial pick satisfies all caller constraints."},"evidenceAgeDays":{"editorialScoreAgeDays":8,"pricingVerifiedAgeDays":0,"editorialPriorAsOf":"2026-10-19","pricingLastVerifiedAt":"2026-10-27"},"confidenceBand":{"low":7.8,"mid":8.4,"high":9,"halfWidth":0.6,"basis":"editorial_prior","display":"7.8–9.0 (editorial prior)"},"constraintsApplied":false,"constraintBundle":{"task":null,"jtbd":"sql-warehouse-agent-context","quotaExhausted":[],"degraded":[],"healthy":[],"budgetUsd":null,"maxLatencyMs":null,"region":null,"privacy":null,"exit":[],"existing":[]}},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-10-19","tie":false,"scoreGap":1.34,"decidingFactor":null,"tieNote":null,"rationale":"DX for programmatic SQL + pricePerf of bursty agent queries. MotherDuck Lite/Pulse is the agent-native default; hyperscaler warehouses when the data already lives there.","whenNotTopPick":"Snowflake is already the system of record — Cortex; Databricks lakehouse standard — Mosaic; local/embedded only — DuckDB OSS.","skipTopPick":false,"skipReason":null,"matchedConstraints":[],"pricingSummary":"As of 2026-10-24 (motherduck.com/product/pricing, fetched 2026-10-24): Lite $0 — 3 users, 2 service accounts, 10 GB, 10 Pulse hrs/mo. Business $250/org/mo + usage — 10 users, unlimited service accounts, 99.9% SLA. Enterprise custom (PrivateLink, HIPAA BAA, capacity). Storage $0.0…","cite":"Depot Pick for sql-warehouse-agent-context: motherduck (asOf 2026-10-19). See GET /api/jtbds/sql-warehouse-agent-context + GET /api/methodology.","nextActions":[{"step":1,"title":"Inspect full JTBD + embeds","href":"/api/jtbds/sql-warehouse-agent-context?embed=providers","why":"Confirm pick, runners-up, and methodology notes."},{"step":2,"title":"Quote sourced SKUs","href":"/api/quote?jtbd=sql-warehouse-agent-context","why":"Depot Pick SKUs plus the cheapest sourced SKU whose unit matches this job. Does not change the pick. Does not blend input and output or borrow a chat rate for a non-chat job."},{"step":3,"title":"Open provider detail","href":"/api/providers/motherduck","why":"Scores, pricingNotes, strengths/weaknesses, communitySignals (claims only)."},{"step":4,"title":"Cite methodology","href":"/api/methodology","why":"Required when publishing a Depot Pick citation."},{"step":5,"title":"Grab badge SVG","href":"/api/badge?type=depot-pick&jtbd=sql-warehouse-agent-context","why":"Embed in README / agent passport."},{"step":6,"title":"Post production insight","method":"POST","href":"/api/insights","why":"Unverified until curated; never auto-mutates official scores."}],"honesty":["Do not invent scores or benches.","Insights are claims until curated/reviewed; they never silently mutate official scores.","lockInRisk higher = more lock-in (worse).","normalizedUsdPerMillionTokens is set only for a single sourced token row. Otherwise null, with a machine-readable reason. Do not coerce GPU, minute, or per-1k search units.","Runners-up are not Depot Picks.","Depot overall is editorial_weighted, not Arena Elo and not an Artificial Analysis index."],"asOf":"2026-10-19","depth":{"whenNotToUse":{"text":"Snowflake is already the system of record — Cortex; Databricks lakehouse standard — Mosaic; local/embedded only — DuckDB OSS.","source":"editorial `whenNotTopPick` (data/jtbds.json)"},"whenNotToUseReason":null,"runnerUp":{"providerId":"snowflake-cortex","name":"Snowflake Cortex","overallForJob":7.1,"pickOverallForJob":8.44,"beatsPickOn":["maturity"],"source":"first resolvable entry of the job's editorially ranked `runnersUpIds`; scores are stored job-weighted scores"},"runnerUpReason":null,"lockIn":{"pickLockInRisk":4.5,"runnerUpLockInRisk":8,"scale":"0–10 stored curated estimate; higher = more lock-in (worse)","pickExitSignals":[],"runnerUpExitSignals":[],"pickNotes":[],"selfHostFallback":[{"id":"duckdb","name":"DuckDB","license":"MIT","sourceUrl":"https://github.com/duckdb/duckdb/blob/main/LICENSE"}],"migration":"The pick has lower stored lock-in risk than runner-up Snowflake Cortex (4.5 vs 8). Self-host fallback listed for this job: DuckDB.","migrationReason":null,"derivedFrom":"stored lockInRisk scores, provider tags (oss, self-host, openai-compat, open-models), free rows that list this job, and verbatim provider notes. No migration guide was invented."}},"citation":{"text":"Agent Provider Depot (v0.12.152), Depot Pick for sql-warehouse-agent-context: motherduck, scores as of 2026-10-19, retrieved 2026-10-27. https://getagentdepot.com/jtbds/sql-warehouse-agent-context","markdown":"[Agent Provider Depot](https://getagentdepot.com/jtbds/sql-warehouse-agent-context) (v0.12.152) — Depot Pick for `sql-warehouse-agent-context`: **motherduck** (scores as of 2026-10-19, retrieved 2026-10-27)","fields":{"publisher":"Agent Provider Depot","version":"0.12.152","role":"depot_pick","jtbdId":"sql-warehouse-agent-context","providerId":"motherduck","scoreAsOf":"2026-10-19","retrievedOn":"2026-10-27","page":"https://getagentdepot.com/jtbds/sql-warehouse-agent-context","api":"https://getagentdepot.com/api/decide?jtbd=sql-warehouse-agent-context"},"howToCite":"Cite Depot as an editorial, dated recommendation, not a benchmark: name the job, the Depot Pick (or runner-up), the score asOf date and the day you retrieved it, and link the job page. Format: “Agent Provider Depot (v{version}), Depot Pick for {jobId}: {providerId}, scores as of {scoreAsOf}, retrieved {retrievedOn}. {baseUrl}/jtbds/{jobId}”. Quote prices only with their own sourceUrl and asOf. If the pick's score is stale (freshness.pick.score.stale), say so."},"freshness":{"pick":{"score":{"asOf":"2026-10-19","ageDays":8,"stale":false,"staleAfterDays":30,"reason":null},"lastReviewed":{"asOf":"2026-10-19","ageDays":8,"stale":false,"staleAfterDays":30,"reason":null},"sourceCheck":{"checkedAt":"2026-10-27","sourceUrls":3,"sourcesReachable":3,"pricingRows":12,"pricingRowsReconfirmed":9,"note":"A source re-check confirms the page is reachable and, for pricing rows, that the stored amount and SKU name appear on it. It does not re-derive or change the score.","reason":null}},"scoreAsOf":"2026-10-19","editorialPriorAsOf":"2026-10-19","pricingLastVerifiedAt":"2026-10-27","pickLastReviewed":"2026-10-19","runnersUpScoreAsOf":["2026-09-14","2026-09-14","2026-09-14","2026-10-19"],"contractAsOf":"2026-10-03","pricingShape":"sourced_rows","normalizedUsdPerMillionTokens":null,"normalizationStatus":"unit_mismatch","normalizationReason":"unit_mismatch"},"pricingContract":{"normalizedUsdPerMillionTokens":null,"normalizationStatus":"unit_mismatch","normalizationReason":"unit_mismatch","shape":"sourced_rows","filterable":false,"priceSortEligible":false,"priceSortKeyUsdPerMillionInputTokens":null,"rows":[{"id":"motherduck-lite","providerId":"motherduck","sku":"Lite","unit":"usd_per_month","amountUsd":0,"currency":"USD","sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03","normalizationStatus":"unit_mismatch","normalizedUsdPerMillionTokens":null,"normalizationReason":"unit_mismatch_per_month","priceSortEligible":false,"qualifier":"Up to 3 users, 10 GB, 10 Pulse hours/mo included. Platform access $0 per org / month."},{"id":"motherduck-business","providerId":"motherduck","sku":"Business","unit":"usd_per_org_month","amountUsd":250,"currency":"USD","sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03","normalizationStatus":"unit_mismatch","normalizedUsdPerMillionTokens":null,"normalizationReason":"unit_mismatch_per_org_month","priceSortEligible":false,"qualifier":"$250 per org / month plus usage. Not a per-user rate."},{"id":"motherduck-storage","providerId":"motherduck","sku":"Storage","unit":"usd_per_gb_month","amountUsd":0.04,"currency":"USD","sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03","normalizationStatus":"unit_mismatch","normalizedUsdPerMillionTokens":null,"normalizationReason":"unit_mismatch_per_gb_month","priceSortEligible":false,"qualifier":"Lite and Business. $0.04 per GB / month."},{"id":"motherduck-pulse","providerId":"motherduck","sku":"Pulse","unit":"usd_per_cu_hour","amountUsd":0.6,"currency":"USD","sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03","normalizationStatus":"unit_mismatch","normalizedUsdPerMillionTokens":null,"normalizationReason":"unit_mismatch_per_cu_hour","priceSortEligible":false,"qualifier":"Per CU hour, metered per query, 1 CU-second minimum. Not a vCPU-hour."},{"id":"motherduck-standard","providerId":"motherduck","sku":"Standard","unit":"usd_per_hour","amountUsd":2.4,"currency":"USD","sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03","normalizationStatus":"unit_mismatch","normalizedUsdPerMillionTokens":null,"normalizationReason":"unit_mismatch_per_hour","priceSortEligible":false,"qualifier":"Instance hour, billed per second. Not a vCPU-hour."},{"id":"motherduck-jumbo","providerId":"motherduck","sku":"Jumbo","unit":"usd_per_hour","amountUsd":4.8,"currency":"USD","sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03","normalizationStatus":"unit_mismatch","normalizedUsdPerMillionTokens":null,"normalizationReason":"unit_mismatch_per_hour","priceSortEligible":false,"qualifier":"Instance hour, billed per second. Not a vCPU-hour."},{"id":"motherduck-mega","providerId":"motherduck","sku":"Mega","unit":"usd_per_hour","amountUsd":12,"currency":"USD","sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03","normalizationStatus":"unit_mismatch","normalizedUsdPerMillionTokens":null,"normalizationReason":"unit_mismatch_per_hour","priceSortEligible":false,"qualifier":"Instance hour, billed per second. Not a vCPU-hour."},{"id":"motherduck-giga","providerId":"motherduck","sku":"Giga","unit":"usd_per_hour","amountUsd":24,"currency":"USD","sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03","normalizationStatus":"unit_mismatch","normalizedUsdPerMillionTokens":null,"normalizationReason":"unit_mismatch_per_hour","priceSortEligible":false,"qualifier":"Instance hour, billed per second. Not a vCPU-hour."},{"id":"motherduck-flight-f4","providerId":"motherduck","sku":"Flight F4","unit":"usd_per_hour","amountUsd":0.15,"currency":"USD","sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03","normalizationStatus":"unit_mismatch","normalizedUsdPerMillionTokens":null,"normalizationReason":"unit_mismatch_per_hour","priceSortEligible":false,"qualifier":"0.5 vCPU, 4 GB, billed per hour for the size. Not stored as a per-vCPU rate. Lite without a card includes 30 minutes per day at no charge."},{"id":"motherduck-flight-f16","providerId":"motherduck","sku":"Flight F16","unit":"usd_per_hour","amountUsd":0.6,"currency":"USD","sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03","normalizationStatus":"unit_mismatch","normalizedUsdPerMillionTokens":null,"normalizationReason":"unit_mismatch_per_hour","priceSortEligible":false,"qualifier":"2 vCPU, 16 GB, billed per hour for the size. Lite rate requires a credit card. Not stored as a per-vCPU rate."},{"id":"motherduck-flight-f32","providerId":"motherduck","sku":"Flight F32","unit":"usd_per_hour","amountUsd":1.2,"currency":"USD","sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03","normalizationStatus":"unit_mismatch","normalizedUsdPerMillionTokens":null,"normalizationReason":"unit_mismatch_per_hour","priceSortEligible":false,"qualifier":"4 vCPU, 32 GB, billed per hour for the size. Not stored as a per-vCPU rate."},{"id":"motherduck-ai-unit","providerId":"motherduck","sku":"AI Functions","unit":"usd_per_ai_unit","amountUsd":1,"currency":"USD","sourceUrl":"https://motherduck.com/product/pricing","asOf":"2026-10-03","normalizationStatus":"unit_mismatch","normalizedUsdPerMillionTokens":null,"normalizationReason":"unit_mismatch_per_ai_unit","priceSortEligible":false,"qualifier":"Page says 1 AI Unit = $1.00. Token rates inside an AI Unit were not copied. SQL Assistant is 1 AI Unit per 160 calls and was not divided."}],"notesExcerpt":"As of 2026-10-24 (motherduck.com/product/pricing, fetched 2026-10-24): Lite $0 — 3 users, 2 service accounts, 10 GB, 10 Pulse hrs/mo. Business $250/org/mo + usage — 10 users, unlimited service accounts, 99.9% SLA. Enterprise custom (PrivateLink, HIPAA BAA, capacity). Storage $0.0…","notesCheck":{"status":"no_known_contradiction","pairs":[],"review":null,"note":null},"lastReviewed":"2026-10-19","scoreAsOf":"2026-10-19","website":"https://motherduck.com","doNotParse":"Do not parse pricingNotes. Use rows only. normalizedUsdPerMillionTokens is a single number only when this provider has exactly one sourced token row. Input/output, context tiers, and non-token units stay null at this level.","gap":"Partial coverage. Providers without a fetched SKU are omitted. See GET /api/pricing."},"links":{"jtbd":"/jtbds/sql-warehouse-agent-context","jtbdApi":"/api/jtbds/sql-warehouse-agent-context","leaderboard":"/api/leaderboards?jtbd=sql-warehouse-agent-context","methodology":"/api/methodology","badge":"/api/badge?type=depot-pick&jtbd=sql-warehouse-agent-context","decide":"/api/decide?jtbd=sql-warehouse-agent-context","humanPage":"/jtbds/sql-warehouse-agent-context","alternatives":"/api/alternatives?provider=motherduck","canonical":"/api/canonical","quote":"/api/quote?jtbd=sql-warehouse-agent-context","falsify":"/api/falsify?jtbd=sql-warehouse-agent-context"},"constraintBundle":{"task":null,"jtbd":"sql-warehouse-agent-context","quotaExhausted":[],"degraded":[],"healthy":[],"budgetUsd":null,"maxLatencyMs":null,"region":null,"privacy":null,"exit":[],"existing":[]},"stackContext":{"host":null,"framework":null,"repo":null,"lang":null,"existing":[],"volume":null,"sender":null,"detectedFromTask":[]},"keep":null,"contextAdvice":null,"communityFeedback":{"pickOnThisJob":{"failed":0,"degraded":0,"worked":0,"insights":1,"withVerifiedReceipt":0,"failureModes":{},"latestAt":"2026-09-13T18:55:00.000Z","note":"Agent-reported claims (unverified unless a receipt is verified by Depot's re-check). They never change scores or picks."},"outcomes":{"job":{"n":0,"worked":0,"degraded":0,"failed":0,"failureModes":{},"verifiedReports":0,"contributors":0,"excluded":{"seed_editorial":1,"test":0,"notFeedback":0},"reason":"no_submitted_outcome_reports_yet"},"pick":{"providerId":"motherduck","n":0,"worked":0,"degraded":0,"failed":0,"failureModes":{},"evidenceTiers":{"agent_claim":0,"self_declared":0,"reference_checked":0,"outcome_verified":0},"reason":"no_submitted_outcome_reports_yet"},"scoresMutated":false,"more":"/api/outcomes?jtbd=sql-warehouse-agent-context"},"report":"POST /api/feedback {agentIdentity, outcome: failed|degraded|worked, detail, providerId, jtbdId, failureModeId?, receipt?}"}}