home / mcp / crud mcp server

CRUD MCP Server

Provides MCP endpoints to manage Users and Products via CRUD REST APIs.

Installation

Add the following to your MCP client configuration file.

Configuration

{
  "mcpServers": {
    "amareshwarvarma-mcp-mcp-crud-tools": {
      "url": "http://localhost:8002/mcp",
      "headers": {
        "CRUD_URL": "http://host.docker.internal:8000"
      }
    }
  }
}

You have an MCP server that exposes CRUD tooling for Users and Products. It acts as a bridge to your existing CRUD REST APIs, letting clients perform standard create, read, update, and delete operations through a simple MCP interface that can be accessed over HTTP or run locally from your machine.

How to use

Connect your MCP client to the server to perform operations on Users and Products. Use the HTTP endpoint to stream MCP calls, or run the MCP server locally if you prefer a direct, local execution path. The available tools cover listing, retrieving, creating, updating, and deleting both Users and Products.

- Tools for Users: list_users, get_user, create_user, update_user, delete_user.

- Tools for Products: list_products, get_product, create_product, update_product, delete_product.

To get started, use the HTTP streaming endpoint at http://localhost:8002/mcp if you want to interact with the server over the network. If you prefer running everything locally on your machine, you can start the MCP server directly using Python as shown in the setup instructions.

How to install

Prerequisites you need on your machine before starting the MCP server:

# Ensure you have Docker and Python available on your system.
# The recommended path uses Docker for easy setup.

Install and run the MCP server using Docker. Follow these steps exactly as shown:

# Step 1: Create environment file from the example
cp .env.example .env

# Step 2: Build and start the MCP server with Docker
docker compose up --build

If you prefer to run the server locally without Docker, use Python to set up a virtual environment and start the server directly:

python -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
cp .env.example .env
python server.py

Additional configuration and notes

The server expects a CRUD URL where your REST API is reachable. When using Docker, the default configuration points to a CRUD service at http://host.docker.internal:8000, which works on macOS and Windows if your CRUD service is accessible at http://localhost:8000. If you are on Linux, you have two options: run the MCP server locally (as shown above) or add host-gateway support to Docker so the container can reach your host networking.

Environment variable to configure the CRUD endpoint (used in the default setup): CRUD_URL=http://host.docker.internal:8000

Important: If you run Linux and want to use Docker, add this to docker-compose.yml under the MCP service: extra_hosts: ["host.docker.internal:host-gateway"]

Available tools

list_users

Return a list of all users from the CRUD service.

get_user

Retrieve details for a single user by ID.

create_user

Create a new user with the provided data.

update_user

Update an existing user's data by ID.

delete_user

Remove a user by ID.

list_products

Return a list of all products from the CRUD service.

get_product

Retrieve details for a single product by ID.

create_product

Create a new product with the provided data.

update_product

Update an existing product's data by ID.

delete_product

Remove a product by ID.