supabase / mcp

97%

push

github

Joshenlim/ai 1240 mcp add functionality for listing and getting notebooks (#444)

## Context

_Prefacing this that it's my first time contributing to this repo, so
I've had substantial help from Claude for this 😅 🙏_
Please do let me know if there's anything that i can do better RE the
changes here! 🙂 🙏

This PR adds 2 new MCP tools for managing the new notebooks for projects
- `list_notebooks` and `get_notebook`, which pings the newly added `v2`
management API endpoints for notebooks
([ref](https://github.com/supabase/platform/pull/38167))

## To test

This is what I've done to verify that the MCP tooling is working
correctly - let me know if there's a better way to do this! 🙏 I seem to
be running into permission issues on the API end however, hence why the
PR is still in draft at the moment as I'm unable to test E2E properly.

- Am using the `@modelcontextprotocol/inspector` GUI to test the MCP
server locally (via `pnpm dev:http`)
- Connected to the MCP server via
`http://127.0.0.1:3111/mcp?project_ref=dfbjnxjedvxmmeuiuygg&features=notebooks`
  - Using a production project ref that has some notebooks
- Able to connect successfully as such:
<img width="549" height="285" alt="image"
src="https://github.com/user-attachments/assets/63cd7371-6024-46cb-830b-3424b4b5b59f"
/>
- And able to view the new tools created:
<img width="1175" height="304" alt="image"
src="https://github.com/user-attachments/assets/2398c598-96a2-447b-8555-7a22f08ad12f"
/>
- And able to execute said tools in the inspector
<img width="1203" height="548" alt="image"
src="https://github.com/user-attachments/assets/83ab7ac3-58cd-4644-b1d6-286bf7c16798"
/>
<img width="1165" height="658" alt="image"
src="https://github.com/user-attachments/assets/5b27c8e9-6399-4f51-ac6a-e74fe62dda08"
/>

667 of 711 branches covered (93.81%)

Branch coverage included in aggregate %.

244 of 250 new or added lines in 8 files covered. (97.6%)

4310 of 4418 relevant lines covered (97.56%)

89.2 hits per line