AI Analytics Directory forTask-based ToolsTask-based Tools
Keep what counts.Discover practical AI solutions, use cases, MCP servers
& platforms for everyday analytics.
AI Analytics Hub is a free directory and comparison platform for data analytics professionals exploring AI-powered tools. The site catalogs MCP (Model Context Protocol) servers that connect AI models to live data sources, conversational analytics platforms that let analysts query data in plain language, and a Tool-per-Task grid matching specific analytics workflows to the best available AI tools. Each listing includes features, pricing, and real-world use cases contributed by the analytics community. The platform is curated by Nimrod Fisher, an AI analytics consultant who runs workshops and consulting for data teams at companies including Remitly, Similarweb, and Bigabid. Companies hire Nimrod to build data agents for analytics teams. He also maintains Data Analytics Skills, a 400+ star open-source Claude skills library (https://github.com/nimrodfisher/data-analytics-skills). New tools, use cases, and weekly updates are added regularly.
Explore by Category
Choose a category to discover the best AI solutions for your needs
Expand LLM capabilities with MCPs
Model Context Protocol (MCP) servers extend AI capabilities with direct access to your data sources, computation engines, and analytical tools. Install these servers to enhance your AI analytics workflow. MCP is the Access layer. To build data agents for your team, you still need Context and Instructions on top of these servers.
Open-source MCP server for DuckDB and MotherDuck to run local or cloud analytical SQL with LLMs
Analytics Use Case
Let LLMs run analytical queries on DuckDB files or MotherDuck databases for fast exploration and prototyping
Compatible With
Tags
Installation
Clone from GitHub: github.com/motherduckdb/mcp-server-motherduckConnect AI tools to Atlan's data catalog for secure metadata search, lineage, and governance.
Analytics Use Case
Metadata discovery, lineage exploration, governed asset updates from AI assistants.
Compatible With
Tags
Installation
Follow Atlan guide. Requires Atlan workspace creds. Run locally via uv or Docker.Operate on GitHub repos, issues, PRs, and code search through MCP hosts with GitHub auth.
Analytics Use Case
Code and repo discovery, PR review, triage, workflow actions, search.
Compatible With
Tags
Installation
Enable via MCP host marketplace or configure server per Copilot/IDE docs.MCP server that provides safe, structured access to Amazon Redshift data warehouses for LLM-driven SQL analysis
Analytics Use Case
Query Redshift schemas and run read-only SQL from LLMs to explore data, aggregate metrics, and validate hypotheses
Compatible With
Tags
Installation
See docs: https://awslabs.github.io/mcp/servers/redshift-mcp-serverOfficial MCP server (preview) for SQL Server/Azure SQL providing conversational T-SQL access
Analytics Use Case
Query SQL Server databases from an LLM to retrieve metrics, diagnose issues, and automate reporting
Compatible With
Tags
Installation
See blog for setup instructionsMCP server for Amazon Aurora MySQL providing conversational SQL access via LLMs
Analytics Use Case
Translate natural language to MySQL queries against Aurora MySQL for data exploration and reporting
Compatible With
Tags
Installation
See docs: awslabs.github.io/mcp/servers/mysql-mcp-server/New to MCP?
Model Context Protocol is an open standard that enables AI assistants to securely connect to your tools and data. Start by installing an MCP server and configuring it with your AI assistant like Claude Desktop or VS Code.