Spreadsheet / CSV agents with SQL
Let agents query uploads, Google-sheet exports, and warehouse-like CSVs with SQL + LLM planning instead of brittle cell scraping.
At a glance — Oct 2026
Updated 2026-10-27 · forward this page: /jtbds/spreadsheet-sql-agents#briefScores as of 2026-10-19 (8 days old).
- Depot Pick
- MotherDuck · 8.53/10 for this job (curated estimate, high confidence)
MotherDuck = hosted DuckDB with agent/SQL DX. Confidence: medium — confirm MCP/SQL agent features on current pricing.
- Runner-up
- DuckDB (vector/extensions) · 8.02/10
Scores higher than the pick on: Price / performance, Privacy / data retention, Lock-in risk (higher = worse), Maturity / track record.
- When not to use the pick
- Need Sheets writeback via OAuth tools (Composio), embedded local DuckDB only, or full lakehouse (Databricks).
- Lock-in / migration
- Runner-up DuckDB (vector/extensions) has lower stored lock-in risk (2 vs 4.5, 0–10, higher = more lock-in).
- Sourced price (no comparable unit)
Pick: no sourced price in this job's unit (no_matching_sourced_price).
No cheapest SKU (no_comparable_unit_for_job). No price was invented.
- Free option
- No free resource lists this job. A cheap paid SKU is not a free option.
- Failure modes to watch
- Schema drift: Validate every tool call and every loaded table against the current schema. Quarantine mismatches instead of coercing them.
- Collateral side effects: Snapshot the workspace or app state, then diff it against an allowlist. A passing check plus an unexpected diff is a failure.
- Hallucinated tool arguments: Reject a call that fails the current schema or names an unknown id, and do that before the tool runs a side effect.
- Partial tool success: Require a per-item status and a failure count. Success for the task requires the failed count to be zero or explicitly handed to a retry queue.
- Silent truncation: Tools must return whether the payload was truncated and how long the original was. Fail the task if the answer depends on the missing span.
- Stale retrieval: Store the source URL and the time it was fetched. If a newer canonical page exists, or two stored sources disagree, do not answer from the older one.
Cite: Agent Provider Depot, Depot Pick for spreadsheet-sql-agents: motherduck, scores as of 2026-10-19. Agents: GET /api/decide?jtbd=spreadsheet-sql-agents
MotherDuck
MotherDuck = hosted DuckDB with agent/SQL DX. Confidence: medium — confirm MCP/SQL agent features on current pricing.
Pricing (directional): 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 (Private…
Lock-in risk: higher = more lock-in (worse). Overall already inverts this dimension.
Depot pick when the agent needs SQL warehouse context (analytics, DuckLake/Iceberg, shared Guides). Snowflake Cortex / Databricks Mosaic when the lakehouse is already the system of record.
Quote for Spreadsheet / CSV agents with SQL
Depot Pick stays MotherDuck. Prices below are sourced SKU rows only (as of 2026-10-27). Input and output are not blended. GET /api/quote?jtbd=spreadsheet-sql-agents
Nothing was compared. no comparable sourced unit for this job; chat input $/1M and other units were not borrowed pickIsPriceWinner is null.
- AI Functions usd_per_ai_unit $1 source as of 2026-10-03
- Business usd_per_org_month $250 source as of 2026-10-03
- Flight F16 usd_per_hour $0.6 source as of 2026-10-03
- Flight F32 usd_per_hour $1.2 source as of 2026-10-03
- Flight F4 usd_per_hour $0.15 source as of 2026-10-03
- Giga usd_per_hour $24 source as of 2026-10-03
- Jumbo usd_per_hour $4.8 source as of 2026-10-03
- Lite usd_per_month $0 source as of 2026-10-03
- Mega usd_per_hour $12 source as of 2026-10-03
- Pulse usd_per_cu_hour $0.6 source as of 2026-10-03
- Standard usd_per_hour $2.4 source as of 2026-10-03
- Storage usd_per_gb_month $0.04 source as of 2026-10-03
2 of 5 candidates have no sourced price row. 5 are excluded from the Matching price comparison (none). no comparable sourced unit for this job; chat input $/1M and other units were not borrowed
Runners-up
DuckDB (vector/extensions)
Use for local analytics + light vector experiments. Production agent memory → pgvector/Qdrant/Mem0.
Composio
Depot pick for tool/MCP router with managed OAuth across 1500+ apps. Official rate card is now public — Hobby…
Neon
Excellent serverless Postgres for agent apps that want branching + pgvector without Supabase's full BaaS.
Databricks Mosaic AI
Pick only when your data/platform already is Databricks. Otherwise Bedrock/Vertex or direct APIs.
When NOT to use the top pick
Need Sheets writeback via OAuth tools (Composio), embedded local DuckDB only, or full lakehouse (Databricks).
Full ranking (score table)
Ranked with this JTBD's weights. Scores are curated estimates unless marked otherwise. Agents: prefer /api/decide then this table for tie-breaks.
| # | Provider | Overall | Fit | $/perf | Latency | DX | As of |
|---|---|---|---|---|---|---|---|
| 1 | Neon | 8.7 | 8.6 | 8.8 | 8.6 | 9.4 | 2026-09-14 |
| 2 | MotherDuckDepot Pick | 8.5 | 8.8 | 8.6 | 8.6 | 9.0 | 2026-10-19 |
| 3 | DuckDB (vector/extensions) | 8.0 | 6.0 | 9.5 | 7.5 | 8.5 | 2026-09-14 |
| 4 | Composio | 7.8 | 8.2 | 7.5 | 7.8 | 8.8 | 2026-10-19 |
| 5 | Databricks Mosaic AI | 7.1 | 8.4 | 4.8 | 8.5 | 6.8 | 2026-09-14 |
Score methodology for this job
MotherDuck = hosted DuckDB with agent/SQL DX. Confidence: medium — confirm MCP/SQL agent features on current pricing.
capabilityFit: 22%pricePerformance: 14%latencyReliability: 14%developerDx: 28%privacyPosture: 8%lockInRisk: 6%maturity: 8%