Skip to content
MCP server

Sakila MCP

Read-only MySQL MCP server with a fail-closed SQL classifier and structured results.

Runs locallyStatus and history
Install
Pricing
Open source
Runs
Locally
Version
0.1.2
Listing updated
today

About Sakila MCP

Sakila MCP is an open-source MCP server. It runs locally on your machine and is started by your AI client.

Install

Run in a terminal

claude mcp add sakila-mcp --env SAKILA_MCP_USER='<SAKILA_MCP_USER>' --env SAKILA_MCP_PASSWORD='<SAKILA_MCP_PASSWORD>' -- uvx sakila-mcp

Add to claude_desktop_config.json

{
  "mcpServers": {
    "sakila-mcp": {
      "command": "uvx",
      "args": [
        "sakila-mcp"
      ],
      "env": {
        "SAKILA_MCP_USER": "<SAKILA_MCP_USER>",
        "SAKILA_MCP_PASSWORD": "<SAKILA_MCP_PASSWORD>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "sakila-mcp": {
      "command": "uvx",
      "args": [
        "sakila-mcp"
      ],
      "env": {
        "SAKILA_MCP_USER": "<SAKILA_MCP_USER>",
        "SAKILA_MCP_PASSWORD": "<SAKILA_MCP_PASSWORD>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "sakila-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "sakila-mcp"
      ],
      "env": {
        "SAKILA_MCP_USER": "<SAKILA_MCP_USER>",
        "SAKILA_MCP_PASSWORD": "<SAKILA_MCP_PASSWORD>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "sakila-mcp": {
      "command": "uvx",
      "args": [
        "sakila-mcp"
      ],
      "env": {
        "SAKILA_MCP_USER": "<SAKILA_MCP_USER>",
        "SAKILA_MCP_PASSWORD": "<SAKILA_MCP_PASSWORD>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "sakila-mcp": {
      "command": "uvx",
      "args": [
        "sakila-mcp"
      ],
      "env": {
        "SAKILA_MCP_USER": "<SAKILA_MCP_USER>",
        "SAKILA_MCP_PASSWORD": "<SAKILA_MCP_PASSWORD>"
      }
    }
  }
}

Using several servers? Build one config file with the MCP config generator.

Configuration

  • SAKILA_MCP_USERMySQL account name. Give it read-only grants.Required
  • SAKILA_MCP_PASSWORDPassword of the MySQL account. Empty if the account has none.
  • SAKILA_MCP_HOSTMySQL host.
  • SAKILA_MCP_PORTMySQL port.
  • SAKILA_MCP_DATABASE_ALLOWLISTComma-separated databases the agent may query. Empty means every non-system database.

Pricing

Open source

Sakila MCP FAQ

Is Sakila MCP free?

Yes. Sakila MCP is open source, so you can use and self-host it for free.

How do I add Sakila MCP to Claude Code?

Run this command in your terminal: claude mcp add sakila-mcp --env SAKILA_MCP_USER='<SAKILA_MCP_USER>' --env SAKILA_MCP_PASSWORD='<SAKILA_MCP_PASSWORD>' -- uvx sakila-mcp

Where this comes from

  • Description: from the official MCP Registry entry.
  • Install steps: from the official MCP Registry entry.

How AIPoweredBot checks servers