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
Serveurs connexes
Metabase Server
Integrates with Metabase for data visualization and business intelligence. Requires METABASE_URL, METABASE_USERNAME, and METABASE_PASSWORD environment variables.
Elasticsearch
Connects agents to Elasticsearch data, enabling natural language interaction with indices.
PostgreSQL
Provides read-only access to PostgreSQL databases, allowing LLMs to inspect schemas and execute queries.
OpenDart-MCP
Access the DART (Data Analysis, Retrieval and Transfer System) API for detailed financial information retrieval and analysis.
Redash
Execute queries and retrieve results using the Redash API.
MongoDB
Provides read-only access to MongoDB databases through standardized MCP tools and resources.
CData CSV Files
A read-only MCP server for CSV files from CData, requiring an external JDBC driver for connection.
College Football Data
Access college football statistics from the College Football Data API.
DART-MCP
Perform financial analysis using the DART API and Claude.
MCP-PostgreSQL-Ops
MCP-PostgreSQL-Ops is a professional MCP server for PostgreSQL database operations, monitoring, and management. Supports PostgreSQL 12-17 with comprehensive database analysis, performance monitoring, and intelligent maintenance recommendations through natural language queries.