IDMS Identity SQL MCP

Standalone MCP server for SQL-based IDMS identity lookups.

This folder is repository-ready and can be moved directly into its own Git repository.

Setup

1. Create local environment variables:

cp .env.example .env

2. Install dependencies with uv:

uv sync

Alternative with pip:

pip install -r requirements.txt

3. Configure environment variables in .env:

SQL_SERVER=your_hostname_or_instance
SQL_DATABASE=your_database
# Optional SQL auth
# SQL_USERNAME=your_sql_username
# SQL_PASSWORD=your_sql_password

Related MCP server: IBM i MCP Server

Permission Matrix

This server does not use Microsoft Graph and does not request OAuth scopes.

Run

uv run python main.py

Optional HTTP mode:

uv run python main.py --transport http --port 8003

Claude/Copilot Integration

See CLAUDE_SETUP.md in this folder for standalone MCP configuration examples.

Standalone Repo Contents

• main.py - MCP server entrypoint

• modules/ - SQL identity assistant module

• pyproject.toml - Project metadata and dependencies

• uv.lock - Locked dependency graph for reproducible installs

• .env.example - Environment template

• .gitignore - Local repo ignores