oracle.data-studio-mcp-server

MCP serverMCP

Oracle Data Studio MCP server — Essbase, ADP (Autonomous Database Data Platform), and Data Transforms with Oracle 23ai annotation-aware query routing

repository ↗homepage ↗v1.0.2Universal Permissive License v 1.0

Is this yours?

This record is unclaimed

Wellknown found it in public sources; nobody has proven control of it yet. Claiming takes one click if the repository is under your GitHub account, or a small file on your domain otherwise. Verified owners get the badge, 15-minute checks, status alerts, edits that outrank crawled data, and a ranking boost.

Agents can do it too: POST https://wellknown.network/api/v1/claims with {"agent":"oracle-data-studio-mcp-server","method":"well_known_file"} — machine-readable steps at claim.json, guide at /docs/claim.

Claim this record

Observed by Wellknown

Evidence

Everything here was measured by our prober or read from a registry. Nothing is self-reported.

30-day availabilityno checks in window

30 days agotoday

Endpoints

pypi:oracle.data-studio-mcp-serverpackage pypi · not network-checkable
pypi:oracle-mcp-commonpackage pypi · not network-checkable
pypi:oracle.oci-api-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-cloud-guard-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-cloud-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-object-storage-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-compute-instance-agent-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-compute-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-fsdr-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-identity-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-load-balancer-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-logging-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-migration-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-monitoring-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-networking-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-network-load-balancer-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-recovery-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-registry-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-resource-search-mcp-serverpackage pypi · not network-checkable
pypi:oracle.oci-usage-mcp-serverpackage pypi · not network-checkable

Registry facts

registry: pypi
package: oracle.data-studio-mcp-server
latest: 1.0.2
published: 17 d ago
weekly downloads: —
observed: 2 d ago

Declared by sources

What the publisher says

Attributed to the source that supplied each field. Treated as claims, not facts.

# Oracle Data Studio MCP Server ## Overview This server provides task-oriented MCP tools for three Oracle Data Studio services: - **Oracle Essbase** — applications, databases, outline, MDX, calc scripts, files, security, jobs. - **ADP** (Autonomous Database Data Platform) — Analytic Views, Select AI, Insights, cloud loading, catalogs, data sharing, **Oracle 23ai annotations**. - **Data Transforms** — pipelines, schedules, connections, workflows, dataloads. Built on [FastMCP](https://github.com/jlowin/fastmcp) and the [oracle-data-studio](https://pypi.org/project/oracle-data-studio/) Python SDK. Each tool combines multiple SDK calls into a single coherent operation that returns LLM-ready output, rather than exposing raw REST endpoints. **60 high-level tools + 1 reusable prompt template.** ## Running the server ### STDIO transport mode ```sh uvx oracle.data-studio-mcp-server ``` ### MCP client configuration (Claude Desktop, Cursor, Codex, …) ```json { "mcpServers": { "oracle-data-studio": { "command": "uvx", "args": ["oracle.data-studio-mcp-server"] } } } ``` By default the server runs in the safe **viewer** profile — metadata browsing only, no execution or modification. To unlock query/execute operations, opt into a higher profile **explicitly**: ```json "args": ["oracle.data-studio-mcp-server", "--profile", "analyst"] ``` ```json "args": ["oracle.data-studio-mcp-server", "--profile", "admin"] ``` See the *Profiles* section below for what each tier exposes. ## Authentication Connection details and credentials are read from (in order of priority): 1. CLI args / environment variables 2. OS keyring (recommended for desktop use) 3. INI file at `~/.oracle-data-studio/config` Configure once with the bundled CLI: ```sh uvx oracle.data-studio-config set adp \ --url 'https://<adb-host>.adb.<region>.oraclecloudapps.com' \ --user ADMIN # prompts for password, stores in OS keyring uvx oracle.data-studio-config set essb…

mcpdisaster-recoveryfsdrocioracle

kind PyPI

name PyPI

license PyPI

repoUrl PyPI

summary PyPI

version PyPI

description PyPI

homepageUrl PyPI

Provenance