Skip to main content
Glama
prateekmulye

Engineering Workflow for Microsoft 365

by prateekmulye

Engineering Workflow for Microsoft 365

Verify Quality and security CodeQL License: MIT

An independent, MIT-licensed release candidate for a portable enterprise engineering/Gemba workflow, with Microsoft 365 as the first domain adapter. It supports service-specific MCP federation through separately approved connectors. No affiliation with Microsoft, OpenAI, Anthropic, Agilent, or other vendors.

The Python MCP server uses stdio and explicit Entra identities. It ships 18 curated read operations across Microsoft Graph, Power BI, and Dataverse, plus an optional create-only Gemba action tool. No permissions are granted by installation. Broad Microsoft product coverage is an adapter roadmap, not a claim that every product action works today.

Local dashboard — no SaaS account

git clone https://github.com/prateekmulye/engineering-workflow-m365.git
cd engineering-workflow-m365
python3 scripts/install.py
.venv/bin/python -m engineering_workflow_m365.dashboard

On Windows use py -3.12 scripts/install.py, then .venv\Scripts\python.exe -m engineering_workflow_m365.dashboard. The browser opens automatically. Workflow runs, review evidence, and event history stay in a local SQLite database. See dashboard controls and security boundaries. This records reviewed progress; it does not execute agents or automatically connect a tenant.

Related MCP server: onenote-mcp

MCP quick start

Use Python 3.12 or 3.13. From the repository on macOS/Linux:

python3 -m venv .venv
.venv/bin/python -m pip install --require-hashes -r requirements.lock
.venv/bin/python -m pip install --no-deps --no-build-isolation .
export M365_WORKFLOW_CONFIG="$PWD/examples/config.demo.json"
.venv/bin/python -m unittest discover -s tests -v

On Windows PowerShell:

py -3.12 -m venv .venv
.venv\Scripts\python.exe -m pip install --require-hashes -r requirements.lock
.venv\Scripts\python.exe -m pip install --no-deps --no-build-isolation .
$env:M365_WORKFLOW_CONFIG = "$PWD\examples\config.demo.json"
.venv\Scripts\python.exe -m unittest discover -s tests -v

The demo needs no Microsoft credentials: discovery and local draft preparation work offline. Network operations need a real IT-controlled configuration and approved identity. Install into a path writable only by your account/IT. Keep tenant configuration and certificates outside this public repository.

Register the absolute venv Python executable, -m engineering_workflow_m365.server, and an absolute M365_WORKFLOW_CONFIG path in your client. See harness setup, vendor-neutral federation, reuse research, Microsoft coverage, security and permissions, architecture, and Gemba implementation.

What is included

  • A portable MCP protocol server with fixed resource handles, separate audience tokens, bounded responses, no redirects, and read-only default configuration.

  • An original engineering skill and dedicated role prompts for intake, architecture, test-first implementation, independent verification, Microsoft integration, manufacturing operations, and release.

  • A Dataverse Gemba schema and Power Apps/Power Automate implementation recipes. These are source templates, not an exported or tenant-tested managed solution.

  • A cross-client configuration generator, CI, hash-locked dependencies, license inventory, threat model, and release instructions.

  • A JSON Schema work-packet contract and validator for required reuse decisions and explicit red/green/review evidence states: python scripts/validate_packet.py examples/work-packet.json.

  • An optional visual automation profile for a separately reviewed browser/computer-use MCP. This release does not contain a browser driver or full desktop-control implementation.

End-state design

See the editable architecture SVG, proposed review console, and Figma import handoff. The SVG console is the broader design concept; the installed dashboard now implements local workflow tracking and review gates. No live Figma file was created.

Limits

API behavior, permissions, licensing, national clouds, DLP, and client approval settings differ. Windows/macOS configuration examples are provided; runtime tests here ran on Linux. No live tenant is connected or certified. Writes other than PendingReview action creation, native Office document editing, Power Platform administration, Azure administration, SAP/robot control, and unattended GUI actions are not implemented.

See release verification for exact test evidence and publication status. Contributions should add a failing boundary test before extending an adapter. MIT applies to this project; dependency and Microsoft service licenses remain separate. See third-party notices.

Maintenance

ActivityMaintained
ResponsivenessNo issues

Related MCP Connectors

Related MCP Servers

  • A
    license
    Not graded
    quality
    B
    maintenance
    A local MCP server for read-only SQL Server / MS Fabric queries. It authenticates as the user via Entra ID and runs one server process per tenant.
    47 PyPI
    MIT
  • A
    license
    Not graded
    quality
    B
    maintenance
    A secure MCP server for Microsoft OneNote via the Graph API, enabling listing/reading notebooks, sections, and pages, with optional gated write tools. Read-only by default and deployable to Azure Container Apps.
    9 npm
    MIT
  • A
    license
    A
    quality
    A
    maintenance
    A secure, local-first MCP server for read-only inspection and troubleshooting of development environments, exposing narrow, typed, auditable capabilities for repository inspection, log summarization, Docker review, and security scanning without granting unrestricted machine access.
    8
    MIT