Skip to content
MCP server

Oracle MCP Lite

Analyzes Oracle AWR and ASH reports offline and returns a ranked tuning summary

Runs locallyStatus and history
Install
Pricing
Open source
Platforms
CLI
Runs
Locally
Version
0.1.1
Listing updated
today

Similar MCP servers

About Oracle MCP Lite

Oracle MCP Lite is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.

Hand it an AWR or ASH report in HTML or text and it works out the report type, database version, average active sessions, load profile, top wait events and top SQL. Each finding carries short, version-aware DBA tuning advice, and the output ends with a prioritized top-3 tuning_summary.

It covers Oracle 10g through 23ai, single instance or RAC global reports. Everything runs locally, so reports never leave the machine, and no Oracle client or database connection is needed. The README's example summary flags things like slow redo shipping to a standby, heavy CPU time and a SQL statement with long time per execution.

This is the free edition. The author points to a full version that adds PL/SQL code review, DDL summaries and Data Pump dump inspection. Install with pip and register oracle-mcp-lite in your client.

Install

Run in a terminal

claude mcp add oracle-mcp-lite -- uvx oracle-mcp-lite

Add to claude_desktop_config.json

{
  "mcpServers": {
    "oracle-mcp-lite": {
      "command": "uvx",
      "args": [
        "oracle-mcp-lite"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "oracle-mcp-lite": {
      "command": "uvx",
      "args": [
        "oracle-mcp-lite"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "oracle-mcp-lite": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "oracle-mcp-lite"
      ]
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "oracle-mcp-lite": {
      "command": "uvx",
      "args": [
        "oracle-mcp-lite"
      ]
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "oracle-mcp-lite": {
      "command": "uvx",
      "args": [
        "oracle-mcp-lite"
      ]
    }
  }
}

Using several servers? Build one config file with the MCP config generator.

What it does

AWR and ASH parsing
Reads HTML or text reports from Oracle 10g to 23ai.
Top-3 tuning summary
Ranks the three most important findings.
Wait and SQL analysis
Covers load profile, top wait events and top SQL.
RAC support
Handles global RAC reports as well as single instances.
Fully offline
No Oracle client or database connection; reports stay local.

Good for

  • Triage an AWR report from a slow nightly batch
  • Find the first thing to fix in an ASH report
  • Explain wait events to a developer without DBA training
  • Review RAC performance reports with consistent advice

Pricing

Open source

Free MIT edition; a fuller version is offered separately

Oracle MCP Lite FAQ

Does it connect to my database?

No. It analyzes report files only and needs no Oracle client.

Which versions are supported?

Oracle 10g to 23ai, including RAC global reports.

Does my data leave the machine?

The README says it runs locally and reports never leave it.

How do I install it?

`pip install oracle-mcp-lite`, then add the command to your MCP client.

Is Oracle MCP Lite free?

Yes. Oracle MCP Lite is open source, so you can use and self-host it for free.

How do I add Oracle MCP Lite to Claude Code?

Run this command in your terminal: claude mcp add oracle-mcp-lite -- uvx oracle-mcp-lite

What are the best alternatives to Oracle MCP Lite?

The closest alternatives to Oracle MCP Lite are Midplane, Postgres Secured (Aegis Zero-Trust), ArcadeDB, Seqora and Snowflake sequence bits, id discarded.

Where this comes from

  • Description: written from the project's README.
  • Install steps: from the official MCP Registry entry.

How AIPoweredBot checks servers