Data & analytics AI agent tools
18 data & analytics tools in the AgentScout directory, each with a link-checked listing. SQL and BI agents, text-to-SQL copilots, and spreadsheet or data-pipeline agents that query a warehouse, build a chart, and explain the result in plain language.
Updated
There are 18 data & analytics tools: 12 open source, 4 free or freemium, 2 paid, usage-based or enterprise.
Quick answer: the top picks on this list, ranked by GitHub stars and listing maturity, are Chat2DB, Teable and Cube, out of 18 tools listed below. At a glance: 12 open-source, 16 free or freemium and 12 local or self-hosted across 18 link-checked tools (last verified ).
Verified on : every tool link on this page was checked by our daily link check. No paid placements.
Ranked comparison (top 10)
| # | Tool | Pricing | Best for | Open source | Runs locally | GitHub stars |
|---|---|---|---|---|---|---|
| 1 |  Chat2DB | Open source | data & analytics | Yes | Offline | 28,347 |
| 2 |  Teable | Open source + cloud | data & analytics | Yes | Self-hosted | 21,933 |
| 3 |  Cube | Open source | data & analytics | Yes | Self-hosted | 21,125 |
| 4 |  WrenAI | Open source + cloud | data & analytics | Yes | Self-hosted | 17,986 |
| 5 |  DBHub | Open source | connect tools via MCP | Yes | Self-hosted | 3,730 |
| 6 |  Postgres MCP Pro | Open source | connect tools via MCP | Yes | Self-hosted | 3,430 |
| 7 |  Anyquery | Open source | data & analytics | Yes | Self-hosted | 1,787 |
| 8 |  Saiku | Open source | connect tools via MCP | Yes | Self-hosted | 1,334 |
| 9 |  Power BI Modeling MCP | Open source | connect tools via MCP | Yes | Self-hosted | 1,249 |
| 10 |  JamAIBase | Open source | data & analytics | Yes | Self-hosted | 1,105 |
Tasks in this category
/best/ & /compare/ placement for $49, or book the exclusive $99/wk sitewide & newsletter sponsor slot.Showing 18 of 18 tools
Chat2DB
Chat2DB is a local-first database client where you ask questions in plain language and get SQL
Added
Cube
Cube is an open-source semantic layer that lets BI tools and AI agents query the same metrics
Added
BambooAI
BambooAI is a data-analyst agent that writes Python step by step and checks its own analysis
Added
JamAIBase
JamAIBase is a collaborative spreadsheet for AI where cells chain into agent pipelines
Added
Saiku
Saiku is an open-source semantic layer that serves Excel, dashboards, and AI agents over MCP
Added
Anyquery
Anyquery is one SQL interface over 60 tools, and it plugs into an LLM or agent. It lets an agent query data and explain the result in plain language.
Added
Sourcetable
AI spreadsheet that analyzes data, builds models and charts from prompts.
Added
Kater
AI data analyst that answers business questions from your data warehouse.
Added
Teable
AI spreadsheet and database for business with built-in agents.
Added
WrenAI
Generative BI for agents: governed text-to-SQL with a semantic context layer.
Added
DBHub
Database MCP server for Postgres, MySQL, SQL Server and others from Bytebase.
Added
Power BI Modeling MCP
Microsoft's MCP server that lets agents build and edit Power BI semantic models.
Added
Anamap
AI analytics agent that investigates conversion and revenue changes using your data and release history.
Added
Querri
AI data analyst that cleans scattered data and answers questions in plain English.
Added
MotherDuck MCP
MotherDuck's MCP server that lets AI assistants run SQL on local DuckDB files, S3-hosted databases and MotherDuck.
Added
Postgres MCP Pro
Postgres MCP server with index tuning, explain plans, health checks and safe SQL execution for agents.
Added
Hex
Analytics platform for humans and agents, with conversational analytics, notebooks and context management for data teams.
Added
Dot
AI data analyst that answers data questions, runs root-cause analysis and sends automated reports.
Added
Top data & analytics repos on GitHub (12)
| Repo | GitHub stars | Licence | Last push |
|---|---|---|---|
| Chat2DB ↗ | 28,347 | — | — |
| Teable ↗ | 21,933 | AGPL-3.0 for the core apps; MIT for the packages directory | 2026-10-26 |
| Cube ↗ | 21,125 | — | — |
| WrenAI ↗ | 17,986 | Apache-2.0 for code; CC BY 4.0 for docs | 2026-10-27 |
| DBHub ↗ | 3,730 | MIT | 2026-10-26 |
| Postgres MCP Pro ↗ | 3,430 | MIT | 2026-08-16 |
| Anyquery ↗ | 1,787 | — | — |
| Saiku ↗ | 1,334 | — | — |
| Power BI Modeling MCP ↗ | 1,249 | MIT | 2026-09-29 |
| JamAIBase ↗ | 1,105 | — | — |
| BambooAI ↗ | 828 | — | — |
| MotherDuck MCP ↗ | 535 | — | 2026-10-07 |
12 repos. Stars and licence come from each repo, checked when the listing was last verified.
All categories
Who uses these
Best-of lists
Facts come from our directory listings; pricing is as each maker states it. Check official sites before you choose.