MCP server
Sakila MCP
Read-only MySQL MCP server with a fail-closed SQL classifier and structured results.
Runs locallyStatus and history
- 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-mcpAdd 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.RequiredSAKILA_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.