IDMS Identity SQL

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

Permission Matrix

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

Access type	Tool coverage
SQL read access to dbo.Identities_MIM	search_identity_by_account, search_identity_by_employee_id, search_identities_by_name, get_identities_by_department, get_identities_by_manager, get_active_students, get_identity_stats

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