Loading pattern preview
BlocksReal-world Examples
Data Analysis Agent
Data Analysis Agent
Upload CSV or JSON data and get AI-powered analysis with interactive visualizations. Detect patterns, correlations, outliers, and generate insights with confidence scores. Export comprehensive reports.
Use this when users upload a CSV or JSON dataset and need an agent to find correlations, outliers, and trends, then chart them and export a report.
Loading pattern preview
Problems solved
Technical challenges this implementation handles out of the box.
- Upload and parse CSV or JSON datasets for analysis
- Detect correlations, outliers, and trends with AI insights
- Create interactive chart visualizations from the dataset
- Export analysis reports as Markdown or JSON
Use cases
Products and workflows this pattern is designed to support.
- Exploratory data analysis tools
- Business intelligence reporting chats
- Dataset quality assessment
- Automated insight generation for tabular uploads
Compare with
Similar patterns, and when each one is the better fit.
PDF Analysis ToolUse this when users upload PDF files and you need the model to read the raw document bytes and stream back a summary or key points.
AI Profile Enrichment FormUse this when users fill out a sparse profile form and you want AI to stream in the missing fields for them to review before accepting.
CSV Editor ArtifactUse this when your chat app needs a spreadsheet artifact that auto-detects column types and is backed by Upstash storage.
Chart ArtifactUse this when users ask financial questions in chat and you need a tool call to return a live chart plus computed runway and expense insights.
Setup
Requirements, wiring steps, and what this pattern adds to your project.
Getting started
Pick how you want to pull this pattern in. Then wire env vars and routes the same way.
- 1
Download → Next.js app
Use Download → Next.js app in the preview toolbar. You get a zip scaffold (Pro downloads rewrite preview `/view/.../api/*` paths to `/api/*` automatically).
- 2
Extract the zip and install dependencies
Unzip the archive, then run `pnpm install` (or npm / yarn) in the project folder.
- 3
Fill .env.local
The download includes .env.local placeholders when needed. Add real values for: OPENAI_API_KEY.
- 4
Customize the agent and tool files
Adapt prompts, tools, and stop conditions in the generated project for your product.
- 5
Run the app and open the pattern route
Run `pnpm dev`, open the setup/checklist page if present, then navigate to the generated pattern route and verify responses.
Environment variables
OPENAI_API_KEYGet key
Capabilities
AI SDK APIs
useChatgatewayToolLoopAgenttoolhasToolCallstepCountIscreateAgentUIStreamResponseInferAgentUIMessageDefaultChatTransportUIMessageProviders
OpenAI
External services
Upstash
Files added
15 files
app/page.tsxapp/layout.tsxapp/api/data-analysis-agent/route.tslib/actions.tslib/data-types.tslib/dataset-utils.tslib/rate-limit.tslib/ai/data-analysis-agent.tslib/ai/tools/analyze-dataset.tslib/ai/tools/detect-patterns.tslib/ai/tools/generate-visualization.tslib/ai/tools/suggest-insights.tslib/ai/tools/clean-data-suggestions.tslib/ai/tools/export-analysis.tsREADME.md
Dependencies
10 total
npm packages
8AISDKUpstashlucide-reactNext.jsReactrechartssonnerZod
Registry components
buttonchart
Critical files
8 files
data-analysis-agent/route.tsAPI route using createAgentUIStreamResponse with datasetContext passed via callOptions.
ai/data-analysis-agent.tsToolLoopAgent with dynamic tool creation pattern: prepareCall recreates all tools with injected dataset context via createAgentTools(options.datasetContext).
tools/analyze-dataset.tsDataset analysis tool computing summary statistics, data types, missing values, and cardinality.
tools/detect-patterns.tsPattern detection tool finding correlations, outliers, trends, and anomalies.
tools/generate-visualization.tsChart generation tool producing interactive visualization configs from dataset data.
tools/suggest-insights.tsAI-powered insights tool generating findings with confidence scores and business implications.
tools/clean-data-suggestions.tsData quality tool identifying issues and suggesting fixes with before/after previews.
tools/export-analysis.tsAnalysis export tool generating Markdown reports or JSON summaries.
Requirements
- Complexity
- Advanced
- Setup time
- ~5 minutes
- Node
- 24+
- Memory
- 256MB
Upstash Redis
