Skip to main content
Glama
josephstreeter

IDMS Identity SQL MCP

by josephstreeter
OverviewSchemaRelated ServersScoreDiscussions
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: Microsoft SQL Server MCP

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 installed

RayrunBuild, deploy, and operate MCP servers without becoming an infrastructure team.ray.runAd

Maintenance

ActivityStale
ResponsivenessNo issues

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

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.
    19
    5
    MIT

  • Microsoft SQL Server MCP

    AdrianCY
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables interaction with Microsoft SQL Server databases through T-SQL query execution, table exploration, and schema inspection. Supports configurable write protection and row limiting for safe database operations.
    907
    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

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/josephstreeter/mcp_idms'

If you have feedback or need assistance with the MCP directory API, please join our Discord server