MCP Oracle Async

Oracle MCP server exposing Oracle databases as MCP tools.
Built with FastAPI, uvicorn, and uv for dependency management.

---

Features

• /health → Liveness/readiness check (no DB touch).
• /config → Show loaded MCP config (sanitized).
• /mcp/tools → Advertise available MCP tools.
• /mcp/tools/invoke → (stub) Invoke a tool, echoing request payload.

Profiles are configured in config/profiles.yaml.
Multiple Oracle databases can be supported (informatica, statements, transformer).

---

Project Structure

. ├── README.md ├── pyproject.toml └── mpc-oracle/ ├── config/ ├── docker/ └── src/

---

Quickstart (Dev)

# Build image
docker compose build

# Run container
docker compose up


🧪 Test Endpoints

Health check:

curl http://localhost:8008/health


List tools:

curl http://localhost:8008/mcp/tools


Invoke stub:

curl -X POST http://localhost:8008/mcp/tools/invoke `
  -H "Content-Type: application/json" `
  -d '{"name":"db.query","arguments":{"db_key":"transformer","sql":"SELECT * FROM DUAL","max_rows":2}}'


Expected (stubbed) response:

{
  "tool": "db.query",
  "db_key": "transformer",
  "sql": "SELECT * FROM DUAL",
  "max_rows": 2,
  "rows": []
}