bw-modeling-mcp

Overview

This is a comprehensive MCP server that enables AI assistants to work directly with SAP BW/4HANA systems through their internal REST API. It provides extensive functionality for reading, creating, and modifying BW modeling objects including aDSOs, InfoObjects, Transformations, DTPs, and BW Queries. The server supports both metadata operations and live data querying, with advanced features like dependency analysis, data flow navigation, and role management.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• bw_search

  Search BW objects by name or description with optional wildcard support and object type filtering.

  Try:Find all aDSOs with 'sales' in the nameTry:Search for InfoObjects with 'customer' in description
• bw_xref

  Find all objects that reference a given BW object (where-used analysis) including source systems for DataSources.

  Try:Show all DTPs connected to aDSO Z_SALESTry:Find which queries reference InfoObject Z_CUST
• bw_get_adso

  Read the full structure of an aDSO including fields, key fields, settings and version state.

  Try:Show me the structure of aDSO Z_SALESTry:Get details of aDSO including key fields
• bw_create_adso

  Create a new aDSO from template or empty, supporting all aDSO type presets including write-interface.

  Try:Create a new write-interface aDSO from template Z_TEMPLATETry:Make an empty aDSO with name Z_TEMP
• bw_update_adso

  Modify an existing aDSO by adding/removing fields, managing keys, updating properties or changing settings.

  Try:Add field Z_COST to aDSO Z_SALESTry:Make field Z_REVENUE a key field in aDSO Z_SALES
• bw_query_data

  Execute a BEx Query or preview data from any InfoProvider with variables, filters and axis layout control.

  Try:Run BEx query Z_SALES_Q1 with 2023 as fiscal yearTry:Preview data from aDSO Z_SALES with region filter
• bw_get_roles

  Read the full role hierarchy including folders and roles in BW system.

  Try:Show all roles in BW systemTry:Get the full role hierarchy structure
• bw_set_query_roles

  Publish or remove a query from a role or specific sub-folder in BW role management.

  Try:Publish query Z_SALES_Q1 to role Z_SALES_MGMTTry:Remove query Z_SALES_Q2 from role folder Z_2023
• bw_get_dataflow

  Trace the complete structural data flow graph of any BW object in any direction.

  Try:Show the data flow for aDSO Z_SALESTry:Trace sources and targets for query Z_SALES_Q1
• bw_list_datasources

  Recursively list all DataSources under a source system with full APCO hierarchy path.

  Try:List all DataSources under source system SAP_ERPTry:Show all FILE system DataSources
• bw_get_composite_provider

  Read a CompositeProvider structure including view node types, source providers with mappings and join conditions.

  Try:Show structure of CompositeProvider Z_SALES_CPTry:Get join details for CompositeProvider Z_MERGE
• bw_activate

  Activate BW objects including aDSO, InfoObject, Transformation and DTP.

  Try:Activate aDSO Z_SALESTry:Activate Transformation Z_SALES_TRFN

Comparable tools

Installation

# Install via npm (recommended)
npm install -g bw-modeling-mcp

# Or clone and build
git clone https://github.com/dnic-dev/bw-modeling-mcp.git
cd bw-modeling-mcp
npm install
npm run build

{
  "mcpServers": {
    "bw-modeling-mcp": {
      "command": "node",
      "args": ["/path/to/bw-modeling-mcp/dist/index.js"],
      "env": {
        "BW_URL": "https://your-bw-host:50001",
        "BW_USER": "YOUR_USER",
        "BW_PASSWORD": "YOUR_PASSWORD",
        "BW_CLIENT": "001",
        "BW_LANGUAGE": "EN"
      }
    }
  }
}

FAQ

Which SAP systems are supported?

SAP BW/4HANA (all versions) is fully supported. SAP BW on HANA (7.5) is not supported due to HTTP version negotiation issues.

How do I get API access to my BW system?

You need REST API access to your BW/4HANA system at the /sap/bw/modeling/ endpoint. Contact your SAP administrator to enable this access.

Compare bw-modeling-mcp with