# Oracle MCP Lite

> Oracle MCP Lite is an open-source MCP server for databases. Analyzes Oracle AWR and ASH reports offline and returns a ranked tuning summary. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** CLI
- **Repository:** https://github.com/bluegemsk/oracle-mcp-lite
- **MCP Registry name:** io.github.bluegemsk/oracle-mcp-lite
- **Categories:** [databases](https://ai-powered.com/categories/databases)
- **Listing updated:** 2026-11-18

## About

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.

## Features

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

## Install

### Claude Code (Terminal)

```sh
claude mcp add oracle-mcp-lite -- uvx oracle-mcp-lite
```

### Claude Desktop (claude_desktop_config.json)

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

### Cursor (~/.cursor/mcp.json)

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

### VS Code (.vscode/mcp.json)

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

### Windsurf (~/.codeium/windsurf/mcp_config.json)

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

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "oracle-mcp-lite": {
      "command": "uvx",
      "args": [
        "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.

## Alternatives

- [Midplane](https://ai-powered.com/mcp/midplane): Midplane is an open-source MCP server for databases.
- [Postgres Secured (Aegis Zero-Trust)](https://ai-powered.com/mcp/postgres-secured-aegis-zero-trust): Postgres Secured (Aegis Zero-Trust) is an open-source MCP server for databases.
- [ArcadeDB](https://ai-powered.com/mcp/arcadedb): ArcadeDB is an open-source MCP server for databases.
- [Seqora](https://ai-powered.com/mcp/seqora): Seqora is a freemium MCP server for databases.
- [Snowflake sequence bits, id discarded](https://ai-powered.com/mcp/snowflake-sequence-bits-id-discarded): Snowflake sequence bits, id discarded is an open-source MCP server for databases.
- [Snowflake id shape](https://ai-powered.com/mcp/snowflake-id-shape): Snowflake id shape is an MCP server for databases.
- [Snowflake worker-id bits, id discarded](https://ai-powered.com/mcp/snowflake-worker-id-bits-id-discarded): Snowflake worker-id bits, id discarded is an MCP server for databases.
- [Snowflake timestamp bits, id discarded](https://ai-powered.com/mcp/snowflake-timestamp-bits-id-discarded): Snowflake timestamp bits, id discarded is an MCP server for databases.

---
Source: https://ai-powered.com/mcp/oracle-mcp-lite
