Skip to main content
Glama
MarioDeFelipe

SAP Datasphere MCP Server

🚀 SAP Datasphere MCP Server

PyPI version npm version Python 3.10+ MCP Protocol License: MIT Production Ready PII Masking

Production-ready Model Context Protocol (MCP) server that enables AI assistants to seamlessly interact with SAP Datasphere environments for real tenant data discovery, metadata exploration, analytics operations, ETL data extraction, database user management, data lineage analysis, and column-level data profiling — with built-in config-driven PII masking so sensitive fields never reach the LLM.

đŸ“Ļ Which version do I install?

Package

MCP Python SDK

Status

2.x (current)

mcp>=2.0,<3

Active development. Implements the 2026-07-28 stateless spec.

1.x

mcp>=1.28,<2

Maintenance only — security and critical fixes.

pip install sap-datasphere-mcp gives you 2.x. The 2.x server is dual-era: it answers both the modern server/discover handshake and the legacy initialize one, so 2025-era clients keep working without changes.

Stay on 1.x only if your environment cannot install SDK 2.x:

pip install 'sap-datasphere-mcp<2'

Related MCP server: SAP Datasphere MCP Server

🆕 What's New (v2.0.1 — MCP SDK v2 / stateless spec)

  • Ported to MCP Python SDK 2.0.0 and the 2026-07-28 stateless specification. Handlers moved from the removed decorator API to Server(on_*=â€Ļ) constructor kwargs. The dependency floor is now mcp>=2.0,<3 — this is why the package major changed.

  • Dual-era by default — modern and legacy clients are both served from the same process; no configuration needed.

  • Response cache hints (ttlMs / cacheScope, SEP-2549) on tools/list, prompts/list and resources/list, sourced from CacheManager so the protocol hint and the internal cache cannot drift. Hints are sent to modern clients only, as the spec requires. tools/list is deterministically ordered.

  • Per-asset capability discovery — Datasphere capability varies per asset, not per tenant. $count is now decided by reading the asset's own Capabilities.CountRestrictions annotation rather than a blanket rule, and a lineage-gated filter verdict is remembered per asset instead of being rediscovered on every call.

  • Every 1.7.0 protection forward-ported, verified by the same test suite running green on both SDK lines. See CHANGELOG_v2.0.1.md.

🆕 What's New (v1.7.0 — input validation hardening)

  • Every tool with inputs now has validation rules — 12 tools shipped without any, including query_relational_entity and smart_query. Coverage is 45/45 tools, 145/150 inputs.

  • Path identifiers are constrained and percent-encoded. space_id / asset_id / entity_name / object_id are interpolated into URL paths; they now reject traversal-shaped values and pass through quote() as a backstop.

  • Two silent-no-op bugs fixed — the validator registry had drifted so two tools' rules never ran, and allowed_values was ignored on STRING rules (which also left get_catalog_metadata.endpoint_type unenforced).

  • A CI guard now fails if a tool ships without validation rules. See CHANGELOG_v1.7.0.md.

🆕 What's New (v1.6.0 — partial text matching in $filter)

  • startswith / endswith / contains are now supported in $filter on the Consumption API, so an agent can match on partial values instead of first listing distinct ones. Example: startswith(Product,'TV') and Country eq 'US'.

  • Filtering is case-sensitive — 'us' does not match 'US'. Verified against a live tenant; there is no server-side workaround, as tolower() is not in the supported function list.

  • $filter is now validated before it is sent. Unknown fields, non-text columns, and unsupported functions are rejected with a message the model can act on rather than an opaque 400. Values containing a single quote are refused outright — the API has no escape form for them.

  • Federated assets degrade gracefully — an asset whose lineage includes non-replicated sources supports only eq/and/or/(); that failure is now mapped to a message suggesting an equality retry.

  • See CHANGELOG_v1.6.0.md for the full tenant-probe results.

🆕 What's New (v1.3.0 — lean tool profile)

  • Leaner agent-facing tool surface — the server now advertises 39 tools by default (down from 49) by hiding redundant/overlapping metadata-discovery tools and developer diagnostics. Tool handlers are unchanged; only what's advertised to the MCP client is filtered, which improves LLM tool-selection accuracy. Controlled by two env vars:

    • DATASPHERE_TOOL_PROFILE — lean (default) or full (advertise everything)

    • DATASPHERE_EXPOSE_DIAGNOSTICS — false (default) or true (advertise the test_phase* diagnostic tools)

🆕 What's New (v1.2.1 — wave 2026.10)

  • get_asset_variables tool — surfaces input parameters/variables and filter capability annotations declared in OData $metadata. Use it to discover what variables a parameterised view or analytic model expects before querying.

  • Variables & filters parsing — parse_odata_metadata_xml_full returns {columns, variables, filters} in one call; the legacy parse_odata_metadata_xml is preserved as a back-compat wrapper.

  • Aligns with SAP Datasphere wave 2026.10 (May 6, 2026). All calls use the current /api/v1/datasphere/consumption/... path; the superseded dwc form was removed from the codebase in v1.6.0.

🚀 Quick Start

# Install globally
npm install -g @mariodefe/sap-datasphere-mcp

# Run the server
npx @mariodefe/sap-datasphere-mcp

Option 2: Install via PyPI (Python)

# Install from PyPI
pip install sap-datasphere-mcp

# Run the server
sap-datasphere-mcp

See Getting Started Guide for complete setup instructions.


✨ What's New in v1.5.0

🩹 OData V4 annotation parsing for consumption $metadata — Datasphere's consumption APIs return OData 4.0, where semantic info (Common.Label, Analytics.Dimension, Analytics.measure, units, hierarchies) lives in <Annotation Term="â€Ļ"> elements rather than legacy sap:* attributes. The metadata tools now read both forms, restoring previously-empty label, dimensions, and measures on get_relational_metadata / get_analytical_metadata / get_analytical_model. The V2 attribute path is kept as a fallback for older sources. See CHANGELOG_v1.5.0.md.

What's New in v1.4.0

🔏 Config-driven PII / Sensitive-Field Masking — a fail-closed masking layer now runs inside the MCP response pipeline. Sensitive columns are redacted, dropped, hashed, or tokenised before the data ever reaches the LLM, based on a YAML/JSON policy file you control. No prompt can bypass it.

Highlights

  • ✅ DATASPHERE_PII_POLICY — point at a YAML or JSON policy file to activate masking; leave it unset for zero behaviour change.

  • ✅ Five masking actions — redact (***), drop (column removed), hash (SHA-256, deterministic — safe for GROUP BY), partial:N (keep last N chars), tokenize (stable TKN_xxxx surrogate).

  • ✅ Fail-closed — if the policy file is configured but can't be parsed, the server refuses to start. It never silently falls back to serving raw data.

  • ✅ Allowlist mode — lock an asset to an explicit column whitelist; everything else is dropped before column rules even run.

  • ✅ Value-pattern scanning — secondary regex net catches PII in free-text columns (email, IBAN, SSN, phone) with no explicit column rule required.

  • ✅ Audit log — every tool call emits a structured log line with space, asset, masked_fields, and mode — SIEM / EU-AI-Act ready. Raw values are never logged.

  • ✅ audit_only mode — log what would be masked without changing the data; use during policy rollout to validate coverage before enforcing.

  • ✅ Hooked into all 5 data tools — smart_query, query_relational_entity, query_analytical_data, get_space_assets, analyze_column_distribution.


✨ What's New in v1.1.0

🌐 Streamable HTTP Transport — the server now speaks MCP over HTTP as well as stdio, so you can run it as a long-lived service (Docker, ECS, App Runner, behind a reverse proxy) and point multiple clients at the same instance.

Highlights

  • ✅ New --transport http flag — serves MCP Streamable HTTP (spec 2025-03-26) at /mcp, replacing the legacy SSE dual-endpoint dance with a single HTTP route.

  • ✅ Backward compatible — stdio is still the default; existing Claude Desktop / Claude Code configs keep working with zero changes.

  • ✅ Optional bearer-token auth — enable via --auth-token or MCP_HTTP_AUTH_TOKEN. The server warns if bound to a non-loopback interface without one.

  • ✅ /health endpoint — plain JSON liveness probe for load balancers and uptime checks.

  • ✅ Fixed async entry point — new main_sync() wraps asyncio.run(main()) so the console script works reliably on macOS and Linux.

Usage

# stdio (default, unchanged)
sap-datasphere-mcp

# Streamable HTTP on http://127.0.0.1:8080/mcp
sap-datasphere-mcp --transport http --port 8080

# Exposed on LAN with bearer-token auth
MCP_HTTP_AUTH_TOKEN=$(openssl rand -hex 32) \
  sap-datasphere-mcp --transport http --host 0.0.0.0 --port 8080

# Via env vars only (great for Docker / ECS)
MCP_TRANSPORT=http MCP_HTTP_PORT=8080 \
MCP_HTTP_AUTH_TOKEN=$MY_TOKEN \
  sap-datasphere-mcp

Install with HTTP extras

pip install 'sap-datasphere-mcp[http]'   # adds starlette + uvicorn
# or
uv tool install 'sap-datasphere-mcp[http]' --python 3.12

Client call example

curl -N -X POST http://127.0.0.1:8080/mcp/ \
  -H "Content-Type: application/json" \
  -H "Accept: application/json, text/event-stream" \
  -d '{"jsonrpc":"2.0","id":1,"method":"initialize",
       "params":{"protocolVersion":"2025-03-26",
                 "capabilities":{},
                 "clientInfo":{"name":"curl","version":"0"}}}'

CLI / env reference

Flag

Env var

Default

Purpose

--transport

MCP_TRANSPORT

stdio

stdio or http

--host

MCP_HTTP_HOST

127.0.0.1

Bind address in HTTP mode

--port

MCP_HTTP_PORT

8080

Bind port in HTTP mode

--path

MCP_HTTP_PATH

/mcp

URL path for the MCP endpoint

--auth-token

MCP_HTTP_AUTH_TOKEN

(none)

Require Authorization: Bearer <token>

See PR #31 for implementation details.


✨ What's New in v1.0.9

Enhanced Aggregation & Improved Logging - Production-ready smart query enhancements:

v1.0.9 - Smart Query Enhancements:

  • ✅ Simple Aggregation Support - Queries like SELECT COUNT(*) FROM table now work correctly

    • Support for aggregations without GROUP BY (returns single row)

    • Enhanced regex to handle ORDER BY in GROUP BY queries

    • Both simple and grouped aggregations fully supported

  • ✅ Enhanced Asset Detection - Multi-strategy search reduces false warnings

    • Exact name match + contains match for case-insensitive searches

    • Graceful fallback for catalog API limitations

    • Better handling of schema-prefixed views

  • ✅ Improved Logging - Better user experience with clearer messages

    • Info emoji (â„šī¸) instead of warning emoji (âš ī¸) for non-critical messages

    • More accurate descriptions ("not in catalog search" vs "not found")

    • Actionable suggestions only when queries likely to fail

v1.0.8 - Critical Hotfix:

  • ✅ Fixed aggregation fallback bug - Client-side aggregation now works in both primary and fallback paths

v1.0.7 - Smart Query Production Enhancements:

  • ✅ Client-side aggregation for GROUP BY queries

  • ✅ Asset capability detection

  • ✅ Fuzzy table name matching

  • ✅ LIMIT pushdown optimization

Result: 39 tools advertised by default (49 with diagnostics enabled) with a production-ready smart query engine supporting all SQL patterns

See CHANGELOG_v1.0.9.md for complete details.


📊 Current Status

🎉 45 TOOLS AVAILABLE - 44 with real data (98%) | Phases 1-5.1 Complete + Smart Query Engine

  • ✅ Real data integration - all non-diagnostic tools read live tenant data

  • ✅ OAuth 2.0 Authentication - Enterprise-grade security with automatic token refresh

  • ✅ 100% Foundation Tools - All authentication, connection, and user tools working perfectly

  • ✅ 100% Catalog Tools - Complete asset discovery and metadata exploration

  • ✅ 100% Search Tools - Client-side search workarounds for catalog and repository

  • ✅ 100% Database User Management - All 5 tools using real SAP Datasphere CLI

  • ✅ 100% ETL Tools - All 4 Phase 5.1 tools with enterprise-grade data extraction (up to 50K records)

  • ✅ NEW: Data Lineage & Quality - Column search and distribution analysis tools

  • 🟡 1 diagnostic tool - Endpoint testing utility (intentionally mock mode)


📚 Complete Documentation

New! Comprehensive production-ready documentation:

Guide

Description

Time to Read

📖 Getting Started Guide

10-minute quick start with examples

10 min

📋 Tools Catalog

Complete reference for all 44 tools

30 min

🔧 API Reference

Technical API docs with Python/cURL examples

45 min

🚀 Deployment Guide

Production deployment (Docker, K8s, PyPI)

20 min

🐛 Troubleshooting

Common issues and solutions

15 min

Quick Links:


📊 Query Examples & Available Data

The server provides access to 37+ data assets including sales, products, HR, financial, and time dimension data. See QUERY_EXAMPLES.md for complete examples and documentation.

Available Data Assets

  • Sales Data: Detailed orders and analytics (All For Bikes, eBike 100, etc.)

  • Product Catalog: Forklifts ($7,900), Bikes ($288-$699), specifications

  • HR Analytics: Headcount, job classifications, locations

  • Financial Data: Transaction details and GL accounts

  • Time Dimensions: Calendar data from 1900-present

Quick Examples

Sales orders (Relational):

query_relational_entity(
    space_id="SAP_CONTENT",
    asset_id="SAP_SC_SALES_V_SalesOrders",
    entity_name="SAP_SC_SALES_V_SalesOrders",
    select="SALESORDERID,COMPANYNAME,GROSSAMOUNT,CURRENCY",
    top=5
)

Product information (Relational):

query_relational_entity(
    space_id="SAP_CONTENT",
    asset_id="SAP_SC_FI_V_ProductsDim",
    entity_name="SAP_SC_FI_V_ProductsDim",
    select="PRODUCTID,MEDIUM_DESCR,PRICE,CURRENCY",
    top=5
)

Sales analytics (Analytical):

query_analytical_data(
    space_id="SAP_CONTENT",
    asset_id="SAP_SC_SALES_AM_SalesOrders",
    entity_set="SAP_SC_SALES_AM_SalesOrders",
    select="COMPANYNAME,GROSSAMOUNT",
    orderby="GROSSAMOUNT desc",
    top=8
)

Performance: 1-5 second response times, up to 50K records per batch.

See QUERY_EXAMPLES.md for 37+ data assets, 5 detailed examples, and best practices.


🌟 Key Highlights

  • đŸŽ¯ 45 MCP Tools: Comprehensive SAP Datasphere operations via Model Context Protocol

  • 🔐 OAuth 2.0: Production-ready authentication with automatic token refresh

  • 🔏 Built-in PII Masking: Config-driven, fail-closed masking layer — sensitive fields never reach the LLM

  • ✅ Real Data Access: 44 tools (98%) accessing actual tenant data - spaces, assets, users, metadata

  • 🚀 API Integration: 44 tools (98%) with real data integration via API and CLI

  • 🧠 Smart Query Engine: Production-ready SQL support with client-side aggregation for all query types

  • 🔍 Asset Discovery: 36+ real assets discovered (HR, Finance, Sales, Time dimensions)

  • 📊 Data Querying: Execute OData queries and ETL extraction through natural language on real data

  • đŸ§Ŧ Data Lineage: Find assets by column name for impact analysis and lineage tracking

  • 📈 Data Quality: Statistical column analysis with null rates, percentiles, and outlier detection

  • đŸ‘Ĩ User Management: Create, update, and manage database users with real API

  • 🧠 AI Integration: Claude Desktop, Cursor IDE, and other MCP-compatible assistants

  • 🏆 100% Foundation & Catalog Tools: All core discovery tools fully functional

  • đŸ“Ļ Production Ready: Docker, Kubernetes, PyPI + npm packaging available


đŸ› ī¸ Complete Tool Catalog (39 advertised by default, 49 with diagnostics)

🏆 Real Data Success Summary

Category

Total Tools

Real Data

Success Rate

Foundation Tools

5

5 ✅

100%

Catalog Tools

4

4 ✅

100%

Space Discovery

3

3 ✅

100%

Search Tools

2

2 ✅

100% (client-side workarounds)

Data Discovery & Quality

2

2 ✅

100% (v1.0.3 - lineage & profiling)

Database User Management

5

5 ✅

100% (SAP CLI integration)

Metadata Tools

4

4 ✅

100%

Analytical Consumption Tools

4

4 ✅

100% (OData analytical queries)

Additional Tools

5

5 ✅

100% (connections, tasks, marketplace, etc.)

Relational Query Tool

1

1 ✅

100% (SQL to OData conversion)

Smart Query Engine

1

1 ✅

100% (v1.0.9 - all SQL patterns supported)

ETL-Optimized Relational Tools

4

4 ✅

100% (Phase 5.1 - up to 50K records)

Diagnostic Tools

3

0 🟡

Mock Mode (endpoint testing utilities)

Repository Tools (legacy)

2

0 ❌

0% (deprecated - use Catalog instead)

TOTAL

45

44 (98%)

98% Coverage


🔐 Foundation Tools (5 tools) - 100% Real Data ✅

Tool

Status

Description

test_connection

✅ Real Data

Test OAuth connection and get health status

get_current_user

✅ Real Data

Get authenticated user information from JWT token

get_tenant_info

✅ Real Data

Get SAP Datasphere tenant configuration

get_available_scopes

✅ Real Data

List OAuth2 scopes from token

list_spaces

✅ Real Data

List all accessible spaces (DEVAULT_SPACE, SAP_CONTENT)

Example queries:

"Test the connection to SAP Datasphere"
"Who am I? Show my user information"
"What tenant am I connected to?"
"What OAuth scopes do I have?"
"List all SAP Datasphere spaces"

Real Data Examples:

  • Real tenant: your-tenant.eu20.hcs.cloud.sap

  • Real spaces: DEVAULT_SPACE, SAP_CONTENT

  • Real user info from OAuth JWT token

  • Real OAuth scopes (typically 3+ scopes)


🔍 Space Discovery Tools (3 tools) - 100% Real Data ✅

Tool

Status

Description

get_space_info

✅ Real Data

Get detailed information about a specific space

get_table_schema

✅ Real Data

Get column definitions and data types for tables

search_tables

✅ Real Data

Search for tables and views by keyword (client-side filtering)

Example queries:

"Show me details about the SAP_CONTENT space"
"Get the schema for FINANCIAL_TRANSACTIONS table"
"Search for tables containing 'customer'"

