InterSystems IRIS MCP Server
Enables interaction with InterSystems IRIS databases, allowing for database queries, data manipulation, and automation through the IRIS connection parameters (hostname, port, namespace, credentials).
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@InterSystems IRIS MCP Servershow me the top 10 patients by admission date"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
mcp-server-iris: An InterSystems IRIS MCP server
mcp-server-iris: An InterSystems IRIS MCP server
Overview
A Model Context Protocol server for InterSystems IRIS database interaction and automation.
Related MCP server: IRIS MCP Blueprint
Configure Claude
{
"mcpServers": {
"iris": {
"command": "uvx",
"args": [
"mcp-server-iris"
],
"env": {
"IRIS_HOSTNAME": "localhost",
"IRIS_PORT": "1972",
"IRIS_NAMESPACE": "USER",
"IRIS_USERNAME": "_SYSTEM",
"IRIS_PASSWORD": "SYS"
}
}
}
}Available Tools
10 toolsexecute_sqlC
Execute an SQL query on the Server
Inputs: query (required), params. Returns: result
interoperability_production_createC
Create an Interoperability Production
Inputs: name (required). Returns: result
interoperability_production_logsD
Get Interoperability Production logs
Inputs: item_name, limit, log_type_info, log_type_alert, +2 more. Returns: result
interoperability_production_needsupdateA
Check if an Interoperability Production needs update
Inputs: no named parameters. Returns: result
interoperability_production_queuesC
Get Interoperability Production queues
Inputs: no named parameters. Returns: result
interoperability_production_recoverC
Recover an Interoperability Production
Inputs: no named parameters. Returns: result
interoperability_production_startD
Start an Interoperability Production
Inputs: name. Returns: result
interoperability_production_statusD
Status of an Interoperability Production
Inputs: name, full_status. Returns: result
interoperability_production_stopD
Stop an Interoperability Production
Inputs: timeout, force. Returns: result
interoperability_production_updateD
Update Interoperability Production
Inputs: timeout, force. Returns: result
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
TDQS
Scored across 10 tools
The tools are clearly distinct: one for SQL execution and the rest for various operations on Interoperability Productions. Each production tool has a unique verb (create, logs, status, etc.) with no overlap.
Nine production tools follow the consistent pattern 'interoperability_production_<verb>', but 'execute_sql' breaks this pattern by lacking the domain prefix and using a different verb format. Minor inconsistency.
Ten tools is well-scoped for a server focused on InterSystems IRIS, covering SQL execution and comprehensive production lifecycle management without being overwhelming.
Production management is thorough (create, update, start, stop, status, logs, queues, etc.), but missing a delete/remove tool for productions. SQL is limited to execution only, with no schema introspection tools.
Maintenance
Related MCP Connectors
DBRE-grade SQL analysis inside any MCP client. No connection. No install. Paste a query.
Run SOQL queries to explore and retrieve Salesforce data. Inspect records, fields, and relationshi…
The best QuickBooks Desktop MCP server on the planet: every operation on every record type
Run SOQL queries to explore and retrieve Salesforce data. Access accounts, contacts, opportunities…
Related MCP Servers
- -
- AlicenseBqualityDmaintenanceMCP server that enables AI assistants to interact with InterSystems IRIS databases through tools for SQL, globals, class methods, Atelier API, and interoperability, plus guided prompts for common workflows.26MIT
- AlicenseNot gradedqualityBmaintenanceEnables AI assistants to interact with InterSystems IRIS databases through SQL queries, document management, ObjectScript execution, debugging, and unit testing via the Atelier REST API.AGPL 3.0
- AlicenseNot gradedqualityCmaintenanceRaw SQL MCP is a STDIO MCP server for executing raw SQL against SQL Server, SQLite, PostgreSQL, MySQL, and MariaDB.AGPL 3.0