loading…
en/
Browse all
by Anthropic
by wenb1n-dev
by madhurprashby modelcontextprotocol
Pagila
FreeNot checkedA read-only Model Context Protocol server developed with FastMCP for querying the Pagila PostgreSQL database. It enables secure access to movie rental data incl
About
A read-only Model Context Protocol server developed with FastMCP for querying the Pagila PostgreSQL database. It enables secure access to movie rental data including films, actors, and customer information through natural language queries.
README
Servidor MCP desarrollado con FastMCP para consultar la base de datos Pagila (PostgreSQL) de forma segura (solo lectura).
Requisitos
- PostgreSQL 18 (o compatible)
- Base de datos: pagila (cargada)
- Python 3.x
- uv recomendado
Instalación
uv venv
.\.venv\Scripts\activate
uv pip install fastmcp "mcp[cli]" psycopg[binary] sqlparse
v
#VARIABLES DE ENTORNO
$env:PG_HOST="localhost"
$env:PG_PORT="5432"
$env:PG_DB="pagila"
$env:PG_USER="postgres"
$env:PG_PASS="TU_PASSWORD"
# Modelo relacional (Pagila)
La base de datos Pagila contiene 15 tablas principales, entre ellas:
actor, address, category, city, country, customer, film, film_actor, film_category,
inventory, language, payment, rental, staff, store.
Relaciones principales:
- rental se relaciona con inventory mediante inventory_id.
- inventory se relaciona con film mediante film_id.
- payment se relaciona con rental mediante rental_id.
- film_actor es una tabla puente (muchos a muchos) entre film y actor.
- film_category es una tabla puente (muchos a muchos) entre film y category.
- customer se relaciona con rental mediante customer_id.
//Lyrken Calle V.//
Install Pagila in Claude Desktop, Claude Code & Cursor
Run in your terminal:
claude mcp add pagila-mcp -- npx FAQ
Is Pagila MCP free?
Yes, Pagila MCP is free — one-click install via Unyly at no cost.
Does Pagila need an API key?
No, Pagila runs without API keys or environment variables.
Is Pagila hosted or self-hosted?
Self-hosted: the server runs locally on your machine via the install command above.
How do I install Pagila in Claude Desktop, Claude Code or Cursor?
Open Pagila on unyly.org, pick your client tab (Claude Desktop, Claude Code, Cursor) and press Install — the config is generated automatically, no JSON editing.
Related MCPs
Postgres
Query your database in natural language
by Anthropic4.822.3K
wenb1n-dev/SmartDB_MCP
A universal database MCP server supporting simultaneous connections to multiple databases. It provides tools for database operations, health analysis, SQL optim
by wenb1n-devPostgres Server
This server enables interaction with PostgreSQL databases through the Model Context Protocol, optimized for the AWS Bedrock AgentCore Runtime. It provides tools
by madhurprashPostgreSQL
Read-only database access with schema inspection.
by modelcontextprotocolCompare Pagila with
Not sure what to pick?
Find your stack in 60 seconds
Author?
Embed badge for your README
Browse similar
All data MCPs