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.

IntroThis article presents a framework for building data pipelines on the Sui blockchain using Sentio, illustrated through a complete implementation to analyze Rootlets NFT holders. Sentio is used for efficient data backfilling, custom processing with TypeScript, and real-time analysis via its SQL Studio. The article culminates in demonstrating a user-friendly Sentio dashboard that queries Rootlet ownership by wallet address. This approach provides a reusable and adaptable foundation for deve...

Over 50% of transactions to mutate shared liquidity pool objects that pay the maximum gas fee end up below the median block position. Users paying max gas fees have a 0.001-0.002% chance of securing the top block position, compared to 7-10% for those not paying the highest fees.SIP-45 proposes increasing the max gas price to 1 trillion MIST and making tra...

Sentio Referral Code: Reach out to @is_ye in the sentio telegram chat and give the referral code evandekim2025 for a 20% discount for Sentio subscription! IntroSentio is a game-changing development platform that enables end-to-end data observability for web3 data pipelines. The platform provides a fully integrated, hosted experience that combines modern monitoring, alerting, and debugging capabilities. What makes Sentio particularly powerful is its real-time processing architecture: developer...

How “Latest State” Works on SuiThe latest-state pattern is one of the most important techniques for anyone working with Sui object data. This technique generalizes to every Sui object type and forms the backbone for any analysis rooted in the chain’s actual state. Every asset—whether a coin, NFT, or protocol object—exists as a Move object that evolves through a sequence of versions. Each mutation creates a new version, deleted objects remain visible with object_status = 'Deleted', and there i...