# MCP Playground

## Requirements

- Python 3.13
- [uv](https://docs.astral.sh/uv/) package manager
- SQLite3

## Installation

1. **Clone the repository**

   ```bash
   git clone <repository-url>
   cd mcp_playground
   ```

2. **Install dependencies with uv**

   ```bash
   uv sync
   ```

3. **Setup the SQLite database**

   1. Create a new SQLite database file using the provided schema.

   ```bash
   cd db
   ```

   ```bash
   sqlite3 database.db < schema.sql
   ```

   2. Insert dummy data into the database.

   ```bash
   sqlite3 database.db < insert_data.sql
   ```

4. **Start the venv (if you want to start the server manually)**

   ```bash
   source .venv/bin/activate
   ```

## Usage

### Starting the server

The server currently uses IO for communication. It is not meant to be started manually, instead it should be accessed through an MCP client.

### Implemented Functions

The following functions are implemented in the server:

1. **`db_schema` (resource)**

   - Returns the database schema by reading the `schema.sql` file.

2. **`get_users` (tool)**

   - Fetches a list of all user names from the `users` table in the database.

3. **`get_all_employee_profiles` (tool)**

   - Retrieves all employee profiles

4. **`send_email` (tool)**

   - Sends an email using mailtrap.
   - Requires API-key in .env file:
     ```
     MAILTRAP_API_TOKEN=your_mailtrap_api_key
     ```

5. **`propose_team_for_project` (prompt)**

   - Given a project description and team size, proposes a team of employees best suited for the project based on their skills and experience.

### Integration with Claude Desktop as the MCP client

Add the following configuration to your MCP client (e.g., Claude Desktop):

- Settings → Developer → Edit config → `claude_desktop_config.json`
- `mcpServers`: The server name, in this case `not-solita-corp`.
- `command`: The ABSOLUTE path to the `uv` executable on your system.
- `args`: The arguments to start the MCP server, including the ABSOLUTE path to the `mcp_playground` directory.
- Note: Windows paths use backslashes (`\`).

```json
{
  "mcpServers": {
    "mcp_demo": {
      "command": "/path/to/user/.local/bin/uv",
      "args": [
        "--directory",
        "/path/to/user/mcp_playground",
        "run",
        "server.py"
      ]
    }
  }
}
```