Movie Database

You can run a lightweight MCP server that gives you natural language access to a MongoDB movie database. It lets you search, filter, and retrieve detailed movie information, all through simple, natural-language queries integrated with your MCP client.

How to use

Connect your MCP client to the Movie Database MCP Server and start asking questions in plain language. You can search by title, genre, actor, year, or rating, retrieve top-rated movies by year or genre, count how many movies match criteria, and fetch detailed information about a specific title. Use natural language prompts like “Find movies with Tom Hanks” or “What are the top 5 movies from 1994?” to explore the collection.

How to install

Prerequisites you need before running the server: Python 3.7 or newer, MongoDB (local or cloud), and a sample database named sample_mflix with a movies collection.

Step by step commands to set up the server locally:

# 1) Clone the repository
git clone https://github.com/patw/movie-mcp-simple.git
cd movie-mcp-simple

# 2) Install dependencies
pip install pymongo fastmcp python-dotenv

# 3) Create a .env file with your MongoDB connection string
cp sample.env .env
# Edit .env to add your actual MongoDB URI

Additional notes

MCP server configuration is provided to connect your MCP client. The following stdio configuration runs the server locally through the UV runtime, loading the fastMCP and pymongo integrations and starting the Python script that powers the movie MCP server.

{
  "mcpServers": {
    "Movie Database": {
      "command": "uv",
      "args": [
        "run",
        "--with",
        "fastmcp, pymongo",
        "fastmcp",
        "run",
        "<path to>/movie-mcp-simple/movie-mcp.py"
      ]
    }
  }
}

Available tools

find_movies

Search for movies by title, genre, actor, year, or minimum rating with a limit on results.

count_movies

Count how many movies match given criteria such as genre, year, and minimum rating.

get_top_movies

Retrieve highest rated movies, optionally filtered by year or genre, up to a specified limit.

get_movie_details

Fetch full details for a specified movie title.