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

F
license - not found
-
quality - not tested
C
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

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

Related MCP Servers

  • SQL MCP Server

    polarisxb
    A
    license
    -
    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.
    10
    5
    MIT

  • Microsoft SQL Server MCP

    AdrianCY
    A
    license
    -
    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.
    746
    MIT

  • Universal Database MCP Server

    xiaoshi7915
    F
    license
    -
    quality
    D
    maintenance
    A versatile MCP server that connects to multiple relational databases (MySQL, PostgreSQL, Oracle, SQL Server, SQLite) and enables secure read-only SQL query execution and metadata access.
    4

  • SQL Server MCP Server (Diamond

    DhruviPatel712
    A
    license
    -
    quality
    C
    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

View all related MCP servers

Related MCP Connectors

  • outris-identity-mcp

    Identity resolution MCP server for phone/email lookups across 31+ services. Global + India coverage.

  • kodey-ai-salesforce-mcp-minimal

    Run SOQL queries to explore and retrieve Salesforce data. Access accounts, contacts, opportunities…

  • coralquery-mcp

    A paid remote MCP for AI SDK data query MCP, built to return verdicts, receipts, usage logs, and aud

View all MCP Connectors

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