# Pagila MCP

> Use this tool when you need to access and query movie rental data, including films, actors, and customer information, through natural language queries in a secure and read-only manner. It solves problems related to data retrieval and analysis, providing insights into the movie rental database. The Pagila MCP server takes natural language queries as input and returns relevant data from the Pagila PostgreSQL database as output.

Canonical page: https://skillsregistry.net/skills/lyrken-pagila-mcp  
JSON: https://api.skillsregistry.net/v1/skills/lyrken-pagila-mcp

## Description

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.

## Trust

- **Trust score (0–1):** 0.95
- **Verification tier:** verified
- **Last scanned:** 2026-09-19

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-19

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/x7st8z0b9m)
- **Repository:** <https://github.com/lyrken/pagila_mcp>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "lyrken-pagila-mcp"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/lyrken-pagila-mcp` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/lyrken-pagila-mcp/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt