AI Analytics Hub — by Nimrod Fisher
AI Analytics Directory for MCP Servers
Keep what counts.Discover practical AI solutions, MCP servers
& platforms for everyday analytics.
Free to use, no account needed. Want help putting these to work? Work with me
AI Analytics Hub is the free resources section of Nimrod Fisher's site: a directory of MCP (Model Context Protocol) servers that connect AI models to live data and tools, conversational analytics platforms that let people query data in plain language, open-source projects and weekly updates. Nimrod Fisher builds AI systems for companies and advises teams that build their own (work with Nimrod). He also maintains Data Analytics Skills, an open-source Claude and Codex skills library (https://github.com/nimrodfisher/data-analytics-skills).
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
How analysts use it
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.
How analysts use it
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.
How analysts use it
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
How analysts use it
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
How analysts use it
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
How analysts use it
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.