# Product recipe: Data analyst agent (AgentGid)

For an agent that answers questions about your data: writes SQL or Python, runs it safely, and returns tables and charts.

Parts were picked from AgentGid's catalog by rules: free tier, official MCP server, use in public projects built with AI agents, downloads, price. Prices are list prices from the official pages (see each card for the check date); confirm before you commit.

## What it costs
- Start: $0 a month on the free tiers of the first picks (their limits apply).
- If you outgrow the free tiers, the lowest paid plans of the first picks are E2B $150, LangSmith $39 (together about $189/month); usage beyond a plan's credits is billed on top.
- Billed by usage (grows with traffic): OpenRouter.
- Model, default: fast and cheap: about $1.2 per 1,000 questions with Claude Haiku 5.5 (AgentGid estimate at ~8,000 input + 800 output tokens each).
- Model, harder questions: about $9 per 1,000 questions with Gemini 3.8 Flash (AgentGid estimate at ~8,000 input + 800 output tokens each).
- Prices of the picks below were checked on the official pages between 2026-10-09 and 2026-10-10.

## How it fits together
1. Load the user's data (CSV, Parquet or a database) into the analytics database or DuckDB.
2. The model writes SQL or Python for the question.
3. Run that code in the sandbox, never on your own server, with a time limit.
4. Return the table or chart with the code used, so people can check it.

## Code sandbox (runs the agent's Python)
- E2B: free: Hobby: $100 one-time usage credit, sessions up to 1 hour, 20 concurrent sandboxes · paid from $150/mo · usage: $0.000014/s per vCPU ($0.0504 per vCPU-hour) + $0.0000045/s per GiB RAM; default sandbox 2 vCPU / 4 GiB · official MCP @e2b/mcp-server · npm e2b · pip e2b · card https://agentgid.com/apis/e2b/agent.md
- Daytona: free: $200 in free compute, no credit card · usage: vCPU $0.0504/hour; memory $0.0162 per GiB-hour; storage $0.000108 per GiB-hour after first 5 GiB free · official MCP · npm @daytonaio/sdk · pip daytona · card https://agentgid.com/apis/daytona/agent.md
- Vercel Sandbox: free: Hobby: 5 active-CPU hours, 420 GB-hours memory, 5,000 sandbox creations per month · paid from $20/mo · usage: Active CPU $0.128/hour; provisioned memory $0.0212 per GB-hour; creations $0.60 per 1M (iad1) · official MCP https://mcp.vercel.com · npm @vercel/sandbox · pip vercel · card https://agentgid.com/apis/vercel-sandbox/agent.md
- Also fits: Modal Sandboxes, Riza, CodeSandbox SDK, Judge0 (https://agentgid.com/apis/sandbox/)

## Analytics database
- DuckDB: open source · npm @duckdb/node-api · pip duckdb · card https://agentgid.com/apis/duckdb/agent.md
- Redis: free: Up to 30 MB · paid from $5/mo · usage: $0.007 per hour (Essentials), $0.014 per hour (Pro) · npm redis · card https://agentgid.com/apis/redis/agent.md
- Also fits: ClickHouse Cloud, SingleStore (https://agentgid.com/apis/backend-db/)

## LLM gateway (one key, many models)
- OpenRouter: free: 25+ free models, 50 requests/day · usage: Provider list price per token (no markup); fee on credit purchases: 5.5% Standard, 8% Business · official MCP https://mcp.openrouter.ai/mcp · npm @openrouter/sdk · pip openrouter · card https://agentgid.com/apis/openrouter/agent.md
- Also fits: LiteLLM, Vercel AI Gateway, Cloudflare AI Gateway, Portkey (https://agentgid.com/apis/llm-gateway/)

## Traces and evals
- LangSmith: free: Developer plan: 1 seat, up to 5k base traces / mo, then pay-as-you-go · paid from $39/mo · usage: Plus: $39 / seat per month incl. up to 10k base traces / mo; trace overage is pay-as-you-go (rate not listed on pricing page); 1 LSU = $1 (Deployment/Fleet/Sandbox usage) · official MCP https://docs.langchain.com/langsmith/langsmith-mcp-server · npm langsmith · pip langsmith · card https://agentgid.com/apis/langsmith/agent.md
- Also fits: LangWatch, W&B Weave, Ragas, Pydantic Logfire (https://agentgid.com/apis/observability/)

## Model (all of these can call tools; prices per 1M tokens)
- Default: fast and cheap: Claude Haiku 5.5 ($0.1 in / $0.5 out) · https://agentgid.com/models/claude-haiku-5-5/agent.md · or GPT-6 Luna, MiMo V2.6 Flash
- Harder questions: Gemini 3.8 Flash ($0.75 in / $3.75 out) · https://agentgid.com/models/gemini-3-8-flash/agent.md · or Kimi K2.7 Code, DeepSeek V4 Pro
- Hardest work: Kimi K3 ($3 in / $15 out) · https://agentgid.com/models/kimi-k3/agent.md · or Claude Opus 5.5, Claude Fable 5.1

## Or start from a ready platform
- Pyod: free tier · https://agentgid.com/agents/pyod/agent.md
- Hex: free tier, from $36/mo · https://agentgid.com/agents/hex/agent.md
- PandasAI: free tier · https://agentgid.com/agents/pandasai/agent.md
- Julius AI: free tier, from $20/mo · https://agentgid.com/agents/julius-ai/agent.md

## Libraries
- `pip install duckdb`: DuckDB (MIT) · https://agentgid.com/tools/duckdb/agent.md
- `pip install pandas`: pandas (BSD) · https://agentgid.com/tools/pandas/agent.md
- `pip install polars`: Polars (MIT) · https://agentgid.com/tools/polars/agent.md
- `pip install plotly`: Plotly (MIT) · https://agentgid.com/tools/plotly/agent.md
- `pip install streamlit`: Streamlit (Apache-2.0) · https://agentgid.com/tools/streamlit/agent.md
- `pip install e2b-code-interpreter`: E2B Code Interpreter (Python) (MIT) · https://agentgid.com/tools/e2b-code-interpreter-pypi/agent.md

## Agent Skills (read a skill before you install it: skills can run scripts)
- `npx skills add K-Dense-AI/scientific-agent-skills --skill exploratory-data-analysis`
- `npx skills add wshobson/agents --skill sql-optimization-patterns`
- `npx skills add openai/skills --skill jupyter-notebook`
- `npx skills add phuryn/pm-skills --skill sql-queries`
- `npx skills add google/skills --skill bigquery-migration-sql-translator`
- `npx skills add yusufkaraaslan/Skill_Seekers --skill golden-jupyter`

## Coding agent to build it
- OpenAI Codex: free tier, from $8/mo · https://agentgid.com/agents/openai-codex/agent.md
- Claude Code: from $20/mo · https://agentgid.com/agents/claude-code/agent.md
- OpenCode: free tier, from $10/mo · https://agentgid.com/agents/opencode/agent.md

## Before you ship
- Give the agent read-only database credentials.
- Keep API keys on the server, never in the client; set spending limits where the provider offers them.
- Read each service's terms for your use (data retention, commercial use, rate limits).
- Log model calls (traces) and test with your own real inputs before launch.

Recipe page: https://agentgid.com/build/recipes/data-analyst-agent/ · all product recipes: https://agentgid.com/build/recipes/agent.md