---
name: "Odoo Assessment MCP"
description: "Pull Assessment, Test Case, and Mandays data from Odoo straight from a Claude chat — no terminal or CLI scripts needed."
type: mcp
roles: ["Engineering", "Quality Assurance", "Project Management"]
activities: ["Assessment", "Quality Assurance", "Reporting"]
tags: ["Odoo", "MCP", "Assessment", "Test Case", "Mandays"]
owner: "Integration Team"
compatibility: "All MCP-compatible AI agents"
---

# Odoo Assessment MCP

> Pull Assessment, Test Case, and Mandays data from Odoo straight from a Claude chat — no terminal or CLI scripts needed.

## Overview

The Odoo Assessment MCP connects Claude directly to the Assessment, Test Case, and Mandays data in Qiscus's internal Odoo. You can ask Claude to search, summarize, or check the status of an assessment through a normal chat — no need to open a terminal, run a CLI script, or log in to Odoo manually.

This integration is **Read-Only** — you cannot change, edit, or delete Odoo data through this MCP.

> **Required:** the company VPN must be active and stable before using this MCP. The Odoo system sits on a closed network — without the VPN, every request will be rejected or time out.

## Capabilities

| Capability | Description |
| --- | --- |
| List Assessments | Show a list of the most recent assessments in the system |
| Get Assessment Detail | Fetch the full detail of a single assessment by name or ID |
| List Test Cases | View test cases and their status for a given feature or assessment |
| Get Mandays | Pull mandays data along with reference links from the related solution IDs |
| Search Assessment | Search for assessments by name or keyword |

## Install Steps

### Before You Start

- Company VPN active and connection stable
- Claude Desktop installed — [download](https://claude.ai/download)
- Node.js v18+ — check with `node --version`. Don't have it? Install from [nodejs.org](https://nodejs.org) (choose LTS)
- Login access to Qiscus's internal Odoo

### 1. Create an API Key in Odoo

1. Open the company Odoo site in your browser and log in
2. Click your profile photo in the top right → select **My Profile**
3. Switch to the **Account Security** tab
4. Scroll to the **API Key** section → click **New API Key**
5. Give it a clear name, e.g. `MCP Claude Demo` or `Claude AI Integration`
6. Click **Generate**

> **Important:** copy the API Key right away and save it in a password manager (Bitwarden, 1Password, etc.). Odoo shows this code only **once** — if you miss it, you'll have to delete that key and create a new one.

### 2. Set Up the Configuration in Claude Desktop

Open Claude Desktop → **Settings** → **Developer Settings** → **Edit Config**.

Add the snippet below into `mcpServers`. Replace every `[...]` part with your own data:

```json
{
  "mcpServers": {
    "kiskas-assessment": {
      "command": "npx",
      "args": ["-y", "[MCP_PACKAGE_NAME]"],
      "env": {
        "ODOO_URL": "[COMPANY_ODOO_URL]",
        "ODOO_DB": "[ODOO_DATABASE_NAME]",
        "ODOO_USERNAME": "[YOUR_ODOO_EMAIL]",
        "ODOO_API_KEY": "[API_KEY_FROM_STEP_1]"
      }
    }
  }
}
```

> Make sure the package name in `args` matches the latest instructions from the dev team. Even a single typo will stop Claude from connecting to the MCP.

If your config already has other MCP servers, merge the `kiskas-assessment` entry into the existing `mcpServers` — don't overwrite the whole file.

Save the file (`Cmd+S` / `Ctrl+S`).

### 3. Restart Claude Desktop

Quit Claude Desktop completely — don't just close the window:

- **macOS:** `Cmd+Q`, or the Claude menu in the menu bar → Quit
- **Windows:** system tray in the bottom right → Claude icon → right-click → Quit. Or via Task Manager
- **Linux:** system tray → Claude icon → Quit

Open Claude Desktop again. If the setup worked, an extra tools icon will appear — a sign the MCP is now active.

## Example Prompts

Claude can sometimes pick the wrong tools and use its own built-in ones instead. Give specific instructions so Claude uses the right MCP:

```
Don't use your built-in assessment validation skill. Use the Kiskas Assessment MCP
tools to list the 5 most recent assessments in the system.
```

```
Find the mandays data along with the reference links for assessment [Assessment_Name].
```

```
Using the Kiskas Assessment MCP, check the detailed test case status for [Feature_Name]
and write me a summary.
```

## Technical Notes: Mandays Lookup

Mandays data doesn't sit at the surface level of the Odoo database — it's stored deep inside the **Solution IDs** tables. When you request mandays data, Claude has to run a multi-step process: find the assessment ticket → trace the solution ID → then pull the mandays figure. Give it a moment so the process finishes completely and accurately.

## Troubleshooting

| Problem | Solution |
| --- | --- |
| Request rejected / timeout | Make sure the VPN is active and the connection is stable |
| `kiskas-assessment` doesn't show up in Connectors | Validate the JSON at [jsonlint.com](https://jsonlint.com), restart Claude fully |
| Odoo authentication error | Check that `ODOO_USERNAME` and `ODOO_API_KEY` are correct |
| API Key invalid | The key may have been deleted. Create a new API Key in Odoo |
| Claude uses the wrong tools | Add an explicit instruction in the prompt: *"Use the Kiskas Assessment MCP"* |
| Mandays data doesn't appear | It's a multi-step process — give it more time, or retry the prompt with a more specific assessment name |