/datasphere-mcp-tools

name: datasphere-mcp-tools
description: List all available SAP Datasphere MCP tools with descriptions and usage examples
allowed-tools:
  - Read
  - Grep
  - Glob
  - Bash

Shell Snippet Notes

• Shell snippets assume Bash on Linux/macOS, WSL2, or Git Bash.
• Install the command-specific tooling shown near each snippet before running it.
• Confirm before running commands that delete files, change ownership, deploy, or modify remote systems.

Output Contract

Return the relevant MCP tool category, configuration checks, local fallback approach, and unresolved tenant/MCP availability items. Default to read-only guidance and avoid changing MCP config.

Display available MCP tools for SAP Datasphere integration.

Operation Safety

• **Classification**: `read-only tenant`, `mutating tenant`, `destructive`
• The Datasphere MCP server uses tenant OAuth credentials from environment variables and can expose tenant-affecting operations.
• Treat read/list/search tools as read-only tenant operations. Require explicit user approval before create, update, delete, reset, deploy, publish, trigger, or other destructive actions.
• Do not claim live tenant verification unless matching evidence is recorded in the source verification ledger.

SAP Datasphere MCP Tools (45 total)

The SAP Datasphere MCP Server (@mariodefe/sap-datasphere-mcp) provides 45 tools for direct tenant interaction.

**GitHub:** https://github.com/MarioDeFelipe/sap-datasphere-mcp **Package:** npm install -g @mariodefe/sap-datasphere-mcp@1.5.2

---

Foundation Tools (5)

test_connection

**Purpose:** Verify connectivity to SAP Datasphere tenant **Returns:** Connection status, latency, tenant URL **Use when:** Setting up MCP integration, troubleshooting connectivity

get_current_user

**Purpose:** Get authenticated user details **Returns:** User ID, email, permissions, authentication status **Use when:** Verifying authentication, checking user context

get_tenant_info

**Purpose:** Retrieve tenant configuration and capabilities **Returns:** Tenant URL, version, features, region **Use when:** Discovering tenant features, checking version compatibility

get_available_scopes

**Purpose:** List available permission scopes **Returns:** Scopes array with descriptions **Use when:** Understanding permission model, configuring OAuth clients

list_spaces

**Purpose:** Discover all spaces in tenant **Returns:** Space names, IDs, storage info, owners **Use when:** Finding available spaces, discovering data domains

---

Catalog & Asset Tools (4)

search_catalog

**Purpose:** Search business catalog for objects **Returns:** Matching objects with metadata **Use when:** Finding existing views, tables, models by name or description

find_assets_by_column

**Purpose:** Find data assets by column name **Returns:** Objects containing specified column **Use when:** Discovering which tables/views contain specific columns

analyze_column_distribution

**Purpose:** Profile data distribution in columns **Returns:** Statistics, distinct values, nulls, distribution **Use when:** Data quality analysis, understanding data patterns

get_asset_metadata

**Purpose:** Retrieve detailed asset metadata **Returns:** Complete object definition, lineage, usage **Use when:** Deep dive into object structure and dependencies

---

Space Discovery (3)

get_space_details

**Purpose:** Get space configuration and settings **Returns:** Storage allocation, members, permissions, priority **Use when:** Understanding space setup, auditing configuration

list_space_objects

**Purpose:** List all objects in a space **Returns:** Tables, views, models, flows by type **Use when:** Discovering space content, cataloging objects

get_space_permissions

**Purpose:** Review space access controls **Returns:** User permissions, role assignments **Use when:** Auditing security, understanding access levels

---

Database User Management (5)

create_database_user

**Purpose:** Create new database user **Parameters:** Username, password, permissions **Use when:** Setting up technical users, ETL accounts

update_database_user

**Purpose:** Modify database user properties **Parameters:** Username, new permissions **Use when:** Changing user permissions, updating configuration

delete_database_user

**Purpose:** Remove database user **Parameters:** Username **Use when:** Deprovisioning users, cleanup

reset_database_user_password

**Purpose:** Reset database user password **Parameters:** Username **Returns:** New password (encrypted) **Use when:** Password recovery, security incidents

list_database_users

**Purpose:** List all database users **Returns:** Usernames, permissions, status **Use when:** Auditing users, permission review

---

Metadata Tools (4)

get_table_metadata

**Purpose:** Get table structure and properties **Returns:** Columns, data types, keys, partitions **Use when:** Designing integrations, understanding table structure

get_view_metadata

**Purpose:** Get view definition and dependencies **Returns:** SQL definition, source tables, columns **Use when:** Understanding view logic, tracing lineage

get_model_metadata

**Purpose:** Get analytic model structure **Returns:** Dimensions, measures, associations, variables **Use when:** Building SAC stories, understanding model capabilities

describe_entity

**Purpose:** Get comprehensive entity information **Returns:** Full metadata, relationships, lineage **Use when:** Detailed analysis, documentation generation

---

Analytical Consumption (4)

query_analytical_data

**Purpose:** Query analytic models for consumption **Parameters:** Model name, filters, dimensions, measures **Returns:** Aggregated data **Use when:** Testing analytic models, validating calculations

get_analytic_model_structure

**Purpose:** Get analytic model definition **Returns:** Model structure, available dimensions/measures **Use when:** Building queries, unders