Oracle Data Studio MCP server — Essbase, ADP (Autonomous Database Data Platform), and Data Transforms with Oracle 23ai annotation-aware query routing
Until 2026-09-25 this record combined several servers published from one repository. The others now have records of their own: oracle.oci-resource-search-mcp-server, oracle.oci-api-mcp-server, oracle.oci-cloud-guard-mcp-server, oracle.oci-cloud-mcp-server, oracle.oci-compute-instance-agent-mcp-server, oracle.oci-compute-mcp-server, oracle.oci-fsdr-mcp-server, oracle.oci-load-balancer-mcp-server, oracle.oci-migration-mcp-server, oracle.oci-network-load-balancer-mcp-server, oracle.oci-recovery-mcp-server, oracle-mcp-common, oracle.oci-identity-mcp-server, oracle.oci-logging-mcp-server, oracle.oci-object-storage-mcp-server, oracle.oci-usage-mcp-server, oracle.oci-monitoring-mcp-server, oracle.oci-networking-mcp-server, oracle.oci-registry-mcp-server. Checks from before that date include them.
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.
Everything here was measured by our prober or read from a registry. Nothing is self-reported.
Attributed to the source that supplied each field. Treated as claims, not facts.
# Oracle Data Studio MCP Server ## Platform compatibility The locked cryptography dependency no longer supports Intel macOS or 32-bit Windows. Use Apple Silicon macOS, 64-bit Windows, or a supported Linux environment. ## 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-stu…
Mapped onto the structured taxonomy from declared text and observed tool names. Confidence shown for derived entries.
Every source is kept verbatim. Field changes are logged as events.