Oracle Database MCP Toolkit

tools:
  hotels-by-name:
    dataSource: prod-db
    description: Returns hotel details by name including capacity, rating and address
    parameters:
      - name: name
        type: string
        description: Hotel name to search for
        required: false
    statement: SELECT * FROM hotels WHERE name LIKE '%' || :name || '%'

mvn clean package

{
  "mcpServers": {
    "oracle-db-mcp-toolkit": {
      "command": "java",
      "args": [
        "-Ddb.url=jdbc:oracle:thin:@your-host:1521/your-service",
        "-Ddb.user=your_user",
        "-Ddb.password=your_password",
        "-jar",
        "/path/to/oracle-db-mcp-toolkit-1.0.0.jar"
      ]
    }
  }
}

"Analyze JDBC log file at /logs/app.log"
"Search for similar documents about 'database performance tuning'"
"Explain the execution plan for: SELECT * FROM orders WHERE status = 'PENDING'"

dataSources:
  prod-db:
    url: jdbc:oracle:thin:@prod-host:1521/ORCLPDB1
    user: ${user}
    password: ${password}

tools:
  my-custom-query:
    dataSource: prod-db
    description: Custom query description
    statement: SELECT * FROM my_table WHERE id = :id
    parameters:
      - name: id
        type: number
        description: Record ID
        required: true

"Compare JDBC logs from before and after the optimization"
"Get performance statistics from the application log"
"Explain the execution plan for the slow query and suggest improvements"

"Extract all errors from the JDBC log file"
"Show me connection events in the last hour"
"Get packet dumps for connection ID 12345"

"Find documents similar to 'Oracle Database backup strategies'"
"Search for knowledge base articles about performance tuning"

"Get customer details by email address" (custom YAML tool)
"List all orders pending shipment" (custom YAML tool)
"Find hotels near a specific location" (custom YAML tool)

# Step 1: Analyze logs
"Get JDBC statistics from /logs/app.log"

# Step 2: Identify slow queries
"Get all queries from the JDBC log"

# Step 3: Analyze execution plan
"Explain the execution plan for: SELECT * FROM large_table WHERE date > SYSDATE - 7"

# Step 4: Get tuning suggestions
# (The explain_plan tool returns an LLM-ready prompt)

# Step 1: Set up vector embeddings (run SQL directly)
CREATE TABLE knowledge_base (
  id NUMBER PRIMARY KEY,
  text CLOB,
  embedding VECTOR
);

# Step 2: Search using similarity_search tool
"Find knowledge base articles similar to 'database connection pooling'"

# Step 3: Retrieve top results
# Returns JSON with similar documents and scores

# Define in config.yaml
tools:
  customer-orders:
    description: Get all orders for a customer by email
    parameters:
      - name: email
        type: string
        description: Customer email address
        required: true
    statement: |
      SELECT o.id, o.order_date, o.total, o.status
      FROM orders o
      JOIN customers c ON o.customer_id = c.id
      WHERE c.email = :email
      ORDER BY o.order_date DESC

"Get all orders for customer [email protected]"