← Use cases · Coding agents & IDE assistants
AI agent tools for analytics
Short answer: Our top pick for analytics: Observal, with the highest AgentPick Score (78/100) among tools tagged "analytics". Runners-up: saiku (70) and excelize (69). Compare what each does, its license and how recently it was updated below.
| # | Tool | What it does | Score | Stars | License | Updated |
|---|---|---|---|---|---|---|
| #1 | Observal | Observal is self-hosted registry for your coding agent extensions with a built in insight engine. Setup Observal, define the scope and share your Skil… | 78/100 | ★ 4.5k | Apache-2.0 | 14 Oct 2026 |
| #2 | saiku | Open-source semantic layer: one cube for Excel (MDX/XMLA), dashboards, and AI agents (MCP). Mondrian + Apache Calcite. | 70/100 | ★ 1.3k | Apache-2.0 | 12 Oct 2026 |
| #3 | excelize | Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets | 69/100 | ★ 21k | BSD-3-Clause | 14 Oct 2026 |
| #4 | temps | AI-native open-source alternative to Vercel + Sentry + PostHog + Pingdom + Resend + E2B. 440+ CLI operations with drop-in skills for Claude Code, Code… | 69/100 | ★ 843 | Apache-2.0 | 14 Oct 2026 |
| #5 | traceroot | TraceRoot - Open Source AI Agent Improvement Platform YC S25 | 66/100 | ★ 803 | See repo | 14 Oct 2026 |
| #6 | anyquery | One SQL interface for 60+ tools (e.g., GitHub, Notion, Airtable). Plug into any LLM through MCP. | 63/100 | ★ 1.8k | See repo | 8 Oct 2026 |
| #7 | Frappe_Assistant_Core | Infrastructure that connects LLMs to ERPNext. Frappe Assistant Core works with the Model Context Protocol (MCP) to expose ERPNext functionality to any… | 62/100 | ★ 322 | AGPL-3.0 | 14 Oct 2026 |
| #8 | agentacct | See what your coding agents did and what it cost. Breaks each task down into work steps — tools used, files changed, tests run, time and tokens spent.… | 61/100 | ★ 765 | MIT | 3 Oct 2026 |
| #9 | dbt-charts | Declarative YAML around SQL for dbt-native dashboards: easy for agents to write, easy for humans to audit. | 60/100 | ★ 565 | Apache-2.0 | 14 Oct 2026 |
| #10 | google-analytics-mcp | Google Analytics 4 data to AI agents, agentic workflows, and MCP clients. Give agents analysis-ready access to website traffic, user behavior, and per… | 60/100 | ★ 243 | MIT | 14 Oct 2026 |
| #11 | openanalytics | Open-source, privacy-first and cookieless web analytics with revenue attribution and an MCP server. | 59/100 | ★ 626 | AGPL-3.0 | 29 Sept 2026 |
| #12 | ktx | ktx is an executable context layer for data and analytics agents 🐙 Allow Claude Code, Codex, or other AI agents to query analytical databases accurat… | 53/100 | ★ 1.6k | Apache-2.0 | 11 Sept 2026 |
| #13 | Databuddy | Open-source product analytics for startups: track visitors, events, funnels, and goals without cookies, and ask Databunny, the built-in AI analyst. Up… | 52/100 | ★ 1.2k | AGPL-3.0 | 14 Oct 2026 |
| #14 | Claude-Code-Usage-Monitor | Real-time Claude Code usage monitor with predictions and warnings | 43/100 | ★ 8.7k | MIT | 5 Jul 2026 |
| #15 | facebook-ads-library-mcp | MCP Server for Facebook ADs Library - Get instant answers from FB's ad library | 40/100 | ★ 313 | MIT | 12 Aug 2026 |
| #16 | cc-lens | Local analytics dashboard for Claude Code. No cloud, no telemetry. | 35/100 | ★ 598 | MIT | 27 Jun 2026 |
| #17 | agentlytics | Comprehensive analytics dashboard for AI coding agents — Cursor, Windsurf, Claude Code, VS Code Copilot, Zed, Antigravity, OpenCode, Command Code | 31/100 | ★ 583 | See repo | 3 Aug 2026 |
| #18 | pgmcp | An MCP server to query any Postgres database in natural language. | 17/100 | ★ 542 | See repo | 26 May 2026 |
Source: each project's public GitHub repository (description, stars, license, last push). Listed tools aren't tested or ranked by AgentPick.
How to choose
- Check which models and providers it supports.
- Prefer tools that show diffs and ask before running commands.
- Look for recent commits: coding agents change fast.
Get the best new agent tools every week. Free, with a verdict on each. Get the weekly digest
Related
AI agent tools for agent skills →
Coding agents & IDE assistants
AI agent tools for developer tools →
Coding agents & IDE assistants
AI agent tools for the terminal →
Coding agents & IDE assistants
AI agent tools for macOS →
Coding agents & IDE assistants
AI agent tools for agent harnesses →
Coding agents & IDE assistants
AI agent tools for agent orchestration →
Coding agents & IDE assistants
AgentPick Weekly
The week's new agent tools with a verdict on each, every week. Free. We'll email you a link to confirm, and you can unsubscribe any time. See our Privacy Policy.