AI agents for data analysts (2026)

Agents that query databases, clean and chart data, and work inside spreadsheets. We picked the top tools for 4 jobs data analysts do every day: 21 tools in all, 21 of them free or with a free tier.

Jump to: Data analysis · Databases · Spreadsheets and slides · Scrape data from websites

Free tools from AgentScout for data analysts: AI API cost calculator

How we picked: each section takes the tools matched to that task in our directory, putting tools whose category and stated use cases fit the task first, then ordering by tracked GitHub stars. No paid placements.

Data analysis

Agents that query, clean and chart data and explain what it shows. All 42 tools →

• Graphify Open source
  Turns a codebase plus its docs, SQL schemas, configs and PDFs into a knowledge graph that coding agents can query. · ★ 127,237
• LlamaIndex Open source + cloud
  Framework for agents over your data (RAG, document agents). · ★ 52,485
• MindsHub Open source + cloud
  MindsDB's agent workspace for research, analysis, documents and coding, with a model router, a scoped vault for connected data and swappable open-source agent harnesses. · ★ 39,800
• Teable Open source + cloud
  AI spreadsheet and database for business with built-in agents. · ★ 21,892
• DB-GPT Open source
  Open-source agentic data assistant for querying and analyzing data with LLMs. · ★ 20,156
• WrenAI Open source + cloud
  Generative BI for agents: governed text-to-SQL with a semantic context layer. · ★ 17,881

Databases

Database MCP servers, vector stores and text-to-SQL tools that let agents query, manage and store data in Postgres, MySQL, MongoDB and more. All 17 tools →

• Chroma Open source + cloud
  Open-source search and vector database widely used for agent memory and RAG. · ★ 29,512
• Teable Open source + cloud
  AI spreadsheet and database for business with built-in agents. · ★ 21,892
• WrenAI Open source + cloud
  Generative BI for agents: governed text-to-SQL with a semantic context layer. · ★ 17,881
• MCP Toolbox for Databases Open source
  Open-source MCP server from Google for connecting agents to databases. · ★ 16,669
• InsForge Open source + cloud
  Open-source backend platform that gives coding agents a database, auth and storage. · ★ 13,129
• LanceDB Open source + cloud
  Open-source multimodal vector database for search, RAG and agent memory. · ★ 11,684

Spreadsheets and slides

AI spreadsheets, slide makers and office tools, plus MCP servers that let agents read and edit Excel, Airtable and Google Workspace files. All 8 tools →

• Google Workspace CLI Open source
  Official Google Workspace command-line tool for Drive, Gmail, Calendar, Docs and more, usable by agents. · ★ 31,557
• Teable Open source + cloud
  AI spreadsheet and database for business with built-in agents. · ★ 21,892
• GenOffice Open source
  Free, open-source office suite with docs, sheets and slides editors and a built-in AI agent. · ★ 9,843
• LobsterAI Open source
  NetEase Youdao's desktop agent for data analysis, slides, documents and web research. · ★ 6,119
• PPTAgent Open source
  Agentic framework that generates and refines PowerPoint presentations. · ★ 5,122
• Excel MCP Server Open source
  MCP server that lets agents create and edit Excel files with formulas and charts. · ★ 4,244

Scrape data from websites

Tools that turn websites into clean data or text an agent can use, from single pages to whole sites. All 8 tools →

• Crawl4AI Open source
  Open-source crawler that turns websites into clean, LLM-ready Markdown for agents and RAG pipelines. · ★ 85,667
• Apify MCP Server Open source + cloud
  Apify's MCP server giving agents access to thousands of scrapers for social media, search and maps. · ★ 11,578
• Wigolo Open source
  Local-first web search, fetch and crawl for coding agents over MCP, with no API keys. · ★ 5,479
• Spider Open source + cloud
  Fast Rust web crawler for collecting data for agents and LLMs. · ★ 2,784
• Bright Data MCP Open source + cloud
  Bright Data's MCP server for web search, scraping and browsing. · ★ 2,678
• ScrapeGraph MCP Open source
  ScrapeGraphAI's MCP server for AI-powered web scraping. · ★ 115

Popular searches for data analysts

MCP servers and AI tools for databases · AI agents for spreadsheets, slides and docs · AI web scraping and crawling tools

Other roles: Developers · AI engineers · Marketers · Sales teams · Customer support teams · Designers · Researchers · Crypto traders · Founders and small businesses · DevOps and SRE engineers · Security engineers · Game developers · Content creators · All roles

Best-of lists for data analysts: Best MCP servers for Cursor · Best MCP servers for Codex · All best lists

Facts come from our directory listings; pricing is as each maker states it and can change. Missing a tool? Submit it free.