Movie Database
Access a MongoDB movie database using natural language queries.
Movie Database MCP Server (Simplified)
A FastMCP server that provides access to a MongoDB movie database with natural language queries.
Features
- Search movies by title, genre, actor, year, or rating
- Get top-rated movies by year or genre
- Count movies matching criteria
- Get detailed information about specific movies
Prerequisites
- Python 3.7+
- MongoDB (local or cloud)
sample_mflixdatabase withmoviescollection
Installation
- Clone this repository:
git clone https://github.com/patw/movie-mcp-simple.git
cd movie-mcp-simple
- Install dependencies:
pip install pymongo fastmcp python-dotenv
- Create a
.envfile with your MongoDB connection string:
cp sample.env .env
Edit the .env file to add your actual MongoDB URI.
Usage
Configure the MCP server in Claude desktop with the following config:
{
"mcpServers": {
"Movie Database": {
"command": "uv",
"args": [
"run",
"--with",
"fastmcp, pymongo",
"fastmcp",
"run",
"<path to>/movie-mcp-simple/movie-mcp.py"
]
}
}
}
Example queries you can ask:
- "Find movies with Tom Hanks"
- "How many Comedy movies are there?"
- "What are the top 5 movies from 1994?"
- "Show me details for The Shawshank Redemption"
MCP Tools
The server provides these tools:
find_movies
Search for movies with various filters:
find_movies(title=None, genre=None, actor=None, year=None, min_rating=None, limit=10)
count_movies
Count movies matching criteria:
count_movies(genre=None, year=None, min_rating=None)
get_top_movies
Get highest rated movies:
get_top_movies(year=None, genre=None, limit=5)
get_movie_details
Get full details for a specific movie:
get_movie_details(title)
License
MIT
Related Servers
FinanceMCP
Provides real-time financial data using the Tushare API.
Simple MySQL MCP Server
A simple MCP server for MySQL, demonstrating fundamental MCP protocol concepts. Requires a MySQL database connection configured via environment variables.
Solana MCP Server
Provides comprehensive access to Solana blockchain data using 21 essential RPC methods.
Iceberg MCP Server (via Impala)
Provides read-only access to Apache Iceberg tables via Apache Impala, allowing LLMs to inspect schemas and execute queries.
MCP Toolbox for Databases
Open source MCP server specializing in easy, fast, and secure tools for Databases.
MySQL DB
An MCP server for integrating with and managing MySQL databases.
CData Salesforce MCP Server
A read-only MCP server by CData that allows LLMs to query live Salesforce data. Requires the CData JDBC Driver for Salesforce.
YugabyteDB MCP Server
Allows LLMs to directly interact with a YugabyteDB database.
CData Square Server
A read-only MCP server for querying live data from Square using the CData JDBC Driver.
Supavec MCP Server
Fetch relevant content from Supavec, a vector database service.