All tools A–Z

Every tool of every published MCP host, A to Z: 508 tools and 34 deprecated names. Each line gives the tool name (linked to its reference), the host that serves it, and what the tool does.

To browse by task instead, start at All MCP hosts. The machine-readable list is /tools-manifest.json.

A

account_close_readiness · financing — Deprecated name. Use check_account_close_readiness (removed after 2026-12-04).
ack_comms_message · ops — Move your read cursor (work.thread_members.last_read_seq) on a thread to seq.
add_assumption · strategy — Create a strategy.assumptions row for a business_unit — a testable belief underpinning the strategy (desirability/viability/feasibility), its status, evidence gathered so far, and the risk if it turns out to be wrong.
add_business_unit_relationship · strategy — Deprecated name. Use add_canvas_business_unit_relationship (removed after 2026-12-04).
add_canvas_business_unit_relationship · strategy — Create a typed edge in strategy.business_unit_relationships between two business units (from_bu → to_bu), e.g. “the Fellowship BU funds the Studio BU” or “Itera commercializes Revera’s methodology”.
add_competitor · strategy — Create a strategy.competitors row for a business_unit.
add_event_guest · events — Add or link a guest for an event (the interview dispatch audience).
add_event_photo · events — Add a photo to an event. Inserts the photo, then upserts the tagged members into event_photo_members.
add_persona · strategy — Create a strategy.personas row under a customer_segment — a named buyer/user persona (occupation, buying role in the deal, ICP priority tier).
add_question · quiz — Deprecated name. Use add_quiz_question (removed after 2026-12-04).
add_quiz_question · quiz — Add a question (and its options for choice types) to a quiz.
add_requirements · proposals — Bulk-add the extracted checklist for an opportunity: document/eligibility/content/form/budget requirements, each with provenance (source_excerpt + source_page) back to the notice PDF.
add_slide_beat · studio — Insert one beat into a slide’s template_data.animation.beats.
add_source · strategy — Create a strategy.sources row — a provenance record for where a strategy artifact came from (a Fireflies call, a plans.devfellowship.com plan, a Company Brain node, or a manual note), or of a keyword-metrics collection…
add_stage_dependency · learn — Add a sequence/dependency edge (predecessor -> successor) within a program.
advance_payment · payments — Move ONE payment (invoice) forward by exactly one transition: submitted→approved (approve) or approved→payment_requested (dispatch Woovi PIX).
annotate_suppression_reason · financing — Write the audit reason on reconciliation_staging rows that are ALREADY suppressed.
annotate_ux_map_region · engineering — Pin a design note to a REGION of a captured screen in engineering.ux_map_annotations.
answer_question · plans — Record an answer to a plan question.
approve_post · campaigns — Record that a PERSON cleared this post for publishing, when they said so to you instead of clicking in the dfl-campaigns UI — the case the queue had no answer for (Tainan asked for a Reel over Telegram, 2026-09-11).
approve_staging · financing — Move financial.reconciliation_staging rows from status=pending_review to status=approved — the MIDDLE step of the pending_review → approved → executed lifecycle, which until now NO MCP tool performed (only the preview…
approve_story_sequence · campaigns — Record that a PERSON cleared this whole Story sequence for publishing (show them its user_tags first: the tags go to Instagram with the Stories, and what Instagram renders was not verified), when they said so to you…
archive_business_unit · strategy — Deprecated name. Use archive_canvas_business_unit (removed after 2026-12-04).
archive_canvas_business_unit · strategy — Set strategy.business_units.is_archived on a row (default true — archive).
archive_form · quiz — Soft-archive a form (sets is_active=false) by id or slug.
archive_post · campaigns — Hide an approved or PUBLISHED post from dfl-campaigns — the calendar, the profile pages (recent posts, top posts, cadence, counts) and analytics — while KEEPING its metric snapshots in the database.
archive_suggested_topic · campaigns — Archive one suggested topic (“pauta”) of the Curadoria board of /posts/pautas in dfl-campaigns, or bring an archived one back with restore=true.
assign_developer · engineering — Suggests and assigns the best-matched developer for a work.tasks row via the dfl-ai-task-assigner-matching-task Edge Function (deterministic scoring + optional AI re-rank).
assign_spec_run_feature_groups · engineering — Assign items to feature groups in ONE batch.
assign_spec_run_layers · engineering — Assign items to scope layers in ONE batch.
assign_user_role · ops — Assign a GLOBAL IAM role to a user via public.iam_insert_user_role.
attach_document · proposals — The compliance join: record that a specific vault document (company_document_id) satisfies a submission — optionally tied to the exact requirement it fulfills (requirement_id).
attach_entity · plans — Attach an external entity (diagram / document / image / ux_path / spec_run) to a plan by inserting a {{dfl-entity:<type>:<locator>}} token into its body — without you having to republish the whole body.
attach_slide_recording · studio — Attach a raw recording (URL or media_id) to a slide: writes its slide_media row (one per slide), sets the slide duration to the trim window, starts the server transcode, and writes captions — transcribed by dfl-render…
audit_staging_routing · financing — READ-ONLY audit of the reconciliation staging queue: flag every queued row whose classification would post to the wrong place.

B

backfill_journal_line_asset_type · financing — Fill the MISSING asset_type_id on the lines of POSTED financial.journal_entries — and write NOTHING else.
backfill_nubank_identifier_refs · financing — Idempotent maintenance backfill: re-keys LEGACY Nubank financial.reconciliation_staging rows onto the statement’s native Nubank Identificador (source_raw.identifier), rewriting source_ref to…
backfill_row_signatures · financing — Idempotent maintenance backfill: compute and persist the stable row_signature on every financial.reconciliation_staging row where it IS NULL.
book_linked_entry · financing — Book N balanced journal-entry legs ATOMICALLY across accounts and/or tenants for a cross-boundary financial event (transfer+FX, capital contribution / on-behalf, internal transfer).
bump_project_version · studio — Create a new version of a Lesson Studio project (version_number = max existing + 1, starting at 1).

C

capture_cover_slide · studio — Render the composition’s cover slide (template_data.is_cover, set by set_cover_slide) to a PNG for the deck’s video thumbnail, and return its image_url.
check_account_close_readiness · financing — READ-ONLY. Per wallet: the posted BOOK balance, the REAL balance and its date (financial.bank_balance_snapshots for fiat, financial.onchain_balance_snapshots for on-chain), the current drift, the staging queue by status…
check_batch_divergence · financing — Compare a batch’s stored projected-balances snapshot (captured at publish time) against freshly-fetched REAL balances — bank via financial.bank_balance_snapshots (latest per bank+currency) and on-chain via the canonical…
check_eligibility · proposals — Cross a company against an opportunity’s requirements and return a per-requirement verdict + gap list.
check_in_guest · events — Check in an event guest by setting check_in_at to the current timestamp.
check_routing_memory_reachability · financing — READ-ONLY measurement: how many financial.routing_memory rows the classifier can actually reach AND APPLY, split by signature scheme (A = this package, exact amount; B = the dfl-financing SPA, banded amount), how many…
check_story_sequence_order · campaigns — Read from Zernio when each part of the sequence was published, and compare the order.
check_studio_export · studio — A machine review of a COMPLETED export (dfl-render /media/export-check): the duration (and the gap to expected_duration_s), the frame size, black-frame ranges, JPEG frames just after each slide starts, at its middle and…
classify · financing — Re-run the classifier on a specific reconciliation_staging row.
classify_bulk · financing — Re-run the classifier over MANY financial.reconciliation_staging rows at once.
close_comms_thread · ops — Close a thread: set work.threads status=closed and closed_at.
comment_spec_run · engineering — Add a review comment to a whole spec run, or to ONE item of it, into the currently OPEN hand-off batch.
comms_ack · ops — Deprecated name. Use ack_comms_message (removed after 2026-12-04).
comms_inbox · ops — Deprecated name. Use get_comms_inbox (removed after 2026-12-04).
comms_list · ops — Deprecated name. Use list_comms_threads (removed after 2026-12-04).
comms_post · ops — Deprecated name. Use post_comms_message (removed after 2026-12-04).
comms_thread_close · ops — Deprecated name. Use close_comms_thread (removed after 2026-12-04).
comms_thread_open · ops — Deprecated name. Use open_comms_thread (removed after 2026-12-04).
comms_wait · ops — Deprecated name. Use wait_comms_thread (removed after 2026-12-04).
copy_sheet · engineering — Duplicate an existing sheet under a new name — the way a TEMPLATE becomes an INSTANCE.
create_account · financing — Create a financial.ledger_accounts row (a chart-of-accounts entry).
create_actor · ops — Create one actor (human, agent, or service) in public.actors.
create_agent · ops — Create a new agent identity for the CALLER.
create_answer · proposals — Add a reusable answer to the library.
create_app · ops — Create a new app.
create_asset_symbol_alias · financing — Add one or more rows to financial.asset_symbol_aliases — the ONE list that BOTH the preview and the SQL write path (financial.publish_batch_atomic) read when a source reports a different SPELLING of an asset the ledger…
create_asset_type · financing — Register a new asset in financial.asset_types — the global lookup that every ledger line, wallet and staging row resolves its currency against.
create_branch · ops — Create a new feature branch on a DevFellowship GitHub repository.
create_business_unit · strategy — Deprecated name. Use create_canvas_business_unit (removed after 2026-12-04).
create_business_unit · work — Create a new business unit.
create_canvas_business_unit · strategy — Create a strategy.business_units row — the root entity every BM Canvas block (value propositions, customer segments, channels, etc.) hangs off of via business_unit_id.
create_canvas_snapshot · strategy — Assemble a business_unit’s full Business Model Canvas (business_unit row + all 9 block tables + active relationships/assumptions) into a strategy.canvas_snapshots row, status=draft.
create_cohort · learn — Create an LMS cohort (batch).
create_composition · studio — Create a composition (lesson-level grouping / “frame”) under a Lesson Studio project.
create_course · learn — Create a new course. Admin only.
create_delegation · ops — Create a new actor delegation, granting a delegatee the ability to act on behalf of a delegator within an optional scope.
create_delivery · work — Create a new delivery.
create_dev_environment · ops — Orchestrates a full agent development workflow: creates a feature branch and provisions a sandbox environment.
create_diagram · engineering — THE way to make a diagram anywhere in DFL.
create_epic · work — Create a new epic. 🔴 AN EPIC CANNOT BE SHOWN ON A PLAN — do not tell anyone you linked one.
create_event · events — Create a new event in a business unit (strategy_business_unit_id is required).
create_event_expense · events — Create a new event expense.
create_event_guest · events — Create a new event guest.
create_event_session · events — Create a new event session.
create_event_task · events — Create a new event task.
create_form · quiz — Create a shareable batch-answer form on the quiz app.
create_image_slide · studio — Create a slide that displays a single image filling the entire slide canvas, using the fullscreen-image template.
create_interview_quiz · quiz — Create a quiz (with per-interview agent_context / guardrails / business_unit_id) and all its questions in one call.
create_journal_entry · financing — Create a DRAFT financial.journal_entries row plus its double-entry lines.
create_journal_entry_template · financing — Create a financial.journal_entry_templates row — an alias of {debit_ledger_account_id, credit_ledger_account_id, optional default_cost_center_id} keyed by a code.
create_lesson · learn — Create a new lesson within a course.
create_member · learn — Create a new community member.
create_member_label_alias · work — Map a raw speaker/label string to a member by upserting into work.member_label_aliases.
create_milestone · learn — Create a milestone under a stage.
create_opportunity · proposals — Register an edital/RFP/public tender/incentive program/award as a structured object (deadlines, value, status).
create_placement · work — Record a DFL fellow placement (job/freelance/internal) in work.placements.
create_plan · plans — Create a new plan (or upsert one by slug) on plans.devfellowship.com.
create_plan_comment · plans — Create a comment on a plan at plans.devfellowship.com — the same annotation the web UI produces with select-to-comment.
create_program · learn — Create an LMS program. Admin only.
create_project · work — Create a new project.
create_project_from_video · studio — Turn one raw take into a new Lesson Studio project in one call: creates the project (portrait by default, no project camera box) with burned-in caption settings, a fullscreen-camera slide per part (default: one slide…
create_quiz · quiz — Create a quiz/interview definition in quiz.quizzes (slug, title, description, welcome_message, and the per-interview agent_context / guardrails / business_unit_id).
create_routing_memory · financing — Record a learned (validated) classification decision in financial.routing_memory — the “a human confirmed that THIS row signature routes to tenant X / template Y” layer that lets the same signature auto-classify next…
create_routing_rule · financing — Create a financial.routing_rules entry — a declarative human classification rule (pattern match → target_tenant_slug + optional ledger_template_code, with a note capturing the human rationale).
create_sheet · engineering — THE way to make a spreadsheet anywhere in DFL.
create_slide · studio — Create a slide under a composition (mirrors the Lesson Studio editor insert shape so it is valid + editable in the UI).
create_slide_comment · studio — Create a review comment anchored to a slide in a Lesson Studio project (Course Canvas comments).
create_slide_element · studio — Create a free-canvas box on a slide: a text box, an image, or a shape drawn on top of the slide’s template.
create_spec_run · engineering — Generate a pack of CANDIDATE tasks from spec prose and store it as a spec run — a first-class, versioned, linkable entity with its own URL.
create_stage · learn — Create a stage (top-level Gantt node) under a program.
create_studio_project · studio — Create a new Lesson Studio project in the lesson_studio schema, plus a “Default” composition.
create_submission · proposals — Open a submission = one company applying to one opportunity (the multi-company anchor).
create_suggested_topic · campaigns — Add one suggested topic to the Curadoria board of /posts/pautas in dfl-campaigns.
create_task · work — Create a new task. Requires a context package (why/what) so the task is readable by whoever was not in the conversation it came from.
create_transaction · payments — Create a new transaction.
create_wallet · financing — Create a financial.wallets row pointing at an EXISTING ledger account (ledger_account_id).
create_wiki_article · learn — Create a dfl-wiki article AS THE CALLER (author_id = you), as a DRAFT by default.

D

decisions_search · ops — Deprecated name. Use search_decisions on plans (removed after 2026-12-04).
delete_agent · ops — GLOBAL ADMIN ONLY. Permanently delete one agent identity, found by metadata.agent_slug.
delete_app · ops — Delete an app by ID.
delete_asset_symbol_alias · financing — Remove one or more rows from financial.asset_symbol_aliases.
delete_bank_balance_snapshot · financing — Hard-delete ONE financial.bank_balance_snapshots row by id (the complement of insert_bank_balance_snapshot / set_wallet_fiat_balance).
delete_business_unit · work — Delete a business unit by ID.
delete_comms_thread · ops — GLOBAL ADMIN ONLY. Permanently delete one agent communication thread: its messages (work.comments with entity_name = “thread” and entity_id = thread_id), then the work.threads row.
delete_composition · studio — Delete a composition. Its slides must be removed or reassigned first (slides.composition_id is NOT NULL).
delete_course · learn — Delete a course. Admin only.
delete_customer_segment · strategy — Hard-delete a strategy.customer_segments row by id.
delete_delivery · work — Delete a delivery.
delete_draft_entries · financing — HARD-delete DRAFT financial.journal_entries (and their journal_entry_lines via ON DELETE CASCADE) that were created in error — used to clean up malformed reconciliation restatement drafts.
delete_epic · work — Delete an epic. This will fail if the epic has associated deliveries or tasks.
delete_keywords · strategy — Hard-delete strategy.keywords rows by id, scoped to one business unit.
delete_lesson · learn — Delete a lesson. Admin only.
delete_media · ops — Delete a media object COMPLETELY — the public.media row AND the underlying S3 object.
delete_member · learn — Soft delete a member by setting is_active to false.
delete_milestone · learn — Delete a milestone. Admin only.
delete_persona · strategy — Hard-delete a strategy.personas row by id.
delete_plan_comment · plans — Delete one plan comment by id.
delete_post · campaigns — Permanently delete a post that YOU created, while it is a draft or rejected — for example a smoke or test post.
delete_program · learn — Delete an LMS program. Admin only.
delete_project · work — Delete a project. This will fail if the project has associated epics.
delete_question · quiz — Deprecated name. Use delete_quiz_question (removed after 2026-12-04).
delete_quiz_question · quiz — Hard-delete a question (and its options) by question_id.
delete_slide · studio — Delete a slide. By default this is a SOFT delete (recoverable via restore_slide; slide_elements/slide_media are kept).
delete_slide_comment · studio — Delete a Course Canvas comment by id.
delete_slide_element · studio — Delete a free-canvas box and repair the slide’s animation in the same call.
delete_spec_run · engineering — PERMANENTLY delete one spec run and everything scoped to it: the run row (work.ai_spec_inputs), its items (work.ai_spec_tasks, via CASCADE), its version snapshots (work.spec_run_versions, via CASCADE) and its…
delete_spec_run_feature_group · engineering — Delete a feature group. REFUSED while any item still points at it.
delete_spec_run_package · engineering — Delete a scope layer. REFUSED while any item still points at it — reassign those items first with assign_spec_run_layers.
delete_stage · learn — Delete a stage. Admin only.
delete_studio_project · studio — Delete a Lesson Studio project.
delete_suggested_topic · campaigns — Permanently delete one suggested topic (“pauta”) from the Curadoria board of /posts/pautas in dfl-campaigns.
delete_task · work — Delete a task.
delete_thread · ops — Deprecated name. Use delete_comms_thread (removed after 2026-12-04).
delete_transaction · payments — Delete a transaction by ID.
delete_ux_map_capture · engineering — PERMANENTLY delete ONE UX map capture — the engineering.ux_map_captures row named by capture_id — through engineering.ux_map_delete_capture.
delete_wallet · financing — HARD-delete financial.wallets rows by an EXPLICIT allowlist of ids (wallet_ids) — NEVER a filter/query-based delete, so a sweep cannot happen by accident.
destroy_sandbox · ops — Destroy an existing sandbox by its slug.
detach_entity · plans — Remove an external entity reference from a plan — deletes the {{dfl-entity:<type>:<locator>}} token(s) from the body, leaving the rest of the plan untouched.
dispatch_interview · quiz — Send a quiz/interview to a list of recipients via the interview engine over WhatsApp (phone) or Discord.
dispatch_post · campaigns — Approving a post already sends it to Zernio — you do not need this after approve_post or after a person approves in the UI.
draft_post_for_review · campaigns — Write one post into the calendar.
draft_story_sequence_for_review · campaigns — Write an ordered Instagram Story sequence: one post per video part, published in index order a few minutes apart.

E

edit_caption_cue · studio — Edit ONE cue of a slide’s caption_cues by its 0-based index: new text and/or startMs/endMs (source clock, ms).
eligibility_check · proposals — Deprecated name. Use check_eligibility (removed after 2026-12-04).
execute_group · financing — Settle a whole financial.reconciliation group (a transfer’s classified send-leg + its matched counterpart legs) as ONE action: post EXACTLY ONE balanced journal entry from the classified (TPL-XFER-*) primary leg’s…
expire_stale_studio_exports · studio — Find Lesson Studio video exports stuck in a non-terminal state (pending/processing) older than N hours and mark them failed with an explanatory error_message, so an abandoned export stops looking like it is still…
export_diagram · engineering — Export any stored diagram to a shareable artifact by id.
export_sheet · engineering — Read a sheet out in a portable format: “csv”, “markdown”, “json” or “xlsx”.

F

find_staging_duplicates · financing — READ-ONLY. Find reconciliation_staging rows that were ingested more than once, and report each group with EVERY copy’s ingestion date so an operator can tell a re-import from a genuine same-day repeat.

G

generate_lesson_from_profile · studio — Author a NEW lesson topic in a specific tutor’s proven pedagogical style.
generate_tasks · engineering — ⚠️ DEPRECATED — prefer create_spec_run followed by promote_spec_run_items.
generate_thumbnail · studio — Render a gold-standard DevFellowship YouTube thumbnail (1280x720) via the youtube_gold layout.
get_account_analytics · campaigns — The last 30 São Paulo days of ONE Zernio account on ONE platform, the same numbers as the Analytics page of dfl-campaigns.
get_actor · ops — Get a single actor by ID.
get_actor_delegations · ops — Get active delegations for an actor.
get_actor_for_user · ops — Resolve an auth user to their actor by looking up actor_links where linked_table is auth.users.
get_adr · plans — Get a single architectural decision record by plan slug + decision number (or id).
get_agent_by_slug · ops — Get an agent definition by its unique slug.
get_app · ops — Get a specific app by ID or slug.
get_batch · financing — Read one financial.reconciliation_batches row: label, status (open|published|reverted), created/reverted provenance, its journal entries (id/date/status/posted_at/voided_at), and the stored projected_snapshot /…
get_business_unit · strategy — Deprecated name. Use get_canvas_business_unit (removed after 2026-12-04).
get_business_unit · work — Get a specific business unit by ID.
get_business_unit_voice · campaigns — READ the brand VOICE of a business unit before you write any post copy — the writing patterns that say how that BU sounds.
get_camera · studio — Read the camera box + visibility for a project (project_id) and optionally one of its slides (slide_id).
get_canvas_business_unit · strategy — Fetch one strategy.business_units row (the canvas record of a business unit) by id.
get_comms_inbox · ops — List the threads where you are a member and that have messages after your read cursor (work.thread_members.last_read_seq), with unread and unread_mentions counts.
get_company · proposals — Get one company by id, optionally with its fiscal-year history (revenue/headcount) and contacts (accountant/legal/admin/partner).
get_course · learn — Get a specific course by ID, including lesson count.
get_current_user · ops — Returns the profile and member data for the currently authenticated user.
get_delivery · work — Get a specific delivery by ID with its epic and tasks.
get_diagram · engineering — Get one diagram by id, including its full nodes/edges in the normalised @xyflow/react shape (the same shape whether it was created from mermaid_text or from explicit nodes).
get_diagram_version · engineering — Get one specific revision of a diagram from public.diagram_versions, including its full nodes/edges — this is what makes a prior state actually recoverable, as opposed to list_diagram_versions which only returns counts.
get_epic · work — Get a specific epic by ID with its deliveries and tasks.
get_event · events — Get a specific event by ID, including strategy_business_unit_id (its business unit in strategy.business_units).
get_event_guest · events — Get a specific event guest by ID.
get_event_photo · events — Get a specific event photo by ID, including its tagged member_ids[].
get_export_check · studio — Read an export check that check_studio_export started (the same answer when it is done).
get_form · quiz — Get a form by id or slug: metadata + its items (questions and decoded external_ref).
get_form_responses · quiz — Read submitted batch answers for a form (by id or slug), mapped back to each item via external_ref.
get_handoff_document · engineering — Read documents.document rows.
get_interview_status · quiz — Track one interview: the dispatch row (status, timestamps), its session, and answers collected so far.
get_journal_entry · financing — Fetch a single financial.journal_entries row plus its journal_entry_lines (the double-entry debit/credit lines).
get_lesson · learn — Get a specific lesson by ID.
get_media_import · studio — Read an import_media_from_url job.
get_media_transcription · studio — Read a transcription job that transcribe_media started: its status while it runs, else the text, cues and translation.
get_member · learn — Get a specific member by their ID.
get_my_course_progress · learn — Get the authenticated user’s progress for a specific course.
get_my_lesson_progress · learn — Get the authenticated user’s progress for one or more lessons.
get_my_roles · ops — Returns the current user’s global IAM role row (role_id, role_level) and effective global level (level = iam.get_global_level(), which includes delegation: an agent user inherits its delegator’s level, capped at 80).
get_payment · payments — Get a single payment (invoice) by id, including its line items and the full transition-timestamp history (submitted/reviewed/approved/rejected/paid).
get_plan · plans — Read a plan’s full markdown body plus metadata (status, version, ADR count, parent, tags, visibility/owner) by slug.
get_post · campaigns — One post with its channels, its lifecycle state and its approval trail — who approved it and when, and whether it was already dispatched to Zernio.
get_post_metric_history · campaigns — Return stored daily absolute counters for one campaigns post.
get_profile · learn — Get a specific user profile by ID.
get_program · learn — Read ONE LMS program by id (or slug) together with its full tree: stages (ordered by position) each with their milestones (ordered by position), plus the program’s stage_dependencies edges.
get_program_member_progress · learn — Read the lms.program_member_progress VIEW — computed per-(member, cohort) progress through the cohort’s instance program (total milestones, done milestones, percentage, last completion).
get_project · work — Get a specific project by ID with its epics.
get_question · plans — Fetch ONE plan question by its UUID — no slug needed.
get_quiz · quiz — Get a quiz by id or slug, including its ordered questions and each question’s options.
get_sandbox_status · ops — Get the status of a sandbox by its slug, including container health and port information.
get_sheet · engineering — Read one sheet by id: the header plus every tab, each with its full columns and rows.
get_sheet_version · engineering — Read ONE stored snapshot of a sheet back, by sheet_id + version_number.
get_skill · skills — Fetch one skill by id (‘owner/repo/slug’, e.g. ‘devfellowship/skills/dfl-stack’).
get_slide_recording · studio — Read a slide’s recording: source URL, trim window, transcode_status (export needs ‘done’; ‘processing’ still runs) and captions.
get_spec_run · engineering — Read a spec run: its items with points, short_ref anchors, review status and point provenance, its points_total, both version counters, and the OPEN comment batch.
get_story_sequence · campaigns — One Story sequence with every part in index order: status, scheduled_for, updated_at, the approval trail and the Zernio id, and the user tags (sequence.user_tags and parts[].user_tags; absent when the dfl-schema column…
get_story_split · studio — Read a Story split job that split_export_for_stories started.
get_studio_export · studio — Read one export and, while it is still rendering, ask the render service where it is and write the answer back to the row.
get_submission_checklist · proposals — Assemble the full compliance + drafting state of a submission: every opportunity requirement with the documents attached to satisfy it (submission_documents), plus each submission section and its status.
get_task · work — Get a specific task by ID with its epic and delivery.
get_task_branch_name · ops — Deprecated name. Use get_task_branch_name on work (removed after 2026-12-04).
get_task_branch_name · work — Returns the suggested Git branch name for a task based on its identifier and name.
get_template · studio — Fetch all source files (HTML landscape, HTML portrait, CSS landscape, CSS portrait, config YAML) for a specific template.
get_theme · studio — Fetch the CSS source for a specific theme.
get_transaction · payments — Get a specific transaction by ID.
get_user_role · ops — Read another user’s GLOBAL IAM role (role_id + numeric level) via public.iam_get_user_global_role.
get_verification_report · ops — Retrieve a previously-run verification result for a sandbox.
get_version_comments · studio — Get all comments for a project version as a clipboard-ready text block, one comment per line prefixed with project/composition/slide references.
get_weekly_updates · work — Read-only. What one member did in the last N days (Brasília calendar days, today included): tasks moved to done/dev_completed, tasks in progress, merged PRs (review_request.review_requests), Core Daily lines they said…
get_wiki_article · learn — One dfl-wiki article by id or slug, with its markdown body and its content type.

H

handoff_spec_run_comments · engineering — Take the OPEN batch of review comments on a spec run, format it as a ready-to-paste agent prompt with a short_ref anchor per item, mark the batch as sent (handed_off_at) and BUMP THE COMMENT VERSION.
harvest_answers · proposals — The loop that compounds: promote reusable text written in a past submission back into the answer library.

I

ignore_onchain_tokens · financing — Add tokens to financial.onchain_token_ignores, the per-tenant denylist that keeps spam airdrops and dust out of the RED “sem atribuição” panel on /reconciliation/preview.
import_media_from_url · studio — Import a clip from a public video URL (e.g. a YouTube/X post) through dfl-render: download, optional [start_s, end_s) cut, optional portrait fit, transcription and translation.
import_sheet · engineering — Turn a csv, a tsv, a markdown table or an .xlsx workbook you already have into a real DFL sheet.
index_ux_map_capture · engineering — Record a UX map capture — an app, a role, and the screens observed for that role — in engineering.ux_map_apps, engineering.ux_map_captures and engineering.ux_map_screens.
ingest_bb · financing — Ingest a Banco do Brasil PJ (BBPJ) checking-account statement (CSV export) into financial.reconciliation_staging.
ingest_binance · financing — Ingest a Binance “Transaction History” account-ledger CSV export (header: User ID,Time,Account,Operation,Coin,Change,Remark) into financial.reconciliation_staging as source_type=binance, status=pending_review.
ingest_c6 · financing — Ingest a C6 Bank PF checking-account statement into financial.reconciliation_staging with source_type=bank_statement, source_bank_name=‘C6 Bank’.
ingest_hyperliquid_fills · financing — Land Hyperliquid TRADE FILLS in financial.reconciliation_staging as source_type=onchain, status=pending_review, so on-chain activity reaches the review queue without anyone remembering to ask.
ingest_hyperliquid_transfers · financing — Land Hyperliquid DEPOSITS, WITHDRAWALS and TRANSFERS in financial.reconciliation_staging as source_type=onchain, status=pending_review — the sibling of ingest_hyperliquid_fills, which reads userFillsByTime and therefore…
ingest_nubank · financing — Ingest a Nubank PF or PJ statement (CSV format) into financial.reconciliation_staging.
ingest_onchain · financing — Ingest an on-chain transaction history CSV (Etherscan / BSCScan / Snowtrace / Arbiscan) into financial.reconciliation_staging with source_type=onchain.
ingest_onchain_alchemy · financing — AUTOMATIC on-chain ingest: pulls wallet transfers from Alchemy (alchemy_getAssetTransfers) into financial.reconciliation_staging with source_type=onchain and status=pending_review.
ingest_uuv · financing — Ingest a UUV / Binance “Deposit & Withdrawal” or “Trade History” CSV export into financial.reconciliation_staging with source_type=binance.
ingest_wise · financing — Ingest a Wise balance statement (CSV export) into financial.reconciliation_staging, and record what period was read into financial.bank_statements.
ingest_woovi · financing — Ingest a Woovi Pix-account CSV export (Revera/DFL-PJ payment account) into financial.reconciliation_staging with source_type=bank_statement, source_bank_name=‘Woovi’.
insert_bank_balance_snapshot · financing — Manually persist ONE bank or brokerage balance into financial.bank_balance_snapshots (Phase 6 of the reconciliation Preview — the Current-balances panel reads this table).
install_pack · skills — Fetch a DFL skill pack — a root skill plus the skills it routes to — and return every file of every member, each with its target path and verified sha256, plus the commit each member was delivered at.
install_skill · skills — Fetch a DFL skill and return the exact files to write, so the host agent can install it without cloning the registry or having GitHub access.
instantiate_program · learn — Deep-copy a TEMPLATE program tree (program -> stages -> milestones -> stage_dependencies) into a new per-cohort INSTANCE program, and return the new instance program id.

L

link_actor · ops — Link an actor to any row in public.actor_links.
link_artifact_source · strategy — Create a strategy.artifact_sources row linking any strategy artifact row (by table name + id, e.g. artifact_table: “assumptions”) to a strategy.sources row created via add_source.
link_company_doc · proposals — The definitive large-file path: record a proposals.company_documents vault row that points at a file ALREADY uploaded to the private bucket — NO file bytes travel through the MCP body, so there is no size limit.
link_epic_to_plan · engineering — Bind a work.epics epic to a plan, so the plan shows which epic carries its work and the dfl-learn epics panel can find the plan from the epic.
link_staging_legs · financing — Record that one or more financial.reconciliation_staging rows are the COUNTERPART LEG of a money movement ALREADY booked by a posted journal entry — the second statement’s view of a transfer between two accounts we own.
list_accounts · financing — List financial.ledger_accounts (the chart of accounts) for a tenant.
list_actors · ops — List all actors (humans, agents, services), optionally filtered by type.
list_adrs · plans — List architectural decision records (ADRs).
list_agent_definitions · ops — List all agent definitions, optionally filtered by status.
list_animation_presets · studio — The slide animation presets set_slide_animation can apply, with the template_data slots each one reads.
list_answers · quiz — List the answers (per-question transcript) for a session.
list_apps · ops — List all apps with optional filters.
list_asset_symbol_aliases · financing — Show every row of financial.asset_symbol_aliases, resolved to the asset it means: the alias spelling, the canonical symbol and name, the asset_type_id, the recorded reason, and when the row was created and last updated.
list_batches · financing — List financial.reconciliation_batches rows (newest first), optionally filtered by tenant and status (open|published|reverted).
list_business_units · strategy — Deprecated name. Use list_canvas_business_units (removed after 2026-12-04).
list_business_units · work — List all business units with optional filters.
list_campaign_accounts · campaigns — List each platform and Zernio account combination that has stored post metric snapshots.
list_canvas_business_units · strategy — List strategy.business_units rows — the Business Model Canvas record of a business unit.
list_cohorts · learn — List LMS cohorts (batches, e.g. “Winter 2025”, “Summer 2026”) with optional filters.
list_comms_threads · ops — Read the messages of a thread with thread_seq > after_seq, in thread_seq order (at most 100).
list_companies · proposals — List the companies that can apply to an opportunity — own entities (Revera/Itera/devfellowship) and external partners (e.g. B42).
list_compositions · studio — List the compositions of a Lesson Studio project, ordered by order_index.
list_core_daily_topics · campaigns — What each person said in the last N days, merged per person from the Discord channel #core-daily-updates (primary) and the Core Daily meeting transcripts (when there was one).
list_courses · learn — List all courses with optional filters.
list_customer_segments · strategy — List strategy.customer_segments rows for a business_unit_id.
list_deliveries · work — List all deliveries with optional filters.
list_diagram_versions · engineering — List the revision history of a diagram from public.diagram_versions, ordered by version_number DESC (newest first).
list_diagrams · engineering — Find an EXISTING diagram and, above all, its uuid — the id you need to reference it from a plan or a document (plans MCP attach_entity, or the {{dfl-diagram:<uuid>}} token).
list_discord_channels · plans — List the Discord channels the DevFellowship bot can see, grouped by category — the ONLY valid source of a channel_id for set_plan_discord_channel.
list_dispatches · quiz — List interview dispatch rows (who received which quiz, channel, status, timestamps).
list_entity_connections · engineering — Read the plan-to-entity links in work.entity_connections — the join that binds a plan to its tasks, epics, diagrams, documents, images, ux_paths and spec runs.
list_epics · work — List all epics with optional filters.
list_event_expenses · events — List expenses for an event with optional filters.
list_event_guests · events — List guests for an event with optional filters.
list_event_photos · events — List photos for an event.
list_event_sessions · events — List sessions for an event with optional filters.
list_event_tasks · events — List tasks for an event with optional filters.
list_events · events — List all events with optional filters.
list_expiring_documents · proposals — The certificate-renewal radar: vault documents whose valid_until falls within within_days from today (already-expired included).
list_forms · quiz — List forms (newest first).
list_global_questions · plans — List OPEN (pending, non-snoozed) questions across ALL readable plans — the cross-plan question inbox.
list_iam_roles · ops — List the DFL global IAM role ladder (role id + numeric level + context) from iam.roles, so you can see the rungs before choosing one with assign_user_role.
list_journal_entries · financing — List financial.journal_entries (headers only) for a tenant, newest first.
list_keywords · strategy — List strategy.keywords rows (the SEO keyword corpus) of one business unit, ordered by text.
list_lessons · learn — List lessons for a specific course.
list_meeting_series · work — READ-ONLY discovery of recurring meeting SERIES PARENTS in work.meetings (is_recurring = true), so an operator can find duplicate/dedup targets without psql.
list_members · learn — List all members with optional filters.
list_milestones · learn — List the milestones under a stage, ordered by position.
list_onchain_addresses · financing — List financial.onchain_address_book — every wallet address that is read on chain at all.
list_onchain_token_ignores · financing — Show every entry in financial.onchain_token_ignores for your tenant, each with the number of currently unattributed rows it hides, their USD total, and how many of them carry no price.
list_opportunities · proposals — List editais/RFPs/public tenders/incentive programs/awards already registered in the pipeline.
list_payments · payments — List fellow payments (invoices) by state, with amount, recipient, and ids.
list_personas · strategy — List strategy.personas rows.
list_plan_comments · plans — List the comments on a plan (the select-to-comment annotations from the web UI, plus any written by a bot).
list_plan_entities · plans — List the external entities (diagrams / documents / images) a plan references — the {{dfl-entity:…}} tokens embedded in its body, with each one’s type, locator, mode (live/pinned) and caption.
list_plan_tasks · plans — List the DevFellowship work tasks bound to a plan — the plan’s EXECUTION CHECKLIST, the read half of set_plan_tasks.
list_plans · plans — List plans with optional filters (status, source, tag, has_children, has_pending_questions).
list_plans_by_activity · plans — List the plans with ACTIVITY in a day window — the same rule as the calendar Day board (plans.devfellowship.com/calendar?view=day).
list_post_business_units · campaigns — The business units the post calendar can schedule for — strategy.business_units, archived ones excluded.
list_posts · campaigns — Read the post calendar, ordered by scheduled_for.
list_profile_fellow_slugs · learn — List every user that has a public.profiles.fellow_slug (the Thumbify fellows/<slug> folder mapping): user_id, name, fellow_slug, ordered by slug.
list_profile_fellow_slugs · ops — Deprecated name. Use list_profile_fellow_slugs on learn (removed after 2026-12-04).
list_profiles · learn — List user profiles with optional filters.
list_programs · learn — List LMS programs (curriculum trees rendered by the Gantt).
list_project_versions · studio — List the versions of a Lesson Studio project, ordered by version_number descending (current/highest first).
list_projects · work — List all projects with optional filters.
list_questions · plans — List structured questions (blocking + non-blocking) with their options and current answers.
list_quizzes · quiz — List quiz/interview definitions from quiz.quizzes.
list_responses · quiz — List response (session) rows for a quiz — one per interview session, with completion status.
list_routing_memory · financing — List financial.routing_memory rows — the learned/validated classification decisions (row_signature → validated tenant + template, with hit_count reuse stats).
list_routing_rules · financing — List financial.routing_rules for a tenant — the declarative human classification rules (pattern → target tenant + ledger account) the reconciliation classifier consults.
list_settled_memory_disagreements · financing — READ-ONLY report (no write path of any kind, not a dry-run flag): every already-settled financial.reconciliation_staging row carrying a financial.routing_memory decision that DISAGREES with what the row was actually…
list_sheet_versions · engineering — List the snapshot history of one sheet from work.sheet_versions, ordered by version_number DESC — NEWEST FIRST.
list_sheets · engineering — Find an EXISTING sheet and, above all, its uuid — the id you need to reference it from a plan (plans MCP attach_entity, or the {{dfl-entity:sheet:<uuid>}} token), to read it with get_sheet, or to write it.
list_skills · skills — List the skills, MCP servers and connections the caller can see in the DFL Forge registry (skills.sh-compatible).
list_slide_beats · studio — List the beats of a slide’s template_data.animation, each tagged with the beat_index add_slide_beat/update_slide_beat/remove_slide_beat address.
list_slide_comments · studio — List Course Canvas comments of a project (newest first), optionally filtered by version and/or resolved state.
list_slide_elements · studio — List a slide’s free-canvas boxes (text/image/shape), ordered by creation time.
list_slides · studio — List the slides of a composition, ordered by order_index.
list_social_accounts · campaigns — List campaigns.social_accounts: each Zernio account with its business unit (name, logo) and its owner (name, avatar).
list_solana_transactions · financing — READ-ONLY. Enumerate every asset movement of one Solana address over a time or slot window, from the chain itself.
list_sound_effects · studio — The sound-effect catalog available to template_data.sfx / set_slide_sfx: every valid sound key, its category, use-case hint and duration.
list_spec_run_feature_groups · engineering — List the feature groups of a spec run with their item count and point total, PLUS the items that are outside every group.
list_spec_run_packages · engineering — List the scope layers (the “onion”) of a spec run, each with its item count, point total, and — the number that actually sells — what that layer ADDS over the previous one.
list_spec_runs · engineering — Find spec runs and get the run_id every other spec-run tool needs.
list_stage_dependencies · learn — List the sequence/dependency edges (predecessor -> successor) of a program.
list_stages · learn — List the stages (top-level Gantt nodes) of a program, ordered by position.
list_staging · financing — List financial.reconciliation_staging rows for a tenant.
list_stale_answers · proposals — The library review queue: answers explicitly marked status=“stale” PLUS answers whose expires_at falls within within_days from now (already-expired included).
list_studio_exports · studio — List the rendered video exports (MP4) of the caller’s Lesson Studio projects, newest first.
list_studio_projects · studio — List Lesson Studio projects owned by the caller (RLS-scoped), most recently updated first.
list_suggested_topics · campaigns — Read the suggested topics on the Curadoria board of /posts/pautas in dfl-campaigns.
list_tasks · work — List all tasks with optional filters.
list_templates · studio — List all slide templates available in dfl-slide-templates (reads registry.json from GitHub).
list_themes · studio — List the CSS themes that actually exist in dfl-slide-templates at the pinned revision.
list_transactions · payments — List all transactions with optional filters.
list_ux_map_annotations · engineering — Read design notes pinned to regions of captured screens.
list_ux_paths_app_images · engineering — Every screenshot of the MOST RECENT build of one application, from the UX-map index (dfl-ux-paths / “XPaths”).
list_wallet_reality_feed · financing — Read financial.v_wallet_reality_feed — one row per wallet, answering “does this wallet have anything to check itself against?”.
list_wiki_articles · learn — List dfl-wiki articles (wiki.devfellowship.com), newest update first, without the body.
list_writing_patterns · strategy — List strategy.writing_patterns rows for a business_unit.
list_zernio_accounts · campaigns — The social accounts connected in Zernio, each with the id a channel needs to actually publish.
list_zernio_profiles · campaigns — Who publishes where: each Zernio profile (a person or the company) with its connected accounts per network, plus the accounts that belong to no profile.
lookup_member · learn — Resolve a fellow’s name to their public.members.id (e.g. the id used as work.placements.member_id).

M

mark_lesson_complete · learn — Mark a lesson as completed by the authenticated user.
mark_lesson_viewed · learn — Mark a lesson as viewed by the authenticated user.
merge_actors · ops — GLOBAL ADMIN ONLY. Fold one actor (the source) into another (the target) when both are the same principal, then delete the source.
merge_meetings · work — Dedup a duplicate recurring-meeting cluster by MERGING a skeleton meeting into a canonical meeting, then removing the skeleton.
move_suggested_topic · campaigns — Move one suggested topic (“pauta”) to a column of the Curadoria board of /posts/pautas in dfl-campaigns and, optionally, to a place inside it.

O

open_comms_thread · ops — Open a new agent communication thread and return its id.

P

patch_status · plans — Transition a plan’s lifecycle status: draft -> fired -> executing -> done (or archived).
plans_set_visibility · ops — Deprecated name. Use set_plan_visibility on plans (removed after 2026-12-04).
plans_set_visibility_batch · ops — Deprecated name. Use set_plan_visibility_batch on plans (removed after 2026-12-04).
post_comms_message · ops — Append one message to a thread (a work.comments row with entity_name=thread) and return its thread_seq.
post_from_staging · financing — Promote an APPROVED financial.reconciliation_staging row into the canonical double-entry ledger and stamp the row executed.
post_journal_entry · financing — Confirm a DRAFT financial.journal_entries row → status=posted (sets posted_at).
post_question · plans — Create a structured question on a plan (DTQ — drift/decision to question).
promote_occurrence_to_standalone · work — Promote ONE work.meeting_occurrences row to a standalone (“avulsa”) work.meetings row and then detach/delete the occurrence.
promote_spec_run_items · engineering — Turn APPROVED spec-run items into real work.tasks rows — the only tool here that writes the real backlog, and the only irreversible one (there is no task-delete tool in the DFL MCP fleet, by policy).
provision_sandbox · ops — Provision a new sandbox environment for a branch via the sandbox-manager API.
publish_batch · financing — Publish an EXPLICIT list of APPROVED financial.reconciliation_staging rows as ONE reversible batch: creates a financial.reconciliation_batches row, posts one journal entry per staging_id (stamped with the batch id via…
publish_plan · plans — Publish (or re-publish) a plan body, creating a new version.
publish_wiki_article · learn — Set the status of a dfl-wiki article: published (default — anonymous readers can see it), draft (signed-in users only) or archived.

R

rank_account_posts · campaigns — Rank one Zernio account’s campaigns posts.
read_plan · plans — Deprecated name. Use get_plan (removed after 2026-12-04).
read_solana_transactions · financing — Deprecated name. Use list_solana_transactions (removed after 2026-12-04).
reconcile_match · financing — Link the legs of ONE money-movement across on-chain → Binance → bank into a reconciliation_group, by ordered passes: (1) TXID exact onchain.tx_hash ↔ binance deposit txid; (2) fuzzy amount±tolerance + date-window +…
record_onchain_balance_snapshots · financing — Record 1 to 25 precise on-chain balance observations in financial.onchain_balance_snapshots.
redate_journal_entries · financing — Move the entry_date of individually named financial.journal_entries — and NOTHING else.
redate_snapshot_observations · financing — Repair financial.onchain_balance_snapshots rows whose recorded observation date (snapshot_at) disagrees with when the balance was actually read (fetched_at).
regenerate_spec_run · engineering — TWO PATHS, chosen by whether you pass operations.
register_export_as_media · studio — Make a completed Lesson Studio export (MP4) usable by the post calendar: creates a public.media row pointing at the exported file and returns the media_id plus the stable media.devfellowship.com/<id> link.
register_onchain_address · financing — Register a public wallet address in financial.onchain_address_book — the book that decides which wallets are read on chain at all.
reject_post · campaigns — Move a post that YOU created from awaiting_review to rejected — for example a smoke or test post, or a post the person told you to drop.
reject_staging · financing — Move specific financial.reconciliation_staging rows to the TERMINAL status=rejected state with a reviewer_notes audit stamp — the canonical terminal for a row that must never be posted (e.g. a confirmed phishing /…
remove_meeting_series · work — Remove ONE recurring meeting SERIES PARENT from work.meetings, promoting its occurrences to standalone (“avulsa”) meetings FIRST so the ON DELETE CASCADE can never destroy a transcript.
remove_slide_beat · studio — Remove one beat from a slide’s template_data.animation.beats, addressed by beat_index (from list_slide_beats).
remove_stage_dependency · learn — Remove a dependency edge.
render_composition_images · studio — Render every surviving slide of a composition to a PNG and return the URLs in order_index order — the batch form of render_slide_image, and the tool a carousel needs.
render_slide_image · studio — Render one stored slide to a PNG and return its URL.
replace_sheet_tab · engineering — Replace the ENTIRE contents of one tab — its columns and all of its rows — in a single atomic write.
reset_unposted_staging · financing — Return financial.reconciliation_staging rows that claim status=executed but NEVER reached the ledger back to status=pending_review (the active review queue), and CLEAR the broken journal_entry_id + executed_at.
resolve_discord_id · events — Preview how a recipient resolves to a Discord id for channel=discord dispatch, via precedence: event_guests.discord_id override > member→profile (profiles.discord_user_id) > none.
resolve_ux_map_annotation · engineering — Move an annotation between “open” and “addressed”, and/or record the request pull request it produced.
restore_slide · studio — Restore a soft-deleted slide (clears deleted_at/deleted_by so it reappears in list_slides).
retry_story_sequence · campaigns — Use it only after approve_story_sequence (or a later retry) stopped at a part that Zernio rejected or refused.
reverse_batch · financing — Undo a published reconciliation batch by VOID + RESET (NOT reversing-entries): voids every posted journal entry stamped with the batch id (existing void mechanism → voided_at + void_reason) and resets each linked…
revise_post_in_review · campaigns — Rewrite a post that is still in the queue — typically after a reviewer left review_notes, or when a rejected post is being redone.
revoke_agent · ops — Revoke an agent that the CALLER delegated to.
revoke_delegation · ops — Revoke an active actor delegation by setting its revoked_at timestamp to now.
revoke_media · ops — Revoke a media capability link — the counterpart to upload_file.
revoke_user_role · ops — Revoke a user’s GLOBAL IAM role via public.iam_delete_user_role — deletes their single iam.user_roles row, dropping iam.get_global_level() to 0 and closing every RLS gate above it (iam.is_member() included).
routing_memory_reachability · financing — Deprecated name. Use check_routing_memory_reachability (removed after 2026-12-04).

S

score_spec_run_items · engineering — Price one or more spec-run items with the points_v2 decision table, and record the provenance of every number it produces.
search_answers · proposals — Search the reusable answer library by free text (question_canonical / short_answer / long_answer_md) and/or facet tags.
search_decisions · plans — Semantic search over architectural decision records (ADRs) using pgvector cosine similarity.
search_entities · plans — Find a diagram, document, image or spec run across the DFL fleet and get its LOCATOR — the UUID (diagram / document / spec_run) or media id/URL (image) that attach_entity requires.
search_opportunities · proposals — Text search over opportunities by title, notice_number (número do edital), or funder name — the dedup entry point before create_opportunity (find it first, don’t create it blind).
search_plans · plans — Hybrid semantic + keyword search over plans (and optionally ADRs) on plans.devfellowship.com.
search_skills · skills — Search the DFL Forge registry for skills, MCP servers, connections and packs by query.
search_slide_images · studio — Search the stock photo library for an image to put on a slide, and get back candidate URLs.
search_templates · studio — Find the best slide templates for an intent.
seed_template · engineering — Create or update a documents.template + its documents.template_variable rows, without a dfl-schema migration.
set_answer_status · proposals — Transition an answer through its governance lifecycle: draft → approved → stale → retired.
set_canvas_block · strategy — Upsert a row into one of the 9 Business Model Canvas block tables for a business_unit: value_proposition, customer_segment, customer_relationship, channel, revenue_stream, key_partner, key_activity, key_resource…
set_course_tutor · learn — Set the tutor (the person who taught the course, on camera) for a course by writing lms.courses.tutor_id (FK -> work.members.id).
set_cover_slide · studio — Mark a slide as the deck’s cover (template_data.is_cover), or unmark it (is_cover: false).
set_links · plans — Replace a plan’s external links list — the FIRST-CLASS sidebar links (Miro / Figma / GitHub / Epic / docs / any URL) rendered in the plans-app sidebar, SEPARATE from the URLs inside the markdown body.
set_media_visibility · ops — Move one or many media objects between the three access tiers, without changing their ids or breaking published links.
set_meeting_recurrence_time · work — Set the time-of-day window (recurrence_start_time / recurrence_end_time) on a single recurring meeting series in work.meetings, so its recurring occurrences render at the right hour on the /meetings time-grid.
set_meeting_template · work — Set the UI template (work.meetings.template) on a single meeting in work.meetings.
set_owner · plans — Reassign the owner column of plans to a canonical Supabase auth uid.
set_plan_discord_channel · plans — Bind a plan to ONE Discord channel so that EVERY COMMENT posted on that plan is announced in that channel (author + excerpt + link), or unbind it with channel_id: null.
set_plan_tasks · plans — Bind DevFellowship work tasks (work.tasks) to a plan — the plan’s EXECUTION CHECKLIST, rendered in the plans-app right sidebar with each task’s LIVE status and a done/total progress counter.
set_plan_visibility · plans — Set a single plan’s visibility to personal or shared.
set_plan_visibility_batch · plans — Set the visibility (personal or shared) of MANY plans in one call.
set_post_content_tag · campaigns — Write media_group + archetype on ONE post, in any status — published posts included.
set_post_keywords · campaigns — Replace the SEO keywords linked to a post, in any status — including posts already dispatched, so older content can be mapped to keywords.
set_profile_fellow_slug · learn — Set or clear public.profiles.fellow_slug of ONE user: the Thumbify fellows/<slug> folder that belongs to that user.
set_profile_fellow_slug · ops — Deprecated name. Use set_profile_fellow_slug on learn (removed after 2026-12-04).
set_project_camera · studio — Set the project-wide camera default: aspect (16:9 or 1:1), box (preset size+corner or custom fractions), and default visibility (off/overlay).
set_project_glossary · studio — Set a Lesson Studio project’s caption glossary: the canonical spellings (names, tickers — ‘Bessent’, ‘USDC’) that the server transcription applies to the captions (a whole-word near match becomes the term; timings never…
set_slide_animation · studio — Animate a slide with one of the presets from list_animation_presets.
set_slide_camera · studio — Override this slide’s camera box and/or visibility, on top of the project default set_project_camera sets.
set_slide_captions · studio — Replace a slide’s caption cues (template_data.caption_cues).
set_slide_insert · studio — Make a slide an INSERT slide: an inserted video on its own slide (the video cuts from the camera to the clip, then back).
set_slide_layout · studio — Apply a camera/content layout preset to one slide.
set_slide_sfx · studio — Write this slide’s sound effects (template_data.sfx).
set_social_account_mapping · campaigns — Create or update the campaigns.social_accounts row of one Zernio account (idempotent UPSERT on zernio_account_id).
set_spec_run_points_provenance · engineering — Record HOW the estimated_points of one or more spec-run items were produced — write points_source, engine_version and rule_id on work.ai_spec_tasks.
set_wallet_fiat_balance · financing — Record the REAL (bank-statement) balance for a financial.wallets wallet, so the Reconciliation Preview can compare PROJECTED (ledger-derived) vs REAL per wallet (plan 20260625-financial-wallet-projected-balance).
settled_memory_disagreements · financing — Deprecated name. Use list_settled_memory_disagreements (removed after 2026-12-04).
snapshot_account_drift · financing — Compute computed-vs-real balance drift for every active wallet and persist it as one financial.reconciliation_runs row per tenant plus its financial.reconciliation_diffs rows.
snapshot_diagram_version · engineering — Save the CURRENT nodes/edges of a diagram as a new row in public.diagram_versions, so this state is recoverable later via get_diagram_version.
snapshot_sheet_version · engineering — Save the CURRENT state of a sheet — the header plus EVERY tab, with all their columns and rows — as a new row in work.sheet_versions, so this state stays recoverable through get_sheet_version.
split_export_for_stories · studio — Cut a completed export (MP4) into ordered Story parts of at most 60 s each, and register each part as media.
split_recording_across_slides · studio — Spread ONE raw take over several slides.
staging_routing_audit · financing — Deprecated name. Use audit_staging_routing (removed after 2026-12-04).
start_composition_export · studio — Render a whole composition into an MP4, server-side.
submission_checklist · proposals — Deprecated name. Use get_submission_checklist (removed after 2026-12-04).
suppress_staging · financing — Audit-preserving SOFT-suppress of specific financial.reconciliation_staging rows: stamps source_raw.suppressed=true (+ optional suppressed_reason + suppressed_at) so the rows are HIDDEN from list_staging / the…

T

transcribe_media · studio — Transcribe a video/audio (URL or media_id) with dfl-render, optionally translated.

U

un_ignore_onchain_tokens · financing — Deprecated name. Use unignore_onchain_tokens (removed after 2026-12-04).
un_suppress_staging · financing — Deprecated name. Use unsuppress_staging (removed after 2026-12-04).
unarchive_form · quiz — Restore a soft-archived form (sets is_active=true) by id or slug.
unignore_onchain_tokens · financing — Remove tokens from financial.onchain_token_ignores so they appear again in the RED “sem atribuição” panel.
unreject_staging · financing — Reverse a prior reject_staging: move specific financial.reconciliation_staging rows from the TERMINAL status=rejected state BACK to status=pending_review (the active review queue), with a reviewer_notes audit stamp.
unschedule_post · campaigns — Stop a post that Zernio is holding from publishing: the server cancels it in Zernio FIRST and only then rewrites the row, which comes back as awaiting_review with the approval trail cleared.
unsuppress_staging · financing — Reverse a prior suppress_staging: restore a suppressed financing staging row back to pending_review (active).
update_account · financing — Update the mutable fields of a financial.ledger_accounts row (a chart-of-accounts entry) — toggle is_active (activate/deactivate, e.g. retire a wrong FX account without deleting its history), rename it, or set/clear its…
update_actor · ops — GLOBAL ADMIN ONLY. Edit one actor in place, by id: its type (human, agent, service), its display_name, its metadata.agent_slug, and a shallow metadata patch (a key set to null is removed).
update_answer · proposals — Edit an answer in the library.
update_app · ops — Update an existing app.
update_business_unit · strategy — Deprecated name. Use update_canvas_business_unit (removed after 2026-12-04).
update_business_unit · work — Update an existing business unit.
update_canvas_business_unit · strategy — Partially update a strategy.business_units row (the canvas record of a business unit) by id.
update_cohort · learn — Update an LMS cohort. Admin only — RLS rejects writes from non-global-admins.
update_composition · studio — Update a composition title and/or order_index.
update_course · learn — Update an existing course.
update_customer_segment · strategy — Partially update a strategy.customer_segments row by id.
update_delivery · work — Update an existing delivery.
update_diagram · engineering — Update an existing diagram in public.diagrams by id — the right way to change a diagram that a plan or a document already references.
update_epic · work — Update an existing epic.
update_event · events — Update an existing event.
update_event_expense · events — Update an existing event expense.
update_event_guest · events — Update an existing event guest.
update_event_photo · events — Update an event photo. Updates caption/sort_order and, when member_ids is provided, re-syncs event_photo_members to exactly that set.
update_event_session · events — Update an existing event session.
update_event_task · events — Update an existing event task.
update_journal_entry_template · financing — Repoint an EXISTING financial.journal_entry_templates row, keyed by (tenant_id, code).
update_keyword_metrics · strategy — Set columns on existing strategy.keyword_metrics snapshots of one business unit: relabel the typed source (channel, provider, collection_method, source_id, market, language, raw) or set a metric (search_volume, score…
update_lesson · learn — Update an existing lesson.
update_member · learn — Update an existing community member.
update_milestone · learn — Update a milestone. Admin only.
update_persona · strategy — Partially update a strategy.personas row by id.
update_profile · learn — Update your own profile. Only the authenticated user can update their profile.
update_program · learn — Update an LMS program’s name, slug, or status.
update_project · work — Update an existing project.
update_question · plans — Edit question_text and/or context on an existing question.
update_question · quiz — Deprecated name. Use update_quiz_question (removed after 2026-12-04).
update_quiz · quiz — Update an existing quiz (by id OR slug): title, description, welcome_message, welcome_cta, completion_redirect_url, is_active, and the per-interview agent_context / guardrails / business_unit_id.
update_quiz_question · quiz — Edit an existing question in place by question_id — change text, position, type, is_required, and/or its options — WITHOUT deactivating the quiz or re-authoring a new slug.
update_routing_rule · financing — Patch an existing financial.routing_rules entry by id — change priority, toggle active, edit the match pattern, retarget the tenant, set/clear the ledger_template_code, adjust the split, or update the note rationale.
update_slide · studio — Update a slide. template_data replaces the slots; an omitted slot is removed.
update_slide_beat · studio — Replace one beat of a slide’s template_data.animation.beats, addressed by beat_index (from list_slide_beats).
update_slide_comment · studio — Update a Course Canvas comment body and/or its resolved state.
update_slide_element · studio — Update a free-canvas box’s content and/or geometry (position_x/position_y/width/height/rotation/opacity/z_index).
update_spec_run_items · engineering — Apply HUMAN edits to the items of a spec run — rename, re-describe, re-point, re-stage, re-tag, approve or reject.
update_stage · learn — Update a stage. Admin only.
update_staging · financing — Edit classification/attribution fields (account_holder_id, ledger_account_code, ledger_template_code, ai_category, cost_center_id, usd_value_at_block) of financial.reconciliation_staging rows — the fields human review…
update_studio_project · studio — Update a project’s title, description, thumbnail, orientation, active theme (settings.theme_id), burned-in captions (settings.captions_*) or export watermark (settings.watermark).
update_suggested_topic · campaigns — Edit the content of one suggested topic (“pauta”) on the Curadoria board of /posts/pautas in dfl-campaigns: title, briefing, due date, formats, channels, reference links, BU or assignee.
update_task · work — Update an existing task.
update_template · studio — Open a ready-to-merge PR in dfl-slide-templates with updated HTML/CSS and optional config YAML for a template.
update_theme · studio — Open a ready-to-merge PR in dfl-slide-templates with updated CSS for a theme.
update_transaction · payments — Update an existing transaction.
update_ux_map_capture · engineering — Correct the PROSE and the PROVENANCE of ONE already-indexed UX map capture — the engineering.ux_map_captures row named by capture_id — through engineering.ux_map_update_capture.
update_wallet · financing — Patch an EXISTING financial.wallets row by id (the complement of create_wallet).
update_wiki_article · learn — Change fields of a dfl-wiki article, by id or slug.
upload_company_doc · proposals — Upload a SMALL document into the company vault by sending its bytes inline: base64 file_content is POSTed to the upload-file edge function as PRIVATE (public.media row, folder proposals/<company_id>/) and a…
upload_file · ops — Upload a file to the devfellowship S3 bucket via the upload-file edge function.
upload_slide_image · studio — Upload an image (base64 PNG, JPEG, WebP or GIF, at most 6 MB; the type is read from the bytes, SVG is refused) to DFL media as the caller, PUBLIC (the editor and the export load slide images by URL).
upsert_actor · ops — Create-or-update an actor keyed by (type, agent_slug).
upsert_agent_definition · ops — Create-or-update an agent_definitions row keyed by slug.
upsert_bank_wallet_alias · financing — Add or update a row in financial.bank_wallet_aliases — the shared copy of the statement-label -> wallet-name map, so SQL, views and the app can join it instead of re-deriving it (re-deriving it by hand was wrong twice…
upsert_company · proposals — Create a new company, or update an existing one when id is given.
upsert_keywords · strategy — Create strategy.keywords rows (the SEO corpus) in one business unit, with an optional keyword_metrics snapshot and an optional parent (parent_keyword_id, the mind-map tree).
upsert_section · proposals — Create or update a section of a submission.
upsert_spec_run_feature_group · engineering — Create or rename one feature group of a run, keyed by (run_id, code).
upsert_spec_run_package · engineering — Create or rename ONE scope layer of a spec run, keyed by (run_id, layer).
upsert_tutor_profile · learn — Upsert a tutor’s pedagogical pattern profile (the extracted signature/rubric/typology JSON) into lms.tutor_profiles, keyed on (member_id, version).
upsert_writing_pattern · strategy — Create or update one strategy.writing_patterns row (a “voice slot”) for a business_unit.
ux_paths_app_images · engineering — Deprecated name. Use list_ux_paths_app_images (removed after 2026-12-04).

V

validate_staging_row · financing — Record a HUMAN classification decision on a reconciliation_staging row and LEARN from it.
verify_sandbox · ops — Run verification tests against a provisioned sandbox.
void_journal_entries · financing — VOID individually named POSTED financial.journal_entries — the missing inverse of post_journal_entry for a single entry.

W

wait_comms_thread · ops — Block until your inbox changes, then return it.
withdraw_question · plans — Retire an obsolete plan question by setting its status to “withdrawn”.
write_document · engineering — Create or update a documents.document row from a template category, an explicit template id, or a literal body.
write_handoff_document · engineering — Convenience wrapper over write_document for the “handoff” template category: resolves a work.epics id to its name, instantiates the active handoff template, and injects {{dfl-diagram:UUID}} tokens for every diagram…
write_sheet_cells · engineering — Write individual cells into one tab, MERGING with what is already there.