Real Data Examples:

  • Real space metadata from API

  • Real table schemas (when tables exist in space)

  • search_tables uses client-side filtering workaround (API doesn't support OData filters)


đŸ“Ļ Catalog & Asset Tools (4 tools) - 100% Real Data ✅

Tool

Status

Description

list_catalog_assets

✅ Real Data

Browse all catalog assets across spaces (36+ assets found!)

get_asset_details

✅ Real Data

Get comprehensive asset metadata and schema

get_asset_by_compound_key

✅ Real Data

Retrieve asset by space and name

get_space_assets

✅ Real Data

List all assets within a specific space

Example queries:

"List all catalog assets in the system"
"Get details for asset SAP_SC_FI_AM_FINTRANSACTIONS"
"Show me all assets in the SAP_CONTENT space"
"Get asset by compound key: space=SAP_CONTENT, id=SAP_SC_HR_V_Divisions"

Real Assets Discovered (36+ real assets):

  • HR Assets: SAP_SC_HR_V_Divisions, SAP_SC_HR_V_JobClass, SAP_SC_HR_V_Location, SAP_SC_HR_V_Job

  • Finance Assets: SAP_SC_FI_V_ProductsDim, SAP_SC_FI_AM_FINTRANSACTIONS

  • Time & Sales Models: Multiple analytical models with real metadata URLs

  • All assets include real metadata URLs pointing to your tenant


🔎 Search Tools (2 tools) - 100% Real Data ✅

Tool

Status

Description

search_catalog

✅ Real Data

Search catalog assets by query (client-side workaround)

search_repository

✅ Real Data

Search repository objects with filters (client-side workaround)

Example queries:

"Search catalog for 'sales'"
"Find repository objects containing 'customer'"
"Search for analytical models in SAP_CONTENT"

Real Data Examples:

  • Client-side search across name, label, businessName, and description fields

  • Support for facets (objectType, spaceId aggregation)

  • Support for filters (object_types, space_id)

  • Support for why_found tracking (shows which fields matched)

  • Pagination and total_matches reporting

Implementation: Both tools use client-side search workarounds since /api/v1/datasphere/consumption/catalog/search endpoint returns 404 Not Found. They fetch all assets from /catalog/assets and filter client-side.


đŸ”Ŧ Data Discovery & Quality Tools (2 tools) - 100% Real Data ✅

Tool

Status

Description

find_assets_by_column

✅ Real Data

Find all assets containing a specific column name for data lineage

analyze_column_distribution

✅ Real Data

Statistical analysis of column data distribution and quality profiling

Example queries:

"Which tables contain CUSTOMER_ID column?"
"Find all assets with SALES_AMOUNT"
"Analyze the distribution of ORDER_TOTAL column"
"What's the data quality of CUSTOMER_AGE field?"
"Profile the PRICE column for outliers"

Real Data Examples:

  • Data Lineage: Cross-space column search, impact analysis before schema changes

  • Quality Profiling: Null rates, distinct values, percentiles, outlier detection (IQR method)

  • Use Cases: Data discovery, schema relationship mapping, data quality assessment, pre-analytics profiling

Implementation: Both tools introduced in v1.0.3 provide advanced data discovery and quality capabilities:

  • find_assets_by_column: Searches across multiple spaces, case-insensitive by default, up to 200 results

  • analyze_column_distribution: Analyzes up to 10,000 records, automatic type detection, percentile analysis


📊 Metadata Tools (4 tools) - 100% Real Data ✅

Tool

Status

Description

get_catalog_metadata

✅ Real Data

Retrieve CSDL metadata schema for catalog service

get_analytical_metadata

✅ Real Data

Get analytical model metadata with pre-flight checks

get_relational_metadata

✅ Real Data

Get relational schema with SQL type mappings

list_analytical_datasets

✅ Real Data

List analytical datasets (fixed query parameters)

Example queries:

"Get the catalog metadata schema"
"Retrieve analytical metadata for SAP_SC_FI_AM_FINTRANSACTIONS"
"Get relational schema for CUSTOMER_DATA table"
"List analytical datasets"

Status: All 4 tools return real data with proper error handling and capability checks.


đŸ‘Ĩ Database User Management Tools (5 tools) - 100% Real Data ✅

Tool

Status

Description

Requires Consent

list_database_users

✅ Real Data

List all database users (SAP CLI)

No

create_database_user

✅ Real Data

Create new database user (SAP CLI)

Yes (ADMIN)

update_database_user

✅ Real Data

Update user permissions (SAP CLI)

Yes (ADMIN)

delete_database_user

✅ Real Data

Delete database user (SAP CLI)

Yes (ADMIN)

reset_database_user_password

✅ Real Data

Reset user password (SAP CLI)

Yes (SENSITIVE)

Example queries:

"List all database users in SAP_CONTENT space"
"Create a new database user named ETL_USER"
"Update permissions for DB_USER_001"
"Delete database user TEST_USER"
"Reset password for DB_USER_001"

Status: All 5 tools use real SAP Datasphere CLI integration with subprocess execution, temporary file handling, and comprehensive error handling.

Consent Management: High-risk operations (create, update, delete, reset password) require user consent on first use. Consent is cached for 60 minutes.


🔧 API Syntax Fixes (4 tools) - 100% Real Data ✅

Tool

Status

Description

search_tables

✅ Real Data

Search tables/views (client-side filtering)

get_deployed_objects

✅ Real Data

List deployed objects (removed unsupported filters)

list_analytical_datasets

✅ Real Data

List datasets (fixed query parameters)

get_analytical_metadata

✅ Real Data

Get metadata (pre-flight capability checks)

Status: All 4 tools fixed during Phase 2 - removed unsupported OData filters and added client-side workarounds.


🔧 HTML Response Fixes (2 tools) - 100% Real Data ✅

Tool

Status

Description

get_task_status

✅ Real Data

Graceful error handling for HTML responses

browse_marketplace

✅ Real Data

Professional degradation for UI-only endpoints

Status: Both tools fixed during Phase 3 - added content-type validation and helpful error messages when endpoints return HTML instead of JSON.


📈 Analytical Consumption Tools (4 tools) - 100% Real Data ✅

Tool

Status

Description

get_analytical_model

✅ Real Data

Get OData service document and analytical model metadata

get_analytical_service_document

✅ Real Data

Get service capabilities, entity sets, and navigation properties

list_analytical_datasets

✅ Real Data

List all analytical datasets and entity sets for a model

query_analytical_data

✅ Real Data

Execute OData analytical queries with $select, $filter, $apply, $top

Example queries:

"Get analytical model for SAP_SC_FI_AM_FINTRANSACTIONS"
"Show me the service document for SAP_SC_HR_V_Divisions"
"List all datasets in the analytical model"
"Query analytical data from SAP_SC_FI_AM_FINTRANSACTIONS with filters"

Real Data Features:

  • OData v4.0 analytical consumption API (/api/v1/datasphere/consumption/analytical)

  • Full metadata discovery (service documents, entity sets, properties)

  • Advanced filtering with $filter, $select, $top, $skip, $orderby

  • Aggregation support with $apply (groupby, aggregate functions)

  • Real tenant data from your SAP Datasphere instance

Status: All 4 analytical consumption tools fully operational with real SAP Datasphere data!


🔌 Additional Tools (5 tools) - 100% Real Data ✅

Tool

Status

Description

list_connections

✅ Real Data

List all configured connections (HANA, S/4HANA, etc.)

get_task_status

✅ Real Data

Monitor task execution status and progress

browse_marketplace

✅ Real Data

Browse Data Marketplace assets and packages

get_consumption_metadata

✅ Real Data

Get consumption layer metadata (CSDL schema)

get_deployed_objects

✅ Real Data

List all deployed objects in a space

Example queries:

"List all connections in the system"
"Check the status of task 12345"
"Browse the Data Marketplace"
"Get consumption metadata schema"
"Show deployed objects in SAP_CONTENT"

Status: All additional tools provide essential system management capabilities with full real data support.


đŸ§Ē Diagnostic Tools (3 tools) - Endpoint Testing Utilities

Tool

Status

Description

test_analytical_endpoints

đŸ§Ē Diagnostic

Test analytical/query API endpoint availability

test_phase67_endpoints

đŸ§Ē Diagnostic

Test Phase 6 & 7 endpoint availability (KPI, monitoring, users)

test_phase8_endpoints

đŸ§Ē Diagnostic

Test Phase 8 endpoint availability (data sharing, AI features)

Purpose: These diagnostic tools help verify which SAP Datasphere API endpoints are available in your specific tenant configuration. They return structured reports with:

  • HTTP status codes for each endpoint

  • Error messages and troubleshooting guidance

  • Recommendations for workarounds or alternative tools

Status: Diagnostic tools intentionally use mock/test mode to validate endpoint availability without modifying data.


đŸ—‚ī¸ Repository Tools (2 tools) - Deprecated (Use Catalog Instead)

Tool

Status

Description

list_repository_objects

âš ī¸ Deprecated

List repository objects (use list_catalog_assets instead)

get_object_definition

âš ī¸ Deprecated

Get object definition (use get_asset_details instead)

Recommendation: These legacy repository tools are deprecated. Use the modern Catalog Tools instead:

  • Replace list_repository_objects → list_catalog_assets or search_catalog

  • Replace get_object_definition → get_asset_details

Status: Catalog Tools provide superior functionality with full real data support.


🔐 Relational Query Tool (1 tool) - 100% Real Data ✅

Tool

Status

Description

Requires Consent

execute_query

✅ Real Data

Execute SQL queries on Datasphere tables/views with SQL→OData conversion

Yes (WRITE)

Example queries:

"Execute query: SELECT * FROM SAP_SC_FI_AM_FINTRANSACTIONS LIMIT 10"
"Query: SELECT customer_id, amount FROM SALES_ORDERS WHERE status = 'COMPLETED' LIMIT 50"
"Get data: SELECT * FROM SAP_SC_HR_V_Divisions"

Real Data Features:

  • SQL to OData Conversion: Automatically converts SQL queries to OData API calls

  • Relational Consumption API: /api/v1/datasphere/consumption/relational/{space_id}/{view_name}

  • Supported SQL Syntax:

    • SELECT * or SELECT column1, column2 → OData $select

    • WHERE conditions → OData $filter (basic conversion)

    • LIMIT N → OData $top

  • Query Safety: Max 1000 rows, 60-second timeout

  • Error Handling: Helpful messages for table not found, parse errors, permission issues

SQL Conversion Examples:

SELECT * FROM CUSTOMERS WHERE country = 'USA' LIMIT 10
→ GET /relational/SPACE/CUSTOMERS?$filter=country eq 'USA'&$top=10

SELECT customer_id, name FROM ORDERS LIMIT 20
→ GET /relational/SPACE/ORDERS?$select=customer_id,name&$top=20

Limitations:

  • No JOINs (OData single-table queries only)

  • Basic WHERE clause conversion (simple comparisons work)

  • No GROUP BY, ORDER BY (future enhancement)

  • Table/view names are case-sensitive

Status: ✅ Fully functional with real SAP Datasphere data! Tested and confirmed working.


🧠 Smart Query Engine (1 tool) - 100% Real Data ✅ NEW v1.0.9!

Tool

Status

Description

Requires Consent

smart_query

✅ Real Data

Intelligent SQL query router with client-side aggregation and multi-tier fallback

No (READ)

Example queries:

"Query: SELECT * FROM SAP_SC_FI_V_ProductsDim LIMIT 5"
"Get product counts by category: SELECT PRODUCTCATEGORYID, COUNT(*) FROM SAP_SC_FI_V_ProductsDim GROUP BY PRODUCTCATEGORYID"
"Simple aggregation: SELECT COUNT(*), AVG(PRICE) FROM SAP_SC_FI_V_ProductsDim"
"Analytics with sorting: SELECT CATEGORY, COUNT(*), AVG(PRICE) FROM Products GROUP BY CATEGORY ORDER BY COUNT(*) DESC"

Real Data Features:

  • Intelligent Routing: Automatically chooses between analytical and relational endpoints based on query type and asset capabilities

  • Client-Side Aggregation: Full support for SQL aggregations when API doesn't support them

    • Simple aggregations: SELECT COUNT(*) FROM table (returns single row)

    • GROUP BY aggregations: SELECT category, COUNT(*) FROM table GROUP BY category

    • All aggregate functions: COUNT, SUM, AVG, MIN, MAX

  • Asset Capability Detection: Multi-strategy search to verify asset support before query execution

  • Enhanced Error Messages: Fuzzy table name matching with actionable suggestions

  • LIMIT Pushdown: Automatically converts SQL LIMIT to OData $top for optimal performance

  • Multi-Tier Fallback: Primary (analytical) → Fallback (relational + aggregation) → Helpful error

Query Types Supported:

-- Simple queries
SELECT * FROM table LIMIT 10

-- Simple aggregations (NEW in v1.0.9)
SELECT COUNT(*) FROM table
SELECT COUNT(*), AVG(price), MAX(price) FROM table

-- GROUP BY aggregations
SELECT category, COUNT(*), AVG(price) FROM table GROUP BY category

-- Complex queries with ORDER BY
SELECT category, COUNT(*) as cnt FROM table GROUP BY category ORDER BY cnt DESC LIMIT 5

Performance:

  • Response Times: 500ms - 2s depending on data volume

  • Batch Size: Up to 50,000 records per query

  • Optimization: LIMIT pushdown reduces data transfer by up to 95%

Status: ✅ Production-ready with comprehensive SQL support! All common query patterns working flawlessly (v1.0.7-v1.0.9 enhancements).


🏭 ETL-Optimized Relational Tools (4 tools) - 100% Real Data ✅ NEW Phase 5.1!

Tool

Status

Description

Requires Consent

list_relational_entities

✅ Real Data

List all available relational entities (tables/views) within an asset for ETL operations

No (READ)

get_relational_entity_metadata

✅ Real Data

Get entity metadata with SQL type mappings (OData→SQL) for data warehouse loading

No (READ)

query_relational_entity

✅ Real Data

Execute OData queries with large batch processing (up to 50,000 records) for ETL extraction

No (READ)

get_relational_odata_service

✅ Real Data

Get OData service document with ETL planning capabilities and query optimization guidance

No (READ)

Example queries:

"List all relational entities in SAP_CONTENT space for asset SAP_SC_SALES_V_Fact_Sales"
"Get entity metadata with SQL types for SAP_CONTENT/SAP_SC_SALES_V_Fact_Sales"
"Query relational entity from SAP_CONTENT, asset SAP_SC_SALES_V_Fact_Sales, entity Results, limit 1000"
"Get OData service document for SAP_CONTENT/SAP_SC_SALES_V_Fact_Sales with ETL capabilities"

Real Data Features:

  • Large Batch Processing: Extract up to 50,000 records per query (vs 1,000 for execute_query)

  • SQL Type Mapping: Automatic OData to SQL type conversion (NVARCHAR, BIGINT, DECIMAL, DATE, etc.)

  • ETL Planning: Service discovery, entity enumeration, batch size recommendations

  • Performance Optimization: Incremental extraction, parallel loading, pagination strategies

  • Production Quality: Sub-second response times with real production data

ETL Use Cases:

  • Data Warehouse Loading: Extract large datasets with proper SQL types for target databases

  • Incremental Extraction: Use $filter with date columns for delta loads

  • Parallel Extraction: Use $skip with multiple concurrent requests for high-volume data

  • Schema Discovery: Get complete metadata with column types, precision, scale before ETL jobs

Advanced Query Capabilities:

OData Parameters Supported:
- $filter: Complex filtering expressions (e.g., "amount gt 1000 and status eq 'ACTIVE'")
- $select: Column projection (e.g., "customer_id,amount,date")
- $top/$skip: Pagination (up to 50K per batch)
- $orderby: Sorting (e.g., "amount desc, date asc")

SQL Type Mapping Examples:

Edm.String       → NVARCHAR(MAX)
Edm.Int32        → INT
Edm.Int64        → BIGINT
Edm.Decimal      → DECIMAL(18,2)
Edm.Double       → DOUBLE
Edm.Date         → DATE
Edm.DateTime     → TIMESTAMP
Edm.Boolean      → BOOLEAN

Endpoint Pattern:

GET /api/v1/datasphere/consumption/relational/{space}/{asset}               → List entities
GET /api/v1/datasphere/consumption/relational/{space}/{asset}/$metadata     → Get metadata
GET /api/v1/datasphere/consumption/relational/{space}/{asset}/{entity}      → Query data

Status: ✅ All 4 tools fully functional with enterprise-grade ETL capabilities! Tested with real production sales data, achieving sub-second performance with large result sets.


🚀 Quick Start

Prerequisites

Python 3.10+
SAP Datasphere account with OAuth 2.0 configured
Technical User with appropriate permissions

Installation

# 1. Clone the repository
git clone https://github.com/MarioDeFelipe/sap-datasphere-mcp.git
cd sap-datasphere-mcp

# 2. Install dependencies
pip install -r requirements.txt

# 3. Configure OAuth credentials
cp .env.example .env
# Edit .env with your SAP Datasphere OAuth credentials

# 4. Start MCP Server
python sap_datasphere_mcp_server.py

Configuration

Create a .env file with your SAP Datasphere credentials:

# SAP Datasphere Connection
DATASPHERE_BASE_URL=https://your-tenant.eu10.hcs.cloud.sap
DATASPHERE_TENANT_ID=your-tenant-id

# OAuth 2.0 Credentials (Technical User)
DATASPHERE_CLIENT_ID=your-client-id
DATASPHERE_CLIENT_SECRET=your-client-secret
DATASPHERE_TOKEN_URL=https://your-tenant.authentication.eu10.hana.ondemand.com/oauth/token

# Optional: Mock Data Mode (for testing without real credentials)
USE_MOCK_DATA=false

âš ī¸ Important: Never commit your .env file to version control!

📖 Need help with OAuth setup? See the complete guide: OAuth Setup Guide


🤖 AI Assistant Integration

Claude Desktop

Option 1: Using npm (Recommended)

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "sap-datasphere": {
      "command": "npx",
      "args": ["@mariodefe/sap-datasphere-mcp"],
      "env": {
        "DATASPHERE_BASE_URL": "https://your-tenant.eu20.hcs.cloud.sap",
        "DATASPHERE_CLIENT_ID": "your-client-id",
        "DATASPHERE_CLIENT_SECRET": "your-client-secret",
        "DATASPHERE_TOKEN_URL": "https://your-tenant.authentication.eu20.hana.ondemand.com/oauth/token"
      }
    }
  }
}

Option 2: Using Python directly

{
  "mcpServers": {
    "sap-datasphere": {
      "command": "python",
      "args": ["-m", "sap_datasphere_mcp_server"],
      "env": {
        "DATASPHERE_BASE_URL": "https://your-tenant.eu20.hcs.cloud.sap",
        "DATASPHERE_CLIENT_ID": "your-client-id",
        "DATASPHERE_CLIENT_SECRET": "your-client-secret",
        "DATASPHERE_TOKEN_URL": "https://your-tenant.authentication.eu20.hana.ondemand.com/oauth/token"
      }
    }
  }
}

Location:

  • Windows: %APPDATA%\Claude\claude_desktop_config.json

  • macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

  • Linux: ~/.config/Claude/claude_desktop_config.json

Example Natural Language Queries

Once configured, ask your AI assistant:

Space & Discovery:

"List all SAP Datasphere spaces"
"Show me the schema for the CUSTOMERS table"
"Search for tables containing 'sales' in SAP_CONTENT"

Metadata Exploration:

"Get the analytical metadata for REVENUE_ANALYSIS"
"Show me the catalog metadata schema"
"Get relational schema for FINANCIAL_TRANSACTIONS"

Analytical Queries:

"Query financial data where Amount > 1000"
"Get analytical model for SALES_ANALYTICS.REVENUE_ANALYSIS"
"Execute aggregation: group by Currency and sum Amount"

User Management:

"List all database users"
"Create a new database user named ETL_READER"
"Update permissions for user DB_USER_001"

Repository Objects:

"Get the complete definition for SAP_SC_FI_AM_FINTRANSACTIONS"
"Show me all assets in SAP_CONTENT space"
"Get repository search metadata"

🔒 Security Features

OAuth 2.0 Authentication

  • ✅ Client Credentials Flow: Secure Technical User authentication

  • ✅ Automatic Token Refresh: Tokens refreshed 60 seconds before expiration

  • ✅ Encrypted Storage: Tokens encrypted in memory using Fernet encryption

  • ✅ No Credentials in Code: All secrets loaded from environment variables

  • ✅ Retry Logic: Exponential backoff for transient failures

  • ✅ Permission Levels: READ, WRITE, ADMIN, SENSITIVE

  • ✅ User Consent: Interactive prompts for high-risk operations

  • ✅ Audit Logging: Complete operation audit trails

  • ✅ Input Validation: SQL injection prevention with 15+ attack patterns

  • ✅ Data Filtering: Automatic PII and credential redaction

Security Best Practices

  • 🔐 Environment-based Configuration: No hardcoded credentials

  • 🔒 HTTPS/TLS: All communications encrypted

  • 📝 Comprehensive Logging: Detailed security audit trails

  • 🔑 Token Management: Automatic refresh and secure rotation

  • đŸ›Ąī¸ SQL Sanitization: Read-only queries, injection prevention


🔏 PII / Sensitive-Field Masking

