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
SingleStore
Interact with the SingleStore database platform
BigQuery
Explore, query, and manage data in Google BigQuery.
Supabase MCP Server
An MCP server providing administrative control over a Supabase PostgreSQL database, compatible with Cursor's Composer and Codeium's Cascade.
FinanceMCP
Provides real-time financial data using the Tushare API.
Neo4j
MCP server for Neo4j — run Cypher queries, explore schema, and inspect database info over stdio
Airtable
Interact with Airtable's API to manage bases, tables, and records.
Database Updater
Update various databases (PostgreSQL, MySQL, MongoDB, SQLite) using data from CSV and Excel files.
ClickHouse MCP Server
A Node.js server for querying ClickHouse databases.
Memory Custom
Extends the MCP Memory server to create and manage a knowledge graph from LLM interactions.
DBeaver MCP Server
Integrates with DBeaver to provide AI assistants access to over 200 database types using existing connections.