Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Introduction

APPM is an Oracle database performance monitoring and analytics tool by Abakus. It continuously collects and stores performance data from Oracle databases, providing administrators with a centralized repository and web-based interface for analyzing database health and diagnosing issues.

MCP Integration

Starting with version 5.0, APPM includes a built-in MCP (Model Context Protocol) server. This allows AI assistants — such as Claude — to connect directly to APPM and query performance data on your behalf.

In practice, this means you can ask an AI agent questions like “Why is my database slow right now?” and it will retrieve the relevant metrics from APPM, analyze them, and provide an actionable summary. The MCP connection is read-only, so the AI agent can observe but never modify your repository or monitored databases.

What This Manual Covers

  • Initial Setup — Enabling MCP access in APPM and generating API keys.
  • MCP Clients — Configuring AI clients (e.g. Claude Code) to connect to the APPM MCP server.
  • Examples — Real-world examples of using an AI assistant to diagnose database performance issues through APPM.