The server ships a config-driven, fail-closed PII masking layer that runs inside the MCP response pipeline. Every data-returning tool (smart_query, query_relational_entity, query_analytical_data, get_space_assets, analyze_column_distribution) funnels results through apply_masking() before the data reaches the LLM client.

Defense-in-depth note. The authoritative access control remains upstream (SAP Datasphere Data Access Controls / not granting the technical user access to PII tables). This layer is the enforced, auditable net on top — no prompt can bypass it.

Configuration

Environment Variable

Values

Default

Purpose

DATASPHERE_PII_POLICY

path to YAML or JSON

(unset)

Policy file path. When unset masking is fully disabled — backwards-compatible default.

DATASPHERE_PII_MODE

enforce | audit_only | off

enforce (when policy present)

audit_only logs what would be masked but passes data through; off disables.

DATASPHERE_PII_SALT

secret string

(empty)

Salt for deterministic hash / tokenize actions. Treat as a secret — never log.

# .env
DATASPHERE_PII_POLICY=/etc/datasphere/pii_policy.yaml
DATASPHERE_PII_MODE=enforce
DATASPHERE_PII_SALT=my-very-secret-salt

Fail-closed behaviour

If DATASPHERE_PII_POLICY is set but the file is missing or unparseable, the server raises a RuntimeError at startup and refuses to start. It never silently falls back to serving raw data with a broken policy.

Policy file schema

See the bundled pii_policy.yaml for a full annotated example. Key concepts:

mode: enforce           # overridden by DATASPHERE_PII_MODE if set
default_action: redact  # applied to value-pattern matches and unknown actions

rules:
  # Most-specific match wins: asset-level > space-level > global > glob pattern
  - space: ZDCS_08
    asset: ZR_SAP_CUSTOMER
    columns:
      EMAIL:  redact       # → "***"
      PHONE:  partial:4    # keep last 4 chars → "******1234"
      TAXID:  hash         # sha256(salt:value) — deterministic, supports grouping
      SSN:    drop         # column removed from every returned row entirely
  - space: "*"             # applies to every space
    columns:
      "*IBAN*": tokenize   # glob match on column name → "TKN_<8hex>"

allowlist:
  enabled: true
  assets:
    ZDCS_08.ZR_OTC_CUST_MONTH: [CUSTOMER, MONTH, REVENUE]  # ONLY these cols returned

patterns:
  email: '[A-Za-z0-9._%+\-]+@[A-Za-z0-9.\-]+\.[A-Za-z]{2,}'
  iban:  '\b[A-Z]{2}\d{2}[A-Z0-9]{10,30}\b'

Masking actions

Action

Result

Deterministic?

redact

"***"

N/A

drop

column removed from row

N/A

hash

sha256(salt:value) hex string

✅ — safe for GROUP BY / JOIN

partial:N

last N chars kept, rest replaced with *

N/A

tokenize

"TKN_<first8 of hash>" stable surrogate

✅

Precedence

  1. Allowlist (strongest): if enabled for an asset, all non-listed columns are dropped before rules run.

  2. Column rules: most-specific match wins (asset > space > global; exact > glob).

  3. Value patterns: scanned on remaining string values; match → default_action.

Audit log

Every tool call emits a structured log line at INFO level:

[pii_masking] space=ZDCS_08 asset=ZR_SAP_CUSTOMER rows=42
              masked_fields=['EMAIL', 'PHONE', 'SSN'] mode=enforce

Raw masked values are never logged. This provides SIEM / EU-AI-Act evidence that masking fired on every call.

The MCP response also includes a masked_fields key listing which columns were touched, so the LLM client can see what was withheld.


📊 Architecture

System Architecture

┌─────────────────┐    ┌──────────────────┐    ┌─────────────────┐
│   AI Assistant  │◄──â–ē│   MCP Server     │◄──â–ē│  SAP Datasphere │
│ (Claude, Cursor)│    │  32 Tools        │    │   (OAuth 2.0)   │
│                 │    │  Authorization   │    │                 │
│                 │    │  Caching         │    │                 │
│                 │    │  Telemetry       │    │                 │
└─────────────────┘    └──────────────────┘    └─────────────────┘

Core Components

Authentication Layer:

  • auth/oauth_handler.py - Token management and refresh

  • auth/datasphere_auth_connector.py - Authenticated API connector

  • auth/authorization.py - Permission-based authorization

  • auth/consent_manager.py - User consent tracking

Security Layer:

  • auth/input_validator.py - Input validation framework

  • auth/sql_sanitizer.py - SQL injection prevention

  • auth/data_filter.py - PII and credential redaction

Performance Layer:

  • cache_manager.py - Intelligent caching with TTL

  • telemetry.py - Request tracking and metrics

MCP Server:

  • sap_datasphere_mcp_server.py - Main server (39 tools advertised, 49 with diagnostics)


🚀 Production Deployment

Quick Deployment Options

Docker (Recommended):

# Build and run
docker build -t sap-datasphere-mcp:latest .
docker run -d --name sap-mcp --env-file .env sap-datasphere-mcp:latest

# Using Docker Compose
docker-compose up -d

PyPI Package (Coming Soon):

pip install sap-datasphere-mcp
sap-datasphere-mcp

Kubernetes:

# Create secrets
kubectl create secret generic sap-mcp-secrets \
  --from-literal=DATASPHERE_CLIENT_ID='...' \
  --from-literal=DATASPHERE_CLIENT_SECRET='...'

# Deploy
kubectl apply -f k8s/deployment.yaml
kubectl scale deployment sap-mcp-server --replicas=5

Manual:

git clone https://github.com/MarioDeFelipe/sap-datasphere-mcp.git
cd sap-datasphere-mcp
pip install -r requirements.txt
cp .env.example .env  # Edit with your credentials
python sap_datasphere_mcp_server.py

📖 See DEPLOYMENT.md for complete production deployment guide


📈 Performance Characteristics

Response Times

  • ⚡ Metadata Queries: Sub-100ms (cached)

  • ⚡ Catalog Queries: 100-500ms

  • ⚡ OData Queries: 500-2000ms (depends on data volume)

  • ⚡ Token Refresh: Automatic, transparent to user

Caching Strategy

  • 📊 Spaces: 1 hour TTL

  • đŸ“Ļ Assets: 30 minutes TTL

  • 🔍 Metadata: 15 minutes TTL

  • đŸ‘Ĩ Users: 5 minutes TTL

  • 🔄 LRU Eviction: Automatic cleanup of old entries

Scalability

  • 🔄 Concurrent Requests: Multiple simultaneous MCP operations

  • đŸ›Ąī¸ Error Recovery: Automatic retry with exponential backoff

  • 📊 Connection Pooling: Efficient resource management


đŸ§Ē Testing

Run Tests

# Test MCP server startup
python test_mcp_server_startup.py

# Test authorization coverage
python test_authorization_coverage.py

# Test input validation
python test_validation.py

# Test with MCP Inspector
npx @modelcontextprotocol/inspector python sap_datasphere_mcp_server.py

Test Results

Current suite: run pytest for the live number. The counts below are a point-in-time record from the v1.0.x era and are kept for history only.

  • ✅ 42/42 tools registered (as of v1.0.9) - All tools properly defined

  • ✅ 42/42 tools authorized (as of v1.0.9) - Authorization permissions configured

  • ✅ 41/42 tools working (as of v1.0.9) - 98% success rate


📁 Project Structure

sap-datasphere-mcp/
├── 📁 auth/                            # Authentication & Security
│   ├── oauth_handler.py                # OAuth 2.0 token management
│   ├── datasphere_auth_connector.py    # Authenticated API connector
│   ├── authorization.py                # Permission-based authorization
│   ├── consent_manager.py              # User consent tracking
│   ├── input_validator.py              # Input validation framework
│   ├── sql_sanitizer.py                # SQL injection prevention
│   └── data_filter.py                  # PII and credential redaction
├── 📁 config/                          # Configuration management
│   └── settings.py                     # Environment-based settings
├── 📁 docs/                            # Documentation
│   ├── OAUTH_SETUP.md                  # OAuth setup guide
│   ├── TROUBLESHOOTING_CLAUDE_DESKTOP.md
│   └── OAUTH_IMPLEMENTATION_STATUS.md
├── 📄 sap_datasphere_mcp_server.py     # Main MCP server (39 lean / 49 full)
├── 📄 odata_v4_annotations.py          # OData V4 CSDL annotation reader (V2 fallback)
├── 📄 odata_filter.py                  # $filter parsing, validation, capability gating
├── 📄 asset_capability.py              # Per-asset countability / filter profile
├── 📄 pii_masking.py                   # Config-driven PII masking (fail-closed)
├── 📄 error_helpers.py                 # Actionable error construction
├── 📄 tool_descriptions.py             # Tool text and visibility profiles
├── 📄 cache_manager.py                 # Intelligent caching
├── 📄 telemetry.py                     # Monitoring and metrics
├── 📄 mock_data.py                     # Mock data for testing
├── 📄 pii_policy.yaml                  # Masking policy (editable)
├── 📄 .env.example                     # Configuration template
├── 📄 requirements.txt                 # Python dependencies
├── 📄 README.md                        # This file
└── 📄 ULTIMATE_TEST_RESULTS.md         # Comprehensive test results

🙏 Acknowledgments

This MCP server was built with significant contributions from:

Amazon Kiro

Provided comprehensive specifications, architectural steering, and development guidance that shaped the MCP server's design and implementation.

Claude Code

AI-powered development assistant that contributed to:

Phase 1: Security & Authentication

  • OAuth 2.0 implementation with automatic token refresh

  • Permission-based authorization (READ, WRITE, ADMIN, SENSITIVE)

  • User consent flows for high-risk operations

  • Input validation and SQL sanitization

  • Sensitive data filtering and PII redaction

Phase 2: UX & AI Interaction

  • Enhanced tool descriptions with examples

  • Intelligent error messages with recovery suggestions

  • Parameter validation with clear format requirements

Phase 3: Performance & Monitoring

  • Intelligent caching with category-based TTL

  • Comprehensive telemetry and metrics

  • Performance optimization (up to 95% faster for cached queries)

Phase 4: Repository & Analytics

  • Repository object discovery tools

  • Analytical model access and OData query support

  • Metadata extraction and schema discovery

Mock Data Remediation Journey:

  • Phase 1: Database User Management (5/5 tools) - SAP CLI integration ✅

  • Phase 2: API Syntax Fixes (4/4 tools) - OData filter workarounds ✅

  • Phase 3: HTML Response Fixes (2/2 tools) - Graceful degradation ✅

  • Phase 4: Search Workarounds (2/2 tools) - Client-side search ✅

  • Achievement: From 42.9% → 80% real data integration! đŸŽ¯


📄 License

This project is licensed under the MIT License - see the LICENSE file for details.


📞 Support


đŸŽ¯ Roadmap

Completed ✅

  • OAuth 2.0 authentication with automatic token refresh

  • 35 MCP tools implementation

  • đŸŽ¯ TARGET ACHIEVED: 80% real data integration (28/35 tools)

  • Authorization and consent management

  • Input validation and SQL sanitization

  • Intelligent caching and telemetry

  • Phase 1: Database User Management (5/5 tools) - SAP CLI integration

  • Phase 2: API Syntax Fixes (4/4 tools) - OData filter workarounds

  • Phase 3: HTML Response Fixes (2/2 tools) - Graceful degradation

  • Phase 4: Search Workarounds (2/2 tools) - Client-side search

  • Comprehensive testing with real SAP Datasphere tenant

  • 36+ real assets discovered (HR, Finance, Sales, Time dimensions)

  • 100% Foundation, Catalog, Search, Metadata & User Management Tools

Future Enhancements 🔮

  • Analytical tools real data integration (requires tenant configuration)

  • Enhanced query execution capabilities

  • Additional permission scopes for restricted endpoints

  • Vector database integration for semantic search

  • Real-time event streaming

  • Advanced schema visualization

  • Multi-tenant support

  • Machine learning integration


🏆 Production-Ready SAP Datasphere MCP Server

đŸŽ¯ TARGET ACHIEVED: 28/35 Tools with Real Data (80%)

36+ Real Assets Discovered | All Critical Tools Working

GitHub stars MCP Compatible Real Data API Integration

Built with â¤ī¸ for AI-powered enterprise data integration

From 42.9% → 80% real data integration through systematic mock data remediation!

Available Tools

39 tools
analyze_column_distributionA

Perform advanced statistical analysis of a column's data distribution including nulls, distinct values, percentiles, and outlier detection.

Use this tool when:

  • User asks "What's the data quality of AMOUNT column?"

  • Performing data profiling before analytics

  • Assessing column completeness and distribution

  • Detecting outliers and data anomalies

  • Understanding data patterns for ML/AI

What you'll get:

  • Basic statistics (count, nulls, distinct values, completeness)

  • Numeric statistics (min, max, mean, percentiles)

  • Distribution analysis (top values, frequency)

  • Outlier detection (IQR method)

  • Data quality assessment

Use cases:

  • Data quality assessment

  • Pre-analytics data profiling

  • Outlier and anomaly detection

  • Understanding value distributions

  • ML feature engineering preparation

  • Data cleansing planning

Example queries:

  • "Analyze the distribution of SALES_AMOUNT column"

  • "What's the data quality of CUSTOMER_AGE?"

  • "Profile the ORDER_STATUS column"

  • "Detect outliers in PRICE column"

  • "Show me statistics for QUANTITY field"

Analysis includes:

  • Null percentage and completeness rate

  • Distinct value count and cardinality

  • For numeric columns: min, max, mean, percentiles (p25, p50, p75)

  • Top value frequencies

  • Outlier detection using IQR method

  • Data quality recommendations

Performance notes:

  • Analyzes up to 10,000 records (configurable)

  • Default sample size: 1,000 records

  • Works with numeric, string, and date columns

  • Automatic type detection and appropriate statistics

ParametersJSON Schema
NameRequiredDescriptionDefault
space_idYesSpace ID containing the asset (e.g., 'SAP_CONTENT', 'SALES_ANALYTICS')
asset_nameYesAsset (table/view) name containing the column
column_nameYesColumn name to analyze (e.g., 'SALES_AMOUNT', 'CUSTOMER_AGE', 'ORDER_STATUS')
sample_sizeNoOptional: Number of records to analyze (10-10000). Default: 1000. Larger samples = more accurate but slower.
include_outliersNoOptional: Detect and report outliers using IQR method. Default: true

TDQS

A4.1/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Without annotations, the description carries the full burden and discloses key behaviors such as sampling up to 10,000 records, default sample size 1,000, support for numeric/string/date columns, and automatic type detection. It does not mention side effects because it is a read-only analysis, but the disclosed operational traits are sufficient for informed use.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness3/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with sections, but it is lengthy and contains redundancy: 'What you'll get' and 'Analysis includes' overlap, and use cases repeat the 'Use this tool when' content. It could be trimmed significantly without losing value.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the absence of an output schema, the description compensates effectively with a 'What you'll get' section that outlines return information, plus performance notes and examples. It covers all essential aspects—purpose, usage, behavior, and parameters—making it complete for an AI agent.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100% with detailed descriptions for all parameters, including defaults and bounds (e.g., sample_size min/max, include_outliers default). The description adds little beyond the schema; the 'Performance notes' mostly echo parameter constraints, so the baseline of 3 is appropriate.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description explicitly states 'Perform advanced statistical analysis of a column's data distribution including nulls, distinct values, percentiles, and outlier detection.' This uses a specific verb and resource, and clearly differentiates from siblings like get_table_schema or execute_query by focusing on distribution profiling and statistics.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Provides an explicit 'Use this tool when' list and multiple example queries, giving clear context for when to deploy this tool. However, it does not explicitly state when not to use it or name alternative tools, so it falls short of a 5.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

browse_marketplaceA

Browse and search available data packages in the SAP Datasphere marketplace.

Use this tool when:

  • User asks "What data packages are available?"

  • Looking for external reference data (benchmarks, currency rates, etc.)

  • Exploring marketplace offerings

  • Planning to enrich internal data with external sources

What you'll get:

  • Package IDs and names

  • Package descriptions and categories

  • Provider information

  • Package versions and sizes

  • Pricing information (Free or paid)

Categories:

  • Reference Data (industry benchmarks, standards)

  • Financial Data (currency rates, market data)

  • Geospatial Data

  • Industry-specific datasets

Example queries:

  • "What marketplace packages are available?"

  • "Find financial data packages"

  • "Show me industry benchmarks"

  • "Search for currency rate data"

Use cases:

  • Data enrichment planning

  • Finding external reference data

  • Competitive benchmarking

  • Currency conversion support

ParametersJSON Schema
NameRequiredDescriptionDefault
categoryNoOptional: Filter by category (e.g., 'Reference Data', 'Financial Data'). Leave empty to browse all.
search_termNoOptional: Search keyword for package names or descriptions (e.g., 'currency', 'benchmark'). Case-insensitive.

TDQS

