IDMS Identity SQL

БесплатноНе проверен

Enables SQL-based identity lookups for IDMS systems, supporting search by account, employee ID, name, department, and manager, plus active students and stats.

автор: josephstreeter

GitHub Embed

Описание

Enables SQL-based identity lookups for IDMS systems, supporting search by account, employee ID, name, department, and manager, plus active students and stats.

README

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

Create local environment variables:

cp .env.example .env

Install dependencies with uv:

uv sync

Alternative with pip:

pip install -r requirements.txt

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

from github.com/josephstreeter/mcp_idms

Установка IDMS Identity SQL

У этого сервера нет опубликованного пакета — он собирается из исходников. Открой репозиторий и следуй инструкции в README.

▸ github.com/josephstreeter/mcp_idms

FAQ