{"product_id":"analyze-supabase-data-with-claude-sonnet-via-rest-api","title":"Analyze Supabase Data with Claude Sonnet via REST API","description":"\u003ch3\u003eAsk Claude questions—and get answers powered by live Supabase data via REST API\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow lets you chat with \u003cstrong\u003eClaude (Anthropic)\u003c\/strong\u003e, where every question is answered by reading your \u003cstrong\u003eSupabase database\u003c\/strong\u003e through its \u003cstrong\u003ePostgREST REST API\u003c\/strong\u003e. Instead of static reports, Claude queries your tables in real time, using the Supabase OpenAPI schema to discover what’s available.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a chat message\u003c\/strong\u003e through an n8n \u003cem\u003echat trigger\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eClaude (Anthropic)\u003c\/strong\u003e with \u003cstrong\u003econversation memory\u003c\/strong\u003e to interpret the question and plan which data to fetch.\u003c\/li\u003e\n  \u003cli\u003eWhen needed, \u003cstrong\u003efetches the Supabase OpenAPI schema\u003c\/strong\u003e to identify tables, columns, and foreign-key relationships.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQueries Supabase tables\u003c\/strong\u003e using the \u003cstrong\u003ePostgREST REST API\u003c\/strong\u003e, including filtering, sorting, pagination, and foreign-key joins.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eexact row counts\u003c\/strong\u003e from response headers when required, and computes totals\/summaries \u003cstrong\u003eclient-side\u003c\/strong\u003e (since Supabase REST aggregates are not used).\u003c\/li\u003e\n  \u003cli\u003eReturns a plain-language answer, using a small \u003cstrong\u003emarkdown table\u003c\/strong\u003e for multi-row results.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAnswer business questions like “How many active users did we have last week?” using live Supabase metrics.\u003c\/li\u003e\n  \u003cli\u003eSupport analysts and SaaS operators with ad-hoc queries across related tables using foreign-key joins.\u003c\/li\u003e\n  \u003cli\u003eExplore data confidently by letting Claude discover schema details from the Supabase OpenAPI specification.\u003c\/li\u003e\n  \u003cli\u003eCreate an internal “data chat” experience without building a separate BI layer.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Chat Trigger\u003c\/strong\u003e: \u003ccode\u003en8nn8n-nodes-langchainchat trigger\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLLM\u003c\/strong\u003e: \u003ccode\u003en8nn8n-nodes-langchainlm chat anthropic\u003c\/code\u003e with \u003ccode\u003en8nn8n-nodes-langchainmemory buffer window\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAgent orchestration\u003c\/strong\u003e: \u003ccode\u003en8nn8n-nodes-langchainagent\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupabase access\u003c\/strong\u003e: \u003ccode\u003eHTTP Request\u003c\/code\u003e tool calling Supabase \u003cstrong\u003eOpenAPI schema\u003c\/strong\u003e and \u003cstrong\u003ePostgREST REST API\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e Add an \u003cstrong\u003eAnthropic API credential\u003c\/strong\u003e, a \u003cstrong\u003eSupabase API credential\u003c\/strong\u003e (project URL + API key), and replace \u003ccode\u003eYOUR_PROJECT_REF\u003c\/code\u003e in the Supabase request URLs so schema and table queries target your correct instance.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46086653804723,"sku":"N8N-19909","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/j-cBSHy_XHMuCCCFIpCtn_mUfL1n2k.png?v=1790327309","url":"https:\/\/buyflowscripts.com\/products\/analyze-supabase-data-with-claude-sonnet-via-rest-api","provider":"N8N Commerce","version":"1.0","type":"link"}