A4.5/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Since no annotations are provided, the description carries the full burden. It discloses the read-only nature implicitly through 'Browse and search' and details the expected output fields (package IDs, names, descriptions, categories, provider info, versions, sizes, pricing). It does not mention side effects, authentication requirements, or limitations, but for a non-mutating marketplace browse tool, this is acceptable and adds meaningful context.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with clear sections (when to use, what you'll get, categories, examples, use cases). It is front-loaded with the main purpose, and every section provides actionable information. There is no filler or redundant content.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Although the tool is simple (2 optional params, no output schema), the description is comprehensive. It explains the tool's scope, typical use cases, example queries, and the structure of returned data. For an AI agent, it provides enough context to decide when and how to invoke the tool without additional information.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema already documents both parameters with descriptions, and schema coverage is 100%. The description adds value beyond the schema by supplying example queries and categories that clarify how to use the filters (e.g., 'currency' or 'benchmark' for search_term). This helps the agent map natural language to parameter values.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose with a specific verb and resource: 'Browse and search available data packages in the SAP Datasphere marketplace.' It is distinctly different from sibling tools, which focus on connections, tables, queries, and administrative operations. The description also enumerates the types of data returned, further reinforcing its unique purpose.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description includes an explicit 'Use this tool when:' section with concrete scenarios (e.g., 'What data packages are available?', 'Looking for external reference data'). It also provides example queries and use cases. However, it does not explicitly mention when not to use the tool or any sibling alternatives, so it stops short of full guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

create_database_userA

Create a new database user in a SAP Datasphere space with specified permissions.

IMPORTANT: This is a HIGH-RISK tool that requires user consent before execution.

Use this tool when:

  • User requests "Create a database user named JEFF in SALES"

  • Setting up new user access for applications or analysts

  • Configuring data ingestion users

  • Establishing read-only consumption users

Required parameters:

  • space_id: The space where user will be created

  • database_user_id: User name suffix (e.g., 'JEFF', 'REPORTING_USER')

  • user_definition: JSON object defining permissions and settings

User definition structure:

{
  "consumption": {
    "consumptionWithGrant": false,
    "spaceSchemaAccess": false,
    "scriptServerAccess": false,
    "enablePasswordPolicy": false,
    "localSchemaAccess": false,
    "hdiGrantorForCupsAccess": false
  },
  "ingestion": {
    "auditing": {
      "dppRead": {
        "isAuditPolicyActive": false,
        "retentionPeriod": 7
      },
      "dppChange": {
        "isAuditPolicyActive": false,
        "retentionPeriod": 7
      }
    }
  }
}

Permission types:

  • Consumption: Read access to space data

    • consumptionWithGrant: Allow granting privileges to others

    • spaceSchemaAccess: Access to space schema objects

    • scriptServerAccess: Execute stored procedures/UDFs

  • Ingestion: Write access for data loading

    • Audit policies for compliance (DPP read/change tracking)

Security notes:

  • New password is auto-generated and returned (store securely!)

  • Audit retention period: 1-365 days

  • Minimum privilege principle recommended

  • Password must be changed on first login

Example queries:

  • "Create a read-only database user named ANALYST in SALES"

  • "Set up a database user for data loading in FINANCE"

  • "Create user REPORTING with consumption access"

Note: Corresponds to CLI: datasphere dbusers create --space --databaseuser --file-path <def.json>

ParametersJSON Schema
NameRequiredDescriptionDefault
space_idYesThe space ID where user will be created (e.g., 'SALES', 'FINANCE'). Must be uppercase.
output_fileNoOptional: Path to save user credentials JSON (e.g., 'jeff.json'). RECOMMENDED for security - credentials shown only once!
user_definitionYesJSON object defining user permissions and settings. Must include 'consumption' and 'ingestion' sections.
database_user_idYesDatabase user name suffix (e.g., 'JEFF', 'ANALYST', 'ETL_USER'). Will be prefixed with space name.

TDQS

A4.8/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden. It explicitly flags the tool as HIGH-RISK, requires user consent, states that passwords are auto-generated and shown once, and includes security notes about retention and privilege principles. This goes beyond a typical create operation.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is long but well-structured with headings, bullet lists, a JSON example, and a CLI mapping. The high-risk warning is front-loaded, and every section adds practical value for such a complex tool.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the complex nested parameters, absence of output schema, and high-risk nature, the description is remarkably complete. It covers return behavior ('password is auto-generated and returned'), parameter details, security warnings, usage examples, and even a CLI equivalent.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters5/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, but the description adds substantial meaning: it explains the nested user_definition structure in detail, clarifies that database_user_id is a suffix prefixed with space name, and recommends output_file for credential safety. This far exceeds the schema descriptions.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a specific verb+resource: 'Create a new database user in a SAP Datasphere space with specified permissions.' It clearly distinguishes this from sibling tools like list_database_users, update_database_user, and delete_database_user by focusing on creation.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides explicit 'Use this tool when' bullets and example queries, making the intended use clear. It does not include when-not-to-use or alternative tool recommendations, but the context is strong enough for selection.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

delete_database_userA

Delete a database user from a SAP Datasphere space.

IMPORTANT: This is a HIGH-RISK tool that requires user consent before execution. WARNING: This action is IRREVERSIBLE. User and all associated permissions are permanently deleted.

Use this tool when:

  • User explicitly requests "Delete database user JEFF from SALES"

  • Decommissioning user accounts

  • Removing unauthorized access

  • Cleaning up test/temporary users

  • User left organization

What happens:

  • User account is permanently deleted

  • All active sessions terminated immediately

  • All granted privileges revoked

  • Cannot be undone - must recreate if needed

  • Deletion is logged for audit

Required parameters:

  • space_id: The space containing the database user

  • database_user_id: The user to delete

  • force: Optional flag to skip confirmation dialog

Safety considerations:

  • PERMANENT deletion - no recovery possible

  • Verify user identity and authorization

  • Check if user owns any objects (may cause errors)

  • Document reason for deletion

  • Consider deactivating instead of deleting

Before deleting:

  1. List user's current permissions (list_database_users)

  2. Verify no applications depend on this user

  3. Check if user owns database objects

  4. Get management approval for production users

  5. Document deletion in change log

Example queries:

  • "Delete database user JEFF from SALES space"

  • "Remove TEMP_USER from FINANCE"

  • "Delete TEST_ANALYST - no longer needed"

Best practices:

  • Always confirm with user before deleting

  • Use force=false for interactive confirmation

  • Keep audit trail of deletions

  • For temporary removal, consider update instead

Note: Corresponds to CLI: datasphere dbusers delete --space --databaseuser [--force]

ParametersJSON Schema
NameRequiredDescriptionDefault
forceNoSkip confirmation dialog. Default: false (ask for confirmation). Set true only if user explicitly confirmed deletion.
space_idYesThe space ID containing the database user (e.g., 'SALES', 'FINANCE'). Must be uppercase.
database_user_idYesDatabase user name suffix to delete (e.g., 'JEFF', 'TEMP_USER'). WILL BE PERMANENTLY DELETED.

TDQS

A4.9/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description takes full responsibility for disclosing behavioral traits. It explicitly states the action is IRREVERSIBLE, permanently deletes the user, terminates all active sessions, revokes all privileges, and logs the deletion for audit. It also warns about potential errors if the user owns objects, going well beyond what annotations could convey.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Although the description is long, it is highly structured with sections (IMPORTANT, WARNING, Use this tool when, What happens, Required parameters, Safety considerations, Before deleting, Example queries, Best practices, Note). Each section earns its place by addressing a distinct concern—risk, use cases, effects, parameters, safety, procedure, examples, best practices, and CLI mapping. No fluff.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the high-risk nature, absence of annotations, and lack of output schema, the description leaves nothing to guesswork. It covers the action, consequences, prerequisites, safety checks, step-by-step pre-deletion actions, example queries, and even a CLI equivalent. The tool is fully contextualized within its environment, making it safe for an agent to act on.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents each parameter clearly. The description adds value by grouping them under 'Required parameters,' clarifying the force flag as optional, providing example queries that map to parameter values, and noting the uppercase requirement for space_id. While not dramatically expanding on the schema, it reinforces practical usage.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states 'Delete a database user from a SAP Datasphere space' with a specific verb and resource, and it distinguishes itself from sibling tools like create_database_user, update_database_user, and reset_database_user_password by focusing solely on deletion. The explicit 'Use this tool when' list reinforces its unique purpose.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides explicit when-to-use scenarios (e.g., 'User explicitly requests...', 'Decommissioning user accounts') and a detailed 'Before deleting' checklist that includes verifying dependencies and getting approvals. It also suggests an alternative ('Consider deactivating instead of deleting') and references sibling tools like list_database_users for pre-checks, making usage boundaries crystal clear.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

execute_queryA

Execute read-only SQL queries against SAP Datasphere tables to retrieve and analyze data.

IMPORTANT: This is a HIGH-RISK tool that requires user consent before execution.

Use this tool when:

  • User explicitly requests data retrieval (e.g., "Show me customers from USA")

  • Need to perform data analysis with aggregations

  • Joining multiple tables for insights

  • Filtering and sorting data

Capabilities:

  • SELECT queries with full SQL syntax (WHERE, JOIN, GROUP BY, ORDER BY, LIMIT)

  • Read-only access - NO write operations allowed

  • Results limited to 100 rows by default (configurable via limit parameter)

  • Automatic query sanitization and injection prevention

Security & Restrictions:

  • Only SELECT statements allowed

  • Blocked operations: INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, etc.

  • No SQL comments allowed (security risk)

  • Queries sanitized to prevent injection attacks

  • User consent required before execution (high-risk operation)

Query best practices:

  1. Always specify a LIMIT to control result size

  2. Use WHERE clauses to filter data efficiently

  3. Check table schema first with get_table_schema()

  4. Use qualified table names when joining

Example queries:

  • "SELECT * FROM CUSTOMER_DATA WHERE country = 'USA' LIMIT 10"

  • "SELECT customer_id, SUM(amount) as total FROM SALES_ORDERS GROUP BY customer_id ORDER BY total DESC LIMIT 20"

  • "SELECT c.customer_name, o.order_date, o.amount FROM CUSTOMER_DATA c JOIN SALES_ORDERS o ON c.customer_id = o.customer_id WHERE o.status = 'COMPLETED' LIMIT 50"

Error handling:

  • Invalid SQL syntax: Returns syntax error with guidance

  • Forbidden operations: Blocked with explanation

  • Missing tables: Suggests using search_tables() to find correct name

  • Permission denied: Explains consent requirement

Note: This tool uses mock data in development. Real query execution requires OAuth authentication.

ParametersJSON Schema
NameRequiredDescriptionDefault
limitNoMaximum number of rows to return. Default: 100. Range: 1-1000. Use smaller limits for faster responses.
space_idYesThe Datasphere space ID where tables exist (e.g., 'SALES_ANALYTICS', 'FINANCE_DWH'). Must be uppercase.
sql_queryYesThe SELECT query to execute. Must start with SELECT. Examples: 'SELECT * FROM CUSTOMER_DATA LIMIT 10', 'SELECT customer_id, COUNT(*) FROM SALES_ORDERS GROUP BY customer_id'

TDQS

A4.3/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden. It discloses critical behaviors: read-only access, blocked operations (INSERT, UPDATE, etc.), no SQL comments, query sanitization, user consent requirement, default row limit, and mock-data/OAuth notes. It even labels itself 'HIGH-RISK', providing strong transparency.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with headers, bullet points, and front-loaded purpose and risk warnings. It is verbose and contains some redundancy (e.g., 'no write operations' repeated, 'user consent' mentioned twice), but each section adds useful information. Slightly over-long but organized enough to earn a 4.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the complexity (SQL execution, security restrictions), the description covers use cases, capabilities, security rules, best practices, examples, error handling, and environment-specific notes. However, with no output schema, it does not explicitly describe the exact response format (e.g., array of objects), leaving a minor gap in completeness.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

All three parameters have rich descriptions in the input schema, covering defaults, ranges, case requirements, and syntax examples. The tool description adds examples and best practices but does not introduce new parameter semantics beyond what the schema already provides. Baseline of 3 is appropriate due to 100% schema coverage.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a specific verb and resource: 'Execute read-only SQL queries against SAP Datasphere tables to retrieve and analyze data.' It clearly states the tool's purpose and scope (read-only SQL on tables), distinguishing it from siblings like query_analytical_data or query_relational_entity. Examples further reinforce the SELECT-only nature.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description includes a dedicated 'Use this tool when:' section with explicit scenarios (data retrieval, aggregations, joins, filtering). It also suggests checking table schema with get_table_schema() and mentions using search_tables() for missing tables. However, it does not explicitly name alternative tools or provide 'when not to use' exclusions, which prevents a 5.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

find_assets_by_columnA

Find all assets (tables/views) containing a specific column name across SAP Datasphere spaces.

Use this tool when:

  • User asks "Which tables contain CUSTOMER_ID?"

  • Performing data lineage analysis

  • Impact analysis before schema changes

  • Finding datasets for specific use cases

  • Locating related data across spaces

What you'll get:

  • Asset names and types (View, Table, etc.)

  • Space IDs where assets are located

  • Column information (name, type, position)

  • Total column count per asset

  • Consumption URLs for data access

Use cases:

  • Data lineage discovery (find all uses of a column)

  • Impact analysis (before renaming/removing columns)

  • Dataset discovery (find tables with specific fields)

  • Cross-space data exploration

  • Schema relationship mapping

Example queries:

  • "Find all tables with CUSTOMER_ID column"

  • "Which views contain SALES_AMOUNT?"

  • "Show me assets with COUNTRY_CODE in SAP_CONTENT space"

  • "List tables that have ORDER_DATE column"

Performance notes:

  • Searches across multiple spaces by default

  • Uses intelligent caching for better performance

  • Results limited to 50 assets by default (configurable)

  • Case-insensitive search by default

ParametersJSON Schema
NameRequiredDescriptionDefault
space_idNoOptional: Limit search to specific space (e.g., 'SAP_CONTENT'). Leave empty to search all spaces.
max_assetsNoOptional: Maximum number of matching assets to return (1-200). Default: 50
column_nameYesColumn name to search for (case-insensitive by default). Examples: 'CUSTOMER_ID', 'SALES_AMOUNT', 'ORDER_DATE'
case_sensitiveNoOptional: Perform case-sensitive column name matching. Default: false

TDQS

A4.2/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It adds useful details such as multi-space search by default, intelligent caching, a configurable 50-asset limit, and case-insensitive search. While it doesn't cover error handling or pagination, it gives a solid behavioral picture beyond the basic function.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with clear sections (overview, when to use, expected results, use cases, examples, performance notes). It is somewhat long but each section adds value and the core purpose is front-loaded. No wasted sentences, but it could be slightly more concise without losing substance.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a search tool with no output schema and no annotations, this description is remarkably complete. It explicitly lists what the user will get (asset names, types, space IDs, column info, URLs), covers a wide range of use cases and example queries, and even notes performance characteristics. This fully compensates for the missing structured metadata.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema descriptions already cover 100% of parameters, so the baseline is 3. The tool description reinforces parameter usage through example queries but does not add significant semantic meaning beyond what the schema already provides. It correctly mentions default behaviors like case-insensitivity and the 50-asset limit, which appear in schema defaults.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses a specific verb+resource+scope: 'Find all assets (tables/views) containing a specific column name across SAP Datasphere spaces.' This clearly distinguishes it from siblings like search_tables or get_table_schema, and the detailed use cases reinforce the tool's specialty in column-based discovery.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides explicit 'Use this tool when' bullets and multiple use cases, giving clear context for when to invoke it. However, it does not explicitly name alternative tools or state 'when not to use' this tool, so it stops short of a perfect score.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_analytical_metadataA

Retrieve CSDL metadata for analytical consumption of a specific asset. Returns analytical schema with dimensions, measures, hierarchies, and aggregation information for BI and analytics integration. Automatically identifies analytical elements based on SAP annotations.

ParametersJSON Schema
NameRequiredDescriptionDefault
asset_idYesAsset identifier (e.g., 'SAP_SC_FI_AM_FINTRANSACTIONS')
space_idYesSpace identifier (e.g., 'SAP_CONTENT')
identify_dimensions_measuresNoAutomatically identify dimensions and measures based on annotations (default: true)

TDQS

A4/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description is the only source of behavioral information. It discloses the automatic identification of analytical elements via SAP annotations and outlines the returned schema components. However, it does not mention any side effects, prerequisites, permission requirements, or failure behavior. For a read-only metadata retrieval, this is adequate but not comprehensive.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is three concise sentences, immediately states the action and resource, and adds relevant detail about return content and behavior without fluff.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The description adequately covers the tool's purpose, return content, and a key behavior for a metadata retrieval tool. Without an output schema, it does enough to set expectations about dimensions, measures, hierarchies, and aggregation. However, it lacks information about the exact CSDL format or how missing annotations are handled, which could be useful but is not critical.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the baseline is 3. The description indirectly relates to the identify_dimensions_measures parameter by mentioning automatic identification, but does not provide explicit parameter-level guidance beyond the schema. The main parameters space_id and asset_id are only described in the schema, not elaborated further in the description.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses the specific verb 'Retrieve' and clearly identifies the resource as 'CSDL metadata for analytical consumption of a specific asset.' It distinguishes itself from sibling tools like get_relational_metadata by explicitly specifying analytical metadata, and mentions the return schema content.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides clear context that this tool is for analytical and BI integration needs, but does not explicitly name alternatives or exclusion criteria. The context signals show several sibling metadata tools, but the description relies on the term 'analytical' to differentiate.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_analytical_modelA

Get the OData service document and metadata for a specific analytical model. Returns entity sets, dimensions, measures, and query capabilities. Parses CSDL metadata (OData V4) to identify analytical properties via Common.Label / Analytics.Dimension / Analytics.Measure / Analytics.AggregationRole annotations, with V2 sap:* attributes kept as a fallback.

ParametersJSON Schema
NameRequiredDescriptionDefault
asset_idYesAsset identifier
space_idYesSpace identifier
include_metadataNoInclude parsed CSDL metadata with dimensions and measures (default: true)

TDQS

A3.6/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations provided, so description carries full burden. It explains return content and parsing logic (CSDL, annotations, fallback), but omits side effects, authentication requirements, or error handling. Adequate but not comprehensive.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two sentences, no redundancy. First sentence states purpose and output, second sentence provides technical detail. Every word serves a purpose.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given no output schema and no annotations, the description adequately explains the tool's return content (dimensions, measures, entity sets) and parsing methodology. Lacks output format specifics and error scenarios, but sufficient for a retrieval tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema covers 100% of parameters with descriptions. The description adds technical context about returned metadata and parsing approach but does not elaborate on parameter syntax or constraints beyond the schema. Baseline score of 3 is appropriate.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states it retrieves the OData service document and metadata for a specific analytical model, listing key components (entity sets, dimensions, measures, query capabilities). It distinguishes itself from siblings by focusing on a single model's metadata with parsing details.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No guidance on when to use this tool versus alternatives like get_analytical_metadata or list_analytical_datasets. Lacks context on prerequisites, exclusions, or typical use cases.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_asset_by_compound_keyA

Retrieve asset using OData compound key identifier (alternative access method).

Use this tool when:

  • You have both space ID and asset ID ready

  • Want direct access without knowing the exact endpoint structure

  • Working with bookmarked or favorited assets

  • Have pre-known asset identifiers from other systems

  • Need to resolve cross-references quickly

What you'll get:

  • Same comprehensive metadata as get_asset_details

  • Complete asset information with consumption URLs

  • All dimensions, measures, and relationships

  • Technical and business context

Required parameters:

  • space_id: The space identifier

  • asset_id: The asset identifier

How it works: This tool combines space_id and asset_id into an OData compound key format: spaceId='SAP_CONTENT',assetId='SAP_SC_FI_AM_FINTRANSACTIONS'

Example queries:

  • "Get asset SAP_SC_FI_AM_FINTRANSACTIONS from SAP_CONTENT using compound key"

  • "Retrieve CUSTOMER_VIEW in SALES_SPACE"

When to use this vs get_asset_details:

  • Use this: When you want simplified parameter passing

  • Use get_asset_details: When you need expand options or prefer explicit endpoint

Note: This uses the Catalog API: GET /api/v1/datasphere/consumption/catalog/assets({compoundKey})

ParametersJSON Schema
NameRequiredDescriptionDefault
asset_idYesThe asset identifier (e.g., 'SAP_SC_FI_AM_FINTRANSACTIONS', 'CUSTOMER_VIEW').
space_idYesThe space identifier in UPPERCASE (e.g., 'SAP_CONTENT', 'SALES_SPACE').

TDQS

A4.8/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the full burden. It explains the compound-key mechanism, the API endpoint, and the comprehensive return content (dimensions, measures, relationships, technical/business context). This is robust disclosure for a read-only retrieval operation, exceeding the typical vague 'retrieves data'.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is longer than typical but well-structured with headings and bullet lists, and front-loaded with a concise summary sentence. Every section serves a clear purpose, though some repetition exists (e.g., 'same metadata as get_asset_details' appears twice in different forms).

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a two-parameter retrieval tool with no output schema, the description is exceptionally complete. It covers use cases, parameters with examples, behavior, endpoint, and comparison with sibling tools, leaving little ambiguity for an agent to select and invoke it correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so the baseline is 3. The description adds substantial meaning: it explains how space_id and asset_id combine into the OData compound key, provides a concrete format example, and includes example queries. This enriches the parameter understanding beyond the schema's simple field types.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

Clearly states 'Retrieve asset using OData compound key identifier' with a specific verb and resource, and immediately distinguishes it as an 'alternative access method' relative to get_asset_details. The title 'null' is compensated by a dense first sentence that precisely defines the tool's unique function.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Provides explicit bulleted 'Use this tool when' criteria and a dedicated 'When to use this vs get_asset_details' section, listing both scenarios and alternatives. This goes far beyond implied usage, giving the agent clear decision rules.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_asset_detailsA

Get comprehensive metadata for a specific SAP Datasphere asset.

Use this tool when:

  • User asks "Show me details about the Financial Transactions asset"

  • Need complete asset documentation and structure

  • Want to understand asset dimensions, measures, and relationships

  • Looking for consumption URLs to access the data

  • Checking asset business purpose and technical details

  • Validating asset availability before integration

What you'll get:

  • Complete asset metadata (name, description, business purpose)

  • Space information and ownership details

  • Asset type and consumption type (analytical/relational)

  • Consumption URLs for data access

  • Metadata URLs for schema information

  • Dimensions and measures (for analytical models)

  • Relationships to other assets

  • Technical details (row count, size, refresh info)

  • Business context (domain, classification, retention)

  • Version and status information

  • Tags and categorization

Required parameters:

  • space_id: The space containing the asset (e.g., 'SAP_CONTENT')

  • asset_id: The asset identifier (e.g., 'SAP_SC_FI_AM_FINTRANSACTIONS')

Optional parameters:

  • expand_fields: Related entities to expand (e.g., ['columns', 'relationships'])

Example queries:

  • "Get details for SAP_SC_FI_AM_FINTRANSACTIONS in SAP_CONTENT"

  • "Show me the structure of the Financial Transactions asset"

  • "What are the dimensions and measures of this analytical model?"

  • "Give me the consumption URL for the Sales Data View"

Use cases:

  • Understand asset structure before querying

  • Get consumption URLs for data access

  • Review asset business purpose and classification

  • Check asset relationships and dependencies

  • Validate data freshness (last refresh time)

  • Generate asset documentation

Note: This uses the Catalog API: GET /api/v1/datasphere/consumption/catalog/spaces('{spaceId}')/assets('{assetId}')

ParametersJSON Schema
NameRequiredDescriptionDefault
asset_idYesThe asset identifier (e.g., 'SAP_SC_FI_AM_FINTRANSACTIONS', 'CUSTOMER_VIEW').
space_idYesThe space ID in UPPERCASE format (e.g., 'SAP_CONTENT', 'SALES_ANALYTICS'). Must match exactly.
expand_fieldsNoRelated entities to expand (e.g., ['columns', 'relationships', 'metadata']).

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden. It is transparent about the tool's read-only nature (implicit via the GET endpoint note) and thoroughly discloses the output structure. It does not explicitly state 'does not modify data' or discuss potential errors, permissions, or rate limits, but for a metadata retrieval tool, the behavioral expectations are clearly conveyed.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is long but well-structured with clear headings (Use this tool when, What you'll get, Required parameters, etc.). Every section contributes useful information, though there is some redundancy between 'Use this tool when' and 'Use cases' sections. It is front-loaded with the primary action and remains organized throughout.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (returns comprehensive metadata, no output schema), the description compensates admirably. It lists the full spectrum of returned information, includes the API endpoint for context, provides example queries, and covers parameter usage. It leaves little ambiguity about what the tool does and when to invoke it.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The schema already describes all parameters with examples (100% coverage), so baseline is 3. The description adds value by providing real-world example values (e.g., 'SAP_SC_FI_AM_FINTRANSACTIONS'), explaining the purpose of expand_fields with examples, and mapping parameters to use cases. This goes beyond the schema's dry field names.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description begins with a clear, specific verb+resource statement: 'Get comprehensive metadata for a specific SAP Datasphere asset.' It then enumerates the detailed metadata fields (dimensions, measures, consumption URLs, relationships, etc.), which clearly distinguishes this tool from siblings like get_asset_by_compound_key or list_space_assets by focusing on a single asset's complete metadata.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides an explicit 'Use this tool when' section with concrete scenarios (e.g., 'Show me details about the Financial Transactions asset') and a 'Use cases' list. However, it does not explicitly mention when not to use it or suggest alternative tools, stopping short of the full 5-point criteria for exclusions/alternatives.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_asset_variablesA

