Sakila MCP
● Activeio.github.pantoniades/sakila-mcp
Read-only MySQL MCP server with a fail-closed SQL classifier and structured results.
Connect this server
One click to install, or copy the config below. Suits: Claude Desktop · Cursor.
Or add it manually — claude_desktop_config.json (Claude Desktop) or .cursor/mcp.json (Cursor):
{
"mcpServers": {
"sakila-mcp": {
"command": "uvx",
"args": [
"sakila-mcp"
],
"env": {
"SAKILA_MCP_USER": "<your SAKILA_MCP_USER>",
"SAKILA_MCP_PASSWORD": "<your SAKILA_MCP_PASSWORD>",
"SAKILA_MCP_HOST": "127.0.0.1",
"SAKILA_MCP_PORT": "3306"
}
}
}
}claude mcp add --env SAKILA_MCP_USER='<your SAKILA_MCP_USER>' --env SAKILA_MCP_PASSWORD='<your SAKILA_MCP_PASSWORD>' --env SAKILA_MCP_HOST=127.0.0.1 --env SAKILA_MCP_PORT=3306 --transport stdio sakila-mcp -- uvx sakila-mcpcodex mcp add sakila-mcp --env SAKILA_MCP_USER='<your SAKILA_MCP_USER>' --env SAKILA_MCP_PASSWORD='<your SAKILA_MCP_PASSWORD>' --env SAKILA_MCP_HOST=127.0.0.1 --env SAKILA_MCP_PORT=3306 -- uvx sakila-mcpcode --add-mcp '{"name":"sakila-mcp","type":"stdio","command":"uvx","args":["sakila-mcp"],"env":{"SAKILA_MCP_USER":"<your SAKILA_MCP_USER>","SAKILA_MCP_PASSWORD":"<your SAKILA_MCP_PASSWORD>","SAKILA_MCP_HOST":"127.0.0.1","SAKILA_MCP_PORT":"3306"}}'Syntax from each client's docs (Claude Code: claude mcp add; Codex: codex mcp add; VS Code: code --add-mcp). Placeholders in angle brackets are values you fill in.
- SAKILA_MCP_USERrequiredMySQL account name. Give it read-only grants.
- SAKILA_MCP_PASSWORDsecretPassword of the MySQL account. Empty if the account has none.
- SAKILA_MCP_HOSTMySQL host.
- SAKILA_MCP_PORTMySQL port.
A starting point — check the repository for exact arguments and setup. Restart your client after editing the config.
- Category
- Databases
- Version
- 0.1.2
- Registry
- active
- Published
- 11/18/2026
Is it safe? Is it maintained?
Serverdex check: Nov 21, 2026Looks healthy: Sakila MCP is maintained, open source.
- Maintained
- Active
- Last commit 4 days ago (Nov 18, 2026), 0 open issues.
- Official registry
- Active
- Published as io.github.pantoniades/sakila-mcp in the official MCP registry, version 0.1.2.
- Source
- Open source, Apache-2.0
- Public repository under the Apache-2.0 licence, 0 stars, 0 forks.
- Runs
- On your machine
- A local PyPI package started by your client; it can reach whatever your user account can.
- Credentials
- 2 required
- Declared environment variables: SAKILA_MCP_USER, SAKILA_MCP_PASSWORD. They stay on your machine; the config on this page shows where each goes.
- Owner
- Unclaimed
- Nobody has claimed this page yet; the data above comes from the registry, GitHub and the live check.
Facts only: last commit and licence from GitHub, the entry's status from the official registry, credentials from the live check. Not a code audit — run the security scan on the endpoint yourself.
On GitHub
read Nov 18, 2026- Stars
- 0
- Forks
- 0
- Last push
- Nov 18, 2026
- License
- Apache-2.0
Python
From the README
sakila-mcp sakila-mcp is an MCP server that lets an LLM agent inspect and query any MySQL database, read-only, with a fail-closed SQL classifier between the agent and the server. sakila-mcp is a general-purpose MySQL MCP server for any MySQL database. It is named after Sakila, the MySQL dolphin mascot, and is not specific to the Sakila sample database. Independent open-source project. Not affiliated with, sponsored by or endorsed by Oracle. MySQL is a trademark of Oracle and/or its affiliates. Status: v0.1 (0.1.1 is the first release on PyPI). What's described here works today. Expect the interface to change. Quickstart You need uv and a MySQL account that can only read (the grants are under Safety model). Then ask "what's in app_db and how do orders relate to customers?" or "why is this query slow?". Any MCP client that speaks stdio works; see Use it. What makes it different • It fails closed. A statement the classifier can't parse is refused, and so is any function that isn't a known MySQL built-in. • It doesn't trust one lexer. Comments are re-scanned with MySQL's own rules, because a parser and the server can disagree about where a comment ends. • A refusal is a result, not an error: a code, a reason and a suggestion, so the agent can rephrase instead of giving up. • Everything is bounded without touching your SQL: rows, cell size and execution time are capped, and no LIMIT is ever added to a query. • The classifier isn't the only layer.…
Read the full README on GitHub →Alternatives to Sakila MCP
All Sakila MCP alternatives →Best Databases servers →The most-starred Databases servers in the index, with their live-check result.
| Server | Stars | Last push | Live check |
|---|---|---|---|
| Dbx | 30,677 | Nov 2026 | Local / not checked |
| MCP Toolbox for Databases | 16,897 | Nov 2026 | Local / not checked |
| MCP Toolbox for Databases | 16,897 | Nov 2026 | Local / not checked |
| Finance Database | 9,648 | Nov 2026 | Working |
| DBHub | 3,868 | Nov 2026 | Local / not checked |
Sakila MCP: questions people ask
- Is Sakila MCP a remote or a local MCP server?
- According to its entry in the official MCP registry, Sakila MCP ships as a local package (PyPI) that your client starts on your machine.
- Does Sakila MCP need an API key?
- Its registry entry declares 2 required environment variables: SAKILA_MCP_USER, SAKILA_MCP_PASSWORD. The config on this page shows where each goes.
- Is Sakila MCP safe to use?
- Looks healthy: Sakila MCP is maintained, open source. In detail — maintained: Active; official registry: Active; source: Open source, Apache-2.0; runs: On your machine; credentials: 2 required. Serverdex check of Nov 21, 2026. This is a reading of the repository, the registry entry and the live check, not a code audit; run the Serverdex security scan on the endpoint before trusting it with real data.
- Is Sakila MCP still maintained?
- Active: the repository's last commit 4 days ago. Last push Nov 18, 2026, 0 GitHub stars, Apache-2.0 licence. Read from GitHub on Nov 18, 2026.
- How do I add Sakila MCP to Claude, Cursor or VS Code?
- Copy the config in "Connect this server" into your client's MCP config file (claude_desktop_config.json, ~/.cursor/mcp.json or .vscode/mcp.json), or use the one-click Add to Cursor / Add to VS Code buttons and the one-line commands for Claude Code and Codex; then restart the client.
More Databases servers
Browse all Databases →pgmcp
pascalallen
Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
Grain SQL
pattrnlabs
Run SQL queries and inspect database schemas through safe, visible MCP tools.
Petal Components MCP
petalframework
Phoenix LiveView component schemas from petal_components, exposed to AI coding assistants.
MCP Database Doctor
petrovicistefan
Offline PostgreSQL query, migration and EXPLAIN diagnostics for AI agents.
MCP DB Connect
phatngoit
MCP server for Oracle, MSSQL, PostgreSQL, MySQL, SQLite, MongoDB, and Qdrant vector search access.
DataLink
pilat
MCP server for secure database access (PostgreSQL, MySQL, SQLite)
Add the badge to your site
Show visitors that Sakila MCP is listed here — it’s also the link we check for a free listing.
HTML — for your website
<a href="https://serverdex.io/server/io-github-pantoniades-sakila-mcp?utm_source=badge"><img src="https://serverdex.io/brand/badge.svg" alt="Sakila MCP — listed on Serverdex" width="123" height="40" loading="lazy"></a>Recommended. A dofollow link from your own domain is the one that counts for search engines, and it's the link we check for a free listing.
Markdown — for your README
[](https://serverdex.io/server/io-github-pantoniades-sakila-mcp?utm_source=badge)Nice for visibility, but GitHub marks README links nofollow, so it doesn't pass authority. Use the HTML badge on your site as well.
Install buttons — for your README
[](https://serverdex.io/install/cursor/io-github-pantoniades-sakila-mcp) [](https://serverdex.io/install/vscode/io-github-pantoniades-sakila-mcp) [](https://serverdex.io/install/claude-code/io-github-pantoniades-sakila-mcp)One click opens Cursor or VS Code with this server's config prefilled; the Claude Code button lands on the one-line command. The links point at Serverdex, so when your config changes the buttons keep working.
Install buttons — HTML for your docs
<a href="https://serverdex.io/install/cursor/io-github-pantoniades-sakila-mcp"><img src="https://serverdex.io/brand/install-cursor.svg" alt="Add to Cursor — via Serverdex" width="140" height="28"></a>
<a href="https://serverdex.io/install/vscode/io-github-pantoniades-sakila-mcp"><img src="https://serverdex.io/brand/install-vscode.svg" alt="Add to VS Code — via Serverdex" width="147" height="28"></a>
<a href="https://serverdex.io/install/claude-code/io-github-pantoniades-sakila-mcp"><img src="https://serverdex.io/brand/install-claude-code.svg" alt="Open in Claude Code — via Serverdex" width="180" height="28"></a>Same buttons as plain links for a docs page or website.
Prefer a live badge with the score, stars and live check? Score badge (links to a page that explains the number and back to this listing).