English Français العربية

io.github.bluegemsk/oracle-mcp-lite

Official registry Other

Offline Oracle AWR/ASH report analyzer with DBA tuning advice and a top-3 tuning summary.

Source code Documentation

Install

Add this to your client's MCP configuration (Claude Desktop: claude_desktop_config.json; Cursor: .cursor/mcp.json; VS Code and others use the same "mcpServers" shape).

PYPI package oracle-mcp-lite
Claude Code 
claude mcp add oracle-mcp-lite -- uvx oracle-mcp-lite==0.1.1
JSON configuration (Claude Desktop, Cursor, VS Code) 
{
    "mcpServers": {
        "oracle-mcp-lite": {
            "command": "uvx",
            "args": [
                "oracle-mcp-lite==0.1.1"
            ]
        }
    }
}

Documentation

From the project's README on GitHub, refreshed weekly. Links open on GitHub.

Contents
  1. oracle-mcp-lite
  2. Install
  3. Use
  4. Development

oracle-mcp-lite

Free, offline Oracle AWR / ASH report analyzer for AI assistants (Model Context Protocol server, MIT).

Give Claude, Cursor, Codex or any MCP client an AWR or ASH report (HTML or text, Oracle 10g–23ai, single instance or RAC global) and get back: report type and DB version, average active sessions, load profile, top wait events and top SQL — each with a short, version-aware DBA tuning advice — plus a prioritised top-3 tuning_summary. Runs locally; your reports never leave your machine. No Oracle client or database connection needed.

Full version: PL/SQL code review, DDL summary (missing PKs, unindexed FKs), Data Pump .dmp inspection and more — see **https://bluegem.sk/oracle-mcp**

Install

pip install oracle-mcp-lite
oracle-mcp-lite --list-tools

Client config (Claude Desktop / Cursor / Gemini CLI):

{"mcpServers": {"oracle-awr": {"command": "oracle-mcp-lite"}}}

Claude Code: claude mcp add oracle-awr -- oracle-mcp-lite

Use

"Analyze the AWR report at /reports/awr_0900.html and tell me what to fix first."

Example tuning_summary (synthetic report):

1. ARCH wait on SENDREQ (41.7%): Redo shipping to the standby is slow: check network bandwidth/latency to the
   standby and the transport mode; ASYNC transport removes it from the commit path.
2. CPU time (27.8%): Find the top SQL by CPU / buffer gets and cut logical I/O ...
3. SQL aaaaaaaaaaaa1 (25.0%): Slow per execution (1,800.0 s/exec): check the plan with DBMS_XPLAN.DISPLAY_AWR ...

Development

pip install -e '.[dev]' && pytest && python -m build

Tests use synthetic fixtures only.

Not affiliated with Oracle. Oracle is a trademark of Oracle Corporation.

Frequently asked questions

What is io.github.bluegemsk/oracle-mcp-lite?

Offline Oracle AWR/ASH report analyzer with DBA tuning advice and a top-3 tuning summary.

How do I install io.github.bluegemsk/oracle-mcp-lite?

It runs on your machine. In Claude Code: claude mcp add oracle-mcp-lite -- uvx oracle-mcp-lite==0.1.1. For other clients, paste the JSON configuration from this page into their MCP settings.

Does io.github.bluegemsk/oracle-mcp-lite need an API key?

Its registry entry lists no required key or secret. Some features may still need an account with the service it connects to.

Is io.github.bluegemsk/oracle-mcp-lite open source?

Yes. Its code is on GitHub under the MIT license.

Who maintains io.github.bluegemsk/oracle-mcp-lite?

It is published by bluegemsk. AI.tn lists it but does not maintain or endorse it.

From the official MCP Registry. Listing is not an endorsement: review a server's code and permissions before giving it access to your data.