Skip to main content
Glama
josephstreeter

IDMS Identity SQL MCP

by josephstreeter
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Remote

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

  1. Install dependencies with uv:

uv sync

Alternative with pip:

pip install -r requirements.txt

  1. 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: SQL Server MCP Server (Diamond Inventory)

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

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • SQL MCP Server

    polarisxb
    A
    license
    Not graded
    quality
    C
    maintenance
    Enables read-only interaction with SQL databases through MCP, providing database metadata exploration, sample data retrieval, and secure query execution. Supports MySQL with multiple transport options and built-in security features including SQL injection protection and data sanitization.
    3 npm
    5
    MIT

  • SQL Server MCP Server (Diamond

    DhruviPatel712
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables safe, read-only querying and schema exploration for Microsoft SQL Server databases with preconfigured Diamond Inventory support, multiple database management, and optional HTTP API.
    MIT

  • sql-mcp

    Gowsi31
    F
    license
    A
    quality
    C
    maintenance
    Provides read-only SQL Server access via MCP tools and a chat interface for natural-language database queries.
    4
    -