Oracle Mcp Lite

io.github.bluegemskPublished by GitHub account bluegemskv0.1.1Updated Oct 29, 2026

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

VerifiedSTDIODesktop onlyDatabases Data & Analytics

Server details

Identifier: io.github.bluegemsk/oracle-mcp-lite
Transport: STDIO
Runtime: Desktop only
Trust: Verified
Published: Oct 29, 2026

Security note

MCP servers receive tool arguments from a conversation and may perform external actions. Review what a server can do before you enable it, and give it only the access it needs.

The registry verified the GitHub account bluegemsk for this listing. That does not show the account is the product's maker.

SourceWeft's checks cover whether the listing is complete and the endpoint answered; they do not review the server's code or what its tools do.

Add a badge to your README

Show readers this MCP server is listed on SourceWeft. The badge links to this page.

[![Listed on SourceWeft](https://sourceweft.com/badge/mcp/io.github.bluegemsk%2Foracle-mcp-lite.svg)](https://sourceweft.com/mcp/io.github.bluegemsk%2Foracle-mcp-lite?utm_source=readme&utm_medium=badge)

Overview

AI-generated overview

Offline MCP server that reads Oracle AWR/ASH reports and returns wait events, top SQL and prioritized DBA tuning advice.

What you can do: Parse a supplied AWR or ASH report (HTML or text, Oracle 10g–23ai, single instance or RAC global) and identify report type and database version
Summarize average active sessions, load profile, top wait events and top SQL
Attach short, version-aware DBA tuning advice to each finding
Produce a prioritized top-3 tuning summary of what to fix first
When to use it: Useful when you have Oracle AWR or ASH report files and want an assistant to interpret them and suggest where to start tuning, without connecting to the database or sending reports off the machine.
Requirements: Local Python package installed with pip (oracle-mcp-lite), run as a stdio MCP server. No Oracle client, database connection, account, API key or environment variable is needed; the report file must be accessible on the local machine.

Before you install

Reports are analyzed locally and are not uploaded, but they contain SQL text, schema and workload details, so keep the files and any assistant output appropriately private. Advice is heuristic guidance, not a substitute for DBA review. The full version with PL/SQL review, DDL checks and Data Pump inspection is a separate product.

Installation

In SourceWeft

Open Oracle Mcp Lite in the dashboard and add it to a workspace.
Enable the server for the chats that should use its tools.

Desktop only via STDIO. STDIO servers start a local process, so they need the SourceWeft desktop host.

Other MCP clients

Follow the launch instructions in the repository.

README

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

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

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

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

Tests use synthetic fixtures only.

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

Source: README.md at commit 3a23154

Tools

SourceWeft has not started this package in its sandbox yet, so its tools are not known.

Version history

v0.1.1LatestOct 29, 2026

Score

50% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

Reached in the last 30 days25 pts
Keep the endpoint answering the MCP handshake; SourceWeft probes it every 30 days.
Auth declared10 pts
Declare the credential headers in the registry entry, or keep the endpoint answering the probe so its auth can be classified.
Tools listed15 pts
Answer tools/list without a credential, or ship a package that starts in a sandbox without one.
DescriptionRequired15 pts
Logo10 pts
Documentation15 pts
License10 pts