sashagoebbels/mcp-server

User Inventory MCP Server

A Model Context Protocol (MCP) server for managing users with their usernames, email addresses, and hardware inventory.

Features

• Create, read, update, and delete users
• Store username, email address, and hardware inventory for each user
• Search users by username or email
• Query hardware inventory for specific users
• Persistent SQLite storage (data persists across server restarts)

Installation

pip install -r requirements.txt

Usage

Run the server:

python server.py

Add sample users:

python add_users.py

Database

The server uses SQLite for persistent storage. The database file users_inventory.db is created automatically in the same directory as the server.

Available Tools

1. create_user - Create a new user with username, email, and hardware inventory
2. get_user - Get user information by user ID
3. list_users - List all users in the system
4. search_users - Search users by username or email
5. update_user - Update user information
6. delete_user - Delete a user by ID
7. get_hardware_inventory - Get hardware inventory for a specific user

Example Usage in GitHub Copilot CLI

1. Add the MEC server to Copilot after starting copilot:

   /mcp add
   

2. Run the script to install the fixtures:

   python add_users.py
   

3. Answer all the questions. The server type is local, the server command is python [/absolute/path]/server.py.
4. Start typing the commands:

   list users
   

   or

   which user does use a mac
   

Running the tests

There is a test implementation in pytest and you can call it with:

pytest -s