Problems to connect to a Community Edition Intersystems IRIS

[gopherlian]

Hi,

We are trying to use the plugin to connect to an IRIS database, in its Community version.

It is running as a docker and the docker configuration is as follows:

version: "3"
services:
database:
container_name: iris-community_2025.1
image: containers.intersystems.com/intersystems/iris-community:2025.1
restart: always
ports:
- "54051:1972"
- "54052:52773"
volumes:
- /media/docker/intersystems/iris-community/iris:/data
environment:
- ISC_DATA_DIRECTORY=/data/data
command: -a /data/bin/init -l /data/data/mgr/messages.log --check-caps false

No action has been performed on the database, except for setting the SuperUser password. No namespace has been created and no configuration has been performed.

Access to the IRIS web portal does not give any problems.

The configuration of the access plugin for Claude has been configured as follows:

{
"mcpServers": {
"iris": {
"command": "uvx",
"args": [
"mcp-server-iris"
],
"env": {
"IRIS_HOSTNAME": "xxxxxxxxx",
"IRIS_PORT": "54051",
"IRIS_NAMESPACE": "%SYS",
"IRIS_USERNAME": "SuperUser",
"IRIS_PASSWORD": "xxxxxxxxx",
"IRIS_SSL": "false"
}
}
}
}
}

However, Claude Desktop returns the following error, to this prompt:

hey, how is the interoperability doing?

Request: {
full_status: true
}

Response: Error executing tool interoperability_production_status: 'Context' object has no attribute 'iris'

What are we doing wrong?

Thanks in advance.

[daimor]

Ohh, I see, my bad, will make a new version with a fix

[daimor]

published version 0.2.0 with a fix, give it a try

[gopherlian]

Hello,

We have tried to run the plugin again but have had no better luck.

A co-worker of mine, who knows python, has tried to make the connection through these two functions:

def get_db_config():
"""Get database configuration from environment variables."""
config = {
"hostname": os.getenv("IRIS_HOSTNAME", "localhost"),
"port": int(os.getenv("IRIS_PORT", 1972)),
"namespace": os.getenv("IRIS_NAMESPACE", "USER"),
"username": os.getenv("IRIS_USERNAME", "_SYSTEM"),
"password": os.getenv("IRIS_PASSWORD", "SYS"),
"sslconfig": None,
}
logger.info("Server configuration:" + config["hostname"] + ":" + str(config["port"]) + ":" + config["namespace"])
if not all([config["username"], config["password"], config["namespace"]]):
raise ValueError("Missing required database configuration")
return config

@asynccontextmanager
async def server_lifespan(server: MCPServer) -> AsyncIterator[dict]:
"""Manage server startup and shutdown lifecycle."""
config = get_db_config()
try:
db = irisnative.connect(**config)
logger.info("Connected to IRIS database")
iris = irisnative.createIRIS(db)
logger.info("Connected to IRIS database 1")
yield {"db": db, "iris": iris}
except Exception as e:
logger.info("CONNECTION ERROR "+str(e))
db = None
iris = None
yield {"db": db, "iris": iris}
finally:
if db:
db.close()

And the code logs have returned this information:

2025-05-07T10:43:50.786Z [iris] [info] Initializing server...
2025-05-07T10:43:50.811Z [iris] [info] Server started and connected successfully
2025-05-07T10:43:50.813Z [iris] [info] Message from client: {"method":"initialize","params":{"protocolVersion":"2024-11-05","capabilities":{},"clientInfo":{"name":"claude-ai","version":"0.1.0"}},"jsonrpc":"2.0","id":0}
[05/07/25 12:43:51] INFO Server server.py:27
configuration:[IP]:54051:TEST
INFO CONNECTION ERROR Failed to connect to server;
Details:
Failed to connect to server; Details:
Error code: -1 Error message:

Any ideas?

Thanks again.

[daimor]

Could you try to reinstall the package, to make sure, it will use the latest version
uvx --reinstall mcp-server-iris

should be 0.2.2
I've added a bit more logging

[daimor]

additionaly, added docker-compose.yml, and example.py, which shows usage directly from python without Claude

