# Agentic analytics in Slack with ClickHouse, MCP, and PydanticAI

DevFeed: [Agentic analytics in Slack with ClickHouse, MCP, and PydanticAI](<https://devfeed.tech/articles/agentic-analytics-in-slack-with-clickhouse-mcp-and-pydanticai-4917.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/agentic-analytics-slack-clickhouse-mcp>)

Author: Al Brown

Published: 2025-07-23T00:00:00Z

Content type: tutorial

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Slack](<https://devfeed.tech/topics/slack.md>), [MCP Server](<https://devfeed.tech/topics/mcp-server.md>), [Large Language Model](<https://devfeed.tech/topics/llm.md>), [anthropic](<https://devfeed.tech/topics/anthropic.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Bot](<https://devfeed.tech/topics/bot.md>), [GitHub](<https://devfeed.tech/topics/github.md>)

Tags: [agentic](<https://devfeed.tech/tags/agentic.md>), [anthropic](<https://devfeed.tech/tags/anthropic.md>), [api](<https://devfeed.tech/tags/api.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [code](<https://devfeed.tech/tags/code.md>), [github](<https://devfeed.tech/tags/github.md>), [llm](<https://devfeed.tech/tags/llm.md>), [mcp-server](<https://devfeed.tech/tags/mcp-server.md>), [self-service](<https://devfeed.tech/tags/self-service.md>), [slack](<https://devfeed.tech/tags/slack.md>), [sql](<https://devfeed.tech/tags/sql.md>), [tools](<https://devfeed.tech/tags/tools.md>)

## AI overview

This tutorial shows how to build a self-service analytics bot in Slack that queries a ClickHouse data warehouse through the ClickHouse MCP server. It uses PydanticAI and the Anthropic API to interpret natural-language questions, invoke MCP tools, generate SQL, interpret query results, and return natural-language answers.

## Source excerpt

Let's build a self-service analytics agent that we can talk to directly in Slack, that transparently queries our ClickHouse data warehouse.