Skip to main content

MCP tools to access portal datasets and catalog

  • December 16, 2025
  • 3 replies
  • 23 views
S

Hi all

I’ve been using Claude Code quite a lot for developing software and doing analysis. It’s an agentic AI coding assistant in the CLI if you haven’t come across it. Anthropic (the parent company) developed a protocol called MCP to help the AI use external resources like APIs.

Someone has developed a tool to take openapi or swagger API specifications and turn it into MCP tools. What this means is that you can ask Claude Code, in natural language, questions about your data, and it will translate this, quite well into code to send a request to the API and return data. HuWise have done something similar on the portal in their “Explore data with AI” feature, but this is a bit more powerful for deeper analysis - but requires some setup and a Claude account and Claude Code.

I simply cloned the repo and asked Claude to create MCP tools from the swagger json for my portal, and it did the rest.

Here is my cloned repo, with the ods_server.py script providing the mcp tools for my portal. Full description of how to use in the README file.

 

hope it’s useful!

cheers

steve

    3 replies

    Benwa
    Huwise Team
    Forum|alt.badge.img
    • Benwa
    • Huwise Team
    • December 17, 2025

    Hi Steve,

    This is excellent work! Thank you for sharing your repository and the detailed walkthrough with the community. It’s really impressive to see how you’ve leveraged the Model Context Protocol (MCP) to enhance the way you interact with your data.

    It is actually very timely that you mention this, as we have been moving in this exact same direction. We’re big believers in the power of MCP to bridge the gap between AI agents and data portals. To support this vision, we’ve developed a hosted Huwise MCP Server that we now offer as an option for our Data Product Marketplace clients.

    Our goal was to provide a seamless, turnkey experience that builds on the kind of workflow you’ve showcased here. Having a managed version allows us to add some additional features that may be of interest to you, such as:

    • Multi-Platform Connectivity: Beyond Claude Code, we’ve successfully integrated this server with the Microsoft Copilot ecosystem, allowing for a seamless experience across different AI environments. You can see how it works here: https://www.huwise.com/en/mcp-ai-agents/.

    • The future of data interaction: we are also starting a new chapter with our own chatbot, Huwy, which is directly integrated into the marketplace. This agent is designed to provide even deeper analysis and will eventually replace the "Explore data with AI" feature. We’ve shared our roadmap and vision in this blog post: https://www.huwise.com/en/blog/huwy-ai-agent-for-smart-data-exploration/

    It’s truly inspiring to see users like you pushing the boundaries of what’s possible with the portal. Since you’ve already spent time under the hood with your own implementation, we’d love to get your thoughts on our approach as we continue to evolve these tools.

    Thanks again for the contribution!

    Best regards,
    Benwa

      S

      Great to see this Benwa, How can users access your MCP service? Is it part of the open data portal offer, or for data marketplace only?

      look forward to seeing how your solution evolves.

       

      Steve

      Lauralee
      Huwise Team
      • Lauralee
      • Huwise Team
      • December 19, 2025

      Hi Steve,

      It’s great to see the work you have done 🎉

      The MCP server simplifies AI integration and reimagines how data is consumed within the marketplace experience. Is is available as an optional add-on, as well as our chatbot Huwy. We can arrange a demo with you and your teams in January if you like.

      In the meantime, I wish you a wonderful Christmas holiday season !

        Terms & ConditionsCookie settingsAccessibility statement
        Huwise Terms & Conditions Cookie settings