[gopherlian]

Hi,

We have reinstalled the plugin and we still get the same SSL error.

Attached is the error log returned by the plugin itself.

The plugin version is the 0.2.2

2025-05-09T10:02:50.653Z [iris] [info] Message from server: {"jsonrpc":"2.0","id":5,"result":{"content":[{"type":"text","text":"Error executing tool execute_sql: Database connection not available"}],"isError":true}}
2025-05-09T10:03:32.500Z [iris] [info] Server transport closed
2025-05-09T10:03:32.501Z [iris] [info] Client transport closed
2025-05-09T10:03:32.501Z [iris] [info] Server transport closed unexpectedly, this is likely due to the process exiting early. If you are developing this MCP server you can add output to stderr (i.e. console.error('...') in JavaScript, print('...', file=sys.stderr) in python) and it will appear in this log.
2025-05-09T10:03:32.501Z [iris] [error] Server disconnected. For troubleshooting guidance, please visit our debugging documentation {"context":"connection"}
2025-05-09T10:03:32.502Z [iris] [info] Client transport closed
2025-05-09T10:04:32.644Z [iris] [info] Initializing server...
2025-05-09T10:04:32.663Z [iris] [info] Server started and connected successfully
2025-05-09T10:04:32.664Z [iris] [info] Message from client: {"method":"initialize","params":{"protocolVersion":"2024-11-05","capabilities":{},"clientInfo":{"name":"claude-ai","version":"0.1.0"}},"jsonrpc":"2.0","id":0}
[05/09/25 12:04:33] INFO Running server with transport: mcpserver.py:148
stdio
INFO Server configuration: server.py:23
iris://XXXXXX:XXXXX/TEST
ERROR Error connecting to IRIS: server.py:39
Failed to
connect to server; Details:
Failed to
connect to server; Details: Error
code: -1 Error message:
2025-05-09T10:04:33.455Z [iris] [info] Message from server: {"jsonrpc":"2.0","id":0,"result":{"protocolVersion":"2024-11-05","capabilities":{"experimental":{},"logging":{},"prompts":{"listChanged":false},"resources":{"subscribe":false,"listChanged":false},"tools":{"listChanged":false}},"serverInfo":{"name":"InterSystems IRIS MCP Server","version":"0.2.2"}}}
2025-05-09T10:04:33.472Z [iris] [info] Message from client: {"method":"notifications/initialized","jsonrpc":"2.0"}
2025-05-09T10:04:33.499Z [iris] [info] Message from client: {"method":"tools/list","params":{},"jsonrpc":"2.0","id":1}
2025-05-09T10:04:33.499Z [iris] [info] Message from client: {"method":"tools/list","params":{},"jsonrpc":"2.0","id":2}
2025-05-09T10:04:33.500Z [iris] [info] Message from client: {"method":"resources/list","params":{},"jsonrpc":"2.0","id":3}
INFO Processing request of type server.py:545
ListToolsRequest
INFO Processing request of type server.py:545
ListToolsRequest
2025-05-09T10:04:33.508Z [iris] [info] Message from server: {"jsonrpc":"2.0","id":1,"result":{"tools":[{"name":"interoperability_production_create","description":"Create an Interoperability Production","inputSchema":{"properties":{"name":{"title":"Name","type":"string"}},"required":["name"],"title":"interoperability_production_createArguments","type":"object"}},{"name":"interoperability_production_status","description":"Status of an Interoperability Production","inputSchema":{"properties":{"name":{"default":null,"title":"Name","type":"string"},"full_status":{"default":false,"title":"Full Status","type":"boolean"}},"title":"interoperability_production_statusArguments","type":"object"}},{"name":"interoperability_production_start","description":"Start an Interoperability Production","inputSchema":{"properties":{"name":{"default":null,"title":"Name","type":"string"}},"title":"interoperability_production_startArguments","type":"object"}},{"name":"interoperability_production_stop","description":"Stop an Interoperability Production","inputSchema":{"properties":{"timeout":{"default":null,"title":"Timeout","type":"integer"},"force":{"default":false,"title":"Force","type":"boolean"}},"title":"interoperability_production_stopArguments","type":"object"}},{"name":"interoperability_production_recover","description":"Recover an Interoperability Production","inputSchema":{"properties":{},"title":"interoperability_production_recoverArguments","type":"object"}},{"name":"interoperability_production_needsupdate","description":"Check if an Interoperability Production needs update","inputSchema":{"properties":{},"title":"interoperability_production_needsupdateArguments","type":"object"}},{"name":"interoperability_production_update","description":"Update Interoperability Production","inputSchema":{"properties":{"timeout":{"default":null,"title":"Timeout","type":"integer"},"force":{"default":false,"title":"Force","type":"boolean"}},"title":"interoperability_production_updateArguments","type":"object"}},{"name":"interoperability_production_logs","description":"Get Interoperability Production logs","inputSchema":{"properties":{"item_name":{"default":null,"title":"Item Name","type":"string"},"limit":{"default":10,"title":"Limit","type":"integer"},"log_type_info":{"default":false,"title":"Log Type Info","type":"boolean"},"log_type_alert":{"default":false,"title":"Log Type Alert","type":"boolean"},"log_type_error":{"default":true,"title":"Log Type Error","type":"boolean"},"log_type_warning":{"default":true,"title":"Log Type Warning","type":"boolean"}},"title":"interoperability_production_logsArguments","type":"object"}},{"name":"interoperability_production_queues","description":"Get Interoperability Production queues","inputSchema":{"properties":{},"title":"interoperability_production_queuesArguments","type":"object"}},{"name":"execute_sql","description":"Execute an SQL query on the Server","inputSchema":{"properties":{"query":{"title":"Query","type":"string"},"params":{"default":[],"items":{"type":"string"},"title":"Params","type":"array"}},"required":["query"],"title":"execute_sqlArguments","type":"object"}}]}}

