Skip to main content
Glama
oracle-mcp-lite

oracle-mcp-lite

by bluegemsk

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

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

Related MCP server: oracledb-mcp

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.

Available Tools

1 tool
awr_analyzeB

Analyze an Oracle AWR or ASH report (HTML or text, 10g-23ai, incl. RAC global). Returns DB info, load profile, top wait events and top SQL with tuning advice, recommendations and a top-3 tuning_summary.

Inputs: path, content.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.4/5.0

    Scored across 1 tool

    Disambiguation5/5

    With only a single tool there is no possibility of confusion or misselection. The purpose (analyze AWR/ASH reports) is clearly stated and unambiguous.

    Naming Consistency4/5

    The lone name awr_analyze follows a clear noun_verb snake_case pattern, though a single data point makes consistency trivially satisfied rather than demonstrated across a set.

    Tool Count2/5

    A one-tool surface is too thin for a database diagnostics server; everything hinges on the user already having a report file. Typical tuning workflows (connect, list snapshots, fetch report) have no supporting tools.

    Completeness3/5

    The analysis itself appears thorough (DB info, waits, top SQL, recommendations), but the lifecycle is a dead end: there is no tool to retrieve or generate an AWR/ASH report from a database, and no follow-up tools for deeper drill-down.

    Maintenance

    ActivityMaintained
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • F
      license
      Not graded
      quality
      C
      maintenance
      Universal database copilot for diagnostics, operations, and performance analysis via MCP and CLI.
      -
    • F
      license
      Not graded
      quality
      D
      maintenance
      MCP server for Oracle SQL performance diagnostics and AWR analysis, compatible with any MCP client that supports stdio or HTTP transports.
      -
    • A
      license
      Not graded
      quality
      A
      maintenance
      Enables AI assistants to inspect and query Oracle Forms modules (blocks, triggers, program units, etc.) without Forms Builder, supporting reverse engineering, code review, and modernization.
      10
      Apache 2.0