Oracle MCP Lite
Analyzes Oracle AWR and ASH reports offline and returns a ranked tuning summary
- 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-liteAdd to claude_desktop_config.json
{
"mcpServers": {
"oracle-mcp-lite": {
"command": "uvx",
"args": [
"oracle-mcp-lite"
]
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"oracle-mcp-lite": {
"command": "uvx",
"args": [
"oracle-mcp-lite"
]
}
}
}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.