Skip to main content
Glama
marat-ak

Fusion Schema MCP Server

by marat-ak
OverviewSchemaSourceRelated ServersDiscussionsAdmin
TypeScript
Remote

Fusion Schema MCP Server

Standalone HTTP MCP server that grounds a Fusion-SQL agent against the Oracle Fusion schema catalog. The models already know most Oracle ERP names (from EBS on-prem), but Fusion Cloud ≠ EBS — so these tools validate and correct the objects/columns the agent thinks it knows, and surface real join paths (declared FKs + mined relationships).

Scope: grounding only. No SQL parsing, no SQL execution/validation (that needs a live Oracle DB — later round). No agent, no CloudBeaver UI (later rounds).

Tools

Tool

Purpose

searchTables(query, limit?)

FTS over name + description + module; discovery by description

getTable(name)

metadata: type, module, description, primary key, column count

getColumns(table)

columns with type/size/nullable/description/PK flag

validateTable(name)

exists? + fuzzy "did-you-mean" (EBS→Fusion drift)

validateColumns(table, columns[])

per-column exists + suggestions

getIndexes(table)

indexes with ordered columns + uniqueness

getRelatedTables(table)

declared FKs + mined relationships, tagged + confidence = join paths

Related MCP server: OracleDB MCP Server

Data

data/ holds the source metadata (copied from ../../Bip/DB_SCHEMA via scripts/copy-data.sh): META_TABLES/COLUMNS/INDEXES/PKEYS/FKEYS.csv + mined_relationships.json. The compile step filters junk table rows to TABLE/VIEW and builds the split seed DBs schema.sqlite + reports.sqlite (FTS5 + lookup indexes).

Boot

The container starts through /entry (setup V1 task 9): it waits for the stack.fusion module on the oservices-setup Config API (SETUP_URL), logs [entry] stack.fusion rev=N and [entry] stack.fusion CATALOG_VERSION=<v|(unset)>, reports its status, then execs /entrypoint.sh unchanged (the CATALOG_DB gate below still applies). A standalone build needs the named build context: docker build --build-context oservices-config=../oservices-setup/config ..

Build & run (CloudBeaver WSL distro)

All commands run inside the CloudBeaver WSL distro. Scripts avoid PowerShell→wsl quoting.

# 1. copy source data into ./data (once)
bash scripts/copy-data.sh

# 2. install deps, build TS, compile schema.sqlite + reports.sqlite
bash scripts/install-build-compile.sh

# 3. boot + live smoke test (starts server, runs a real MCP client, asserts acceptance criteria)
bash scripts/verify.sh

Docker (the shipping form)

docker compose build
docker compose up -d
curl http://localhost:8979/health

The image is code + the bge-small model cache ONLY — no catalog data is compiled or baked (since 2026-09-25). CATALOG_DB is REQUIRED from the deployment (no image default):

  • postgres (dev): DATABASE_URL → the fusion database on stack-db; nothing SQLite is touched and nothing is written under /app.

  • sqlite: DATA_DIR + SEED_DIR — a seed VOLUME carrying VERSION + schema.sqlite.zip + reports.sqlite.zip (built on a dev box with npm run compile && npm run zip-seed); on start entrypoint.sh runs provision.js, which unpacks/upgrades the split DBs in DATA_DIR. A missing seed file is a loud boot failure, never an empty catalog. A pre-split single catalog.sqlite is converted once with node dist/migrate-split.js <catalog.sqlite> --schema <dir>/schema.sqlite --reports <dir>/reports.sqlite.

Connecting an agent

Point any MCP client at the Streamable-HTTP endpoint:

http://<host>:8979/mcp

e.g. Claude Agent SDK / Codex SDK mcpServers config, or the MCP inspector.

Env

Var

Default

Meaning

MCP_PORT

8979

HTTP port

MCP_HOST

0.0.0.0

bind host

CATALOG_DB

— (required)

postgres (+ DATABASE_URL) or sqlite (+ DATA_DIR, SEED_DIR)

DATABASE_URL

— (required, postgres)

the fusion database

DATA_DIR

— (required, sqlite)

dir holding the split DBs; also the source CSV/JSON dir for the dev-box compile step

SCHEMA_DB

<DATA_DIR>/schema.sqlite

schema tables (tables/columns/keys/relationships/meta)

REPORTS_DB

<DATA_DIR>/reports.sqlite

report corpus (report_queries + fts + vec)

CACHE_DB

<DATA_DIR>/cache.sqlite

column-search embedding cache

SEED_DIR

— (required, sqlite)

seed volume: VERSION + schema.sqlite.zip + reports.sqlite.zip read by provision.js

MCP_URL

http://127.0.0.1:8979/mcp

smoke-client target

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityActive
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • Oracle DB Context

    Dhananjay-2024
    F
    license
    Not graded
    quality
    D
    maintenance
    Provides contextual Oracle database schema information to AI assistants, enabling them to understand and work with large databases containing thousands of tables. Supports multi-database connections, smart schema caching, table lookups, and relationship mapping.
    -

  • OracleDB MCP Server

    hemangbhavasar
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables LLMs to interact with Oracle Databases by providing specific table and column metadata as context. Users can generate SQL statements and retrieve query results directly through natural language prompts.
    Apache 2.0

  • oradb-explorer-mcp

    arun-siv
    F
    license
    Not graded
    quality
    B
    maintenance
    Enables read-only exploration of Oracle databases through natural language, providing schema inspection and safe bounded SQL query execution.
    -