You can run a FastMCP server backed by PostgreSQL to resolve user names and emails efficiently, with both local STDIO and HTTP transports. It uses a PostgreSQL database for fast lookups and supports token-based HTTP authorization for secure access.

How to use

Set up your PostgreSQL-backed MCP server and run it in either STDIO (local) or HTTP mode. You can connect with MCP clients to resolve users, look up managers and teams, and query calendar insights and meetings. If you enable HTTP, you can secure requests with an authorization token and connect using a standard HTTP MCP URL.

How to install

pip install -r requirements.txt

Environment configuration

Provide your database credentials and optional HTTP auth token

DB_HOST=your_host DB_PORT=5432 DB_NAME=your_database DB_USER=your_user DB_PASSWORD=your_password

Authentication (optional for STDIO, recommended for HTTP)

MCP_AUTH_TOKEN=your-secret-token-here

## Additional sections

Prerequisites and deployment steps are shown below. You will run the server in either STDIO or HTTP mode and then connect with supported MCP clients or integrations.

Configuration and startup options are provided in clear commands. If you run in HTTP mode, the server will be available at the specified URL and can be secured with an Authorization header using the MCP\_AUTH\_TOKEN value.

## Configuration notes

- The environment file should contain the PostgreSQL connection details and an optional MCP\_AUTH\_TOKEN for HTTP access. The token controls access when HTTP transport is used.

## Available tools

### resolve\_user

Resolve a user name or email to their UUID using fuzzy matching; returns the UUID or prompts for disambiguation.

### resolve\_users\_batch

Resolve multiple user names or emails to UUIDs in a single call; supports batch processing (up to 50 inputs).

### confirm\_user

Confirm a user's exact email to retrieve their UUID after verification.

### confirm\_users\_batch

Confirm multiple exact emails to obtain the corresponding UUIDs in a single call.

### get\_team\_members

Retrieve all team members under a specific manager, including indirect reports.

### get\_manager\_of\_user

Return the manager(s) of a given user, including primary and remote managers when applicable.

### get\_user\_by\_uuid

Fetch complete user details by their UUID.

### resolve\_user\_in\_team

Scoped search to resolve a user within a specific manager's team only.

### get\_user\_calendar\_insights

Get a comprehensive calendar insights dashboard for a user, including health, metrics, and quality signals.

### query\_user\_meetings

Query and filter a user's meetings with sorting, filtering, and search capabilities.

### get\_meeting\_details

Get full details of a specific meeting, including attendees and agenda quality signals.