What it reads and returns

• Any AWR or ASH reportHTML or text reports from Oracle 10g to 23ai, single instance or RAC global.
• Key figuresReport type and database version, average active sessions, load profile, top wait events and top SQL.
• DBA adviceEach wait event and SQL statement comes with short, version-aware tuning advice, plus a prioritised top-3 tuning_summary.
• Local and offlineRuns on your machine. No Oracle client and no database connection are needed, and your reports never leave your machine.

Oracle MCP Lite on GitHub

Install

Install the package from PyPI and list its tools:

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

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

claude mcp add oracle-awr -- oracle-mcp-lite

The JSON snippet is the client configuration for Claude Desktop, Cursor or Gemini CLI; the last line adds it to Claude Code.

Example

Ask your assistant, for example: “Analyze the AWR report at /reports/awr_0900.html and tell me what to fix first.” A tuning_summary from a synthetic report looks like this:

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 ...

Oracle MCP Lite is not affiliated with Oracle. Oracle is a trademark of Oracle Corporation.

Frequently asked questions