Retrieve input parameters/variables and filter-capability annotations declared in the OData $metadata of a SAP Datasphere asset (wave 2026.10). Use this when the asset is parameterised (e.g., a view or analytic model with input variables) and you need to know what variables to bind and which fields are filterable/sortable before querying. Returns variables (name, type, default, nullable, multi_value), filter annotations, and the column list.

ParametersJSON Schema
NameRequiredDescriptionDefault
asset_idYesAsset identifier (view or analytic model exposed for consumption)
space_idYesSpace identifier (e.g., 'SAP_CONTENT')

TDQS

A4.2/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

There are no annotations, so the description carries the full burden. It discloses the source ($metadata) and return payload (variables, filter annotations, column list) with variable attributes. This is adequate for a read-only metadata retrieval operation, though it stops short of stating side-effect absence or potential errors.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is concise: two sentences that front-load the action, then provide usage guidance and a summary of return values. Every sentence earns its place without redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The description covers the main use case (pre-query variable discovery), return fields, and the metadata source. It omits details on filter annotation structure or the meaning of 'wave 2026.10', but for an agent deciding whether to invoke the tool, the information is sufficient.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema descriptions already cover both parameters (asset_id and space_id) with 100% coverage, so the description adds only marginal semantic context by referring to 'asset' and 'parameterised'. It does not further explain the parameters' relationship or any constraints beyond the schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool retrieves input variables and filter-capability annotations from the OData $metadata of a SAP Datasphere asset. It specifies the exact resource (asset metadata) and distinguishes itself from sibling tools like get_asset_details or get_analytical_metadata by focusing on parameters and filter annotations.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It provides explicit usage context: 'Use this when the asset is parameterised' and before querying to know bindable variables and filterable fields. However, it does not name alternative sibling tools for non-parameterised assets, so the guidance is clear but not fully comparative.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_available_scopesA

List available OAuth2 scopes for the current user, showing which scopes are granted and which are available but not granted. Includes scope descriptions and the token's current scopes. Use this to understand API access capabilities and troubleshoot permission issues.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

A4.7/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden. It discloses that the tool shows granted vs. available scopes, includes scope descriptions, and lists the token's current scopes, which goes beyond a simple listing. It implies a read-only operation with no side effects.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is three sentences, each adding value: it lists the output, the included details, and the usage scenario. No redundant information.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

With no parameters, no output schema, and no annotations, the description fully covers what the tool does, what it returns, and when to use it. Nothing is missing.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The tool has zero parameters, so schema coverage is 100%. The description correctly adds no parameter-specific information since none exist. Baseline for zero-param tools is 4.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool lists OAuth2 scopes for the current user, distinguishing between granted and ungranted scopes. This is a specific verb+resource that differentiates it from sibling tools like get_current_user or get_tenant_info.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description explicitly says to use it to understand API access capabilities and troubleshoot permission issues. It provides clear context for when to use the tool, though it does not mention alternatives or exclusion criteria.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_current_userA

Get authenticated user information including user ID, email, display name, roles, permissions, and account status. Use this to understand the current user's identity and access rights in SAP Datasphere.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

A4.5/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the full burden. It clearly indicates a non-mutating read operation ('Get') and describes the returned data (user ID, roles, permissions, account status). It does not explicitly state that no side effects occur, but the verb and context make this apparent for a simple profile endpoint.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is two sentences, front-loaded with the main action, and every phrase earns its place. It lists result fields without redundancy and provides a clear usage context.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a simple zero-parameter tool with no output schema, the description is complete: it states what the tool does, what information it returns, and gives a practical use case. No additional context is necessary to invoke or interpret the result.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The tool has zero parameters, and the schema coverage is 100% (vacuously). The description adds no parameter details because none exist. A baseline of 4 is appropriate since the schema is complete and no parameter explanation is needed.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses a specific verb 'Get' and identifies the resource as 'authenticated user information', listing key fields (ID, email, roles, etc.). This clearly distinguishes it from sibling tools like get_tenant_info or list_database_users.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description explicitly states when to use the tool: 'Use this to understand the current user's identity and access rights.' While no alternative tools are mentioned, the context is clear and there are no direct siblings that compete with this purpose, making the guidance sufficient.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_deployed_objectsA

List runtime/deployed objects that are actively running in SAP Datasphere. Returns deployment status, runtime metrics, execution history for data flows, and performance statistics. Use this for monitoring deployed assets, tracking execution status, analyzing runtime performance, and identifying active vs inactive objects.

ParametersJSON Schema
NameRequiredDescriptionDefault
topNoMaximum number of results to return (default: 50, max: 500)
skipNoNumber of results to skip for pagination (default: 0)
space_idYesSpace identifier (e.g., 'SAP_CONTENT')
object_typesNoFilter by object types: Table, View, AnalyticalModel, DataFlow
runtime_statusNoFilter by runtime status: Active, Running, Idle, Error, Suspended
include_metricsNoInclude runtime performance metrics (query times, execution stats, cache hit rates)

TDQS

A4.2/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the transparency burden. It discloses that the tool returns deployment status, runtime metrics, execution history, and performance statistics, and implies a read-only listing operation. It does not mention auth requirements or limitations, but for a list operation this is acceptable.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is two sentences, front-loaded with the core purpose and followed by concrete use cases. Every word earns its place, with no redundancy or filler.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The tool has no output schema and no annotations, so the description must convey return value nature. It mentions deployment status, metrics, execution history, and performance statistics, which gives a reasonable picture. It could be more explicit about output structure or the fact that both active and inactive objects can be listed, but overall it is adequate for a moderately parameterized tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, with all six parameters documented in the input schema. The description adds general context about what metrics and statuses are returned but does not provide parameter-specific details beyond the schema. Baseline 3 is appropriate.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb 'List' and the resource 'runtime/deployed objects', specifying it operates in SAP Datasphere. It distinguishes the tool from sibling asset-listing tools by focusing on runtime/deployed objects and monitoring use cases.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description explicitly says 'Use this for monitoring deployed assets, tracking execution status, analyzing runtime performance, and identifying active vs inactive objects.' This provides clear use contexts, though it stops short of naming alternative tools or explicit exclusions.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_object_definitionA

Get complete design-time object definition from SAP Datasphere repository. Retrieves detailed structure, logic, transformations, and metadata for tables (with columns, keys, indexes), views (with SQL definitions), analytical models (with dimensions/measures), and data flows (with transformation steps). Use this for understanding object implementation details, extracting schema information, or planning migrations.

ParametersJSON Schema
NameRequiredDescriptionDefault
space_idYesSpace identifier (e.g., 'SAP_CONTENT')
object_idYesObject identifier/name (e.g., 'FINANCIAL_TRANSACTIONS', 'CUSTOMER_VIEW')
include_dependenciesNoInclude dependency information (upstream sources and downstream consumers)
include_full_definitionNoInclude complete object definition with all details (columns, transformations, logic)

TDQS

A4.2/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description must carry the burden of disclosing behavior. It clearly indicates a read-only 'get' operation and details what content is retrieved (columns, keys, SQL, dimensions, transformations). While it doesn't mention permissions or side effects, the read-only nature is implied by the verb 'Get' and the listed return content.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is concise and well-structured: two sentences that front-load the core purpose and then provide additional detail on object types and use cases. Every sentence adds value without waste.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity and lack of an output schema, the description provides helpful context by listing what is returned for each object type. It also differentiates from sibling tools by covering multiple object types, though it doesn't specify response structure or pagination. This is reasonably complete for a retrieval tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so all four parameters are already documented in the schema. The description does not add any additional parameter-specific semantics beyond what the schema provides, which aligns with the baseline score of 3.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose with a specific verb ('Get') and resource ('complete design-time object definition from SAP Datasphere repository'). It enumerates specific object types (tables, views, analytical models, data flows) and their content, which differentiates it from siblings like get_table_schema or get_asset_details.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides explicit use cases: 'understanding object implementation details, extracting schema information, or planning migrations.' This gives clear context for when to use the tool, though it does not explicitly mention when to prefer alternatives like get_table_schema or get_analytical_model.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_relational_entity_metadataA

Get detailed metadata for a specific relational entity including column definitions, data types, SQL type mappings, and ETL extraction capabilities. Optimized for data warehouse loading and transformation workflows.

ParametersJSON Schema
NameRequiredDescriptionDefault
asset_idYesAsset/entity identifier (e.g., 'SAP_SC_FI_AM_FINTRANSACTIONS')
space_idYesSpace identifier (e.g., 'SAP_CONTENT')
include_sql_typesNoInclude SQL type mappings for target databases (default: true)

TDQS

A4/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the full burden. It states 'Get' (read-only) and enumerates the returned metadata types, which is useful. However, it does not disclose any limitations, authentication requirements, error behavior, or how include_sql_types affects the response, leaving some transparency gaps.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is two sentences with no extraneous words. The core purpose is front-loaded, and the second sentence adds relevant context about the intended workflow. Every word earns its place.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given no output schema, the description adequately describes return content (column definitions, data types, SQL type mappings, ETL capabilities). It does not cover error scenarios or pagination, but for a metadata retrieval tool with simple parameters, this is sufficient and complete enough for an agent.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100% with detailed descriptions for all three parameters. The tool description does not add parameter-specific meaning beyond implying that the tool targets a specific entity (asset_id, space_id). Baseline 3 is appropriate since the schema handles parameter documentation.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's function: 'Get detailed metadata for a specific relational entity' and enumerates the content (column definitions, data types, SQL type mappings, ETL extraction capabilities). This distinguishes it from siblings like get_relational_metadata (broader scope) and get_table_schema (narrower focus on table columns).

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description specifies the tool's niche: 'Optimized for data warehouse loading and transformation workflows,' which implies when to use it. However, it does not explicitly mention alternatives or cases where other metadata tools would be preferable, so it lacks explicit exclusions.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_relational_metadataA

Retrieve CSDL metadata for relational consumption of a specific asset. Returns complete schema information including tables, columns, data types, primary/foreign keys, and relationships for relational data access and ETL planning. Includes SQL type mapping.

ParametersJSON Schema
NameRequiredDescriptionDefault
asset_idYesAsset identifier (e.g., 'CUSTOMER_VIEW')
space_idYesSpace identifier (e.g., 'SAP_CONTENT')
map_to_sql_typesNoMap OData types to SQL types (default: true)

TDQS

A4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden. It transparently discloses the return content ('complete schema information including tables, columns, data types, primary/foreign keys, and relationships') and the SQL type mapping behavior. It does not mention potential limitations or output format, but for a read-only metadata retrieval tool, the level of disclosure is sufficient.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is three sentences, front-loaded with the main action, and each sentence adds value: what it does, what it returns, and a key feature. No fluff or redundant phrasing.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

With no output schema, the description sufficiently explains what the tool returns (complete schema info, relationships, SQL type mapping). It covers the core need for relational access and ETL planning. However, it could be slightly clearer about how this differs from similar metadata tools, and it doesn't mention any pagination or limit behavior, which might matter for large assets.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The schema description coverage is 100%, so all three parameters are already documented. The description adds no extra meaning beyond what the schema provides; it only mentions SQL type mapping, which is already described in the schema. Baseline 3 is appropriate since the description doesn't need to compensate.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's function: 'Retrieve CSDL metadata for relational consumption of a specific asset.' It specifies the resource (CSDL metadata for a specific asset) and the purpose (relational consumption), and it lists concrete deliverables (tables, columns, data types, keys, relationships) that distinguish it from siblings like get_analytical_metadata or get_table_schema.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description gives context ('for relational data access and ETL planning') which implies when to use it, but it does not explicitly differentiate from closely related siblings like get_relational_entity_metadata or list_relational_entities. There is no explicit 'when not to use' or alternative recommendation, leaving some ambiguity.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_space_assetsA

List all data assets within a specific SAP Datasphere space.

Use this tool when:

  • User asks "What assets are in the SAP_CONTENT space?"

  • Browsing assets within a specific space

  • Creating a space-specific asset inventory

  • Filtering assets by type within a space

  • Validating space contents and available data

  • Understanding what data is available in a space

What you'll get:

  • All assets within the specified space

  • Asset names, descriptions, and types

  • Exposure status for each asset

  • Consumption URLs (analytical and relational)

  • Creation and modification timestamps

  • Asset counts and pagination info

Required parameters:

  • space_id: The space to browse (e.g., 'SAP_CONTENT')

Optional parameters:

  • filter_expression: Filter by asset type or other criteria

  • top: Maximum results (default 50, max 1000)

  • skip: Results to skip for pagination

Example queries:

  • "List all assets in the SAP_CONTENT space"

  • "Show me analytical models in SALES_ANALYTICS"

  • "What tables are available in FINANCE_SPACE?"

  • "List exposed assets in SAP_CONTENT"

Common filters:

  • By type: filter_expression="assetType eq 'AnalyticalModel'"

  • Exposed only: filter_expression="exposedForConsumption eq true"

  • By name pattern: filter_expression="contains(name, 'Financial')"

  • Combined: filter_expression="assetType eq 'View' and exposedForConsumption eq true"

Asset types:

  • AnalyticalModel: Multi-dimensional models with dimensions and measures

  • View: SQL views combining data from multiple sources

  • Table: Physical tables with business data

  • Fact: Fact tables in dimensional models

  • Dimension: Dimension tables for analysis

Use cases:

  • Space content discovery

  • Asset inventory generation

  • Data availability validation

  • Finding specific asset types

  • Understanding space data landscape

Note: This uses the Catalog API: GET /api/v1/datasphere/consumption/catalog/spaces('{spaceId}')/assets

ParametersJSON Schema
NameRequiredDescriptionDefault
topNoMaximum number of results to return (default: 50, max: 1000).
skipNoNumber of results to skip for pagination (default: 0).
space_idYesThe space ID in UPPERCASE format (e.g., 'SAP_CONTENT', 'SALES_ANALYTICS'). Must match exactly.
filter_expressionNoOData filter expression (e.g., "assetType eq 'AnalyticalModel'" or "exposedForConsumption eq true").

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Since no annotations are provided, the description carries the full burden. It details what the tool returns: asset names, descriptions, types, exposure status, consumption URLs, timestamps, counts, pagination. It also notes the underlying API call. It does not mention auth requirements or rate limits, but for a read-only listing tool, the transparency is high.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is fairly long but well-structured into clear sections (use cases, parameters, examples, filters, asset types). Each section adds relevant information without redundancy. It is appropriately sized for the tool's complexity.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the 4 parameters, no output schema, and no annotations, the description is remarkably complete. It covers all parameter usage, provides practical examples, common OData filter patterns, and lists asset types. An agent can fully understand how to invoke the tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so baseline is 3. The description adds significant value with example values ('SAP_CONTENT'), default values for top and skip, common filter examples, and descriptions of asset types. This goes beyond the schema definitions.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states 'List all data assets within a specific SAP Datasphere space' with a specific verb and resource. It distinguishes from siblings like list_catalog_assets and search_catalog by focusing on assets within a single space.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description explicitly lists user queries and scenarios that trigger the tool, such as 'What assets are in the SAP_CONTENT space?' and 'Filtering assets by type within a space.' However, it does not provide explicit when-not-to-use guidance or name alternative tools.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_space_infoA

Get comprehensive information about a specific SAP Datasphere space.

Use this tool when:

  • User asks about a specific space (e.g., "Tell me about SALES_ANALYTICS")

  • You need to see what tables/views exist in a space

  • Checking space configuration and metadata

  • Following up from list_spaces() results

What you'll get:

  • Complete space metadata (status, owner, created date)

  • List of all tables and views in the space

  • Table schemas and row counts

  • Connection information

Required parameter:

  • space_id: Must be uppercase (e.g., 'SALES_ANALYTICS', 'FINANCE_DWH')

Example queries:

  • "Show me the SALES_ANALYTICS space"

  • "What tables are in FINANCE_DWH?"

  • "Tell me about the HR_ANALYTICS space"

Error handling:

  • If space not found, list_spaces() will show available spaces

ParametersJSON Schema
NameRequiredDescriptionDefault
space_idYesThe space ID in UPPERCASE format (e.g., 'SALES_ANALYTICS', 'FINANCE_DWH', 'HR_ANALYTICS'). Must match exactly.

TDQS

