MCP Server

stepcode

dev.stepcode/stepcode
Data & Analytics Knowledge & Documentation Public & reachable MCP 2025-11-25

What this MCP does

Indexes and retrieves how-to guides for conducting analyses in Excel, Google Sheets, R, Python, SQL, DAX, and Power BI.

get_howto_page
Get one stepcode how-to page
Get the full howto/v2 contract for one page by slug (from list_howto_pages / search_howto_pages): intro, per-step teach/intent/code, divergence notes, cross-tool links, and grounding.
Read only
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['slug'], 'properties': {'slug': {'type': 'string', 'description': 'How-to page slug, e.g. flight-risk-predict-which-employees-will-resign-in-excel.'}}}
Output schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['page'], 'properties': {'page': {'type': 'object', 'required': ['contract', 'slug', 'title', 'h1', 'coordinates', 'intro', 'steps', 'divergences', 'crossTools', 'grounding', 'routing'], 'properties': {'h1': {'type': 'string'}, 'slug': {'type': 'string'}, 'intro': {'type': 'string'}, 'steps': {'type': 'array', 'items': {'type': 'object', 'required': ['op', 'artifact', 'inputs', 'goal', 'bridge', 'callouts', 'how', 'code', 'expect', 'divergence'], 'properties': {'op': {'type': 'string'}, 'how': {'type': 'string'}, 'code': {'type': 'string'}, 'goal': {'type': 'string'}, 'bridge': {'type': 'string'}, 'expect': {'type': 'string'}, 'inputs': {'type': 'array', 'items': {'type': 'string'}}, 'artifact': {'type': 'string'}, 'callouts': {'type': 'array', 'items': {'type': 'object', 'required': ['type', 'body'], 'properties': {'body': {'type': 'string'}, 'type': {'type': 'string'}}, 'additionalProperties': False}}, 'divergence': {'type': 'boolean'}}, 'additionalProperties': False}}, 'title': {'type': 'string'}, 'routing': {'type': 'object', 'required': ['guides', 'toolbox', 'service'], 'properties': {'guides': {'type': 'array', 'items': {'type': 'string'}}, 'service': {'type': 'boolean'}, 'toolbox': {'type': ['string', 'null']}}, 'additionalProperties': False}, 'verdict': {'type': 'string'}, 'contract': {'type': 'string'}, 'grounding': {'type': 'object', 'required': ['source', 'book'], 'properties': {'book': {'type': 'string'}, 'source': {'type': 'string'}}, 'additionalProperties': False}, 'crossTools': {'type': 'array', 'items': {'type': 'object', 'required': ['tool', 'toolLabel', 'slug', 'diverges'], 'properties': {'slug': {'type': 'string'}, 'tool': {'type': 'string'}, 'diverges': {'type': 'boolean'}, 'toolLabel': {'type': 'string'}}, 'additionalProperties': False}}, 'coordinates': {'type': 'object', 'required': ['analysis', 'analysisSlug', 'tool', 'toolLabel', 'vertical', 'verticalLabel', 'ops'], 'properties': {'ops': {'type': 'array', 'items': {'type': 'string'}}, 'tool': {'type': 'string'}, 'analysis': {'type': 'string'}, 'vertical': {'type': 'string'}, 'toolLabel': {'type': 'string'}, 'analysisSlug': {'type': 'string'}, 'verticalLabel': {'type': 'string'}}, 'additionalProperties': False}, 'divergences': {'type': 'array', 'items': {'type': 'string'}}}, 'additionalProperties': False}}, 'additionalProperties': False}
list_analysis_families
List stepcode's analysis families
List the analysis families on stepcode.dev (e.g. flight-risk, diversity-index-EBIT-impact) with the tools each is shown in and how many pages exist for it.
Read only
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
Output schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['count', 'families'], 'properties': {'count': {'type': 'number'}, 'families': {'type': 'array', 'items': {'type': 'object', 'required': ['analysisSlug', 'analysis', 'vertical', 'tools', 'pageCount'], 'properties': {'tools': {'type': 'array', 'items': {'type': 'string'}}, 'analysis': {'type': 'string'}, 'vertical': {'type': 'string'}, 'pageCount': {'type': 'number'}, 'analysisSlug': {'type': 'string'}}, 'additionalProperties': False}}}, 'additionalProperties': False}
list_howto_pages
List stepcode's how-to pages
List every published how-to page on stepcode.dev — 36 analysis x tool cells (Excel, Google Sheets, R, Python, SQL, DAX/Power BI) with slug, title, analysis family, tool, vertical and whether the tool's approach diverges from the others.
Read only
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
Output schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['count', 'pages'], 'properties': {'count': {'type': 'number'}, 'pages': {'type': 'array', 'items': {'type': 'object', 'required': ['slug', 'title', 'analysis', 'analysisSlug', 'tool', 'vertical', 'diverges'], 'properties': {'slug': {'type': 'string'}, 'tool': {'type': 'string'}, 'title': {'type': 'string'}, 'analysis': {'type': 'string'}, 'diverges': {'type': 'boolean'}, 'vertical': {'type': 'string'}, 'analysisSlug': {'type': 'string'}}, 'additionalProperties': False}}}, 'additionalProperties': False}
search_howto_pages
Search stepcode's how-to pages
Filter the how-to index by analysis family, tool, vertical, and/or a case-insensitive text query against title, analysis name, intro, problem statement, and step operations (with practitioner-synonym coverage, e.g. attrition/turnover/churn, logistic regression/classifier, power bi/dax, diversity/simpson/blau). All filters are optional and combine with AND; call with no arguments to get every page (same as list_howto_pages).
Read only
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'tool': {'type': 'string', 'description': 'Tool slug, e.g. excel, sheets, r, python, sql, dax.'}, 'query': {'type': 'string', 'description': 'Case-insensitive text query against title, analysis name, intro, problem statement, and step operations.'}, 'vertical': {'type': 'string', 'description': 'Vertical slug, e.g. hr.'}, 'analysisSlug': {'type': 'string', 'description': 'Analysis family slug, e.g. flight-risk-predict-which-employees-will-resign.'}}}
Output schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['count', 'pages'], 'properties': {'count': {'type': 'number'}, 'pages': {'type': 'array', 'items': {'type': 'object', 'required': ['slug', 'title', 'analysis', 'analysisSlug', 'tool', 'vertical', 'diverges'], 'properties': {'slug': {'type': 'string'}, 'tool': {'type': 'string'}, 'title': {'type': 'string'}, 'analysis': {'type': 'string'}, 'diverges': {'type': 'boolean'}, 'vertical': {'type': 'string'}, 'analysisSlug': {'type': 'string'}}, 'additionalProperties': False}}}, 'additionalProperties': False}
Removed
get_membership_offer
Sept. 27, 2026, 2:43 a.m.
Changed
search_howto_pages
Sept. 27, 2026, 2:43 a.m.
Added
get_membership_offer
Sept. 17, 2026, 12:39 p.m.
Added
list_analysis_families
Sept. 17, 2026, 12:39 p.m.
Added
get_howto_page
Sept. 17, 2026, 12:39 p.m.
Added
search_howto_pages
Sept. 17, 2026, 12:39 p.m.
Added
list_howto_pages
Sept. 17, 2026, 12:39 p.m.