Server data from the Official MCP Registry
Offline Oracle AWR/ASH report analyzer with DBA tuning advice and a top-3 tuning summary.
About
Offline Oracle AWR/ASH report analyzer with DBA tuning advice and a top-3 tuning summary.
Security Report
Valid MCP server (1 strong, 4 medium validity signals). No known CVEs in dependencies. Package registry verified. Imported from the Official MCP Registry.
9 files analyzed · 1 issue found
Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.
Permissions Required
This plugin requests these system permissions. Most are normal for its category.
How to Install
Add this to your MCP configuration file:
{
"mcpServers": {
"io-github-bluegemsk-oracle-mcp-lite": {
"args": [
"oracle-mcp-lite"
],
"command": "uvx"
}
}
}Documentation
View on GitHubFrom the project's GitHub 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
.dmpinspection 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
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.
Reviews
No reviews yet
Be the first to review this server!
More Developer Tools MCP Servers
Rea
Freeby Morluto · Developer Tools
Reverse engineer anything from your terminal or agent with one CLI and MCP server.
Paperclip
Freeby Paperclipai · Developer Tools
Trending hip-hop artist momentum scores across four cultural dimensions.
Git
Freeby Modelcontextprotocol · Developer Tools
Read, search, and manipulate Git repositories programmatically
Toleno
Freeby Toleno · Developer Tools
Toleno Network MCP Server — Manage your Toleno mining account with Claude AI using natural language.
MCP Marketplace
Freeby mcp-marketplace · Developer Tools
Search and install MCP servers from inside your AI client.
mcp-creator-python
Freeby mcp-marketplace · Developer Tools
Create, build, and publish Python MCP servers to PyPI — conversationally.