A4.3/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden. It discloses output contents (metadata, tables/views, schemas, row counts, connection info) and error behavior (if space not found, list_spaces() shows available spaces). It does not explicitly state read-only nature, but the wording strongly implies it.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with clear sections (purpose, when to use, what you'll get, parameter, examples, errors). It is slightly verbose but every section adds practical context. Slight redundancy with the parameter requirement already in schema, so not perfect.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given no output schema, the description compensates with a detailed list of returned data types. It covers purpose, usage, expected output, parameter specifics, and error handling. Missing only minor details like performance implications, but is sufficient for correct invocation.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100% and already documents space_id with UPPERCASE requirement and examples. The description repeats this without adding new semantic meaning, so it meets the baseline but does not go beyond.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

Description opens with a specific verb and resource: 'Get comprehensive information about a specific SAP Datasphere space.' It clearly lists what is included (metadata, tables/views, schemas, row counts, connection info) and implicitly distinguishes from sibling tools like list_spaces by focusing on a single space.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Includes a dedicated 'Use this tool when' section with concrete triggers (user asks about a specific space, need to see tables/views, checking configuration). It explicitly mentions following up from list_spaces() results and suggests list_spaces as an alternative when space is not found.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_table_schemaA

Get detailed schema information for a specific table or view.

Use this tool when:

  • User asks "What columns are in CUSTOMER_DATA?"

  • Need to understand table structure before querying

  • Planning JOIN operations (need to see key columns)

  • Checking data types for analysis

What you'll get:

  • Complete column list with data types

  • Primary key indicators

  • Column descriptions

  • Table metadata (row count, last updated)

Required parameters:

  • space_id: The space containing the table (uppercase)

  • table_name: Exact table name (case-sensitive, usually uppercase)

Example queries:

  • "Show me the schema of CUSTOMER_DATA in SALES_ANALYTICS"

  • "What columns does SALES_ORDERS have?"

  • "Describe the GL_ACCOUNTS table structure"

Best practices:

  • Use search_tables() first if you don't know the exact table name

  • Check column types before writing queries

  • Identify key columns for JOINs

Next steps:

  • Use execute_query() with proper column names and types

ParametersJSON Schema
NameRequiredDescriptionDefault
space_idYesThe space ID containing the table (e.g., 'SALES_ANALYTICS'). Must be uppercase.
table_nameYesExact table or view name (e.g., 'CUSTOMER_DATA', 'SALES_ORDERS'). Case-sensitive, typically uppercase.

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Since no annotations are provided, the description must disclose behavioral details. It does so by listing what the response includes (column list, data types, primary key indicators, descriptions, table metadata) and noting the case-sensitivity of the table name. It doesn't mention potential errors or permission requirements, but for a read-only schema lookup, the disclosure is reasonably thorough.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is longer than average but well-structured with clear headings and bullet points. Each section (use cases, expected output, parameters, examples, best practices, next steps) contributes to usability. There is some minor redundancy with schema details, but the organization makes it easy to scan quickly.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a tool with only 2 parameters, no output schema, and no annotations, the description is extremely comprehensive. It covers when to use the tool, what results to expect, parameter constraints, example queries, best practices, and follow-up steps. An agent has all the information needed to select and invoke this tool correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so the input schema already fully documents both parameters with examples and uppercase requirements. The description's 'Required parameters' section and example queries reinforce this but add little new meaning beyond the schema. It provides contextual usage examples, but the baseline of 3 applies because the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states 'Get detailed schema information for a specific table or view' with a specific verb and resource. It distinguishes itself from sibling tools like search_tables (which finds table names) and execute_query (which runs queries) by specifying that this tool retrieves schema details, and provides example queries that make the purpose unambiguous.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The tool explicitly lists 'Use this tool when:' scenarios, 'Best practices' (including 'Use search_tables() first if you don't know the exact table name'), and 'Next steps' (suggesting execute_query()). This gives clear when-to-use guidance and names alternative tools, making it easy for an agent to decide between this and related tools.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_task_historyA

Get the execution history for a specific task chain or object in SAP Datasphere.

Use this tool when:

  • Viewing all previous runs of a task chain

  • Analyzing task execution patterns

  • Finding failed runs to investigate

  • Checking historical performance

  • Auditing task chain executions

  • Understanding run frequency and duration

What you'll get:

  • Array of all historical task runs for the specified object

  • Each entry includes: logId, status, startTime, endTime, runTime

  • Sorted by most recent first

  • Shows RUNNING, COMPLETED, FAILED, CANCELLED runs

Required parameters:

  • space_id: The space containing the task chain

  • object_id: The task chain name to get history for

Response includes for each run:

  • logId: Unique identifier for this execution

  • status: RUNNING, COMPLETED, FAILED, or CANCELLED

  • startTime: When the task started (ISO format)

  • endTime: When the task finished (if completed)

  • runTime: Duration in milliseconds

  • objectId: The task chain name

  • applicationId: Always 'TASK_CHAINS' for task chains

  • activity: The activity type (e.g., 'RUN_CHAIN')

  • user: Who initiated the run

Example queries:

  • "Show me the run history for Daily_ETL_Pipeline in SALES_SPACE"

  • "List all executions of Customer_Sync in FINANCE"

  • "Get historical runs for Nested_Chain_1 in DWH_SPACE"

  • "How many times has Data_Refresh run this week?"

Use cases:

  • Identify recurring failures

  • Analyze execution duration trends

  • Find specific failed runs to debug

  • Audit who ran tasks and when

  • Plan maintenance windows

  • Monitor SLA compliance

Workflow example:

  1. Get history: get_task_history(space_id='SALES', object_id='Daily_ETL')

  2. Find failed run: Look for status='FAILED', note logId

  3. Get details: get_task_log(space_id='SALES', log_id=, detail_level='detailed')

  4. View error messages in the response

Note: Uses API: GET /api/v1/datasphere/tasks/logs/{space_id}/objects/{object_id}

ParametersJSON Schema
NameRequiredDescriptionDefault
space_idYesThe space ID containing the task chain (e.g., 'SALES_SPACE', 'FINANCE'). Must be uppercase.
object_idYesThe task chain name/identifier to get history for (e.g., 'Daily_ETL_Pipeline', 'Customer_Sync').

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden. It discloses sorting order ('Sorted by most recent first'), statuses included, and detailed response fields. It also mentions the API endpoint. However, it does not mention potential limits, pagination, or error behavior, which would be useful for full transparency, but the disclosure is still strong.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is long but well-structured with clear headings, bullets, and sections. It is front-loaded with the core purpose and then provides examples and use cases. Some redundancy exists between 'What you'll get' and 'Response includes', but overall it is scannable and every section contributes value.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

There is no output schema, so the description compensates by thoroughly listing every response field with descriptions. It also provides a workflow example, API endpoint, and use cases. For a tool with only two simple parameters, this is comprehensively sufficient.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100% and each parameter already has an informative description including examples and casing requirements. The tool description repeats these examples and adds query examples, but does not introduce new semantic meaning beyond the schema. Baseline 3 is appropriate.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a specific verb and resource: 'Get the execution history for a specific task chain or object in SAP Datasphere.' It clearly differentiates from siblings like get_task_status (status) and get_task_log (log details) by focusing on historical runs. The 'Use this tool when' list further reinforces its purpose.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Explicit 'Use this tool when' section lists six concrete use cases. The workflow example demonstrates how to chain get_task_history with get_task_log, indicating when to use the alternative. Example queries provide practical context for invocation.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_task_logA

Get detailed information about a specific task execution in SAP Datasphere.

Use this tool when:

  • Checking status of a running task (after run_task_chain)

  • Investigating why a task failed

  • Viewing detailed execution logs and messages

  • Monitoring task chain progress

  • Debugging data pipeline issues

What you'll get (depends on detail_level):

  • status (default): Simple status object {"status": "COMPLETED"}

  • status_only: Just the status string "COMPLETED"

  • detailed: Full details including messages and child nodes

  • extended: Extended logs with complete message details

Required parameters:

  • space_id: The space where the task ran

  • log_id: The log ID from run_task_chain or get_task_history

Optional parameters:

  • detail_level: Amount of detail to return

    • 'status' (default): Status object only

    • 'status_only': Status string only

    • 'detailed': Full logs with messages and children

    • 'extended': Extended logs with message details

Status values:

  • RUNNING: Task is currently executing

  • COMPLETED: Task finished successfully

  • FAILED: Task encountered an error

  • CANCELLED: Task was manually stopped

Example queries:

  • "Check status of task log 2295172 in SALES_SPACE"

  • "Get detailed logs for log ID 2295172"

  • "Show me why task 2326060 failed in FINANCE"

  • "Get extended execution details for log 2295172"

Detailed response includes:

  • logId, status, startTime, endTime, runTime

  • objectId (task chain name)

  • user who ran the task

  • children: Array of child task executions

  • messages: Array of log messages with severity and timestamps

Use cases:

  • Monitor long-running ETL jobs

  • Debug failed data pipelines

  • Audit task execution history

  • Track data refresh timing

  • Investigate error messages

Note: Uses API: GET /api/v1/datasphere/tasks/logs/{space_id}/{log_id}

ParametersJSON Schema
NameRequiredDescriptionDefault
log_idYesThe log ID to retrieve details for (obtained from run_task_chain or get_task_history).
space_idYesThe space ID where the task ran (e.g., 'SALES_SPACE', 'FINANCE'). Must be uppercase.
detail_levelNoLevel of detail to return. Options: 'status' (default), 'status_only', 'detailed', 'extended'.status

TDQS

A4.5/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden. It discloses the underlying API (GET), explains the four detail_level outputs, lists response fields (logId, status, messages, children), and enumerates possible status values. This is exceptionally transparent.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness3/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with sections and bullet points, but it is quite verbose for a simple read tool. There is redundancy between 'What you'll get' and 'Optional parameters' both explaining detail_level, and the 'Use cases' section largely repeats the 'Use this tool when' list.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

There is no output schema, but the description compensates thoroughly by detailing response contents, status values, example queries, and use cases. It gives an AI agent everything needed to select and invoke the tool correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema documentation covers all 3 parameters with descriptions, so the baseline is 3. The description adds extra value by explaining where log_id comes from, providing example space_id values, and elaborating on the detail_level enum beyond the schema's bare enumeration.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses a specific verb 'Get' and identifies a precise resource: 'detailed information about a specific task execution in SAP Datasphere'. It clearly distinguishes this from sibling tools like get_task_status and get_task_history by focusing on a single log and referencing run_task_chain.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Provides explicit 'Use this tool when' scenarios (checking status, investigating failures, viewing logs, monitoring progress). It also indicates log_id provenance from run_task_chain or get_task_history. However, it lacks explicit when-not-to-use guidance or named alternatives like get_task_status.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_task_statusA

Get status and execution details of data integration and ETL tasks.

Use this tool when:

  • User asks "What tasks are running?"

  • Monitoring data pipeline execution

  • Checking when data was last refreshed

  • Troubleshooting failed tasks

What you'll get:

  • Task IDs and names

  • Execution status (COMPLETED, RUNNING, FAILED, SCHEDULED)

  • Last run timestamp and next scheduled run

  • Execution duration and records processed

  • Associated space information

Filtering options:

  • No parameters: Show all tasks

  • task_id: Get specific task details

  • space_id: Show all tasks for a space

Example queries:

  • "What tasks are currently running?"

  • "Show me all tasks in SALES_ANALYTICS"

  • "When did DAILY_SALES_ETL last run?"

  • "Check status of task FINANCE_RECONCILIATION"

Task types:

  • ETL/data loading tasks

  • Transformation workflows

  • Scheduled data refreshes

  • Data replication jobs

ParametersJSON Schema
NameRequiredDescriptionDefault
task_idNoOptional: Specific task ID to check (e.g., 'DAILY_SALES_ETL'). Leave empty to see all tasks.
space_idNoOptional: Filter tasks by space (e.g., 'SALES_ANALYTICS'). Shows only tasks associated with that space.

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the transparency burden. It discloses return contents (task IDs, status, timestamps, duration, records), filtering options, and task types. It doesn't explicitly state it's read-only, but the verb 'get' and context make that clear.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Well-structured with clear sections and bullets, but a bit verbose. Every section contributes useful information, though the 'Task types' list is somewhat redundant with the overall purpose.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given no output schema and only two optional parameters, the description is remarkably complete. It covers when to use, what to expect, filtering behavior, example queries, and return fields, leaving little ambiguity.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so baseline is 3. The description adds value beyond the schema by explaining the no-parameter behavior, how each filter works, and providing concrete example values for each parameter.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool retrieves status and execution details for data integration/ETL tasks. It distinguishes itself from siblings like get_task_history and get_task_log by focusing on current status and run details, supported by explicit examples.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Provides clear 'Use this tool when' scenarios and example queries. It gives strong contextual guidance but does not explicitly mention alternatives or when not to use it, so it falls short of a 5.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_tenant_infoA

Retrieve SAP Datasphere tenant configuration and system information including tenant ID, region, version, license type, storage quota/usage, user count, space count, enabled features, and maintenance windows. Use this for system administration and capacity planning.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

A3.9/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the full burden. It describes what is retrieved but does not explicitly state safety traits like read-only behavior, permission requirements, rate limits, or any side effects. The verb 'Retrieve' implies a read operation, but the description adds no deeper behavioral disclosure.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single well-structured sentence that front-loads the primary purpose, then enumerates key fields and ends with a usage note. Every phrase earns its place, with no redundant or filler content.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a parameterless read tool with no output schema, the description is quite complete: it lists the returned data types (tenant ID, region, version, etc.) and the use case. It does not mention error cases, authentication needs, or response format, but the level of detail is adequate for a simple retrieval tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema is empty (0 parameters), so the baseline is 4. The description correctly implies that no parameters are needed, and there is nothing more to explain about parameter semantics.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states it retrieves SAP Datasphere tenant configuration and system information, listing specific fields. It uses a specific verb ('Retrieve') and resource ('tenant configuration'), but does not explicitly distinguish from sibling tools like get_space_info or get_current_user, though the tenant-level scope is implicit.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It explicitly says 'Use this for system administration and capacity planning,' providing clear context for when to use it. However, it does not mention when not to use it or name alternative tools, so it lacks exclusions/alternatives.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_analytical_datasetsA

List all available analytical datasets within a specific asset. Discovers analytical models that can be queried for business intelligence and reporting. Returns entity sets with their names, types, and URLs for data access.

ParametersJSON Schema
NameRequiredDescriptionDefault
topNoMaximum number of datasets to return (default: 50, max: 1000)
skipNoNumber of datasets to skip for pagination
asset_idYesAsset identifier (e.g., 'SAP_SC_FI_AM_FINTRANSACTIONS')
space_idYesSpace identifier (e.g., 'SAP_CONTENT')

TDQS

A4.2/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full transparency burden. It correctly frames the operation as a read-only listing and explicitly states what is returned, which is the most important behavioral trait. It doesn't mention auth or side effects, but for a list operation this is reasonably sufficient.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Three sentences, front-loaded with the core verb and object, and every sentence adds useful information about purpose, scope, or return value. There is no wasted verbiage.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a paginated list tool with no output schema, the description adequately covers what the tool does, its scope, and what it returns. It doesn't need to repeat schema details, and the overall context is sufficient for an agent to select it appropriately.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema already covers all four parameters with descriptions, examples, and defaults, so the description adds no additional parameter semantics. This matches the baseline score of 3 when schema coverage is high.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a specific verb ('List') and a specific resource ('analytical datasets within a specific asset'), clearly distinguishing this discovery tool from query-oriented or metadata-only siblings. It also names the expected return content (entity sets, names, types, URLs), making the purpose unmistakable.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description clearly frames when to use the tool: to discover analytical datasets/models that can later be queried for business intelligence. It does not explicitly name alternative tools or exclusion criteria, but the 'can be queried' phrasing implies this is the discovery step, so the usage context is clear.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_catalog_assetsA

Browse all data assets across all SAP Datasphere spaces.

Use this tool when:

  • User asks "What assets are available in Datasphere?"

  • Building a complete data catalog or asset inventory

  • Discovering available data assets across all spaces

  • Searching for specific asset types across the system

  • Understanding the overall data landscape

What you'll get:

  • Asset IDs and names across all spaces

  • Asset types (AnalyticalModel, View, Table)

  • Space information for each asset

  • Consumption URLs (analytical and relational)

  • Exposure status and metadata URLs

  • Creation and modification timestamps

Available parameters:

  • select_fields: Specific fields to return (e.g., ['name', 'description', 'spaceId'])

  • filter_expression: OData filter (e.g., "spaceId eq 'SAP_CONTENT'")

  • top: Maximum results (default 50, max 1000)

  • skip: Results to skip for pagination

  • include_count: Include total count of assets

Example queries:

  • "List all available assets in Datasphere"

  • "Show me all analytical models across all spaces"

  • "Find assets in the SAP_CONTENT space"

  • "List the first 20 assets with their consumption URLs"

Common filters:

  • By space: filter_expression="spaceId eq 'SAP_CONTENT'"

  • By type: filter_expression="assetType eq 'AnalyticalModel'"

  • Exposed only: filter_expression="exposedForConsumption eq true"

  • Combined: filter_expression="spaceId eq 'SALES' and assetType eq 'View'"

Asset types you'll see:

  • AnalyticalModel: Multi-dimensional models for analytics

  • View: SQL views combining multiple data sources

  • Table: Physical tables with business data

  • Fact: Fact tables in analytical models

  • Dimension: Dimension tables in analytical models

Note: This uses the Catalog API: GET /api/v1/datasphere/consumption/catalog/assets

ParametersJSON Schema
NameRequiredDescriptionDefault
topNoMaximum number of results to return (default: 50, max: 1000).
skipNoNumber of results to skip for pagination (default: 0).
include_countNoInclude total count of matching assets (default: false).
select_fieldsNoSpecific fields to return (e.g., ['name', 'description', 'spaceId']). If not specified, returns all fields.
filter_expressionNoOData filter expression (e.g., "spaceId eq 'SAP_CONTENT'" or "assetType eq 'AnalyticalModel'").

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of disclosure. It transparently describes the return fields (IDs, names, types, spaces, URLs, timestamps), pagination parameters with defaults and limits, and even includes the underlying Catalog API endpoint. It implies read-only behavior through 'browse' and 'consumption URLs,' though it does not explicitly state that it is a read-only operation or discuss rate limits or error behavior.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with clear sections: purpose, when-to-use, expected output, parameters, examples, filters, asset types, and a note. The opening sentence states the core function immediately. While the description is long, every section provides actionable details and no superfluous content. It earns a 4 rather than 5 due to its length; a more compact version could retain the same value.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (5 optional parameters, no output schema, no annotations), the description is exceptionally complete. It explains what results look like, provides usage guidelines, gives numerous examples, details common filters, and even names the underlying API. It fully equips an agent to know when and how to invoke the tool correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema already documents all 5 parameters with 100% coverage, so the baseline is 3. The description adds value by providing concrete examples for filter_expression (e.g., spaceId eq 'SAP_CONTENT'), showing typical select_fields usage, and giving common filter combinations. It also explains asset types that appear in results, which enriches the parameter meaning beyond the schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a clear, specific statement: 'Browse all data assets across all SAP Datasphere spaces.' This distinguishes it from siblings like get_space_assets (specific space) or find_assets_by_column (column-specific search). The 'Use this tool when' section further reinforces the tool's role as a system-wide catalog browser.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides an explicit 'Use this tool when' list with concrete scenarios like building a complete data catalog or discovering assets across all spaces. However, it does not name alternative tools for exclusion, such as 'use search_catalog for targeted text search' or 'use get_space_assets for a single space.' This is clear context but lacks explicit when-not-to-use guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_connectionsA

List all external data source connections and their current status.

Use this tool when:

  • User asks "What data sources are connected?"

  • Checking connection health and availability

  • Understanding data lineage and sources

  • Troubleshooting data refresh issues

What you'll get:

  • Connection IDs and names

  • Connection types (SAP_ERP, SALESFORCE, EXTERNAL, etc.)

  • Connection status (CONNECTED, DISCONNECTED, ERROR)

  • Host information and last tested timestamp

Supported connection types:

  • SAP_ERP, SAP_S4HANA, SAP_BW

  • SALESFORCE, EXTERNAL

  • SNOWFLAKE, DATABRICKS

  • POSTGRESQL, MYSQL, ORACLE, SQLSERVER, HANA

Example queries:

  • "What external connections exist?"

  • "Show me all SAP ERP connections"

  • "Check if Salesforce connection is active"

Use cases:

  • Data integration monitoring

  • Connection health checks

  • Understanding data sources

ParametersJSON Schema
NameRequiredDescriptionDefault
connection_typeNoOptional: Filter by specific connection type (e.g., 'SAP_ERP', 'SALESFORCE', 'EXTERNAL'). Leave empty to show all connections.

TDQS

A4.5/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the full burden. It discloses return fields (IDs, names, types, status, host, timestamp) and lists supported connection types. It does not explicitly state the operation is read-only, nor does it mention permissions or error behavior, but the 'List' verb and status focus imply a non-mutating operation. This is a solid but not exhaustive disclosure.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is front-loaded with a clear one-sentence summary, then organized into scannable sections with bullets. Every section—supported types, example queries, use cases—provides distinct value. There is no fluff or repetition; the length is justified by the rich context.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a simple tool with one optional parameter, no annotations, and no output schema, the description is remarkably complete. It explains what the user will get in terms of return content, lists valid connection types, and gives concrete usage examples. Nothing critical is missing for the agent to select and invoke the tool correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The schema already describes the single optional parameter with examples, giving 100% coverage. The description adds value by enumerating possible connection types (SAP_ERP, SALESFORCE, etc.), which is not in the schema. This goes beyond the baseline, though the core semantics are already clear from the schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a specific verb 'List' and a well-defined resource: 'all external data source connections and their current status.' This clearly distinguishes it from sibling tools like test_connection (which tests) and get_task_history (which shows task history). The purpose is unmistakable.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides an explicit 'Use this tool when' section with concrete examples like 'What data sources are connected?' and 'Checking connection health.' It also lists example queries and use cases. However, it does not include explicit when-not-to-use guidance or name alternative tools, so it stops short of a perfect score.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_database_usersA

List all database users in a specific SAP Datasphere space.

Use this tool when:

  • User asks "What database users exist in SALES space?"

  • Auditing user access and permissions

  • Checking who has database access to a space

  • Before creating a new database user (avoid duplicates)

What you'll get:

  • Database user IDs and full names

  • User status (ACTIVE, INACTIVE)

  • Access permissions and privileges

  • Last login information

  • Audit policy settings

Required parameter:

  • space_id: The space ID (uppercase, e.g., 'SALES', 'FINANCE')

Example queries:

  • "List all database users in SALES space"

  • "Show me who has database access to FINANCE"

  • "What database users are configured?"

Database user access types:

  • Consumption: Read data with/without grant privileges

  • Ingestion: Write/load data into space

  • Schema access: Local and space schema access

  • Script server: Execute advanced analytics

Note: This corresponds to the CLI command: datasphere dbusers list --space

ParametersJSON Schema
NameRequiredDescriptionDefault
space_idYesThe space ID in UPPERCASE format (e.g., 'SALES', 'FINANCE', 'HR'). Must match exactly.
output_fileNoOptional: Path to save output as JSON file (e.g., 'users.json'). If not provided, results display in response.

TDQS

A4.5/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden. It explains the output structure ('What you'll get') and access types, giving good insight into behavior. However, it does not explicitly state that the operation is read-only or mention side effects of the optional output_file parameter, so it falls short of perfect transparency.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with clear headings, bullet points, and examples. It front-loads the primary purpose and provides necessary details in an organized manner without unnecessary verbosity. Every section (usage, output, required param, examples, access types) contributes value.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

There is no output schema, so the description compensates by detailing the expected return values (user IDs, status, permissions, etc.). It also includes example queries and a CLI reference, making it comprehensive for a list operation. The optional output_file is covered by the input schema, so the description remains complete enough.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, and the description repeats the space_id parameter with uppercase examples, adding minimal value beyond the schema. The output_file parameter is not mentioned in the description at all, so the description does not significantly enhance parameter understanding beyond what the schema already provides.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's function: 'List all database users in a specific SAP Datasphere space.' It uses a specific verb (list) with a resource (database users) and scope (space), and distinguishes itself from sibling tools like create/update/delete_database_user.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The 'Use this tool when' section explicitly lists scenarios such as auditing user access and checking who has database access to a space. It also advises using it before creating a new user to avoid duplicates, providing clear context for when to use this tool over alternatives.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_relational_entitiesA

List all available relational entities (tables/views) within a specific SAP Datasphere asset for row-level data access and ETL operations. Returns OData entity sets that can be queried for detailed data extraction.

ParametersJSON Schema
NameRequiredDescriptionDefault
topNoMaximum number of entities to return (default: 50, max: 1000)
asset_idYesAsset identifier (e.g., 'SAP_SC_FI_AM_FINTRANSACTIONS')
space_idYesSpace identifier (e.g., 'SAP_CONTENT')

TDQS

A3.5/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the full burden, but it only says 'Returns OData entity sets' without stating that the operation is read-only, requires specific permissions, or has side effects. It does not disclose pagination behavior or other limitations beyond the schema's top parameter, leaving significant ambiguity about execution behavior.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is two sentences, front-loaded with the main verb and resource, and contains no redundant wording. It efficiently communicates purpose and return type.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a simple listing tool, the description covers the core action and return type, but without annotations or an output schema it leaves gaps: what exactly an 'OData entity set' contains is unspecified, and pagination is only hinted at via the top parameter. It is adequate but not rich.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so space_id, asset_id, and top are already fully documented with examples and defaults. The description adds no additional parameter-specific meaning, only a general reference to 'a specific SAP Datasphere asset' that loosely maps to the required parameters.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action: 'List all available relational entities (tables/views) within a specific SAP Datasphere asset.' It also clarifies the return type ('Returns OData entity sets') and distinguishes the tool from query or metadata tools by focusing on enumeration.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The phrase 'within a specific SAP Datasphere asset for row-level data access and ETL operations' gives context on when the tool is useful, but it does not explicitly contrast with sibling tools like query_relational_entity or get_relational_entity_metadata. Usage guidance remains implicit rather than direct.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_spacesA

List all SAP Datasphere spaces with their status and metadata.

Use this tool when:

  • User asks "What spaces are available?" or "Show me all spaces"

  • You need to discover available Datasphere environments

  • Starting data exploration workflow

  • Checking space status and availability

What you'll get:

  • Space IDs and names

  • Space status (ACTIVE, DEVELOPMENT, etc.)

  • Table/view counts per space

  • Owner information (with include_details=True)

Example queries:

  • "What Datasphere spaces exist?"

  • "Show me all data spaces"

  • "Which spaces are active?"

Next steps after using this tool:

  • Use get_space_info() to explore a specific space

  • Use search_tables() to find tables across spaces

ParametersJSON Schema
NameRequiredDescriptionDefault
include_detailsNoSet to true to include detailed information (owner, created date, connection counts). Default: false for quick space listing.

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations are absent, so the description carries the full burden. It discloses what the tool returns (space IDs, names, status, counts, owner with include_details=True) and implies a read-only operation via 'list.' However, it does not explicitly state permissions, pagination, or potential errors, which would be even more transparent. The default behavior and detail flag are explained, earning a 4.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with clear sections and is front-loaded with the main purpose. Some content, like example queries, is slightly redundant but still useful for intent recognition. It is not overly verbose, so 4 is appropriate.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a simple read-only list tool with one optional parameter and no output schema, the description thoroughly covers use cases, expected outputs, parameter semantics, and next steps. It is fully complete for an agent to understand when and how to invoke it.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so the schema already documents include_details well. The description adds minor context by mentioning 'quick space listing' vs. detailed information, but largely duplicates the schema's parameter description. Thus it meets the baseline without significant added meaning.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states it lists all SAP Datasphere spaces with their status and metadata. It distinguishes itself from siblings by mentioning it's for discovering spaces, while get_space_info is for exploring a specific space and search_tables is for finding tables. This provides a specific verb-resource pair with scope.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides explicit 'Use this tool when' bullets, example queries, and next steps that point to alternatives like get_space_info and search_tables. This constitutes clear usage context and alternative guidance, satisfying the highest bar.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

query_analytical_dataA

Execute OData queries on analytical models to retrieve aggregated data with dimensions and measures. Supports full OData query syntax: $select (column selection), $filter (WHERE conditions), $orderby (sorting), $top/$skip (pagination), $apply (aggregations with sum/average/min/max/count/groupby). Perfect for business intelligence, reporting, and data analysis.

ParametersJSON Schema
NameRequiredDescriptionDefault
topNoMaximum number of results (default: 50, max: 10000)
skipNoNumber of results to skip for pagination
applyNoAggregation transformations (e.g., 'groupby((Currency), aggregate(Amount with sum as TotalAmount))')
countNoReport a row count. Analytical entities declare Countable:false, so $count is not sent -- the count returned covers the current page only.
filterNoOData $filter. Operators: eq ne gt ge lt le, and/or/not, (). Partial text matching: startswith(Field,'v'), endswith(Field,'v'), contains(Field,'v') -- text columns only. Values must be single-quoted and are CASE-SENSITIVE ('us' does not match 'US'). A value containing a single quote cannot be filtered on at all. Example: startswith(Product,'TV') and Country eq 'US'. Filtering a dimension is much cheaper than filtering an aggregated measure. Assets whose lineage includes federated sources accept only eq/and/or/().
selectNoComma-separated list of dimensions/measures to return (OData $select)
orderbyNoSort order (e.g., 'Amount desc, TransactionDate asc')
asset_idYesAsset identifier
space_idYesSpace identifier
entity_setYesEntity set name to query

TDQS

A4.5/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations present, the description carries full responsibility for behavioral disclosure. It provides several non-obvious behavioral details: filtering dimensions is cheaper than filtering measures, federated sources support only eq/and/or/(), values must be single-quoted and are case-sensitive, and a value containing a single quote cannot be filtered on. This goes well beyond the schema and informs the agent of important limitations and performance characteristics.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is two sentences and front-loaded with the primary action. The second sentence compactly lists all supported OData clauses in a single line, and the third clause adds clear use cases. No word is wasted, and the structure makes the tool's capability immediately apparent.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Despite lacking an output schema, the description provides a comprehensive view of what the tool does, its supported syntax, and its intended use cases. The rich param schema covers the individual parameters, while the description supplies the overarching query context and behavioral caveats. For a query tool of this complexity, the combination is sufficiently complete.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the baseline is 3. The description adds a high-level overview of OData syntax but does not add significant per-parameter meaning beyond what the schema already explains. The schema's parameter descriptions already cover examples, defaults, and constraints, so the tool description's additional value is marginal.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: executing OData queries on analytical models to retrieve aggregated data. It names the supported query capabilities ($select, $filter, $orderby, $top/$skip, $apply), making it distinct from sibling tools like query_relational_entity or execute_query. The resource (analytical models) and action (execute/retrieve) are specific and unambiguous.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description indicates when to use the tool ('Perfect for business intelligence, reporting, and data analysis') and defines its domain as analytical models. It does not explicitly name alternatives or state when not to use it, but the analytical/OData focus provides clear contextual guidance versus relational query tools.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

query_relational_entityA

Execute OData queries on relational entities for ETL data extraction. Supports large batch processing (up to 50,000 records), advanced filtering, column selection, and pagination. Optimized for data warehouse loading and analytics pipelines. Use list_relational_entities to discover available entity names first.

ParametersJSON Schema
NameRequiredDescriptionDefault
topNoMaximum records to return (default: 1000, max: 50000 for ETL)
skipNoNumber of records to skip for pagination
filterNoOData $filter. Operators: eq ne gt ge lt le, and/or/not, (). Partial text matching: startswith(Field,'v'), endswith(Field,'v'), contains(Field,'v') -- text columns only. Values must be single-quoted and are CASE-SENSITIVE ('us' does not match 'US'). A value containing a single quote cannot be filtered on at all. Example: startswith(Product,'TV') and Country eq 'US'. Assets whose lineage includes federated sources accept only eq/and/or/().
selectNoComma-separated column list for $select (e.g., "customer_id,amount,date")
orderbyNoOData $orderby expression (e.g., "amount desc, date asc")
asset_idYesAsset identifier - same as used in list_relational_entities (e.g., 'SAP_SC_FI_AM_FINTRANSACTIONS')
space_idYesSpace identifier (e.g., 'SAP_CONTENT')
entity_nameYesEntity name from the OData service (e.g., 'Results', 'Data'). Use list_relational_entities to get available entity names. If unsure, try using the asset_id as entity_name.

TDQS

A4/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the burden of behavioral disclosure. It mentions large batch processing (up to 50,000 records), filtering, column selection, and pagination, but does not disclose side effects, permissions, rate limits, or error behavior. The read-only nature is implied but not stated explicitly.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is concise—four sentences that front-load the core purpose and key capabilities. Every sentence provides useful information: what it does, batch limit, feature set, usage context, and a prerequisite tip. There is no redundancy or fluff.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool has 8 parameters and no output schema, the description competently covers the main usage context, capabilities, and a prerequisite step. It lacks explicit details about return value structure, but the absence of an output schema and the straightforward 'query' semantics mitigate this. The description is reasonably complete for a developer to start using the tool effectively.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema covers 100% of parameters with detailed descriptions, so the baseline is 3. The description adds no significant parameter-level detail beyond what the schema already provides; it only refers generally to filtering, column selection, and pagination, which are already documented in the schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description begins with a specific verb phrase 'Execute OData queries' and clearly identifies the resource as 'relational entities', immediately distinguishing this tool from analytical query tools. It further specifies the ETL context and explicitly references sibling tool list_relational_entities, making the purpose unmistakable.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description gives clear context for when to use this tool (ETL data extraction, data warehouse loading, analytics pipelines) and instructs users to call list_relational_entities first. However, it does not explicitly state when not to use it or name alternative query tools, leaving some ambiguity versus query_analytical_data or execute_query.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

reset_database_user_passwordA

Reset the password for an existing database user in SAP Datasphere.

IMPORTANT: This is a HIGH-RISK tool that requires user consent before execution.

Use this tool when:

  • User requests "Reset password for database user JEFF"

  • Password forgotten or compromised

  • Regular password rotation policy

  • Account locked due to failed login attempts

What happens:

  • Old password is invalidated immediately

  • New password is auto-generated securely

  • User must change password on next login

  • Action is logged for security audit

Required parameters:

  • space_id: The space containing the database user

  • database_user_id: The user whose password needs reset

Security considerations:

  • New password shown only once - save securely!

  • Recommend using output_file to save credentials

  • Notify user through secure channel

  • Enforce password change on first login

  • All active sessions are terminated

Example queries:

  • "Reset password for JEFF in SALES space"

  • "Generate new password for database user ANALYST"

  • "REPORTING_USER password expired, reset it"

Best practices:

  • Always save output to secure file

  • Communicate new password via secure channel (not email!)

  • Verify user identity before resetting

  • Document password reset in change log

Note: Corresponds to CLI: datasphere dbusers password reset --space --databaseuser

ParametersJSON Schema
NameRequiredDescriptionDefault
space_idYesThe space ID containing the database user (e.g., 'SALES', 'FINANCE'). Must be uppercase.
output_fileNoOptional: Path to save new credentials JSON (e.g., 'jeff_new.json'). HIGHLY RECOMMENDED for security!
database_user_idYesDatabase user name suffix whose password will be reset (e.g., 'JEFF', 'ANALYST').

TDQS

A4.6/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description fully carries the burden of behavioral disclosure. It does an excellent job: 'Old password is invalidated immediately', 'New password is auto-generated securely', 'User must change password on next login', 'Action is logged for security audit', 'All active sessions are terminated', and the high-risk warning. This far exceeds typical MCP descriptions.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with headings and bullet points, making it scannable. It is longer than average, but this is justified for a high-risk mutation tool. There is minor redundancy (e.g., security reminders in both 'Security considerations' and 'Best practices'), but every section serves a purpose.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Despite having no output schema and no annotations, the description covers operational context, security implications, example queries, CLI mapping, and best practices. It is complete enough for an agent to confidently invoke the tool and handle the response correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, and the input schema already describes each parameter. The description adds contextual meaning by listing 'Required parameters' and explaining their purpose in the workflow, plus recommending 'output_file' to save credentials. This adds value beyond the bare schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a clear explanation: 'Reset the password for an existing database user in SAP Datasphere.' This uses specific verb+resource language and distinguishes the tool from sibling tools like create_database_user or update_database_user by focusing specifically on password reset.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description explicitly lists use cases: 'Use this tool when: User requests "Reset password for database user JEFF" / Password forgotten or compromised / Regular password rotation policy / Account locked due to failed login attempts.' It does not explicitly mention when not to use it or alternative tools, but the examples and best practices provide clear guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

run_task_chainA

Execute a task chain in SAP Datasphere and get a log ID for tracking.

Use this tool when:

  • User asks to "Run the ETL pipeline" or "Execute task chain X"

  • Triggering scheduled data loads or transformations

  • Starting data replication or synchronization jobs

  • Automating data refresh workflows

  • Executing orchestrated data pipelines

What happens:

  • Task chain execution is initiated immediately

  • Returns a logId to track the execution status

  • Task runs asynchronously (use get_task_log to check status)

  • All child tasks in the chain are executed in order

Required parameters:

  • space_id: The space containing the task chain (e.g., 'SALES_SPACE')

  • object_id: The task chain name/ID (e.g., 'Daily_ETL_Pipeline')

What you'll get:

  • logId: Unique identifier to track this execution

  • Use get_task_log(space_id, logId) to monitor progress

  • Use get_task_history(space_id, object_id) to see all runs

Example queries:

  • "Run the Daily_ETL_Pipeline in SALES_SPACE"

  • "Execute task chain Customer_Sync in FINANCE_SPACE"

  • "Trigger the data refresh pipeline in ANALYTICS"

  • "Start the nightly batch job in DWH_SPACE"

Important notes:

  • Task chains run asynchronously - tool returns immediately

  • Check status with get_task_log using the returned logId

  • Requires appropriate permissions to run task chains

  • Failed runs can be investigated with detailed logs

Workflow example:

  1. Run task chain: run_task_chain(space_id='SALES', object_id='Daily_ETL')

  2. Get logId from response (e.g., 2295172)

  3. Check status: get_task_log(space_id='SALES', log_id=2295172)

  4. View details: get_task_log(space_id='SALES', log_id=2295172, detail_level='detailed')

Note: Uses API: POST /api/v1/datasphere/tasks/chains/{space_id}/run/{object_id}

ParametersJSON Schema
NameRequiredDescriptionDefault
space_idYesThe space ID containing the task chain (e.g., 'SALES_SPACE', 'FINANCE'). Must be uppercase.
object_idYesThe task chain name/identifier to execute (e.g., 'Daily_ETL_Pipeline', 'Customer_Sync').

TDQS

A4.9/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, but the description fully discloses asynchronous behavior, immediate return of a logId, ordered child task execution, permission requirements, and the ability to investigate failures. This goes beyond basic expectations for a run-triggering tool.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Although the description is long, it is meticulously structured with labeled sections: when to use, what happens, required parameters, output, examples, and workflow. Every sentence provides useful information, making it efficient despite its length.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The tool has async behavior, a logId output, and related sibling tools. The description covers initiation, what to expect, how to track via get_task_log, how to view history via get_task_history, and even the underlying API endpoint. This is complete for a complex trigger tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the baseline is 3. The description adds value by providing concrete examples for space_id ('SALES_SPACE') and object_id ('Daily_ETL_Pipeline') plus a workflow example, reinforcing the practical meaning beyond the schema's own descriptions.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

Description clearly states 'Execute a task chain in SAP Datasphere and get a log ID for tracking' with a specific verb and resource. It also differentiates from sibling tools by naming get_task_log for status and get_task_history for history, making the purpose unmistakable.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Provides an explicit 'Use this tool when' list with concrete trigger phrases, and in 'What you'll get' explicitly directs to get_task_log and get_task_history as follow-up tools. This completely answers when and how to use it versus alternatives.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

search_catalogA

Universal search across all catalog items in SAP Datasphere using advanced search syntax. Supports searching across KPIs, assets, spaces, models, views, and tables. Use SCOPE: prefix for targeted searches. Boolean operators (AND, OR, NOT) supported.

ParametersJSON Schema
NameRequiredDescriptionDefault
topNoMaximum number of results to return (default: 50, max: 500)
skipNoNumber of results to skip for pagination (default: 0)
queryYesSearch query with optional SCOPE prefix. Format: 'SCOPE:<scope> <terms>'. Scopes: SearchAll, SearchKPIsAdmin, SearchAssets, SearchSpaces, SearchModels, SearchViews, SearchTables. Example: 'SCOPE:comsapcatalogsearchprivateSearchAll financial'
facetsNoComma-separated list of facets to include or 'all' for all facets. Example: 'objectType,spaceId'
facet_limitNoMaximum number of facet values to return per facet (default: 5)
include_countNoInclude total count of matching results (default: false)
include_why_foundNoInclude explanation of why each result matched (default: false)

TDQS

A3.9/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the full burden. It discloses advanced syntax (SCOPE, Boolean operators) and supported scopes, which is useful. However, it doesn't explicitly state read-only behavior, result format, or pagination limitations. The description is adequate but lacks deeper operational context.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is three sentences, each serving a distinct purpose: stating the tool's scope, listing supported item types, and providing usage syntax. It is front-loaded with the core purpose and contains no fluff.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given there is no output schema, the description doesn't explain what the tool returns (e.g., result list format, metadata). It also omits information about result ordering or grouping. The schema covers parameters well, but the lack of return value disclosure leaves a gap for the agent.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the baseline is 3. The description adds a bit of context about query syntax (SCOPE, Boolean operators), but this is also partly in the schema. It doesn't further elaborate on parameters like facets or include_why_found beyond what the schema already provides.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool performs a 'Universal search across all catalog items' and enumerates supported item types (KPIs, assets, spaces, models, views, tables). This distinguishes it from sibling tools like search_tables (table-specific) and list_catalog_assets (listing, not searching).

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description conveys broad applicability ('Universal search') and provides explicit syntax examples (SCOPE prefix, Boolean operators). While it doesn't explicitly contrast with alternatives like search_tables, the scope is clear enough for an agent to choose it for cross-type searches. No when-not-to-use guidance is given, but the use case is well implied.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

search_tablesA

Search for tables and views across all Datasphere spaces by name or description.

Use this tool when:

  • User asks "Find tables with customer data"

  • Looking for tables containing specific keywords

  • Don't know exact table name but know the domain

  • Searching across multiple spaces

Search behavior:

  • Searches both table names and descriptions

  • Case-insensitive matching

  • Returns results from all spaces (or specific space if filtered)

  • Includes table metadata (type, columns, row counts)

Search tips:

  • Use domain keywords: "customer", "sales", "order", "finance"

  • Partial matches work: "cust" finds "CUSTOMER_DATA"

  • Filter by space_id to narrow results

Example queries:

  • "Find all tables related to customers"

  • "Search for sales order tables"

  • "Show me all tables with 'finance' in the name"

Next steps:

  • Use get_table_schema() for detailed column information

  • Use execute_query() to retrieve actual data

ParametersJSON Schema
NameRequiredDescriptionDefault
space_idNoOptional: Filter results to a specific space (e.g., 'SALES_ANALYTICS'). Leave empty to search all spaces.
search_termYesKeyword to search for in table names and descriptions (e.g., 'customer', 'sales', 'order'). Case-insensitive, partial matches work.

TDQS

A4.6/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description fully covers behavioral traits: it searches both names and descriptions, uses case-insensitive matching, supports partial matches, returns results from all spaces or a specific space when filtered, and includes table metadata (type, columns, row counts). This gives the agent a strong understanding of the tool's runtime behavior.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with clear headers for use cases, behavior, tips, examples, and next steps. It is longer than strictly necessary, but each section serves a distinct purpose and the front-loaded summary makes the core meaning immediately clear.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given a simple 2-parameter search tool with no output schema, the description is comprehensive: it explains what the tool does, when to use it, how search works, provides practical tips, example queries, and next steps. It leaves little ambiguity for an agent to select and invoke the tool correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema already provides 100% parameter descriptions for space_id and search_term with examples. The description adds extra semantic value by explaining search behavior (case-insensitive, partial matches) and offering search tips like 'Partial matches work: cust finds CUSTOMER_DATA.' This goes beyond the schema but is not essential given the schema's completeness.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a specific action and target: 'Search for tables and views across all Datasphere spaces by name or description.' This clearly defines the tool's scope and differentiates it from siblings like get_table_schema (single table) or list_catalog_assets. The example queries reinforce the purpose.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

A dedicated 'Use this tool when' section lists four concrete scenarios, such as 'User asks Find tables with customer data' and 'Searching across multiple spaces.' It provides clear context for when to use the tool, though it does not explicitly mention when not to use it or name alternative tools for different search types.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

smart_queryA

🚀 SMART QUERY - Intelligent query router that automatically selects the best execution method for your query.

NEW in v1.0.5 - This is a composite tool combining execute_query, query_relational_entity, and query_analytical_data with intelligent routing and fallback logic.

Why use smart_query instead of individual query tools?

  • ✅ Automatic routing to the most reliable method

  • ✅ Fallback handling if primary method fails

  • ✅ No need to understand different query methods

  • ✅ Better error recovery and diagnostics

  • ✅ Performance optimization based on query type

How it works:

  1. Analyzes your query - Detects SQL syntax, aggregations, complexity

  2. Routes intelligently - Chooses the best execution method:

    • Aggregations (SUM, COUNT, GROUP BY) → Analytical endpoint

    • Simple SELECT → Relational endpoint (most reliable)

    • Complex SQL → SQL parsing with OData conversion

  3. Falls back gracefully - If primary method fails, tries alternatives

  4. Returns detailed logs - Shows routing decisions and execution path

Query Modes:

  • auto (default) - Intelligent routing based on query analysis

  • relational - Force use of relational endpoint (most reliable)

  • analytical - Force use of analytical endpoint (for aggregations)

  • sql - Force use of SQL parsing method

Use this tool when:

  • You want reliable query execution without worrying about method selection

  • You're unsure which query method to use

  • You need fallback handling for production reliability

  • You want to see execution diagnostics

Supported query patterns:

  • Simple SELECT: SELECT * FROM SAP_SC_FI_V_ProductsDim LIMIT 10

  • Filtering: SELECT * FROM table WHERE PRICE > 1000

  • Column selection: SELECT PRODUCTID, PRICE FROM table

  • Aggregations: SELECT COMPANYNAME, SUM(GROSSAMOUNT) FROM table GROUP BY COMPANYNAME

  • Sorting: SELECT * FROM table ORDER BY PRICE DESC LIMIT 5

Parameters:

  • space_id - Space ID (e.g., "SAP_CONTENT")

  • query - SQL query or natural language request

  • mode - Routing mode: "auto", "relational", "analytical", "sql" (default: "auto")

  • limit - Max rows to return (default: 1000)

  • include_metadata - Include routing logs and decisions (default: true)

  • fallback - Enable fallback to alternative methods (default: true)

Example queries:

# Auto-routing - simple SELECT
smart_query(space_id="SAP_CONTENT", query="SELECT * FROM SAP_SC_FI_V_ProductsDim LIMIT 5")

# Auto-routing - aggregation
smart_query(space_id="SAP_CONTENT", query="SELECT COMPANYNAME, SUM(GROSSAMOUNT) FROM SAP_SC_SALES_V_SalesOrders GROUP BY COMPANYNAME")

# Force relational mode
smart_query(space_id="SAP_CONTENT", query="SELECT * FROM SAP_SC_FI_V_ProductsDim", mode="relational")

# Disable fallback (fail fast)
smart_query(space_id="SAP_CONTENT", query="SELECT * FROM table", fallback=False)

Response includes:

  • Query results (data)

  • Method used (relational, analytical, sql, or fallback)

  • Execution time

  • Rows returned

  • Routing decision log (if include_metadata=true)

  • Detected query characteristics

Error handling:

  • If primary method fails, automatically tries fallbacks

  • Returns detailed error log showing all attempted methods

  • Provides suggestions for fixing query issues

  • Shows routing decisions for debugging

Performance:

  • Relational: 1-5 seconds, up to 50K records

  • Analytical: Fast for aggregations

  • SQL: 1-5 seconds, up to 1K records

When to use individual tools instead:

  • Use query_relational_entity when you need specific entity_name control

  • Use query_analytical_data when you know you need analytical consumption

  • Use execute_query when you need exact SQL syntax control

  • Use smart_query for everything else (recommended for most use cases)

Note: This tool provides the same functionality as the individual query tools but with better reliability through intelligent routing and fallback handling.

ParametersJSON Schema
NameRequiredDescriptionDefault
modeNoQuery execution mode. Use 'auto' for intelligent routing (recommended). Default: 'auto'auto
limitNoMaximum number of rows to return. Default: 1000. Range: 1-50000
queryYesSQL query to execute. Examples: 'SELECT * FROM table LIMIT 10', 'SELECT col1, SUM(col2) FROM table GROUP BY col1'
fallbackNoEnable fallback to alternative query methods if primary fails. Default: true
space_idYesThe Datasphere space ID (e.g., 'SAP_CONTENT', 'SALES'). Must match existing space.
include_metadataNoInclude execution logs and routing decisions in response. Useful for debugging. Default: true

TDQS

A4.7/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden and meets it exceptionally. It discloses automatic routing, fallback behavior, response contents (method used, execution time, routing logs), error handling, and performance characteristics. This goes beyond a simple 'executes queries' statement and provides rich behavioral context for an AI agent.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness3/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with clear sections, emojis, and bullet points, but it is overly verbose and includes redundant content. For instance, the advantages of smart_query are repeated in both the 'Why use' list and the later 'When to use individual tools' section, and the final note restates the same message. While front-loaded, it would benefit from trimming to make every sentence earn its place.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity, the absence of annotations, and the lack of an output schema, the description is remarkably complete. It covers query modes, supported query patterns, response fields, error handling, performance expectations, and when to use alternatives. An agent would have sufficient context to select and invoke the tool correctly and to interpret its output.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Although schema coverage is 100%, the description adds meaningful context beyond the schema: it explains each parameter in a dedicated 'Parameters' section with added semantics like mode examples, default behavior of fallback, and the purpose of include_metadata. This enriches the bare schema definitions and provides practical usage guidance. A score of 4 reflects this added value while acknowledging the schema already covers the basics.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description begins with a specific verb+resource: 'Intelligent query router that automatically selects the best execution method for your query.' It clearly identifies what the tool does and differentiates itself from sibling query tools by positioning as a composite router with fallback logic. The scope is explicit and not a tautology or vague.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides explicit 'Use this tool when' and 'When to use individual tools instead' sections, naming exact alternatives like query_relational_entity, query_analytical_data, and execute_query. This gives clear guidance on when to choose smart_query versus alternatives, satisfying all rubric criteria for usage guidelines.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

test_connectionA

Test the connection to SAP Datasphere and verify OAuth authentication status. Use this tool to check if the MCP server can successfully connect to SAP Datasphere.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

A4.3/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the full burden. It clearly states the tool tests the connection and checks OAuth status, implying a non-mutating diagnostic operation. It does not describe return values or failure behavior, but for a simple connectivity check this is largely sufficient.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is two sentences and front-loads the main action. The second sentence is slightly redundant with the first ('Use this tool to check...' restates 'Test the connection'), but the overall structure is clear and efficient.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a zero-parameter, no-output-schema health check, the description provides sufficient context to understand the tool's purpose and when to use it. It lacks explicit return value details, but the simple nature of the operation makes this less critical.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

There are zero parameters, so the baseline is 4. The schema already has an empty properties object, and the description adds no parameter-specific detail because none is needed.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description starts with 'Test the connection to SAP Datasphere', providing a specific verb ('Test') and resource ('connection'). It also adds 'verify OAuth authentication status', making the scope precise and distinguishing it from sibling tools like list_connections or datasphere_cli_status.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It explicitly says 'Use this tool to check if the MCP server can successfully connect to SAP Datasphere', giving clear guidance on when to use it. However, it does not mention alternatives or exclusions, so it falls just short of a 5.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

update_database_userA

Update permissions and configuration for an existing database user.

IMPORTANT: This is a HIGH-RISK tool that requires user consent before execution.

Use this tool when:

  • User requests "Grant schema access to JEFF in SALES"

  • Modifying user permissions or access levels

  • Enabling/disabling audit policies

  • Changing retention periods

  • Updating user privileges

What you can update:

  • Consumption permissions (read access, grants)

  • Schema access (space, local, HDI)

  • Script server access

  • Audit policies and retention periods

  • Password policies

Required parameters:

  • space_id: The space containing the database user

  • database_user_id: The user to update

  • updated_definition: JSON with new configuration (full definition required)

Update examples:

Grant schema access:

{
  "consumption": {
    "spaceSchemaAccess": true,
    "consumptionWithGrant": false,
    ...
  },
  "ingestion": {...}
}

Enable audit logging:

{
  "consumption": {...},
  "ingestion": {
    "auditing": {
      "dppRead": {
        "isAuditPolicyActive": true,
        "retentionPeriod": 90
      }
    }
  }
}

Important notes:

  • Must provide complete user definition (not partial updates)

  • Changes take effect immediately

  • Active sessions may need reconnection

  • All changes are logged for audit

Example queries:

  • "Grant space schema access to JEFF"

  • "Enable audit logging for ANALYST with 90 day retention"

  • "Update REPORTING_USER to have consumption with grant"

Note: Corresponds to CLI: datasphere dbusers update --space --databaseuser --file-path <def.json>

ParametersJSON Schema
NameRequiredDescriptionDefault
space_idYesThe space ID containing the database user (e.g., 'SALES', 'FINANCE'). Must be uppercase.
output_fileNoOptional: Path to save updated configuration JSON (e.g., 'jeff_updated.json').
database_user_idYesDatabase user name suffix to update (e.g., 'JEFF', 'ANALYST').
updated_definitionYesComplete JSON object with updated permissions. Must include all settings (consumption, ingestion).

TDQS

A5/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries full burden and excels: it warns 'HIGH-RISK tool that requires user consent', discloses 'Changes take effect immediately', 'Active sessions may need reconnection', 'All changes are logged', and that complete definitions are needed. This is exceptional transparency about side effects and prerequisites.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with headers, bullet lists, and code examples. Every section adds necessary context for a high-risk tool, and despite length, it is efficient and scannable. No fluff.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a mutation tool with no annotations and no output schema, the description covers safety, usage context, parameter details, side effects, and examples. It is fully self-contained for an agent to invoke correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters5/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, but the description adds significant value by listing required parameters, emphasizing 'full definition required', and providing two detailed JSON examples for updated_definition. This goes well beyond the schema descriptions and clarifies usage nuances.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states 'Update permissions and configuration for an existing database user' with specific verb and resource, distinguishing it from sibling tools like create, reset, or delete. It also enumerates exact updateable items (consumption permissions, schema access, audit policies, etc.).

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides an explicit 'Use this tool when' list with concrete examples (e.g., 'Grant schema access to JEFF in SALES'), plus example queries. While it doesn't name alternative tools, the context and sibling tool list make it clear, and the guidance is strong enough for an agent to select appropriately.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

  1. 2 tool updatesv1.6.0
    • Changedquery_analytical_data2 fields changed
      • changedInput schema / properties / count / description
        Previous value: -"Include total count in response"New value: +"Report a row count. Analytical entities declare Countable:false, so $count is not sent -- the count returned covers the current page only."
      • changedInput schema / properties / filter / description
        Previous value: -"OData filter expression (e.g., 'Amount gt 1000 and Currency eq \"USD\"')"New value: +"OData $filter. Operators: eq ne gt ge lt le, and/or/not, (). Partial text matching: startswith(Field,'v'), endswith(Field,'v'), contains(Field,'v') -- text columns only. Values must be single-quoted and are CASE-SENSITIVE ('us' does not match 'US'). A value containing a single quote cannot be filtered on at all. Example: startswith(Product,'TV') and Country eq 'US'. Filtering a dimension is much cheaper than filtering an aggregated measure. Assets whose lineage includes federated sources accept only eq/and/or/()."
    • Changedquery_relational_entity1 field changed
      • changedInput schema / properties / filter / description
        Previous value: -"OData $filter expression (e.g., \"amount gt 1000 and status eq 'ACTIVE'\")"New value: +"OData $filter. Operators: eq ne gt ge lt le, and/or/not, (). Partial text matching: startswith(Field,'v'), endswith(Field,'v'), contains(Field,'v') -- text columns only. Values must be single-quoted and are CASE-SENSITIVE ('us' does not match 'US'). A value containing a single quote cannot be filtered on at all. Example: startswith(Product,'TV') and Country eq 'US'. Assets whose lineage includes federated sources accept only eq/and/or/()."
  2. 39 tool updatesv1.4.0
    • First observedanalyze_column_distribution
    • First observedbrowse_marketplace
    • First observedcreate_database_user
    • First observeddelete_database_user
    • First observedexecute_query
    • First observedfind_assets_by_column
    • First observedget_analytical_metadata
    • First observedget_analytical_model
    • First observedget_asset_by_compound_key
    • First observedget_asset_details
    • First observedget_asset_variables
    • First observedget_available_scopes
    • First observedget_current_user
    • First observedget_deployed_objects
    • First observedget_object_definition
    • First observedget_relational_entity_metadata
    • First observedget_relational_metadata
    • First observedget_space_assets
    • First observedget_space_info
    • First observedget_table_schema
    • First observedget_task_history
    • First observedget_task_log
    • First observedget_task_status
    • First observedget_tenant_info
    • First observedlist_analytical_datasets
    • First observedlist_catalog_assets
    • First observedlist_connections
    • First observedlist_database_users
    • First observedlist_relational_entities
    • First observedlist_spaces
    • First observedquery_analytical_data
    • First observedquery_relational_entity
    • First observedreset_database_user_password
    • First observedrun_task_chain
    • First observedsearch_catalog
    • First observedsearch_tables
    • First observedsmart_query
    • First observedtest_connection
    • First observedupdate_database_user

TDQS

A3.5/5.0

Scored across 39 tools

Disambiguation2/5

Several tools have heavily overlapping purposes: get_analytical_metadata, get_analytical_model, and list_analytical_datasets all expose analytical metadata; get_relational_metadata, get_relational_entity_metadata, and list_relational_entities overlap similarly; and execute_query, query_analytical_data, query_relational_entity, and smart_query all perform querying. get_asset_details vs get_asset_by_compound_key and get_space_assets vs list_catalog_assets add further ambiguity. Despite detailed descriptions, an agent will frequently struggle to choose the correct tool.

Naming Consistency4/5

The vast majority of tools follow a clear snake_case verb_noun pattern with consistent get_, list_, create_, update_, delete_, and query_ prefixes. Minor deviations exist, such as smart_query (adjective+noun) and phrasal names like find_assets_by_column and get_asset_by_compound_key, but there is no mixing of naming conventions or camelCase.

Tool Count2/5

At 39 tools, the server is well above the 25+ threshold and feels heavily bloated. The count is inflated by near-duplicate metadata and query tools that could be consolidated into fewer, more coherent tools. While SAP Datasphere is a broad platform, this surface is not well-scoped for an MCP server.

Completeness3/5

The tool set covers discovery, metadata retrieval, querying, task execution/monitoring, and database-user lifecycle management fairly well, with no obvious dead ends in those workflows. However, it lacks lifecycle operations for spaces, assets, task chains, and connections, offering only list/run/get capabilities where create/update/delete would often be expected in a management-oriented server.

Maintenance

ActivityMaintained
ResponsivenessUnresponsive

Related MCP Connectors

Related MCP Servers

  • A
    license
    Not graded
    quality
    D
    maintenance
    A config-driven MCP server that exposes OData and REST APIs as MCP tools, enabling AI assistants to query, manage, and monitor SAP backends through natural language.
    37 npm
    29
    MIT
  • A
    license
    Not graded
    quality
    C
    maintenance
    Production-ready MCP server enabling AI assistants to interact with SAP Datasphere for real tenant data discovery, metadata exploration, analytics operations, ETL data extraction, database user management, data lineage analysis, and column-level data profiling.
    MIT
  • A
    license
    A
    quality
    D
    maintenance
    MCP server for SAP Analytics Cloud, enabling AI assistants to interact with SAC stories, models, data, users, and audit logs via the SAC REST API.
    34
    ISC
  • A
    license
    A
    quality
    B
    maintenance
    Model Context Protocol server that lets AI assistants explore and query SAP Datasphere — metadata discovery, catalog search, OData and SQL queries, ETL extraction, data lineage and column profiling — with built-in config-driven PII masking.
    42
    55 npm
    1
    MIT