# Building Your Own Knowledge Graph for AI *Presentation for Ed Cotton's StatMonday Webinar* ๐Ÿ”— **Follow along:** [howto.fodda.ai](https://howto.fodda.ai) --- ## Today I'm going to help you make a **knowledge graph-lite** of a set of data that you can query. **What you'll need:** - ๐Ÿ›  Agentic Coder - ๐Ÿ“Š Google Sheets - ๐Ÿค– Anthropic Claude OR Notion - ๐Ÿ“ก Publishing Via Fodda **Or just follow along.** --- ## Static Reports โ†’ Working Knowledge My business used to be all about trend reports.... ๐Ÿ”— [PSFK Reports on Gumroad](https://psfk.gumroad.com/) Recently exploring how I can adapt to how people work with co-pilots. So creating read-me and skills files that can be uploaded into Anthropic. - See newsletter where I post the links to Skills and ReadMe files here: [PSFK Newsletter](https://newsletter.psfk.com/p/eat-shop) - See the downloads of those files here: [Brand-Owned Dining Skills File Download](https://psfk.gumroad.com/l/Brand-Owned-Dining-as-Retail-Extension?layout=profile) --- ## Providing Expert Knowledge Graphs for AI Systems Over the least 3-4 months I've been exploring how to provide expert knowledge graphs for AI systems. ๐Ÿ”— [Fodda Graphs](https://www.fodda.ai/#/graphs) ### Claude Demo Let me show the Fodda system by demonstrating how it works with Claude. ๐Ÿ”— [claude.ai](https://www.claude.ai) The idea behind Fodda - esp with Claude - is that it's **your data streaming in to your LLM.** ### Try Fodda yourself in Claude by adding one of these MCP URLs as a [Connector](https://claude.ai/customize/connectors) | Graph | MCP URL | |-------|---------| | ๐Ÿ›’ Retail | `https://mcp.fodda.ai/mcp?api_key=sk_trial_retail&user_id=claude-user` | | ๐Ÿ’„ Beauty | `https://mcp.fodda.ai/mcp?api_key=sk_trial_beauty&user_id=claude-user` | | โšฝ Sports | `https://mcp.fodda.ai/mcp?api_key=sk_trial_sports&user_id=claude-user` | ### Try yourself in Notion by using a [Fodda agent](https://www.notion.so/marketplace/profiles/fodda) and adding one of these MCP URLs | Graph | MCP URL | |-------|---------| | ๐Ÿ›’ Retail | `https://mcp.fodda.ai/mcp?api_key=sk_trial_retail&user_id=notion-user` | | ๐Ÿ’„ Beauty | `https://mcp.fodda.ai/mcp?api_key=sk_trial_beauty&user_id=notion-user` | | โšฝ Sports | `https://mcp.fodda.ai/mcp?api_key=sk_trial_sports&user_id=notion-user` | --- --- ## Why A Knowledge Graph? One way I think about it is that we add instructions within a table or database so that it's easier for an AI to understand the connections between data. E.g. what brand is this data connected to. - Concepts of knowledge graphs have been around since the 70s, the theory much earlier - **2012** โ€” Google started to use a Knowledge Graph - **2025/26** โ€” Seen as a step 'up' from vector databases For me โ€” as the AI traverses across the data, it promises to uncover connections we would have found hard to find before. --- ## So Let's Get Started โ€” 3 Steps 1. ๐Ÿ“Š **The Table** โ€” Set up a Google Sheet to collect raw data and analysis 2. ๐Ÿ” **The Analysis** โ€” Use an AI agent to find patterns in your signals 3. ๐Ÿ“ก **Publish** โ€” Register on Fodda so AI systems can query your graph That's it. Fodda handles the MCP connection โ€” you don't need to build a server. --- ## Step 1: The Table Two tables that work together: - A table that collects **raw data** โ€” bookmarks, articles, signals - A table that has an **analysis** of the raw data โ€” patterns, trends They are interconnected by `pattern_name` โ€” each signal links to a pattern by name. ๐Ÿ“‹ **Recommended template:** [โ†’ Copy Google Sheets Template](https://docs.google.com/spreadsheets/d/1LqUytJ_Su4CVZvGmxTxDylsQLKmd4yWr5nC8rIhcZAk/copy) ๐Ÿ“„ [โ†’ Readme Help File : Setting Up Your Google Sheets Pattern Graph](briefs/brief-sheets-template.md) ๐Ÿ“‹ **Here's a sheet I updated earlier :** [โ†’ Open Google Sheets Sample]() ## Step 1B: Adding Content to Your Sheet You can add signals (articles, bookmarks, observations) manually โ€” or you can get an AI agent to build a tool that does it for you. **Brief 2 does two things:** 1. ๐Ÿ“ฅ **Signal Collection** โ€” Paste a URL, the tool extracts metadata (summary, brands, technologies, sector) via LLM and writes it to your Signals tab 2. ๐Ÿ” **Pattern Recognition** โ€” Once you have signals, the tool groups them into patterns (manually or AI-suggested) and writes those to your Patterns tab **Add this file to a new session in your agentic coder to build the tool:** ๐Ÿ“„ [โ†’ Brief 2: Signal Collector + Pattern Recognition](briefs/brief-signal-collector.md) ๐Ÿ”— **Dashboard:** [howto.fodda.ai/#briefs](https://howto.fodda.ai/#briefs) ๐Ÿ‘๏ธ **See Example:** [What Brief 2 builds](https://howto.fodda.ai/example.html) --- ## Step 2: The Analysis (pt 1) Yes โ€” you could do the pattern recognition yourself. Or you could use the tool you built in Step 1B โ€” Brief 2 includes an AI-assisted "Suggest Patterns" feature that analyses your untagged signals and proposes groupings. **If you haven't built the tool yet, add this file to a new session in your agentic coder:** ๐Ÿ“„ [โ†’ Brief 2: Signal Collector + Pattern Recognition](briefs/brief-signal-collector.md) ๐Ÿ”— **Dashboard:** [howto.fodda.ai/#briefs](https://howto.fodda.ai/#briefs) ๐Ÿ‘๏ธ **See Example:** [What Brief 2 builds](https://howto.fodda.ai/example.html) --- ## Step 2b: The Analysis (pt 2) To do the analysis โ€” go to the URL and press **Analyze**. Do a human review. Return to your agentic coder and suggest ways to run the analysis next time. --- ## Step 3: Publish to Fodda Your Sheet is your graph. Fodda makes it queryable. 1. Share your Sheet read-only with Fodda's service account 2. Register at [app.fodda.ai](https://app.fodda.ai) 3. Your graph joins the network โ€” discoverable by Claude, Gemini, Cursor, and every MCP-compatible tool ๐Ÿ“„ [โ†’ Brief 3: Publishing Your Graph to the Fodda Network](briefs/brief-publish-to-fodda.md) --- ## The MCP URL I guess for me it's like an **agent talking to an agent**. Before we had API keys and we had to send very specific information in specific fields. Now it's more like **AI-to-AI chat**: if some information is missing, the AIs will discuss what's missing and go find it (rather than error). --- ## What To Do With Your MCP URL ### Option 1: Claude Connector You can add it now to Claude as a connector. ๐Ÿ”— [โ†’ How to set up a Claude Connector](https://app.fodda.ai) ### Option 2: Notion Agent You can add it now to Notion when you create a new agent. ๐Ÿ”— [โ†’ How to set up a Notion Agent](https://app.fodda.ai) ### Option 3: Publish & Sell via Fodda You can register your graph on Fodda to make it discoverable and eventually monetize it. ๐Ÿ“„ [โ†’ Brief 3: Publishing Your Graph to the Fodda Network](briefs/brief-publish-to-fodda.md) --- ## For Power Users: Build Your Own MCP Server If you want full control โ€” custom query logic, caching, or a data source beyond Google Sheets โ€” you can build your own MCP server and register it on Fodda. ๐Ÿ“„ [โ†’ Advanced: Standalone MCP Server Brief](briefs/brief-standalone-mcp.md) --- *Built with [Fodda](https://www.fodda.ai) ยท [PSFK](https://www.psfk.com)*