Tools reference


Endpoint	`https://mcp-server.marquesboxing.devfellowship.com/mcp`
Transport	Streamable HTTP (MCP `2025-06-18`)
Tool count	33
Backing data	Supabase project `ozxwtjvcrkmlswpojmzc` (`db/migrations/0001_initial_schema.sql`, `0002_classes_name.sql`)

Entity groups

Students

5 tools — the gym’s student registry, including LGPD-sensitive health declaration consent. →

Modalities

5 tools — Boxing, Muay Thai, etc. →

Plans

5 tools — pricing tiers (2x/3x/daily). →

Teachers

5 tools — may or may not have a staff login. →

Classes

5 tools — turmas: modality + teacher + schedule. →

Class roster

3 tools — enroll/unenroll a student, list a roster. →

Staff users

3 tools — list, invite, update (owner-only). →

Reports

2 read-only tools — overdue payments, students per teacher. →

list_<entity> — paginated (limit/offset, default 50 / max 200), returns { items, total, has_more }.
get_<entity> — fetch one row by id (uuid). Not-found is a clean tool error, not a raw database error.
create_<entity> — same required fields the staff UI’s create form enforces. org_id is stamped automatically from the caller’s own account — never pass it yourself.
update_<entity> — partial update: only the fields you pass change. Pass null on a nullable field to clear it; omit a field to leave it untouched. Errors if you pass zero fields.
delete_<entity> — hard delete by id. Fails with a clear error if another table still references the row (this schema has no cascading deletes — same as the staff UI’s own delete confirmation).

All ids are UUIDs. All dates are YYYY-MM-DD. All timestamps in responses are ISO 8601 (timestamptz).