Fusion BIP MCP Server
MCP server for Oracle Fusion BI Publisher that lets AI agents run queries, reports, and manage catalog objects via a secure, scoped interface.
README
Fusion BIP MCP Server
An MCP server that gives an AI agent safe, described access to Oracle Fusion BI Publisher. Instead of handing an agent raw credentials, you expose a small set of scoped tools it can call — run a query, run a report, fetch or deploy catalog objects — and the server talks to Fusion's BI Publisher SOAP service directly. No database and no middle tier to stand up.
This is a public, source-only mirror of the core server for people who want to read the code or point their own agent at their own Fusion instance.
The tools
| Tool | What it does | Access |
|---|---|---|
query_fusion |
Run a read-only SELECT against Oracle Fusion and return the rows | read |
run_report |
Run a deployed BI Publisher report and return its output | read |
get_catalog_object |
Download a catalog object definition (.xdm / .xdo) for inspection |
read |
deploy_data_model |
Deploy a BI Publisher data model (.xdm) to a catalog folder |
write |
deploy_report |
Deploy a BI Publisher report (.xdo) linked to a data model |
write |
delete_catalog_object |
Delete a data model or report from the catalog | write, off by default |
The destructive delete_catalog_object tool stays unregistered unless you explicitly opt in with FUSION_MCP_ENABLE_DELETE=1, so an agent cannot delete anything it was never given.
How it fits together
AI agent (Claude Code, etc.)
│ MCP (stdio)
▼
server.py registers the tools, meters usage
│
client.py ─────► direct_client.py ──► BI Publisher SOAP ──► Oracle Fusion
│ (soap.py builds the envelopes,
context.py execute.py runs them,
(credentials/targets) builders.py shapes .xdm/.xdo)
server.py— the MCP server; registers each tool and its description.client.py— the backend seam the server imports.direct_client.py— the six operations implemented against BI Publisher SOAP.soap.py/execute.py/builders.py— envelope construction, execution, and.xdm/.xdoartifact building.context.py— where the Fusion pod and user credentials are resolved for a call. The defaults in this mirror are placeholders (your-pod,bip_user); wire in your own.metering.py— an append-only, metadata-only usage log.
Running it locally
pip install -e ".[stdio]" # installs the mcp runtime
# set your Fusion pod + user in context.py (or via environment) and register
# fusion-mcp with your MCP client (Claude Code / Desktop) over stdio.
Notes
- This mirror is the direct-over-SOAP path only. Credential wiring is intentionally left as placeholders — it does not run as-is against any real instance until you supply your own Fusion pod and a user with the BI Publisher Author role.
- No credentials, tokens, or private endpoints are included.
License
MIT — see LICENSE.
Recommended Servers
playwright-mcp
A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.
Magic Component Platform (MCP)
An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.
Audiense Insights MCP Server
Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.
VeyraX MCP
Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.
graphlit-mcp-server
The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.
Kagi MCP Server
An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.
Neon Database
MCP server for interacting with Neon Management API and databases
E2B
Using MCP to run code via e2b.
Exa Search
A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.
Qdrant Server
This repository is an example of how to create a MCP server for Qdrant, a vector search engine.