Defi, Data, Degen

IntroductionThis is a build log of my first steps building an MCP server for Snowflake. It captures what I tried, what exists today, what worked, what did not, and where I am going next. If you are exploring or building your own MCP, I hope these notes and code references save you time. For install and a quickstart, see the igloo-mcp README.Table of contentsWhy I started building an MCPHow igloo-mcp differs from Snowflake Labs MCPHow igloo-mcp worksLearningsWhat's nextWhy I started building a...

This article presents an AI-powered, LLM-enabled data pipeline for smart contract analytics on the Sui blockchain. Using Snowflake, it curates structured event and object catalogues from 95k+ Move packages, enabling LLMs to perform on-chain data analysis at scale. The pipeline automates SQL generation for DeFi metrics like trading volume, funding rates, DAUs, and open interest, showcasing a scalable approach to blockchain data pipelines.