mcp-server-table 0.2.0

📋 Table of Contents

• 🌟 Overview
• ✨ Key Features
• 🏗️ Architecture
• ⚡ Quick Start
• 🔧 Installation
• ⚙️ Configuration
• 💡 Usage Examples
• 🎛️ Available Tools
• 📊 Supported Formats
• 🗺️ Table Mappings
• 🔒 Authentication
• 🐛 Troubleshooting
• 🤝 Contributing
• 📄 License

🌟 Overview

The ServiceNow MCP Server is a cutting-edge Model Context Protocol server that revolutionizes how you interact with ServiceNow data. By combining the power of AI with intuitive natural language processing, this tool transforms complex ServiceNow API operations into simple conversational commands.

graph TD
    A[👤 User Voice Command] --> B[🤖 Claude AI]
    B --> C[🔧 MCP Server]
    C --> D[🌐 ServiceNow API]
    D --> E[📊 Data Processing]
    E --> F[📁 File Export]
    F --> G[💾 Downloads Folder]

🎯 Why Choose ServiceNow MCP Server?

• 🗣️ Voice-Controlled: Use natural language commands instead of complex API calls
• 🧠 AI-Powered: Intelligent table name resolution from conversational descriptions
• ⚡ Lightning Fast: Optimized async operations for rapid data retrieval
• 🔒 Secure: Built-in authentication and error handling
• 📱 Cross-Platform: Works on Windows, macOS, and Linux
• 🎨 Multiple Formats: Export to CSV, XML, or both simultaneously

✨ Key Features

🏗️ Architecture

┌─────────────────┐    ┌──────────────────┐    ┌─────────────────┐
│   Claude AI     │───▶│   MCP Server     │───▶│   ServiceNow    │
│                 │    │                  │    │                 │
│ • NL Processing │    │ • Table Mapping  │    │ • REST API      │
│ • Tool Calling  │    │ • Data Export    │    │ • Authentication│
│ • User Interface│    │ • File Generation│    │ • Data Storage  │
└─────────────────┘    └──────────────────┘    └─────────────────┘
                                │
                                ▼
                       ┌──────────────────┐
                       │ Local File System│
                       │                  │
                       │ • Downloads Folder│
                       │ • CSV/XML Files  │
                       │ • Auto Naming    │
                       └──────────────────┘

⚡ Quick Start

🚀 1-Minute Setup with Claude

# Clone the repository
git clone https://github.com/divyashah0510/mcp-servicenow-exporter.git
cd mcp-servicenow-exporter

# Install dependencies
pip install -r requirements.txt

# Configure Claude Desktop (see Configuration section)
# Add the servicenow-client configuration to your Claude config

# Restart Claude Desktop
# Start using natural language commands!

🎯 First Export with Claude

Once configured in Claude Desktop, try these natural language commands:

💬 "Export the server table from ServiceNow"

💬 "Get me incident data in XML format"

💬 "Show me all available ServiceNow tables"

💬 "Export users with both CSV and XML formats"

🔄 Workflow Integration

graph LR
    A[👤 User in Claude] --> B[💬 Natural Language]
    B --> C[🔧 MCP Server]
    C --> D[🌐 ServiceNow API]
    D --> E[📊 Data Export]
    E --> F[📁 Claude Attachment]

🔧 Installation

Prerequisites

Step-by-Step Installation

Requirements

# Core dependencies
fastmcp>=0.1.0
httpx>=0.24.0
python-dotenv>=1.0.0

# Optional enhancements
rich>=13.0.0        # Better console output
typer>=0.9.0        # CLI interface
pytest>=7.0.0       # Testing framework

⚙️ Configuration

Claude Desktop Configuration

To use this MCP server with Claude Desktop, add the following configuration to your Claude config file:

Location:

• Windows: %APPDATA%\Claude\claude_desktop_config.json
• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "servicenow-client": {
      "command": "mcp-servicenow-exporter",
      "args": [],
      "env": {
        "SERVICENOW_INSTANCE": "https://your_instance_id.service-now.com",
        "SERVICENOW_USERNAME": "your_username",
        "SERVICENOW_PASSWORD": "your_password"
      }
    }
  }
}

⚠️ Security Note: Replace the example credentials with your actual ServiceNow instance details. For production use, consider using environment variables or secure credential management.

Environment Variables

Alternative: Environment File Setup

Create a .env file in the project root:

SERVICENOW_INSTANCE=https://your_instance_id.service-now.com
SERVICENOW_USERNAME=your_username
SERVICENOW_PASSWORD=your_password

### 🚀 Claude Integration Quick Start

1. **Install the MCP server** following the installation steps above
2. **Update Claude config** with the servicenow-client configuration
3. **Restart Claude Desktop** to load the new MCP server
4. **Start chatting** with natural language commands like:
   - *"Export the server table from ServiceNow"*
   - *"Get me all incidents in XML format"*
   - *"Show me the available ServiceNow tables"*

### 🔧 Advanced Configuration Options

<details>
<summary><strong>🔍 Click to see advanced settings</strong></summary>

You can customize the MCP server behavior by adding additional environment variables:

```json
{
  "mcpServers": {
    "servicenow-client": {
      "command": "mcp-servicenow-exporter",
      "args": ["--verbose", "--max-records=1000"],
      "env": {
        "SERVICENOW_INSTANCE": "https://your-instance.service-now.com",
        "SERVICENOW_USERNAME": "your_username",
        "SERVICENOW_PASSWORD": "your_password",
        "DEBUG": "1",
        "DEFAULT_FORMAT": "xml",
        "DOWNLOAD_PATH": "C:\\Custom\\Downloads"
      }
    }
  }
}

Additional Environment Variables:

• DEBUG: Enable debug logging (set to "1")
• DEFAULT_FORMAT: Set default export format ("csv", "xml", "both")
• DOWNLOAD_PATH: Custom download directory path
• MAX_RECORDS: Default maximum records to export

💡 Usage Examples

Natural Language Commands

Try these conversational commands with Claude:

"Export all incidents from ServiceNow"
"Get me user data in XML format"
"Show available tables in ServiceNow"
"Export server information with both CSV and XML"
"Get cmdb_ci_server table data"

Advanced Queries

"Export incidents where state is active"
"Get all users created this month"
"Export server data with specific fields only"

🎛️ Available Tools

The MCP server provides these tools for Claude AI:

• export_servicenow_table: Main export functionality
• list_available_tables: Browse ServiceNow tables
• get_table_schema: View table structure
• test_connection: Verify ServiceNow connectivity

📊 Supported Formats

• CSV: Comma-separated values (Excel compatible)
• XML: Structured XML format (ServiceNow native)
• Both: Generate both formats simultaneously

🗺️ Table Mappings

Common table aliases supported:

🔒 Authentication

The server supports ServiceNow basic authentication. Ensure your ServiceNow user has appropriate read permissions for the tables you want to export.

🐛 Troubleshooting

Common Issues:

1. Connection failed: Check ServiceNow instance URL and credentials
2. Permission denied: Verify user has table read access
3. Large exports: Use pagination for tables with millions of records

🤝 Contributing

1. Fork the repository
2. Create a feature branch
3. Make your changes
4. Submit a pull request

📄 License

This project is licensed under the MIT License. See the LICENSE file for details.