{"id":"spreadsheet-sql-agents","slug":"spreadsheet-sql-agents","name":"Spreadsheet / CSV agents with SQL","shortName":"Sheet SQL agents","problemStatement":"Let agents query uploads, Google-sheet exports, and warehouse-like CSVs with SQL + LLM planning instead of brittle cell scraping.","whenNotTopPick":"Need Sheets writeback via OAuth tools (Composio), embedded local DuckDB only, or full lakehouse (Databricks).","categoryIds":["cat-vector-memory"],"depotPickProviderId":"motherduck","depotPickRationale":"MotherDuck = hosted DuckDB with agent/SQL DX. Confidence: medium — confirm MCP/SQL agent features on current pricing.","runnersUpIds":["duckdb","composio","neon","databricks-mosaic"],"weights":{"capabilityFit":0.22,"pricePerformance":0.14,"latencyReliability":0.14,"developerDx":0.28,"privacyPosture":0.08,"lockInRisk":0.06,"maturity":0.08},"methodologyNotes":"MotherDuck = hosted DuckDB with agent/SQL DX. Confidence: medium — confirm MCP/SQL agent features on current pricing.","tags":["spreadsheet","sql","duckdb","analytics"],"depth":{"whenNotToUse":{"text":"Need Sheets writeback via OAuth tools (Composio), embedded local DuckDB only, or full lakehouse (Databricks).","source":"editorial `whenNotTopPick` (data/jtbds.json)"},"whenNotToUseReason":null,"runnerUp":{"providerId":"duckdb","name":"DuckDB (vector/extensions)","overallForJob":8.02,"pickOverallForJob":8.53,"beatsPickOn":["pricePerformance","privacyPosture","lockInRisk","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":2,"scale":"0–10 stored curated estimate; higher = more lock-in (worse)","pickExitSignals":[],"runnerUpExitSignals":["open source (provider tag `oss`)"],"pickNotes":[],"selfHostFallback":[],"migration":"Runner-up DuckDB (vector/extensions) has lower stored lock-in risk (2 vs 4.5, 0–10, higher = more lock-in).","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."}},"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}}},"depotPick":{"id":"motherduck","slug":"motherduck","name":"MotherDuck","tagline":"Depot pick when the agent needs SQL warehouse context (analytics, DuckLake/Iceberg, shared Guides). Snowflake…","overall":8.53},"runnersUp":[{"id":"duckdb","slug":"duckdb","name":"DuckDB (vector/extensions)","tagline":"Use for local analytics + light vector experiments. Production agent memory → pgvector/Qdrant/Mem0.","overall":8.02},{"id":"composio","slug":"composio","name":"Composio","tagline":"Depot pick for tool/MCP router with managed OAuth across 1500+ apps. Official rate card is now public — Hobby…","overall":7.81},{"id":"neon","slug":"neon","name":"Neon","tagline":"Excellent serverless Postgres for agent apps that want branching + pgvector without Supabase's full BaaS.","overall":8.72},{"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.","overall":7.11}]}