mcp-iris: An InterSystems IRIS MCP server (Node.js TypeScript)

A Model Context Protocol server for InterSystems IRIS database interaction and automation.

Installation

npm install
npm run build

Configure VS Code

{
  "servers": {
    "iris": {
      "command": "node",
      "args": [
        "dist/index.js",
      ],
      "env": {
        "IRIS_HOSTNAME": "localhost",
        "IRIS_PORT": "1972",
        "IRIS_NAMESPACE": "USER",
        "IRIS_USERNAME": "_SYSTEM",
        "IRIS_PASSWORD": "SYS"
      }
    }
  }
}

Tools

• execute_sql: Execute SQL queries on the IRIS database.
• interoperability_production_create: Create a new Interoperability Production.
• interoperability_production_status: Get the status of an Interoperability Production.
• And more interoperability management tools.

Development

You can run MCP Inspector with:

npx @modelcontextprotocol/inspector node src/index.js

And use the query with tool execute_sql to list all tables in the configured namespace:

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '<TABLE_NAME>' ORDER BY TABLE_NAME;

This will return all table names from the configured namespace and selected schema.

npm run dev
npm run build