_template

Extension Name

Why This Matters

Lead with the human pain point. What real-life scenario makes this extension worth building? Use specific, relatable examples — not tech specs.

What It Does

1-2 sentences on the practical capability this adds to your Open Brain.

Learning Path: Extension X of 6

Extension	What You Build	Status
1. Household Knowledge Base	Home facts your agent can recall
2. Home Maintenance Tracker	Scheduling and history for home upkeep
3. Family Calendar	Multi-person schedule coordination
4. Meal Planning	Recipes, meal plans, shared grocery lists
5. Professional CRM	Contact tracking with interaction history
6. Job Hunt Pipeline	Application tracking and interview pipeline

Mark your current extension with <-- You are here

What You'll Learn

• Concept or technique 1
• Concept or technique 2
• Concept or technique 3

Prerequisites

• Working Open Brain setup (guide)
• Supabase CLI installed and linked to your project
• List any earlier extensions that must be completed first
• List any required primitives with links

Credential Tracker

Copy this block into a text editor and fill it in as you go.

Already have your Supabase credentials from the Setup Guide? You just need the same Project URL, Secret key, and Project ref.

EXTENSION NAME -- CREDENTIAL TRACKER
--------------------------------------

SUPABASE (from your Open Brain setup)
  Project URL:           ____________
  Secret key:            ____________
  Project ref:           ____________

GENERATED DURING SETUP
  MCP Access Key:        ____________  (same key for all extensions)
  MCP Server URL:        ____________
  MCP Connection URL:    ____________

--------------------------------------

---

In your Supabase SQL Editor (https://supabase.com/dashboard/project/YOUR_PROJECT_ID/sql/new), paste and Run:

📋 SQL: Extension tables (click to expand)

-- Paste your schema.sql content here
-- Keep each logical group (tables, functions, policies) in its own sub-step

New query → paste and Run:

📋 SQL: Grant service_role access (click to expand)

grant select, insert, update, delete on table public.table_name to service_role;
grant select, insert, update, delete on table public.table_name_2 to service_role;

Important

This step is required. Supabase does not grant full table permissions to service_role by default on new projects. Without this, your MCP server will return "permission denied" errors.

✅ Done when: Table Editor shows your new tables with the expected columns.

---

Follow the Deploy an Edge Function guide using these values:

Setting	Value
Function name	extension-name-mcp
Download path	extensions/extension-name

Tip

If you already deployed the core Open Brain server, this process is identical — just with a different function name and download path.

✅ Done when: supabase functions list shows extension-name-mcp as ACTIVE.

---

Follow the Remote MCP Connection guide to connect this extension to Claude Desktop, ChatGPT, Claude Code, or any other MCP client.

Setting	Value
Connector name	Extension Name
URL	Your MCP Connection URL from the credential tracker

✅ Done when: Your AI client shows the extension's tools in its available tools list.

---

Try these prompts in your AI client:

1. Test prompt 1 — describe what this tests and what the user should see
2. Test prompt 2 — describe what this tests and what the user should see
3. Test prompt 3 — describe what this tests and what the user should see

Caution

If any prompt returns an error, check the Edge Function logs in your Supabase dashboard (Edge Functions → extension-name-mcp → Logs) before troubleshooting further.

✅ Done when: All test prompts return expected results and you can see data in your Supabase Table Editor.

---

Cross-Extension Integration

Describe how this extension connects to others. What tools bridge between this extension and the rest of the Open Brain ecosystem? This is the proof that extensions compound.

Expected Outcome

What should be working when you're done? Be specific.

Troubleshooting

For common issues (connection errors, 401s, deployment problems), see Common Troubleshooting.

Extension-specific issues:

"permission denied for table table_name"

• You skipped Step 1.2. Go back and run the GRANT SQL.

"relation 'table_name' does not exist"

• The schema SQL wasn't run successfully — re-run it in the Supabase SQL Editor.

Next Steps

Link to the next extension in the learning path and briefly describe what it adds.

Tool hygiene: This extension adds MCP tools to your AI's context window. As you build more extensions, the total tool count grows — and with it, the context cost and risk of your AI picking the wrong tool. See the MCP Tool Audit & Optimization Guide for strategies on auditing, merging, and scoping your tools.