⚙️ MCP Server for Oracle

⏰ When to use

When somebody has MCP client/host and wants to connect to your Oracle database in "MCP" way

❓ What is it

FastAPI with different syntax

🚀 How to use

Just open app.py and copy the code you need. Or:

🖥️ Window

Clone this repo to your machine:

git clone https://github.com/fr33w1f1/mcpy-oracle
cd mcpy-oracle

Install uv (or use conda)

powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/install.ps1 | iex"

Create and use virtual env

uv venv --python 3.12
.\.venv\Scripts\activate

Install requirements

uv pip install -r requirements.txt 

Create .env with these 3:

USERNAME=
PASSWORD=
DSN=HOST:PORT/SERVICENAME

(Optional) Default host 0.0.0.0:8000. If you want to change, add below variable to .env

FASTMCP_PORT=8001
FASTMCP_HOST=0.0.0.0

Start MCP server

python -m app

🐧 Linux

🛠 MCP tools

def execute_sql(sqlString: str) -> str
    """
    Execute a SQL query against the Oracle database.
    """

def get_schemas() -> str
    """
    Retrieve a list of available schemas (users) in the database.
    """

def get_tables(schema: str) -> str
    """
    Retrieve a list of table names for the given schema.
    """

def get_table_columns(schema: str, table_name: str) -> str
    """
    Retrieve column metadata for a given table.
    """

Optional: Expose you MCP outside your local network using ngrok

MCP Inspector to test your tools

Install npx

npx @modelcontextprotocol/inspector uv --directory "D:\sourcecode\mcpy_server" run -m mcpy_server.app