Download the BO Query MCP zip file and unpack it to a preferred location, for example:
C:\Tools\boquerymcp\
The folder should contain at least:
boquerymcp.jar — the main server that talks to your BO platform.license.txt if you have a PRO license.We recommend Eclipse Temurin JRE 17 — download the installer and run it.
BO Query MCP connects to SAP BusinessObjects through the BIP REST API.
If you access SAP BO LaunchPad at:
https://bip-server/BOE/BI
then the BIP REST endpoint is usually:
https://bip-server/biprws
Contact your SAP BO administrator if you are not sure. The URL can normally be found in the Central Management Console under Applications → RESTful Web Service.
In Claude Desktop, open Settings → Developer and click Edit Config — this opens claude_desktop_config.json in your default editor.
{
"mcpServers": {
"boquerymcp": {
"command": "java",
"args": [
"-jar",
"C:\\<path>\\boquerymcp\\boquerymcp.jar"
],
"env": {
"BICLEVER_RWS": "https://bip-server/biprws",
"BICLEVER_USERNAME": "your-username",
"BICLEVER_PASSWORD": "your-password",
"BICLEVER_LICENSE_FILE": "C:\\<path>\\boquerymcp\\license.txt"
}
}
}
}
Alternatively, sensitive environment variables such as BICLEVER_PASSWORD can be set in Windows under System Properties → Environment Variables so you don’t store credentials in the Claude Desktop config file.
Restart Claude Desktop fully (tray-icon Quit, then relaunch). The four universe tools (list_universes, describe_universe, run_query, inspect_sql) become available.
| Var | Required? | What it does |
|---|---|---|
BICLEVER_RWS |
yes | BIP REST root URL, e.g. https://bip-server/biprws. |
BICLEVER_USERNAME |
yes | BIP login. |
BICLEVER_PASSWORD |
yes | BIP password. |
BICLEVER_LICENSE_FILE |
yes for PRO | Absolute path to license.txt. Without it, run_query runs in free mode — first 10 rows only, prefixed with a # Free mode … comment. PRO removes the cap. |
| Tool | Free | PRO | Description |
|---|---|---|---|
list_universes |
✓ | ✓ | List CMS universes by name + folder. |
describe_universe(name, folder?) |
✓ | ✓ | Folders, dimensions, measures, predefined filters with their backslash-joined paths. |
run_query(universe, …) |
preview (10 rows) | full (caller’s limit) |
Ad-hoc query against a universe with optional filter tree. Returns CSV. |
inspect_sql(universe, …) |
✓ | ✓ | Returns the SQL the query would send to the database without executing it. No row cap (no rows returned). |