MCP-Server

SumOffice — real Word and Excel for agents

com.sumoffice/office
Daten & Analytik Produktivität Öffentlich und erreichbar MCP 2025-11-25

Was dieses MCP kann

Reads and edits Word documents and Excel workbooks while preserving document structure, formulas, macros, comments, tracked changes, and workbook features.

document_apply
Apply a proposed paragraph replacement
Apply a proposal from document_propose_replacement to the document in this session's cabin (not to your original file). Stale proposal (the document moved on) is refused by the engine — propose again. Repeating an applied proposal is a no-op.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['proposal_id'], 'properties': {'proposal_id': {'type': 'string', 'maxLength': 64, 'minLength': 4}}}
document_comments
Comments and tracked changes
Comments (author, text, anchor, resolved) and tracked changes — up to 50.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
document_describe
What the document is
Name, pages, paragraphs, words, number of comments and tracked changes, whether track changes is on. For documents; call first.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
document_export_pdf
Render the document to PDF
Lay out the document as it is now in this session's cabin (after applied proposals, or as opened) and return a PDF download link valid for 24 hours, plus the page count. Documents only; for workbooks use document_save_copy.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
document_find
Find in the document
Paragraphs containing the text (case-insensitive), with snippets around the match.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['query'], 'properties': {'query': {'type': 'string', 'maxLength': 200, 'minLength': 2}}}
document_open
Open a demo document or workbook
Open one of the demo files by name: documents footnotes, comments, forms, rtl, wild-horse, workshop, offer, tools; workbooks workbook, functions, macros, queries, gep, vba-web, sqlite, order-desk, onrr, cashflow, pivot, chart, notes, check, xtools. Default is footnotes. For your own file use document_open_file. Opens a separate editor cabin for this session.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['slug'], 'properties': {'slug': {'enum': ['footnotes', 'comments', 'forms', 'rtl', 'wild-horse', 'workshop', 'workbook', 'functions', 'macros', 'queries', 'gep', 'vba-web', 'sqlite', 'order-desk', 'onrr', 'cashflow', 'offer', 'pivot', 'chart', 'notes', 'check', 'tools', 'xtools'], 'type': 'string'}}}
document_open_file
Open your own Word document or Excel workbook
Open YOUR file in a private editor cabin for this session: a .docx/.doc/.odt document or an .xlsx/.xlsm/.xlsb/.xls/.ods workbook, up to 50 MB. Give exactly one of: url (https link the server can fetch), base64 (file bytes; then name with the extension is required). Nothing in the file is executed. The file is kept for 24 hours and then deleted. After opening, use document_* tools for a document or sheet_* / macro_* / query_* / workbook_inspect for a workbook; sheet_propose_edits → sheet_apply and document_propose_replacement → document_apply change the copy in the cabin; document_save_copy returns a download link of the edited file.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'url': {'type': 'string', 'maxLength': 2000}, 'name': {'type': 'string', 'maxLength': 200}, 'path': {'type': 'string', 'maxLength': 1000}, 'base64': {'type': 'string'}}}
document_propose_replacement
Propose replacing one paragraph's text
Propose the full new text of one paragraph (paragraph_index from document_read). Nothing changes yet: the editor core builds the change on a copy and returns before/after plus checks (numbers, dates, links kept). Then call document_apply with the proposal_id. Read the paragraph first.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['paragraph_index', 'text'], 'properties': {'text': {'type': 'string', 'maxLength': 20000, 'minLength': 1}, 'reason': {'type': 'string', 'maxLength': 300}, 'paragraph_index': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0}}}
document_read
Read paragraphs
Paragraph text as a window: from = index of the first paragraph (0-based), count = how many (max 40). The answer carries next — where to continue, null at the end. A missing paragraph is a refusal, not an invention.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['from'], 'properties': {'from': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0}, 'count': {'type': 'integer', 'maximum': 40, 'minimum': 1}}}
document_save_copy
Save a copy of the edited file
Write the document or workbook as it is now in this session's cabin (after applied proposals) to a copy and return a download link valid for 24 hours. Your original file is never touched. A workbook with macros comes back as .xlsm with the VBA project intact; a document keeps its styles, comments and tracked changes.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'inline': {'type': 'boolean', 'description': 'also return the bytes as base64 (only for files up to 4 MB)'}}}
macro_list
List VBA modules and runnable macros (entry points) in this workbook with their route and blockers. Runs nothing.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
macro_plan
Plan a macro run without running it: route, whether the engine can run it natively, blockers, instruction budget.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['entrypoint'], 'properties': {'entrypoint': {'type': 'string', 'description': 'Module.Procedure'}, 'active_sheet': {'type': 'string'}}}
macro_read_source
Read the source text of one procedure (module + procedure name from macro_list). Read-only; runs nothing.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['module', 'procedure'], 'properties': {'module': {'type': 'string'}, 'procedure': {'type': 'string'}}}
query_explain
Explain one Power Query query by name: its steps in order, where it loads, its connection. Reads only; refreshes nothing.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['name'], 'properties': {'name': {'type': 'string'}}}
query_list
List Power Query queries in this workbook: names, step chain, load target, connections. Reads only; refreshes nothing.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
sheet_apply
Apply proposed cell edits
Apply a proposal from sheet_propose_edits to the workbook in this session's cabin (not to your original file); the engine recalculates. Refused if the workbook revision moved on since the proposal — propose again. Repeating an applied proposal is a no-op.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['proposal_id'], 'properties': {'proposal_id': {'type': 'string', 'maxLength': 64, 'minLength': 4}}}
sheet_describe
Workbook overview: every sheet tab with its used range, the current revision, and the header row of the sheet that is open. Call this first, then pass the tab name you need as "sheet" to sheet_read and sheet_find.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
sheet_find
Find cells whose value or formula contains the text (case-insensitive) in the used range of a sheet. ALWAYS pass "sheet" with the exact tab name when the workbook has more than one sheet: without it only the sheet that happens to be open is searched.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['query'], 'properties': {'query': {'type': 'string', 'maxLength': 100, 'minLength': 1}, 'sheet': {'type': 'string', 'description': 'Exact tab name. Required when the workbook has more than one sheet.'}}}
sheet_propose_edits
Propose new contents for up to 20 cells (formulas like =SUM(B2:B9), or numbers/text). Nothing changes in the workbook: the engine previews the edits on the current revision and reports what would change and whether errors appear; the person decides whether to apply. Read the cells first. Do not overwrite input numbers unless the task says so. Then call sheet_apply with the proposal_id.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['edits'], 'properties': {'edits': {'type': 'array', 'items': {'type': 'object', 'required': ['cell', 'input'], 'properties': {'cell': {'type': 'string'}, 'input': {'type': 'string', 'maxLength': 2000}}}, 'maxItems': 20, 'minItems': 1}, 'sheet': {'type': 'string'}, 'reason': {'type': 'string', 'maxLength': 300}}}
sheet_read
Read a rectangular range like A1:F20 (max 60 rows × 26 columns): values and formulas. Empty cells are omitted. ALWAYS pass "sheet" with the exact tab name when the workbook has more than one sheet — without it you read whichever sheet happens to be open, and the answer will quietly be about the wrong sheet. Call sheet_describe first if you do not know the tab names.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['range'], 'properties': {'range': {'type': 'string'}, 'sheet': {'type': 'string', 'description': 'Exact tab name, e.g. "Logical". Required when the workbook has more than one sheet.'}}}
workbook_inspect
Map the whole application model of this workbook in one call: sheets; VBA modules, procedures, which can run here and which are blocked and why; event handlers; external objects (CreateObject) and Windows API (Declare) dependencies; project references; Power Query queries; data connections; form controls, ActiveX, embedded objects (preserved). Runs nothing. Call this first for questions like 'how is this workbook built' or 'what does it depend on'.
Eingabeschema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
Hinzugefügt
document_export_pdf
22. September 2026 02:40
Hinzugefügt
document_save_copy
22. September 2026 02:40
Hinzugefügt
sheet_apply
22. September 2026 02:40
Hinzugefügt
sheet_propose_edits
22. September 2026 02:40
Hinzugefügt
workbook_inspect
22. September 2026 02:40
Hinzugefügt
query_explain
22. September 2026 02:40
Hinzugefügt
query_list
22. September 2026 02:40
Hinzugefügt
macro_plan
22. September 2026 02:40
Hinzugefügt
macro_read_source
22. September 2026 02:40
Hinzugefügt
macro_list
22. September 2026 02:40
Hinzugefügt
sheet_find
22. September 2026 02:40
Hinzugefügt
sheet_read
22. September 2026 02:40
Hinzugefügt
sheet_describe
22. September 2026 02:40
Hinzugefügt
document_apply
22. September 2026 02:40
Hinzugefügt
document_propose_replacement
22. September 2026 02:40
Hinzugefügt
document_comments
22. September 2026 02:40
Hinzugefügt
document_find
22. September 2026 02:40
Hinzugefügt
document_read
22. September 2026 02:40
Hinzugefügt
document_describe
22. September 2026 02:40
Hinzugefügt
document_open_file
22. September 2026 02:40
Hinzugefügt
document_open
22. September 2026 02:40