Prism MCP Server

Prism MCP Server

Enables AI assistants to interact with InterSystems IRIS databases through SQL queries, document management, ObjectScript execution, debugging, and unit testing via the Atelier REST API.

Category
Visit Server

README

<div align="center"> <img src="logo.svg" width="200" alt="Prism Logo" />

Prism

Prism lets AI see through IRIS.

MCP server and CLI for InterSystems IRIS development — SQL queries, document management, compilation, debugging, testing, and ObjectScript execution via the Atelier REST API.

Documentation Python 3.12+ License: AGPL v3 </div>


Features

  • SQL — Run queries, DDL, stored procedures against any IRIS namespace
  • Documents — Upload, fetch, compile, and delete .cls, .mac, .inc files
  • Terminal — Execute ObjectScript via native (SuperServer) or WebSocket backend
  • Debugging — Interactive step-through debugger with breakpoints, variable inspection, and stack traces
  • Testing — Run %UnitTest test classes, list test methods, view historical results
  • MCP Server — Expose all tools to AI assistants (Claude Code, Claude Desktop, Cursor, GitHub Copilot)
  • Cast Plugins — Extend Prism with custom commands from any Git repository
  • Cross-platform — Windows installer, Linux/macOS via pip/uv

Quick Start

# Install
uv sync

# Configure (or use environment variables)
uv run prism config -u _SYSTEM -p SYS -U http://localhost:52773 -n USER

# Run a SQL query
uv run prism sql "SELECT TOP 5 Name FROM %Dictionary.ClassDefinition"

# Start the MCP server
uv run prism serve

Need an IRIS instance? Start one with Docker:

docker run -d --name iris -p 52773:52773 -p 1972:1972 intersystemsdc/iris-community:latest

CLI Commands

Command Description
prism sql Run an SQL query
prism terminal Run ObjectScript via native SuperServer
prism ws Run ObjectScript via WebSocket
prism put-doc Upload a file to IRIS
prism get-doc Fetch a document from IRIS
prism list-docs List source documents
prism delete-doc Delete a document
prism compile Compile documents
prism info Server version and namespaces
prism test Run unit test classes
prism list-tests Discover test classes
prism config View or edit settings
prism cast Run custom commands from Git repos
prism serve Start the MCP server

Global option: prism --format toon for TOON output.

Shell completion

Tab completion is available for bash, zsh, fish, and PowerShell:

prism --install-completion    # auto-detect shell

After running, restart your terminal. Then prism conf + Tab auto-completes to prism config, prism s + Tab cycles through sql and serve, etc.

See the commands overview for details.

MCP Tools

10 tools are always available, 2 workspace-gated (put_document, put_and_compile), and 9 debug-gated (debug_*) — up to 21 total.

See the full tool reference for details.

MCP Client Configuration

Claude Code

Add to ~/.claude/settings.json or .claude/settings.json:

{
  "mcpServers": {
    "iris": {
      "url": "http://localhost:3000/mcp"
    }
  }
}

Claude Desktop

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "iris": {
      "command": "uv",
      "args": ["run", "--directory", "/path/to/prism", "prism", "serve"]
    }
  }
}

GitHub Copilot (VS Code)

Add to .vscode/mcp.json:

{
  "servers": {
    "iris": {
      "type": "http",
      "url": "http://localhost:3000/mcp"
    }
  }
}

Cursor

Add to .cursor/mcp.json:

{
  "mcpServers": {
    "iris": {
      "url": "http://localhost:3000/mcp"
    }
  }
}

Environment Variables

Variable Default Description
IRIS_BASE_URL http://localhost:52773 IRIS instance URL
IRIS_USERNAME _SYSTEM Authentication username
IRIS_PASSWORD SYS Authentication password
IRIS_NAMESPACE USER Default namespace
IRIS_WORKSPACE (empty) Local directory for MCP file I/O tools
IRIS_COMPILE_FLAGS cuk Compiler flags
IRIS_DEBUG_ENABLED false Enable debug tools (debug_*)
IRIS_TERMINAL_METHOD native Terminal backend: native or ws

See the configuration guide for all 21 settings.

Project Structure

src/prism/
├── settings.py        # Pydantic settings (env, .env, config.json)
├── iris/
│   ├── sdk/            # HTTP client, workspace, debug protocols, terminal
│   └── api/            # Thin IRIS REST API wrappers (sql, docs, compile, debug)
├── mcp/               # MCP tools with @logged_tool decorator
│   ├── _decorator.py   # Logging + auto-discovery
│   ├── server.py       # FastMCP server
│   └── *.py            # One module per tool domain
├── cast/              # Cast plugin system (import-based Typer plugins)
│   └── manager.py      # Clone, import, cache, run commands
└── cli/               # Typer CLI commands (async wrappers)

Testing

uv run pytest tests/unit/ -v                    # No IRIS needed (276 tests)
IRIS_BASE_URL=http://localhost:52773 \
  uv run pytest tests/integration/ -v            # Needs IRIS (72 tests)
uv run ruff check . && uv run ruff format --check .  # Lint

Full testing guide: docs/testing.md

Releases

Prism follows a Git Flow release workflow with two protected branches: development (active work) and main (stable releases).

Download the latest Windows installer or standalone exe from GitHub Releases.

Artifact Description
prism-X.Y.Z-setup.exe Windows installer (Inno Setup, adds to PATH)
prism.exe Standalone Windows binary (PyInstaller)
prism-X.Y.Z-py3-none-any.whl Python wheel (pip install prism)

See the release guide for the full release workflow, branch model, hotfix procedure, and CI pipeline details.

Documentation

Full documentation at adriaerni.github.io/Prism

License

Copyright © 2026 Adria Sanchez.

Licensed under the GNU Affero General Public License v3.0 (AGPL-3.0). You may use, modify, and distribute this software freely, including for commercial purposes, as long as you share your source code under the same license. SaaS/hosting providers must also share their source code (network clause).

See LICENSE for full terms.

Recommended Servers

playwright-mcp

playwright-mcp

A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.

Official
Featured
TypeScript
Magic Component Platform (MCP)

Magic Component Platform (MCP)

An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.

Official
Featured
Local
TypeScript
Audiense Insights MCP Server

Audiense Insights MCP Server

Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.

Official
Featured
Local
TypeScript
VeyraX MCP

VeyraX MCP

Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.

Official
Featured
Local
graphlit-mcp-server

graphlit-mcp-server

The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.

Official
Featured
TypeScript
Kagi MCP Server

Kagi MCP Server

An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.

Official
Featured
Python
Neon Database

Neon Database

MCP server for interacting with Neon Management API and databases

Official
Featured
E2B

E2B

Using MCP to run code via e2b.

Official
Featured
Exa Search

Exa Search

A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.

Official
Featured
Qdrant Server

Qdrant Server

This repository is an example of how to create a MCP server for Qdrant, a vector search engine.

Official
Featured