io.github.Raistlin82/btp-sap-odata-to-mcp-server-optimized
Enterprise SAP OData to MCP Server with AI capabilities and Cloud Foundry integration
What can you do with io.github.Raistlin82/btp-sap-odata-to-mcp-server-optimized?
- Smart Query Router: Natural language to OData conversion
- Hierarchical Tool Architecture: 17+ tools organized in logical layers
- Intelligent Workflow Orchestration: Automatic tool chaining and optimization
- Real-time Analytics: KPI monitoring and trend analysis
Install
Add this to your client's MCP configuration (Claude Desktop: claude_desktop_config.json; Cursor: .cursor/mcp.json; VS Code and others use the same "mcpServers" shape).
btp-sap-odata-to-mcp-serverclaude mcp add btp-sap-odata-to-mcp-server-optimized -e 'SAP_IAS_URL=<SAP_IAS_URL>' -e 'SAP_IAS_CLIENT_ID=<SAP_IAS_CLIENT_ID>' -e 'SAP_IAS_CLIENT_SECRET=<your sap_ias_client_secret>' -e 'SAP_DESTINATION_NAME=<SAP_DESTINATION_NAME>' -e 'ODATA_DISCOVERY_MODE=<ODATA_DISCOVERY_MODE>' -e 'ODATA_INCLUDE_PATTERNS=<ODATA_INCLUDE_PATTERNS>' -e 'ODATA_EXCLUDE_PATTERNS=<ODATA_EXCLUDE_PATTERNS>' -e 'PORT=<PORT>' -e 'NODE_ENV=<NODE_ENV>' -- npx -y btp-sap-odata-to-mcp-server@1.0.1
{
"mcpServers": {
"btp-sap-odata-to-mcp-server-optimized": {
"command": "npx",
"args": [
"-y",
"btp-sap-odata-to-mcp-server@1.0.1"
],
"env": {
"SAP_IAS_URL": "<SAP_IAS_URL>",
"SAP_IAS_CLIENT_ID": "<SAP_IAS_CLIENT_ID>",
"SAP_IAS_CLIENT_SECRET": "<your sap_ias_client_secret>",
"SAP_DESTINATION_NAME": "<SAP_DESTINATION_NAME>",
"ODATA_DISCOVERY_MODE": "<ODATA_DISCOVERY_MODE>",
"ODATA_INCLUDE_PATTERNS": "<ODATA_INCLUDE_PATTERNS>",
"ODATA_EXCLUDE_PATTERNS": "<ODATA_EXCLUDE_PATTERNS>",
"PORT": "<PORT>",
"NODE_ENV": "<NODE_ENV>"
}
}
}
}
Environment variables
SAP_IAS_URLrequired URL of the SAP Identity Authentication Service tenantSAP_IAS_CLIENT_IDrequired Client ID for the OAuth application in IASSAP_IAS_CLIENT_SECRETrequired secret Client Secret for the OAuth application in IASSAP_DESTINATION_NAMErequired Name of the BTP destination used for service discoveryODATA_DISCOVERY_MODEOData discovery mode: pattern, business, whitelist, or allODATA_INCLUDE_PATTERNSComma-separated patterns to include (pattern mode)ODATA_EXCLUDE_PATTERNSComma-separated patterns to exclude (pattern mode)PORTThe port on which the Express server will listenNODE_ENVThe application's operating environment
Documentation
From the project's README on GitHub, refreshed weekly. Links open on GitHub.
SAP OData to AI-Powered MCP Server (Optimized)
This repository is an enterprise-ready MCP (Model Context Protocol) server that bridges SAP OData services with AI capabilities. Based on the original project btp-sap-odata-to-mcp-server by @lemaiwo, this optimized version features enhanced security, simplified configuration, modular authentication, and comprehensive Cloud Foundry integration.
✨ Key Features
🔐 Enhanced Security Architecture
- Modular Authentication System: Factory pattern supporting IAS, OAuth2, JWT, Basic Auth, and API Keys
- Secure Session Management: Thread-safe session bridging with proper locking mechanisms
- Role-Based Access Control: Granular permissions with XSUAA integration
- Principal Propagation: Maintains user context throughout the request lifecycle
- Security Best Practices: No sensitive data logging, secure error handling, JWT validation
🎯 Simplified OData Discovery
- Pattern-Based Filtering: Simple include/exclude patterns for service discovery
- Business Domain Mode: Pre-configured domains (sales, finance, HR, etc.)
- Whitelist Mode: Explicit service control for production environments
- Smart Defaults: Automatic exclusion of test/debug services
🧠 AI-Powered Capabilities
- Smart Query Router: Natural language to OData conversion
- Hierarchical Tool Architecture: 17+ tools organized in logical layers
- Intelligent Workflow Orchestration: Automatic tool chaining and optimization
- Real-time Analytics: KPI monitoring and trend analysis
🎨 Interactive UI Tools Suite
ui-form-generator: Dynamic SAP Fiori forms with validationui-data-grid: Interactive tables with sorting and filteringui-dashboard-composer: Real-time KPI dashboardsui-workflow-builder: Visual workflow creationui-report-builder: Analytical reports with drill-down
☁️ Cloud-Native Features
- Cloud Foundry Optimized: Native integration with CF services
- Structured Logging: SAP Cloud Logging with fallback support
- Health Monitoring: Comprehensive health check endpoints
- Performance Metrics: Built-in performance tracking
- Graceful Shutdown: Proper resource cleanup
🚀 Quick Start
Prerequisites
- Access to an SAP BTP, Cloud Foundry environment.
- Required BTP services: XSUAA, Identity, Connectivity, Destination.
- Node.js >= 18.
1. Installation
git clone <this-repo>
cd btp-sap-odata-to-mcp-server-optimized
npm install
2. Configuration
Configure the application using environment variables. See the Configuration Guide for detailed documentation.
cp .env.example .env
# Edit .env with your configuration
Quick Configuration Example
# Authentication
SAP_IAS_URL=https://your-tenant.accounts.ondemand.com
SAP_IAS_CLIENT_ID=your-client-id
SAP_IAS_CLIENT_SECRET=your-secret
# OData Discovery (Simplified)
ODATA_DISCOVERY_MODE=pattern
ODATA_INCLUDE_PATTERNS=*API*,Z*
ODATA_EXCLUDE_PATTERNS=*_TEST*,*_TEMP*
ODATA_MAX_SERVICES=50
# Destinations
SAP_DESTINATION_NAME=SAP_S4HANA
3. Build and Deploy
# Build the TypeScript source code for BTP
npm run build:btp
# Deploy to SAP BTP, Cloud Foundry
npm run deploy:btp
📚 Documentation
Complete documentation is available with structured navigation for all aspects of the project.
🏠 Documentation Hub
Main navigation center with use-case-based guidance and complete file index.
🚀 Quick Links
| Category | Document | Description |
|---|---|---|
| Getting Started | Configuration Guide | Environment setup, OData discovery, CF deployment |
| Architecture | Architecture Overview | System design, security model, tool hierarchy |
| 🎨 Modern Diagrams | Modern Architecture Diagrams | NEW! Interactive visual architecture |
| Usage | User Guide | Authentication, tool usage, workflow examples |
| Reference | Tool Reference | Complete tool documentation with parameters |
| Deployment | Deployment Guide | SAP BTP and local development setup |
| Development | Testing Guide | Test suite and development guidelines |
| Changes | Changelog | Version history and feature updates |
📖 Navigation Flow
README.md → docs/README.md → All Documentation
↓ ↓
Quick Start → Structured Navigation → Complete Coverage
Frequently asked questions
What is io.github.Raistlin82/btp-sap-odata-to-mcp-server-optimized?
Enterprise SAP OData to MCP Server with AI capabilities and Cloud Foundry integration
How do I install io.github.Raistlin82/btp-sap-odata-to-mcp-server-optimized?
It runs on your machine. In Claude Code: claude mcp add btp-sap-odata-to-mcp-server-optimized -e 'SAP_IAS_URL=<SAP_IAS_URL>' -e 'SAP_IAS_CLIENT_ID=<SAP_IAS_CLIENT_ID>' -e 'SAP_IAS_CLIENT_SECRET=<your sap_ias_client_secret>' -e 'SAP_DESTINATION_NAME=<SAP_DESTINATION_NAME>' -e 'ODATA_DISCOVERY_MODE=<ODATA_DISCOVERY_MODE>' -e 'ODATA_INCLUDE_PATTERNS=<ODATA_INCLUDE_PATTERNS>' -e 'ODATA_EXCLUDE_PATTERNS=<ODATA_EXCLUDE_PATTERNS>' -e 'PORT=<PORT>' -e 'NODE_ENV=<NODE_ENV>' -- npx -y btp-sap-odata-to-mcp-server@1.0.1. For other clients, paste the JSON configuration from this page into their MCP settings.
Does io.github.Raistlin82/btp-sap-odata-to-mcp-server-optimized need an API key?
Yes. It expects SAP_IAS_URL, SAP_IAS_CLIENT_ID, SAP_IAS_CLIENT_SECRET, SAP_DESTINATION_NAME, which you set in its configuration.
Is io.github.Raistlin82/btp-sap-odata-to-mcp-server-optimized open source?
Yes. Its code is on GitHub under the MIT license.
Who maintains io.github.Raistlin82/btp-sap-odata-to-mcp-server-optimized?
It is published by Raistlin82. AI.tn lists it but does not maintain or endorse it.
From the official MCP Registry. Listing is not an endorsement: review a server's code and permissions before giving it access to your data.