Fused MCP Agents: Setting up MCP Servers for Data

Fused MCP Agents: Setting up MCP Servers for Data

A Python-based MCP server that allows Claude and other LLMs to execute arbitrary Python code directly through your desktop Claude app, enabling data scientists to connect LLMs to APIs and executable code.

fusedio

Research & Data
Visit Server

README

Fused MCP Agents: Setting up MCP Servers for Data

MCP servers allow LLMs like Claude to make HTTP requests, connecting them to APIs & executable code. We built this repo for ourselves & anyone working with data to easily pass any Python code directly to your own desktop Claude app.

This repo offers a simple step-by-step notebook workflow to setup MCP Servers with Claude's Desktop App, all in Python built on top of Fused User Defined Functions (UDFs).

Demo once setup

Requirements

If you're on Linux, the desktop app isn't available so we've made a simple client you can use to have it running locally too!

You do not need a Fused account to do any of this! All of this will be running on your local machine.

Installation

  • Clone this repo in any local directory, and navigate to the repo:

    git clone https://github.com/fusedio/fused-mcp.git
    cd fused-mcp/
    
  • Install uv if you don't have it:

    macOS / Linux:

    curl -LsSf https://astral.sh/uv/install.sh | sh
    

    Windows:

    powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/install.ps1 | iex"
    
  • Test out the client by asking for its info:

    uv run main.py -h
    
  • Start by following our getting-started notebook fused_mcp_agents.ipynb in your favorite local IDE to get set up and then make your way to the more advanced notebook to make your own Agents & functions

Notebook

Repository structure

This repo is build on top of MCP Server & Fused UDFs which are Python functions that can be run from anywhere.

Support & Community

Feel free to join our Discord server if you want some help getting unblocked!

Here are a few common steps to debug the setup:

  • Running uv run main.py -h should return something like this:

uv helper output function

  • You might need to pass global paths to some functions to the Claude_Desktop_Config.json. For example, by default we only pass uv:
{
    "mcpServers": {
        "qgis": {
            "command": "uv",
            "args": ["..."]
        }

    }
}

But you might need to pass the full path to uv, which you can simply pass to common.generate_local_mcp_config in the notebook:

# in fused_mcp_agents.ipynb
import shutil 

common.generate_local_mcp_config(
    config_path=PATH_TO_CLAUDE_CONFIG,
    agents_list = ["get_current_time"],
    repo_path= WORKING_DIR,
    uv_path=shutil.which('uv'),
)

Which would create a config like this:

{
    "mcpServers": {
        "qgis": {
            "command": "/Users/<YOUR_USERNAME>/.local/bin/uv",
            "args": ["..."]
        }

    }
}

Contribute

Feel free to open PRs to add your own UDFs to udfs/ so others can play around with them locally too!

Using a local Claude client (without Claude Desktop app)

If you are unable to install the Claude Desktop app (e.g., on Linux), we provide a small example local client interface to use Claude with the MCP server configured in this repo:

NOTE: You'll need an API key for Claude here as you won't use the Desktop App

  • Create an Anthropic Console Account

  • Create an Anthropic API Key

  • Create a .env:

    touch .env
    
  • Add your key as ANTHROPIC_API_KEY inside the .env:

    # .env
    ANTHROPIC_API_KEY = "your-key-here"
    
  • Start the MCP server:

    uv run main.py --agent get_current_time
    
  • In another terminal session, start the local client, pointing to the address of the server:

    uv run client.py http://localhost:8080/sse
    

Recommended Servers

Crypto Price & Market Analysis MCP Server

Crypto Price & Market Analysis MCP Server

A Model Context Protocol (MCP) server that provides comprehensive cryptocurrency analysis using the CoinCap API. This server offers real-time price data, market analysis, and historical trends through an easy-to-use interface.

Featured
TypeScript
MCP PubMed Search

MCP PubMed Search

Server to search PubMed (PubMed is a free, online database that allows users to search for biomedical and life sciences literature). I have created on a day MCP came out but was on vacation, I saw someone post similar server in your DB, but figured to post mine.

Featured
Python
dbt Semantic Layer MCP Server

dbt Semantic Layer MCP Server

A server that enables querying the dbt Semantic Layer through natural language conversations with Claude Desktop and other AI assistants, allowing users to discover metrics, create queries, analyze data, and visualize results.

Featured
TypeScript
mixpanel

mixpanel

Connect to your Mixpanel data. Query events, retention, and funnel data from Mixpanel analytics.

Featured
TypeScript
Sequential Thinking MCP Server

Sequential Thinking MCP Server

This server facilitates structured problem-solving by breaking down complex issues into sequential steps, supporting revisions, and enabling multiple solution paths through full MCP integration.

Featured
Python
Nefino MCP Server

Nefino MCP Server

Provides large language models with access to news and information about renewable energy projects in Germany, allowing filtering by location, topic (solar, wind, hydrogen), and date range.

Official
Python
Vectorize

Vectorize

Vectorize MCP server for advanced retrieval, Private Deep Research, Anything-to-Markdown file extraction and text chunking.

Official
JavaScript
Mathematica Documentation MCP server

Mathematica Documentation MCP server

A server that provides access to Mathematica documentation through FastMCP, enabling users to retrieve function documentation and list package symbols from Wolfram Mathematica.

Local
Python
kb-mcp-server

kb-mcp-server

An MCP server aimed to be portable, local, easy and convenient to support semantic/graph based retrieval of txtai "all in one" embeddings database. Any txtai embeddings db in tar.gz form can be loaded

Local
Python
Research MCP Server

Research MCP Server

The server functions as an MCP server to interact with Notion for retrieving and creating survey data, integrating with the Claude Desktop Client for conducting and reviewing surveys.

Local
Python