# 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:

```bash
cp .env.example .env
```

2. Install dependencies with uv:

```bash
uv sync
```

Alternative with pip:

```bash
pip install -r requirements.txt
```

3. Configure environment variables in `.env`:

```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

```bash
uv run python main.py
```

Optional HTTP mode:

```bash
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