Best of Daily Dose of Data Science | Avi Chawla | Substack — May 2025

  1. 1
    Article
    Avatar of dailydoseofdsDaily Dose of Data Science | Avi Chawla | Substack·46w

    The Full MCP Blueprint

    MCP (Model Context Protocol) provides a standardized way for LLMs to interact with tools and capabilities, solving the M×N integration problem where every tool needs manual connection to every model. The protocol enables dynamic tool discovery, plug-and-play interoperability between systems like Claude and Cursor, and transforms AI development from prompt engineering to systems engineering. MCP uses a Host-Client-Server architecture with JSON-RPC communication and supports various transport mechanisms including Stdio and HTTP.

  2. 2
    Article
    Avatar of dailydoseofdsDaily Dose of Data Science | Avi Chawla | Substack·50w

    Build an MCP Server in 3 Steps

    This post describes a simple three-step process to build an MCP server using tools like Gitingest and Google AI Studio, enabling the transformation of FastMCP repository data into LLM-readable text. It also highlights the capabilities of the Firecrawl framework, which converts websites into structured formats for AI applications.

  3. 3
    Article
    Avatar of dailydoseofdsDaily Dose of Data Science | Avi Chawla | Substack·48w

    Building a 100% local MCP Client

    Learn how to build a completely local Model Context Protocol (MCP) client using tools like LlamaIndex, Ollama, and LightningAI. The tutorial provides a comprehensive walkthrough to create an MCP client capable of communicating with external tools and data sources through a structured protocol. It demonstrates setting up an SQLite server and building an AI agent using Deepseek-R1 as the local LLM, providing users with context-aware responses based on their queries.

  4. 4
    Article
    Avatar of dailydoseofdsDaily Dose of Data Science | Avi Chawla | Substack·46w

    Build an MCP Server to Connect to 200+ Data Sources

    A guide to building a Model Context Protocol (MCP) server using MindsDB that can connect to over 200 data sources including Slack, Gmail, GitHub, and Hacker News. The setup uses Docker for local hosting and integrates with Cursor IDE, providing tools to list databases and query federated data through a unified interface. The implementation demonstrates practical use cases like fetching Hacker News data, sending formatted summaries to Slack, and retrieving Gmail messages.

  5. 5
    Article
    Avatar of dailydoseofdsDaily Dose of Data Science | Avi Chawla | Substack·46w

    Building an MCP-powered Financial Analyst

    Explore the process of building a financial analyst powered by MCP (Multi-agent CP), which integrates AI components like DeepSeek-R1 LLM and CrewAI for multi-agent orchestration. The system setup includes agents for query parsing, code writing, executing, and visualization of financial data. The tech stack utilizes various tools to create a locally functional financial analyst that can perform complex stock analysis and generate visual outputs.

See all Daily Dose of Data Science | Avi Chawla | Substack archives