{"id":"tech.basis1/mcp","slug":"tech-basis1-mcp","title":"Basis","description":"The Excel engine for AI agents: read, check and edit Excel models over MCP.","version":"0.3.2","publisher":{"kind":"domain","id":"basis1.tech","label":"basis1.tech","url":"https://basis1.tech"},"website":"https://basis1.tech","repository":"https://github.com/basis1tech/basis-oss","remotes":[{"type":"streamable-http","url":"https://api.basis1.tech/mcp","headers":[{"description":"Bearer followed by your Basis API key","isRequired":true,"value":"Bearer {api_key}","isSecret":true,"variables":{"api_key":{"description":"Your Basis API key","isRequired":true,"isSecret":true}},"name":"Authorization"}]}],"packages":[{"registryType":"npm","registryBaseUrl":"https://registry.npmjs.org","identifier":"@basis1/mcp","version":"0.3.2","runtimeHint":"npx","transport":{"type":"stdio"},"environmentVariables":[{"description":"Your Basis API key, from https://api.basis1.tech","isRequired":true,"format":"string","isSecret":true,"name":"BASIS_API_KEY"},{"description":"Basis API base URL, to use a self-hosted server","format":"string","default":"https://api.basis1.tech","name":"BASIS_BASE_URL"}]}],"published":"2026-11-13","updated":"2026-11-13","status":"online","auth":"","latency_ms":937,"checked":"2026-11-19","uptime":100,"checks":3,"tools":[{"name":"parse_workbook","title":"Parse workbook","description":"Parse an .xlsx workbook (or a .csv/.tsv file, read as one sheet) in one call and return its full semantic NDJSON: one JSON record per line (workbook_meta, sheet, cell, edge, image, image_summary, audit), covering every cell's value and formula and the formula dependency edges. Use it to read a whole file without opening a session. For a large file, use submit_job so the call doesn't wait on the pa","read_only":true},{"name":"submit_job","title":"Submit parse job","description":"Start an async parse of an .xlsx workbook (or a .csv/.tsv file) and return at once with a job handle {job_id, status: \"processing\", status_url, stream_url}. Use it instead of parse_workbook for large files or when you don't want to wait: call stream_job with wait_seconds to wait for the records (or status_only to just check). Every call starts a new job and counts against the API key's parse quota","read_only":false},{"name":"stream_job","title":"Stream job output","description":"Check on or read a parse job started by submit_job. By default it returns the job's NDJSON records once it has completed: the same output parse_workbook returns, one JSON record per line. Pass wait_seconds (up to 60) to wait that long for a job still processing; if it is still processing after that, the call fails with job_not_ready and the job's status, so call again. Pass status_only: true to ge","read_only":true},{"name":"diff_workbooks","title":"Diff workbooks","description":"Compare two .xlsx (or .csv) files cell by cell and return the differences as JSON: {summary, added, removed, changed, format_changed}. Cells are matched on (sheet title, cell ref); changed covers value and formula changes, and format-only changes are listed separately. Use it to see what changed between two versions of a file, such as before and after an edit. For problems inside one workbook use ","read_only":true},{"name":"evaluate_formula","title":"Evaluate formula","description":"Evaluate an Excel formula locally and return the computed result: a quick way to check what a formula returns on a few sample values before you put it in a workbook. Pass data as a map of cell references to values (e.g. {\"A1\": 100, \"A2\": true, \"A3\": \"#N/A\", \"B1\": \"hello\"}) and a formula string (e.g. \"SUM(A1:A2)\"). Values keep their Excel types, as in a workbook: true/false are logical cells (so SU","read_only":true},{"name":"create_session","title":"Create session","description":"Open a workbook in a session that the other workbook tools then use by session_id: the starting point for reading, editing, recalculating and exporting a model. Pass at most one of library_file_id (a file in your Library), base64 (raw .xlsx or .csv bytes) or url, or none for a blank workbook (the only kind add_sheet can extend). A .csv opens as one sheet, typed as Excel types it (numbers, TRUE/FAL","read_only":false},{"name":"close_session","title":"Close session","description":"End a session and discard its workbook: the session_id stops working and the session can't be reopened. Edits not saved with save_to_library (or downloaded with export_workbook) are lost, and its commit_session checkpoints go with it, so restore_session can't bring it back. Call it when you're done with a workbook, or to free a slot when create_session fails with max_sessions. Returns {closed: tru","read_only":false},{"name":"list_sessions","title":"List sessions","description":"List the sessions open for this API key, to recover a session_id you've lost or to see how many are open before create_session. Returns {sessions: [{id, documentId, libraryFileId, createdAt, updatedAt, sheetCount, memBytes}]}, times in epoch milliseconds; closed and expired sessions are left out. Pass an id to any session tool, or to close_session to free a slot. Takes no arguments. Each API key c","read_only":true},{"name":"add_sheet","title":"Add sheet","description":"Add an empty sheet at the end of a session's workbook and make it the active sheet (the one unqualified refs like \"B4\" point to). Only for sessions created blank (create_session with no file); on an imported workbook it fails, so work in its existing sheets with set_inputs instead. To retitle a sheet use rename_sheet; to remove one use delete_sheet. Returns {sheet_index, sheet_name, sheet_count}.","read_only":false},{"name":"rename_sheet","title":"Rename sheet","description":"Rename a sheet in a session's workbook, found by its 0-based index (see the sheets list from create_session or inspect_model). Formulas, named ranges and validations that reference the sheet are rewritten to the new name, so results don't change; use it rather than add_sheet when you only need a different title. Excel's rules apply: 1-31 characters, none of : \\ / ? * [ ], no leading or trailing ap","read_only":false},{"name":"delete_sheet","title":"Delete sheet","description":"Delete a sheet from a session's workbook, found by its 0-based index (see the sheets list from create_session or inspect_model), the way Excel does: formulas on other sheets that referenced it now read #REF! (Gone!A1 becomes #REF!A1) and evaluate to #REF!, a 3D range ending on it (Jan:Mar!B2) shrinks to the neighbouring sheet, names scoped to it are removed and names that pointed into it refer to ","read_only":false},{"name":"set_inputs","title":"Set inputs","description":"Write values or formulas into cells of a session and recalculate: the way to run a scenario on a model (\"what if Revenue is 1.2M?\"). Keys are defined names (e.g. \"Revenue\") or cell refs (\"B4\" on the active sheet, \"Sheet1!A1\"); values are numbers, booleans (logical TRUE/FALSE), error codes such as \"#N/A\", text, or a string starting with \"=\" to store a formula. Whatever the target cells held before ","read_only":false},{"name":"set_calc_settings","title":"Set calc settings","description":"Turn iterative calculation on or off for a session and recalculate. Needed for circular models (e.g. development pro formas where loan size depends on cost, which includes the loan's interest and fees): with it on, set_inputs re-converges the loop on every call. Saved with the session's next commit (restore_session to an earlier commit rolls it back) and written to the workbook, so an exported xls","read_only":false},{"name":"get_outputs","title":"Get outputs","description":"Read computed values from a session by defined name, cell or range: the way to check what a model's formulas return, e.g. after set_inputs. Pass names as defined names, cell refs (\"B4\", \"Sheet1!B4\") or ranges (\"Sheet1!H2:H18\", up to 2,000 cells, one entry per cell); omit names to read every defined name. Returns {values: {<name or ref>: {cell, type, value}}}; a cell holding an Excel error comes ba","read_only":true},{"name":"define_variable","title":"Define variable","description":"Create a defined name for a cell, or repoint an existing one, so set_inputs and get_outputs can use a readable key (\"Revenue\") instead of a cell ref. A name that already exists in the same scope is overwritten with the new target; no cell's value or formula changes. Names follow Excel's rules (start with a letter, _ or \\, no spaces, not a cell ref) and invalid ones fail the call. Returns {name, re","read_only":false},{"name":"delete_variable","title":"Delete variable","description":"Delete a defined name from a session's workbook, e.g. one you made with define_variable and no longer need. Only the name goes; the cell it pointed to keeps its value and formula. Match is by name, ignoring case, in workbook scope or, with scope_sheet, the name scoped to that sheet. A name still used by a formula is not deleted: the call fails with name_in_use and lists those cells, so rewrite the","read_only":false},{"name":"inspect_model","title":"Inspect model","description":"Summarize a session's structure: each sheet's index, name and used rows and columns, every defined name with its target, the iterative-calc settings, and counts of cells, memory, edit events and commits. Use it to find your way around a workbook before reading or editing it: sheet indexes for rename_sheet, delete_sheet and define_variable, names for get_outputs and set_inputs. include_edges adds e","read_only":true},{"name":"export_workbook","title":"Export workbook","description":"Get a session's workbook back as an .xlsx file with every formula's computed value saved in it. Recalculates first. Call this when you need the file itself: to give it to the user, or to read it with pandas, openpyxl (data_only=True) or any tool that is not Excel. Returns file_base64 and a summary of formula errors (#REF!, #DIV/0!, #NAME? with sheet and cell) and of anything that did not survive t","read_only":true},{"name":"recalc_workbook","title":"Recalculate workbook","description":"Recalculate an .xlsx file (or a .csv, returned as .xlsx) and return it with the computed values saved in every formula cell. Use this after you create or edit a workbook with openpyxl or any other library that writes formulas without results: those files have no cached values, so pandas, openpyxl (data_only=True) and other readers see empty cells until the file is recalculated. Replaces running Li","read_only":true},{"name":"get_formula_range","title":"Get formula range","description":"Read the formulas and computed values of one cell or a rectangular range in a session: the way to check what a cell or a block of cells computes. Pass a single cell (\"B4\", \"Sheet1!B4\") or a range (\"A1:D10\"). Returns {worksheet, range, cell_count, cells: [{cell, formula, value, value_type}]}, with formula including its leading \"=\" (null for constants and empty cells) and value_type \"number\", \"strin","read_only":true},{"name":"commit_session","title":"Commit session","description":"Create a named checkpoint of the session's current state, e.g. before a risky edit. Returns {commit_id, message, total_commits}; pass commit_id to restore_session to roll back. Every call adds a new checkpoint. Checkpoints live in the session only and are lost when it closes or expires; to keep one in the Library's version history, call save_to_library after it (the version takes this message as i","read_only":false},{"name":"restore_session","title":"Restore session","description":"Roll a session back to a checkpoint from commit_session: every cell edit made after it is undone, calc settings included, and the workbook is recalculated. Use it to throw away a what-if or a bad edit; it rewinds this session only and can't reopen a closed one. Returns {restored_to, cells_changed, calc, recalc}. A commit_id the session doesn't have fails the call. To compare two states without rol","read_only":false},{"name":"trace_dependencies","title":"Trace dependencies","description":"Follow formula references from one cell in a session, breadth first, up to depth levels (1-5): direction \"precedents\" walks to the cells it reads, \"dependents\" to the cells that read it, and \"both\" (the default) does each. Returns {root, direction, max_depth, levels: [{depth, nodes: [{cell, formula, value, value_type}]}]} for one direction, or precedents and dependents (each a levels list) in plac","read_only":true},{"name":"audit_workbook","title":"Audit workbook","description":"Check a session's whole workbook for modeling problems and return a JSON report: broken references, circular references and whether they converge, hardcoded plugs (a constant or odd formula breaking a run of consistent formulas), external links, volatile functions, hidden sheets and names, stale cached values, and a verification block comparing Basis's computed values with the ones Excel last save","read_only":true},{"name":"save_to_library","title":"Save to Library","description":"Save the session's workbook to the user's Library for durable storage. If the session was loaded from the Library or was previously saved, this creates a new version of that file. Otherwise it creates a new Library file. Each save is a named version in the Library's history: pass `message`, or it takes the latest commit_session message since the last save. commit_session checkpoints themselves sta","read_only":false},{"name":"list_library_files","title":"List Library files","description":"List the workbooks in the user's Library: the files this account owns, newest-updated first, including everything save_to_library saved. Use it to find a library_file_id to open with create_session, or to check that a save landed. Returns {files: [{library_file_id, name, size_bytes, created_at, updated_at, latest_version: {seq, message, created_at}}], truncated}, times in ISO 8601; latest_version ","read_only":true}],"server_info":{"name":"basis-mcp","version":"0.0.1"},"category":"productivity","tags":["hr","agents"],"kind":"remote","source":"registry","submitted":{},"first_party":true,"domain_rank":null,"score":100,"indexable":true,"first_seen":"2026-11-04","stars":0,"badges":["new"],"sponsor":null,"page":"https://agentsindex.org/agents/tech-basis1-mcp/"}