{"jtbd":{"id":"postgres-vector","slug":"postgres-vector","name":"Postgres-native vectors (pgvector)","shortName":"Postgres-native vectors (pgvector)","problemStatement":"Keep vectors next to relational data with minimal new systems."},"pick":{"id":"supabase-pgvector","slug":"supabase-pgvector","name":"Supabase (pgvector)","tagline":"Depot default for most agent apps under ~25–50M vectors. Don't add Pinecone until Postgres actually hurts.","website":"https://supabase.com","overall":8.61,"scoreBand":{"low":8,"mid":8.6,"high":9.2,"halfWidth":0.6,"basis":"editorial_prior","display":"8.0–9.2 (editorial prior)"},"scoreLayers":{"editorialPrior":8.61,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-09-14","pricingNotes":"Postgres + pgvector + Auth + Storage; usage on compute/storage; free tier. Vectors hitchhike on Postgres.","scores":{"capabilityFit":8.5,"pricePerformance":9,"latencyReliability":8.6,"developerDx":9.4,"privacyPosture":8,"lockInRisk":3,"maturity":9,"overall":8.61,"kind":"curated_estimate","confidence":"high","asOf":"2026-09-14"}},"runnersUp":[{"id":"neon","slug":"neon","name":"Neon","tagline":"Excellent serverless Postgres for agent apps that want branching + pgvector without Supabase's full BaaS.","website":"https://neon.tech","overall":8.59,"scoreBand":{"low":8,"mid":8.6,"high":9.2,"halfWidth":0.6,"basis":"editorial_prior","display":"8.0–9.2 (editorial prior)"},"scoreLayers":{"editorialPrior":8.59,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-09-14","pricingNotes":"Serverless Postgres with branching; pgvector supported; usage-based compute/storage.","scores":{"capabilityFit":8.6,"pricePerformance":8.8,"latencyReliability":8.6,"developerDx":9.4,"privacyPosture":8.2,"lockInRisk":3,"maturity":8.5,"overall":8.59,"kind":"curated_estimate","confidence":"high","asOf":"2026-09-14"}},{"id":"aws-ec2","slug":"aws-ec2","name":"AWS EC2","tagline":"Default enterprise VM substrate. Agents should wrap it — humans shouldn't live in the console.","website":"https://aws.amazon.com/ec2/","overall":7.89,"scoreBand":{"low":7.3,"mid":7.9,"high":8.5,"halfWidth":0.6,"basis":"editorial_prior","display":"7.3–8.5 (editorial prior)"},"scoreLayers":{"editorialPrior":7.89,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-09-14","pricingNotes":"Broadest instance catalog; Spot/Savings Plans; everything else in AWS orbits EC2.","scores":{"capabilityFit":9.2,"pricePerformance":7,"latencyReliability":9.5,"developerDx":6.5,"privacyPosture":8.8,"lockInRisk":7.5,"maturity":9.9,"overall":7.89,"kind":"curated_estimate","confidence":"high","asOf":"2026-09-14"}}],"scoreBand":{"low":8,"mid":8.6,"high":9.2,"halfWidth":0.6,"basis":"editorial_prior","display":"8.0–9.2 (editorial prior)"},"scoreLayers":{"editorialPrior":8.61,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"whyPickOverHigherScore":{"pickId":"supabase-pgvector","pickName":"Supabase (pgvector)","pickScore":8.61,"highestScoredCandidateId":"supabase-pgvector","highestScoredCandidateName":"Supabase (pgvector)","highestScore":8.61,"pickHasLowerCompositeScore":false,"delta":0,"pickLeadsOnDimensions":[],"explanation":"Supabase (pgvector) (8.61) holds both the highest composite score among ranked candidates and the editorial pick for Postgres-native vectors (pgvector): dx + pricePerf + lockInRisk. Default for most agent apps."},"cheapest":null,"recommendedWorkloadQuote":null,"representativeQuote":null,"estimatedTaskCost":null,"freeAlternatives":[{"id":"pgvector","name":"pgvector","kind":"dev_tool","jtbdIds":["postgres-vector","self-host-vector"],"whatYouGet":"Postgres extension for vector similarity. Not Supabase hosted Postgres.","cost":"oss","license":"PostgreSQL License","sourceUrl":"https://github.com/pgvector/pgvector/blob/master/LICENSE","notes":"providerId is null on purpose. supabase-pgvector is a hosted product and is not this extension. 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: 'Portions Copyright (c) 1996-2026, PostgreSQL Global Development Group' / 'without fee, and without a written agreement is hereby granted'. License unchanged.","providerId":null,"limits":null,"asOf":"2026-10-25","freeType":"dev_tool","substitutable":true}],"referenceDocs":[],"falsification":{"jtbdId":"postgres-vector","jtbdName":"Postgres-native vectors (pgvector)","currentPickId":"supabase-pgvector","currentPickScore":8.61,"challengerId":"neon","challengerScore":8.59,"currentScoreGap":0.02,"minVerifiedOutcomes":10,"requiredOutcomeMargin":0.17,"requiredSuccessRateDelta":0.15,"maxPickPriceIncreasePct":25,"whatWouldChangePick":["Neon (neon) outperforms Supabase (pgvector) (supabase-pgvector) by >= 0.17 outcome points (or >= 15% worked-rate delta) across >= 10 Countersign-verified production outcomes.","A verified price increase > 25% on Supabase (pgvector)'s representative SKU for postgres-vector without a corresponding capability gain.","Live caller rail exhaustion (?exhausted=supabase-pgvector) 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":"neon","minVerifiedOutcomes":10,"requiredOutcomeMargin":0.17,"requiredWorkedRateDelta":0.15},{"kind":"verified_price_increase","providerId":"supabase-pgvector","maxPriceIncreasePct":25},{"kind":"live_rail_exhaustion_or_degradation","providerId":"supabase-pgvector","immediateOverrideUrl":"/api/decide?jtbd=postgres-vector&exhausted=supabase-pgvector"}],"submissionSpec":{"falsifyEndpoint":"/api/falsify?jtbd=postgres-vector","outcomesEndpoint":"POST /api/feedback","correctionsEndpoint":"POST /api/corrections","payloadTemplate":{"agentIdentity":"agent:<your-agent-id>","jtbdId":"postgres-vector","providerId":"neon","outcome":"worked","detail":"Comparative production evaluation on postgres-vector (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":["Neon (neon) outperforms Supabase (pgvector) (supabase-pgvector) by >= 0.17 outcome points (or >= 15% worked-rate delta) across >= 10 Countersign-verified production outcomes.","A verified price increase > 25% on Supabase (pgvector)'s representative SKU for postgres-vector without a corresponding capability gain.","Live caller rail exhaustion (?exhausted=supabase-pgvector) or sustained >= 30% degraded/failed rate in verified production outcomes."],"routePlan":{"jtbdId":"postgres-vector","primary":{"providerId":"supabase-pgvector","name":"Supabase (pgvector)","overall":8.61,"scoreBand":{"low":8,"mid":8.6,"high":9.2,"halfWidth":0.6,"basis":"editorial_prior","display":"8.0–9.2 (editorial prior)"},"scoreLayers":{"editorialPrior":8.61,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-09-14","role":"primary","reason":"Editorial Depot Pick for Postgres-native vectors (pgvector); healthy/eligible under caller constraints."},"fallback":[{"providerId":"neon","name":"Neon","overall":8.59,"scoreBand":{"low":8,"mid":8.6,"high":9.2,"halfWidth":0.6,"basis":"editorial_prior","display":"8.0–9.2 (editorial prior)"},"scoreLayers":{"editorialPrior":8.59,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-09-14","role":"fallback","reason":"Ranked fallback route for Postgres-native vectors (pgvector)."},{"providerId":"aws-ec2","name":"AWS EC2","overall":7.89,"scoreBand":{"low":7.3,"mid":7.9,"high":8.5,"halfWidth":0.6,"basis":"editorial_prior","display":"7.3–8.5 (editorial prior)"},"scoreLayers":{"editorialPrior":7.89,"measuredBenchmark":null,"verifiedOutcomeScore":null,"verifiedOutcomeCount":0,"accountRuntimeState":"unprobed"},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-09-14","role":"fallback","reason":"Ranked fallback route for Postgres-native vectors (pgvector)."}],"disqualified":[],"expectedRegret":{"scoreDeltaVsUnconstrainedPick":0,"unconstrainedPickId":"supabase-pgvector","activePrimaryId":"supabase-pgvector","summary":"0.00 score regret: unconstrained editorial pick satisfies all caller constraints."},"evidenceAgeDays":{"editorialScoreAgeDays":43,"pricingVerifiedAgeDays":0,"editorialPriorAsOf":"2026-09-14","pricingLastVerifiedAt":"2026-10-27"},"confidenceBand":{"low":8,"mid":8.6,"high":9.2,"halfWidth":0.6,"basis":"editorial_prior","display":"8.0–9.2 (editorial prior)"},"constraintsApplied":false,"constraintBundle":{"task":null,"jtbd":"postgres-vector","quotaExhausted":[],"degraded":[],"healthy":[],"budgetUsd":null,"maxLatencyMs":null,"region":null,"privacy":null,"exit":[],"existing":[]}},"pricingLastVerifiedAt":"2026-10-27","editorialPriorAsOf":"2026-09-14","tie":true,"scoreGap":0.02,"decidingFactor":"pricePerformance (9 vs 8.8)","tieNote":"Scores are within 0.10 on a curated_estimate 0-10 scale (8.61 vs 8.59); treat as a statistical tie and decide on decidingFactor or whenNotTopPick.","rationale":"dx + pricePerf + lockInRisk. Default for most agent apps.","whenNotTopPick":"Corpus/QPS exceeds comfortable Postgres vector range — Qdrant/Milvus/Turbopuffer.","skipTopPick":false,"skipReason":null,"matchedConstraints":[],"pricingSummary":"Postgres + pgvector + Auth + Storage; usage on compute/storage; free tier. Vectors hitchhike on Postgres.","cite":"Depot Pick for postgres-vector: supabase-pgvector (asOf 2026-09-14). See GET /api/jtbds/postgres-vector + GET /api/methodology.","nextActions":[{"step":1,"title":"Inspect full JTBD + embeds","href":"/api/jtbds/postgres-vector?embed=providers","why":"Confirm pick, runners-up, and methodology notes."},{"step":2,"title":"Quote sourced SKUs","href":"/api/quote?jtbd=postgres-vector","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/supabase-pgvector","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=postgres-vector","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-09-14","depth":{"whenNotToUse":{"text":"Corpus/QPS exceeds comfortable Postgres vector range — Qdrant/Milvus/Turbopuffer.","source":"editorial `whenNotTopPick` (data/jtbds.json)"},"whenNotToUseReason":null,"runnerUp":{"providerId":"neon","name":"Neon","overallForJob":8.59,"pickOverallForJob":8.61,"beatsPickOn":["capabilityFit","privacyPosture"],"source":"first resolvable entry of the job's editorially ranked `runnersUpIds`; scores are stored job-weighted scores"},"runnerUpReason":null,"lockIn":{"pickLockInRisk":3,"runnerUpLockInRisk":3,"scale":"0–10 stored curated estimate; higher = more lock-in (worse)","pickExitSignals":[],"runnerUpExitSignals":[],"pickNotes":[],"selfHostFallback":[{"id":"pgvector","name":"pgvector","license":"PostgreSQL License","sourceUrl":"https://github.com/pgvector/pgvector/blob/master/LICENSE"}],"migration":"Self-host fallback listed for this job: pgvector.","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.150), Depot Pick for postgres-vector: supabase-pgvector, scores as of 2026-09-14, retrieved 2026-10-27. https://getagentdepot.com/jtbds/postgres-vector","markdown":"[Agent Provider Depot](https://getagentdepot.com/jtbds/postgres-vector) (v0.12.150) — Depot Pick for `postgres-vector`: **supabase-pgvector** (scores as of 2026-09-14, retrieved 2026-10-27)","fields":{"publisher":"Agent Provider Depot","version":"0.12.150","role":"depot_pick","jtbdId":"postgres-vector","providerId":"supabase-pgvector","scoreAsOf":"2026-09-14","retrievedOn":"2026-10-27","page":"https://getagentdepot.com/jtbds/postgres-vector","api":"https://getagentdepot.com/api/decide?jtbd=postgres-vector"},"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-09-14","ageDays":43,"stale":true,"staleAfterDays":30,"reason":null},"lastReviewed":{"asOf":"2026-09-14","ageDays":43,"stale":true,"staleAfterDays":30,"reason":null},"sourceCheck":{"checkedAt":"2026-10-27","sourceUrls":2,"sourcesReachable":2,"pricingRows":0,"pricingRowsReconfirmed":0,"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-09-14","editorialPriorAsOf":"2026-09-14","pricingLastVerifiedAt":"2026-10-27","pickLastReviewed":"2026-09-14","runnersUpScoreAsOf":["2026-09-14","2026-09-14"],"contractAsOf":"2026-10-03","pricingShape":"prose_notes_only","normalizedUsdPerMillionTokens":null,"normalizationStatus":"unavailable","normalizationReason":"no_sourced_price"},"pricingContract":{"normalizedUsdPerMillionTokens":null,"normalizationStatus":"unavailable","normalizationReason":"no_sourced_price","shape":"prose_notes_only","filterable":false,"priceSortEligible":false,"priceSortKeyUsdPerMillionInputTokens":null,"rows":[],"notesExcerpt":"Postgres + pgvector + Auth + Storage; usage on compute/storage; free tier. Vectors hitchhike on Postgres.","notesCheck":{"status":"no_known_contradiction","pairs":[],"review":null,"note":null},"lastReviewed":"2026-09-14","scoreAsOf":"2026-09-14","website":"https://supabase.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":"No sourced price row for this provider. pricingNotes stay prose. See research/gaps.md."},"links":{"jtbd":"/jtbds/postgres-vector","jtbdApi":"/api/jtbds/postgres-vector","leaderboard":"/api/leaderboards?jtbd=postgres-vector","methodology":"/api/methodology","badge":"/api/badge?type=depot-pick&jtbd=postgres-vector","decide":"/api/decide?jtbd=postgres-vector","humanPage":"/jtbds/postgres-vector","alternatives":"/api/alternatives?provider=supabase-pgvector","canonical":"/api/canonical","quote":"/api/quote?jtbd=postgres-vector","falsify":"/api/falsify?jtbd=postgres-vector"},"constraintBundle":{"task":null,"jtbd":"postgres-vector","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":0,"withVerifiedReceipt":0,"failureModes":{},"latestAt":null,"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":0,"test":0,"notFeedback":0},"reason":"no_submitted_outcome_reports_yet"},"pick":{"providerId":"supabase-pgvector","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=postgres-vector"},"report":"POST /api/feedback {agentIdentity, outcome: failed|degraded|worked, detail, providerId, jtbdId, failureModeId?, receipt?}"}}