pagila-mcp

Small MCP server wrapper for the Pagila sample database. This repository provides:

mcp_pagila_server.py - MCP server that accepts JSON requests on stdin and returns JSON responses on stdout.
db.py - database helpers to run queries against Postgres.
mcp_inspector.py - a small interactive inspector that starts the server subprocess and sends test requests.

Quickstart

Copy the example env and set your DB credentials:

cp config.env.example config.env # edit config.env and set PG_HOST, PG_USER, PG_PASSWORD etc.

Create a virtualenv and install dependencies:

python -m venv .venv .venv/bin/pip install --upgrade pip .venv/bin/pip install -r requirements.txt

Run the inspector (it will start the server for you):

.venv/bin/python mcp_inspector.py # or one-shot examples .venv/bin/python mcp_inspector.py -c "list_films 5" .venv/bin/python mcp_inspector.py -c "text2sql show me film titles from 2010 limit 3"

Usage & safety

The server exposes run_pagila_query which accepts only SELECT statements. text_to_sql generates SELECT SQL from natural language (local heuristic by default).
Do not commit config.env or any secrets. Use environment variables for production.

CI & code style

This repo includes a GitHub Actions CI workflow at .github/workflows/ci.yml to run formatting and tests.
Use pre-commit (configured in .pre-commit-config.yaml) to run black/isort/flake8 locally.

License MIT

Pagila MCP server

Lightweight MCP server around the Pagila DB.

Quick start:

Copy .env.example -> config.env and fill DB creds.
Create a virtualenv and install dependencies:
python -m venv .venv .venv/bin/pip install -r requirements.txt
Run the server:
.venv/bin/python mcp_pagila_server.py
Use the inspector: .venv/bin/python mcp_inspector.py