Thank you very much for the effort.

[daimor]

This error more look like the port is incorrect.
You can try to test with DBeaver for instance if port is correct and can be used for connecting. Make sure you use correct port, it should be 1972

[jbrandtmse]

I'm having a similar issue with a container environment. I'm able to connect on port 1972 with DBeaver, but still get a failure to connect:

Traceback (most recent call last): File "/Users/jbrandt/.local/share/uv/tools/mcp-server-iris/bin/mcp-server-iris", line 4, in from mcp_server_iris import main MCP error -32000: Connection closed

This is IRIS 2024.1 (licensed edition).

It seems like maybe an authentication or permissions issue, but I've double checked the password. Are there additional permissions that are needed for it to run?

"iris": {
"autoApprove": [],
"disabled": false,
"timeout": 60,
"type": "stdio",
"command": "uvx",
"args": [
"mcp-server-iris"
],
"env": {
"IRIS_HOSTNAME": "127.0.0.1",
"IRIS_PORT": "1972",
"IRIS_NAMESPACE": "USER",
"IRIS_USERNAME": "_SYSTEM",
"IRIS_PASSWORD": "xxxxxxx"
}
}

[jbrandtmse]

I tried it again and got a little different error message on startup:
Traceback (most recent call last): File "/Users/jbrandt/.local/share/uv/tools/mcp-server-iris/bin/mcp-server-iris", line 4, in from mcp_server_iris import main File "/Users/jbrandt/.local/share/uv/tools/mcp-server-iris/lib/python3.11/site-packages/mcp_server_iris/init.py", line 1, in from .server import main as main # noqa MCP error -32000: Connection closed

[jbrandtmse]

This appears to be because MacOS defaults to Python 3.9. I had to bypass the uvx wrapper to get it to work:

"iris": {
  "autoApprove": [],
  "disabled": false,
  "timeout": 60,
  "type": "stdio",
  "command": "python3.11",
  "args": [
    "-m",
    "mcp_server_iris"
  ],
  "env": {
    "IRIS_HOSTNAME": "127.0.0.1",
    "IRIS_PORT": "1972",
    "IRIS_NAMESPACE": "USER",
    "IRIS_USERNAME": "_SYSTEM",
    "IRIS_PASSWORD": "xxxxxxxx"
  }
},