npm package: @iflow-mcp/happy-technologies-llc-mcp-servicenow-nodejs
Description: Multi-instance ServiceNow MCP server with 40+ tools, natural language search, and local script development
Author: Happy Technologies LLC
Latest version: 2.1.7

<div align="center">
  <img src="assets/logo.svg" alt="ServiceNow MCP Server" width="200"/>

  # ServiceNow MCP Server v2.1.5

  **Multi-Instance Intelligent Architecture**

  A revolutionary metadata-driven ServiceNow MCP server that supports multiple ServiceNow instances simultaneously with automatic schema discovery and optimized tool generation.

  *Part of the [Happy Technologies](https://happy-tech.biz) composable service ecosystem*

  [![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](LICENSE)
  [![Node.js Version](https://img.shields.io/badge/node-%3E%3D18-brightgreen)](https://nodejs.org)
  [![ServiceNow](https://img.shields.io/badge/ServiceNow-Compatible-00a3ba)](https://www.servicenow.com)

</div>

---

## 🚀 Revolutionary Features

- **🌐 Multi-Instance Support**: Connect to multiple ServiceNow instances simultaneously with instance-specific tool routing
- **🧠 Intelligent Schema Discovery**: Automatically discovers table structures and relationships from your ServiceNow instances
- **📊 160+ ServiceNow Tables**: Complete coverage including ITSM, CMDB, Service Catalog, Platform Development, and Flow Designer
- **⚙️ Generic CRUD Operations**: 44 powerful MCP tools that work on **any** ServiceNow table
- **🔧 Dynamic Schema Loading**: Table metadata discovered at runtime - no hardcoded definitions
- **📱 Instance-Adaptive**: Automatically handles custom fields, modified tables, and different ServiceNow editions
- **🎯 Batch Operations**: 43+ parallel operations tested successfully
- **🎨 Local Script Development**: Sync scripts with Git, watch mode for continuous development
- **🗣️ Natural Language Search**: Query ServiceNow using plain English queries
- **📚 MCP Resources**: 8 read-only resource URIs for quick lookups and documentation

## 🆕 What's New in v2.1.5

**November 2025 Release**

- 💓 **SSE Keepalive Fix**: Automatic heartbeat mechanism prevents Docker SSE connection drops (15s default, configurable)
- 🔒 **Security Patches**: Fixed high-severity glob vulnerability (CVE-2025-64756)
- 🐳 **Production Ready**: Optimized SSE configuration for Docker, Kubernetes, and proxy deployments
- 📖 **Complete Documentation**: Comprehensive SSE setup guide with nginx/Traefik/HAProxy configurations
- 🔍 **Connection Monitoring**: Automatic cleanup and lifecycle logging for debugging

**October 2025 Release (v2.1)**

- 🎨 **Local Script Development**: Sync scripts with Git, watch mode for continuous development, full version control integration
- 🗣️ **Natural Language Search**: Query ServiceNow using plain English (15+ supported patterns)
- ⚡ **10 Convenience Tools**: Specialized ITSM operations (Add-Comment, Add-Work-Notes, Assign, Resolve, Close incidents/changes/problems)
- 📚 **MCP Resources**: 8 read-only resource URIs for quick table lookups and API documentation
- 📊 **Progress Reporting**: Real-time feedback for batch operations and long-running tasks
- ✅ **Validated Features**: Application scope and update set management thoroughly tested in production environments

## ⚡ Quick Start (2-3 Minutes)

### Prerequisites
- Node.js 18+
- ServiceNow instance(s) with API access
- Valid ServiceNow credentials

**Note:** Version 2.1 includes new local development features. See `CLAUDE.md` for complete workflow documentation.

### 🎯 Setup Instructions

1. **Clone and install:**
   ```bash
   git clone <repository-url>
   cd mcp-servicenow-nodejs
   npm install
   ```

2. **Configure your ServiceNow instance(s):**

   **Option A: Multi-Instance Setup (Recommended)**
   ```bash
   # Create config file
   cp config/servicenow-instances.example.json config/servicenow-instances.json

   # Edit with your instances
   nano config/servicenow-instances.json
   ```

   Example multi-instance config:
   ```json
   {
     "instances": [
       {
         "name": "dev",
         "url": "https://dev123456.service-now.com",
         "username": "admin",
         "password": "your-password",
         "default": true
       },
       {
         "name": "prod",
         "url": "https://prod789012.service-now.com",
         "username": "integration_user",
         "password": "your-password"
       }
     ]
   }
   ```

   **Option B: Single Instance Setup (Legacy)**
   ```bash
   # Copy environment template
   cp .env.example .env

   # Edit with your credentials
   nano .env
   ```

3. **Start the server:**
   ```bash
   npm run dev
   ```

4. **Verify connection:**
   ```bash
   # Health check
   curl http://localhost:3000/health

   # List instances
   curl http://localhost:3000/instances
   ```

5. **Connect your AI assistant:**
   - **HTTP Transport:** `http://localhost:3000/mcp`
   - **Stdio Transport:** Use `npm run stdio` (for Claude Desktop)
   - Test with MCP Inspector: `npm run inspector`

## 🌐 Multi-Instance Support

### Instance-Specific Tool Routing

All tools automatically support multi-instance operations:

```bash
# Default instance (marked with "default": true in config)
SN-List-Incidents { "limit": 10 }

# Specific instance
SN-List-Incidents { "instance": "prod", "limit": 10 }

# List all configured instances
curl http://localhost:3000/instances
```

### Tool Naming Convention

**Without Instance Parameter:**
- Uses default instance from config
- Example: `SN-Create-Incident` → creates in default instance

**With Instance Parameter:**
- Routes to specified instance
- Example: `SN-Create-Incident { "instance": "prod", ... }` → creates in prod instance

## 📊 Comprehensive ServiceNow Coverage

### 🎯 **44 MCP Tools** Supporting **160+ ServiceNow Tables**

*Generic tools work on any ServiceNow table through dynamic schema discovery*

| **Tool Category** | **Tools** | **What They Do** |
|-------------------|-----------|------------------|
| **Generic CRUD** | 7 tools | Query, Create, Get, Update on **any** table |
| **Specialized ITSM** | 8 tools | Incident, Change, Problem convenience wrappers |
| **Convenience Tools** | 10 tools | Add-Comment, Add-Work-Notes, Assign, Resolve, Close operations |
| **Natural Language** | 1 tool | Query using plain English instead of encoded queries |
| **Update Set Management** | 6 tools | Set, list, move, clone, inspect update sets |
| **Background Scripts** | 2 tools | Execute scripts, create fix scripts |
| **Script Synchronization** | 3 tools | Sync scripts with local files, watch mode, Git integration |
| **Workflows** | 4 tools | Create workflows, activities, transitions |
| **Batch Operations** | 2 tools | Batch create/update across tables |
| **Schema Discovery** | 3 tools | Get table schemas, field info, relationships |
| **Multi-Instance** | 2 tools | Switch instances, get current instance |
| **MCP Resources** | 8 resources | Read-only URIs for table lists, common tables, field info |

### 📋 **Supported Table Categories (160+ Total)**

| **Category** | **Example Tables** |
|--------------|-------------------|
| **🏆 Core ITSM** | incident, change_request, problem, sc_request, sc_req_item |
| **📦 Service Catalog** | sc_cat_item, catalog_ui_policy, item_option_new |
| **👥 User Management** | sys_user, sys_user_group, sys_user_role |
| **🔧 CMDB & Assets** | cmdb_ci, alm_asset, cmdb_rel_ci |
| **⚙️ Platform Development** | sys_script, sys_ui_policy, sys_update_set, sys_update_xml |
| **🔄 Flow Designer** | sys_hub_flow, sys_hub_flow_logic, sys_hub_flow_variable |
| **🌊 Workflows** | wf_workflow, wf_activity, wf_transition |
| **🔗 Integration** | sys_rest_message, sys_ws_definition, sys_import_set |

### 🧠 **Tool Examples**

**Standard CRUD Operations (Every Table):**
```javascript
// List records with filtering
SN-List-Incidents({ "query": "state=1^priority=1", "limit": 10 })

// Create new record
SN-Create-Incident({ "short_description": "Email down", "urgency": 1 })

// Get single record
SN-Get-Incident({ "sys_id": "abc123..." })

// Update record
SN-Update-Record({ "table_name": "incident", "sys_id": "abc123...", "data": {...} })

// Query with complex filters
SN-Query-Table({ "table_name": "incident", "query": "active=true", "fields": "number,short_description" })
```

**Specialized Tools:**
```javascript
// Background script execution (automated via sys_trigger)
SN-Execute-Background-Script({ "script": "gs.info('Hello');" })

// Update set management
SN-Get-Current-Update-Set()
SN-Set-Update-Set({ "update_set_sys_id": "abc123..." })
SN-Move-Records-To-Update-Set({ "update_set_id": "xyz789...", "source_update_set": "Default" })

// Table schema introspection
SN-Get-Table-Schema({ "table_name": "incident" })
SN-Discover-Table-Schema({ "table_name": "sys_hub_flow", "include_relationships": true })

// Batch operations
SN-Batch-Create({ "operations": [...] })
SN-Batch-Update({ "updates": [...] })

// Workflow creation
SN-Create-Workflow({ "name": "Auto-Approve", "table": "change_request", "activities": [...] })
```

### 🎨 **Local Development Workflow (NEW!)**

Develop ServiceNow scripts locally with Git integration and automatic synchronization:

```javascript
// Sync local script to ServiceNow
SN-Sync-Script-From-Local({
  "local_path": "./scripts/my_business_rule.js",
  "table": "sys_script",
  "sys_id": "abc123...",
  "instance": "dev"
})

// Watch directory for changes (continuous development)
SN-Watch-Scripts({
  "directory": "./scripts",
  "instance": "dev",
  "auto_sync": true
})

// Sync entire directory
SN-Sync-Scripts-Directory({
  "directory": "./scripts",
  "instance": "dev",
  "dry_run": false
})
```

**Benefits:**
- Version control your ServiceNow scripts with Git
- Local IDE development with syntax highlighting
- Automatic sync on file save
- Backup and restore scripts easily
- Team collaboration via Git workflows

See **CLAUDE.md** for complete local development workflow.

### 🗣️ **Natural Language Search (NEW!)**

Query ServiceNow using plain English instead of encoded queries:

```javascript
// Natural language queries
SN-Natural-Language-Search({
  "table": "incident",
  "nl_query": "all high priority incidents assigned to me",
  "instance": "dev"
})

SN-Natural-Language-Search({
  "table": "change_request",
  "nl_query": "emergency changes created this week",
  "instance": "prod"
})

SN-Natural-Language-Search({
  "table": "problem",
  "nl_query": "unresolved problems from network team",
  "instance": "dev"
})
```

**Supported Patterns (15+):**
- "high priority incidents assigned to me"
- "emergency changes created this week"
- "open problems from database team"
- "resolved incidents updated yesterday"
- "active change requests for production"

**When to Use:**
- Use NL search for quick exploratory queries
- Use encoded queries for complex automation
- NL search translates to encoded queries automatically

### ⚡ **Convenience Tools (NEW!)**

Specialized operations for common ITSM tasks:

```javascript
// Add comments (visible to users)
SN-Incident-Add-Comment({
  "sys_id": "abc123...",
  "comment": "Issue resolved, monitoring for 24 hours",
  "instance": "dev"
})

// Add work notes (internal)
SN-Incident-Add-Work-Notes({
  "sys_id": "abc123...",
  "work_notes": "Restarted application server, logs attached",
  "instance": "dev"
})

// Assign incident
SN-Incident-Assign({
  "sys_id": "abc123...",
  "assigned_to": "user_sys_id",
  "assignment_group": "group_sys_id",
  "instance": "dev"
})

// Resolve incident
SN-Incident-Resolve({
  "sys_id": "abc123...",
  "resolution_code": "Solved (Permanently)",
  "resolution_notes": "Fixed configuration error",
  "instance": "dev"
})

// Close incident
SN-Incident-Close({
  "sys_id": "abc123...",
  "close_code": "Solved (Permanently)",
  "close_notes": "User confirmed resolution",
  "instance": "dev"
})
```

**Available for:** Incidents, Change Requests, Problems

**Operations:** Add-Comment, Add-Work-Notes, Assign, Resolve, Close

### 📋 **Complete Table Coverage**

**Core Service Management:**
`incident` • `change_request` • `change_task` • `problem` • `problem_task` • `sc_request` • `sc_req_item` • `sysapproval_approver`

**Service Catalog:**
`sc_cat_item` • `sc_category` • `item_option_new` • `catalog_ui_policy` • `catalog_ui_policy_action`

**CMDB & Assets:**
`cmdb_ci` • `cmdb_ci_*` (all CI types) • `cmdb_rel_ci` • `alm_asset` • `ast_contract`

**Platform Development:**
`sys_script` • `sys_script_client` • `sys_script_include` • `sys_ui_script` • `sys_ui_policy` • `sys_update_set` • `sys_update_xml`

**Flow Designer (NEW!):**
`sys_hub_flow` • `sys_hub_flow_base` • `sys_hub_flow_logic` • `sys_hub_flow_variable` • `sys_hub_flow_stage`

**Workflows:**
`wf_workflow` • `wf_activity` • `wf_transition` • `wf_version`

**Integration & APIs:**
`sys_rest_message` • `sys_ws_definition` • `sys_import_set` • `sys_transform_map`

**160+ total tables** including UI/UX development, user management, knowledge bases, and more!

## Testing with MCP Inspector

1. **Start the MCP server:**
   ```bash
   npm run dev
   ```

2. **Launch MCP Inspector in a new terminal:**
   ```bash
   npm run inspector
   ```

3. **Configure connection:**
   - Transport Type: **Streamable HTTP (SSE)**
   - URL: `http://localhost:3000/mcp`
   - Click **Connect**

4. **Test tools:**
   - Browse available tools in the Tools tab
   - Execute tool calls with parameters
   - View responses and errors

## Claude Desktop Integration

Add to your Claude Desktop config (`~/Library/Application Support/Claude/claude_desktop_config.json`):

```json
{
  "mcpServers": {
    "servicenow-nodejs": {
      "command": "node",
      "args": ["/Users/YOUR_USERNAME/WebstormProjects/mcp-servicenow-nodejs/src/stdio-server.js"],
      "cwd": "/Users/YOUR_USERNAME/WebstormProjects/mcp-servicenow-nodejs",
      "env": {
        "SERVICENOW_INSTANCE_URL": "https://your-instance.service-now.com",
        "SERVICENOW_USERNAME": "your-username",
        "SERVICENOW_PASSWORD": "your-password",
        "SERVICENOW_AUTH_TYPE": "basic"
      }
    }
  }
}
```

**Important:** Replace `YOUR_USERNAME` with your actual username and update credentials.

Then restart Claude Desktop (⌘Q and reopen) to see ServiceNow tools appear.

**Detailed setup guide:** `docs/CLAUDE_DESKTOP_SETUP.md`

## Architecture

```
src/
├── server.js                      # Express HTTP server with SSE transport
├── stdio-server.js                # Stdio transport for Claude Desktop
├── mcp-server-consolidated.js    # MCP tool registration & routing
├── servicenow-client.js           # ServiceNow REST API client
└── config-manager.js              # Multi-instance configuration manager

config/
└── servicenow-instances.json      # Multi-instance configuration

docs/
├── FLOW_DESIGNER_MCP_FEASIBILITY.md  # Flow Designer feasibility analysis
└── MCP_Tool_Limitations.md           # API limitation documentation
```

**Key Features:**
- **Multi-Instance Routing:** Single server connects to multiple ServiceNow instances
- **Dynamic Tool Generation:** Tools auto-generate from table metadata
- **Metadata-Driven:** No hardcoded table definitions
- **Instance Fallback:** Supports `.env` for single-instance backward compatibility
- **Session Management:** Separate MCP sessions per client connection
- **Error Handling:** Comprehensive error reporting with context

## Key Features & Improvements

### ✅ **Multi-Instance Support**
- Connect to multiple ServiceNow instances simultaneously
- Instance-specific tool routing with `instance` parameter
- Centralized configuration in `config/servicenow-instances.json`
- Fallback to `.env` for single-instance backward compatibility

### ✅ **Background Script Execution**
- **Automated execution** via `sys_trigger` table (runs in ~1 second)
- No manual copy-paste required for most scripts
- Automatic trigger cleanup after execution
- Fallback to fix script generation if execution fails

### ✅ **Advanced Update Set Management**
- Set current update set programmatically
- Move records between update sets (including from "Default")
- Clone entire update sets with all records
- Inspect update set contents and dependencies

### ✅ **Comprehensive Table Operations**
- 480+ auto-generated tools across 160+ tables
- Generic CRUD operations work on **any** ServiceNow table
- Schema introspection with relationships and constraints
- Batch create/update operations for efficiency

### ✅ **Workflow & Flow Designer Support**
- Create workflows with activities and transitions
- Read Flow Designer flows (sys_hub_flow tables)
- Create flow variables, stages, and components
- See `docs/FLOW_DESIGNER_MCP_FEASIBILITY.md` for details

## Known Limitations

See `docs/MCP_Tool_Limitations.md` for comprehensive documentation. Key limitations:

**Cannot Be Done via REST API:**
- ❌ Flow Designer logic block creation (use UI or templates)
- ❌ Flow compilation/validation (flows compile in UI)
- ⚠️ UI Policy Actions linking (requires background script with setValue())

**Workarounds Available:**
- ✅ Background scripts execute automatically via `sys_trigger`
- ✅ Update set operations fully automated
- ✅ Generic table operations work on custom tables
- ✅ Workflow creation fully supported

## Troubleshooting

### Connection Issues

```bash
# Test ServiceNow connectivity
curl -u username:password https://your-instance.service-now.com/api/now/table/incident?sysparm_limit=1

# Check server health
curl http://localhost:3000/health

# List configured instances
curl http://localhost:3000/instances
```

### Configuration Issues

**Multi-instance not working:**
- Verify `config/servicenow-instances.json` exists and is valid JSON
- Check that at least one instance has `"default": true`
- Restart server after config changes

**Tools not appearing:**
- Verify MCP connection in Inspector
- Check server logs for registration errors
- Ensure ServiceNow credentials are correct

**Authentication failures:**
- Verify username/password in config file
- Check ServiceNow user has required roles
- Test credentials in browser first

### Debug Mode

```bash
# Enable verbose logging
DEBUG=true npm run dev

# Check background script execution logs
# ServiceNow: System Logs → System Log → All
# Filter by source: "Script execution"
```

## Performance & Statistics

- **Cold start:** ~1-2 seconds
- **Tool execution:** ~200-500ms average (depends on ServiceNow instance)
- **Memory usage:** ~50MB baseline per instance
- **Concurrent sessions:** 100+ supported
- **Background scripts:** Execute in ~1 second via sys_trigger
- **MCP Tools:** 44 total (34 tools + 10 convenience tools)
- **MCP Resources:** 8 read-only resource URIs
- **Natural Language Patterns:** 15+ supported query patterns
- **Convenience Operations:** 10+ specialized ITSM operations (5 operations × 3 table types)
- **Tables Supported:** 160+ ServiceNow tables via generic tools
- **Batch Operations:** 43+ parallel calls tested successfully

## 🙏 Acknowledgments

This project was inspired by and built upon ideas from the [Echelon AI Labs ServiceNow MCP Server](https://github.com/echelon-ai-labs/servicenow-mcp). We're grateful for their pioneering work in bringing Model Context Protocol capabilities to ServiceNow, which provided valuable insights and inspiration for developing this multi-instance, metadata-driven implementation.

**Key innovations we've added:**
- Multi-instance support with dynamic routing
- 40+ tools with natural language search
- Local script development with Git integration
- Automated background script execution via sys_trigger
- Dynamic schema discovery across 160+ tables
- Convenience tools for common ITSM operations

We encourage the community to explore both implementations and contribute to advancing ServiceNow automation through MCP.

## 📄 License

This project is licensed under the **MIT License** - see the [LICENSE](LICENSE) file for details.

**Copyright © 2025 Happy Technologies LLC**

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.