timesfm
TimesFM (Time Series Foundation Model) is a pretrained time-series foundation model developed by Google Research for time-series forecasting.
Read-only MySQL MCP server with a fail-closed SQL classifier and structured results.
Skills that teach the AI this kind of work; they work alongside this one
TimesFM (Time Series Foundation Model) is a pretrained time-series foundation model developed by Google Research for time-series forecasting.
Open-source intelligence for the global theater. Track everything from the corporate/private jets of the wealthy, and spy satellites, to seismic events in one unified interface. Hook an AI agent up to have it parse through data and find previously unseen correlations. The knowledge is available to…
scrape data from Google Maps. Extracts data such as the name, address, phone number, website URL, rating, reviews number, latitude and longitude, reviews,email and more for each place
Lists are ordered by a usage score (out of 100) built from these parts
| Popularity | 0/80 | GitHub stars or weekly downloads: the larger counts 60, the smaller 20 |
|---|---|---|
| Freshness | 12/12 | Full marks for a release or code change within 30 days |
| Still answering | 0/8 | The cloud endpoint answered at the last check |
| Usage score | 12/100 |
Quality: Passed 3/3 basic checks (shown, not used for ordering) · Momentum: No data yet (Used only on the Trending tab)
Pick the AI app you use, then copy the settings.
Let your AI install it with one sentence
Please install Sakila MCP. Follow https://mcp.popnx.com/i/pantoniades-sakila-mcp.md, show me the commands and wait for my OK before running them.Paste it into an AI that can work on your computer (such as Claude Code or Cursor). It reads our steps, shows you the commands and waits for your OK. No key, no sign-up. · See the full text your AI reads
Passed 3/3 checks · Runs on your computer · ✓ Commands checked Nov 18, 2026
First: which AI do you use?
Pick your app and the steps appear below.
Works with Claude, with some setup first
You need a Sakila MCP key (create it on the maker’s site) · 1 setting(s) to fill in (SAKILA_MCP_USER) · Install Python (uv) on your computer first (one time) · Only the Claude desktop app (Windows or Mac), not the web or phone
Copy this message into a Claude chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.
Please install the MCP server Sakila MCP for Claude on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "sakila": { "command": "uvx", "args": [ "sakila-mcp" ], "env": { "SAKILA_MCP_USER": "your-value", "SAKILA_MCP_PASSWORD": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For SAKILA_MCP_PASSWORD, SAKILA_MCP_USER, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Sakila MCP tools really show up.This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.
Already installed? Check first · Open Terminal, type this command and press Enter
uv --versionMac: press ⌘ + Space, type Terminal, press Enter
Windows: open Start, type Windows PowerShell, then Open
Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required
When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version
Install once; it works for everything that needs uv
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
These are program settings, not keys. No sign-up needed; fill them in as the maker describes.
SAKILA_MCP_USER MySQL account name. Give it read-only grants.Descriptions are as written by the maker.
SettingsDeveloperEdit Config
{
"mcpServers": {
"sakila": {
"command": "uvx",
"args": [
"sakila-mcp"
],
"env": {
"SAKILA_MCP_USER": "your-value",
"SAKILA_MCP_PASSWORD": "your-value"
}
}
}
}Paste the key only into the app’s field, never into a chat or to anyone
Use Sakila MCP and tell me what you can do for me, then show me one thing✓ If Claude says it is using Sakila MCP or shows a Sakila MCP tool in the answer, you are connected
The command above works without these. Add them only if you want to change something, following the maker’s description.
SAKILA_MCP_HOST MySQL host. · default 127.0.0.1SAKILA_MCP_PORT MySQL port. · default 3306SAKILA_MCP_DATABASE_ALLOWLIST Comma-separated databases the agent may query. Empty means every non-system database.Descriptions are as written by the maker.
Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version
ChatGPT cannot connect Sakila MCP yet
Sakila MCP runs on your computer, but ChatGPT can only connect servers that run on the web
A · Use an app that can connect Sakila MCP
B · Others in Databases & datasets that work with ChatGPT
Picked from the most used in the same category, only ones that connect by address with no key
Works with Claude Code, with some setup first
You need a Sakila MCP key (create it on the maker’s site) · 1 setting(s) to fill in (SAKILA_MCP_USER) · Install Python (uv) on your computer first (one time)
Copy this message into a Claude Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.
Please install the MCP server Sakila MCP for Claude Code on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): claude mcp add --scope user sakila --env SAKILA_MCP_USER=your-value --env SAKILA_MCP_PASSWORD=your-value -- uvx sakila-mcp 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For SAKILA_MCP_PASSWORD, SAKILA_MCP_USER, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Sakila MCP tools really show up.This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.
Already installed? Check first · Open Terminal, type this command and press Enter
uv --versionMac: press ⌘ + Space, type Terminal, press Enter
Windows: open Start, type Windows PowerShell, then Open
Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required
When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version
Install once; it works for everything that needs uv
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
These are program settings, not keys. No sign-up needed; fill them in as the maker describes.
SAKILA_MCP_USER MySQL account name. Give it read-only grants.Descriptions are as written by the maker.
Mac: press Command+Space and type Terminal · Windows: open PowerShell
claude mcp add --scope user sakila --env SAKILA_MCP_USER=your-value --env SAKILA_MCP_PASSWORD=your-value -- uvx sakila-mcpReplace “your-value” with your key before pressing Enter
Paste the key only into the app’s field, never into a chat or to anyone
You should see Sakila MCP listed as connected
Use Sakila MCP and tell me what you can do for me, then show me one thing✓ If Claude Code says it is using Sakila MCP or shows a Sakila MCP tool in the answer, you are connected
The command above works without these. Add them only if you want to change something, following the maker’s description.
SAKILA_MCP_HOST MySQL host. · default 127.0.0.1SAKILA_MCP_PORT MySQL port. · default 3306SAKILA_MCP_DATABASE_ALLOWLIST Comma-separated databases the agent may query. Empty means every non-system database.Descriptions are as written by the maker.
Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version
Works with Cursor, with some setup first
You need a Sakila MCP key (create it on the maker’s site) · 1 setting(s) to fill in (SAKILA_MCP_USER) · Install Python (uv) on your computer first (one time)
Copy this message into a Cursor chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.
Please install the MCP server Sakila MCP for Cursor on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "sakila": { "command": "uvx", "args": [ "sakila-mcp" ], "env": { "SAKILA_MCP_USER": "your-value", "SAKILA_MCP_PASSWORD": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For SAKILA_MCP_PASSWORD, SAKILA_MCP_USER, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Sakila MCP tools really show up.This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.
Already installed? Check first · Open Terminal, type this command and press Enter
uv --versionMac: press ⌘ + Space, type Terminal, press Enter
Windows: open Start, type Windows PowerShell, then Open
Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required
When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version
Install once; it works for everything that needs uv
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
These are program settings, not keys. No sign-up needed; fill them in as the maker describes.
SAKILA_MCP_USER MySQL account name. Give it read-only grants.Descriptions are as written by the maker.
In the Sakila MCP settings, SAKILA_MCP_PASSWORD, SAKILA_MCP_USER is empty; add your key and save
Paste the key only into the app’s field, never into a chat or to anyone
Use Sakila MCP and tell me what you can do for me, then show me one thing✓ If Cursor says it is using Sakila MCP or shows a Sakila MCP tool in the answer, you are connected
The command above works without these. Add them only if you want to change something, following the maker’s description.
SAKILA_MCP_HOST MySQL host. · default 127.0.0.1SAKILA_MCP_PORT MySQL port. · default 3306SAKILA_MCP_DATABASE_ALLOWLIST Comma-separated databases the agent may query. Empty means every non-system database.Descriptions are as written by the maker.
Menu names checked against Cursor’s help page on Nov 11, 2026 · your screen may differ slightly by app version
Works with VS Code, with some setup first
You need a Sakila MCP key (create it on the maker’s site) · 1 setting(s) to fill in (SAKILA_MCP_USER) · Install Python (uv) on your computer first (one time)
Copy this message into a VS Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.
Please install the MCP server Sakila MCP for VS Code on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "servers": { "sakila": { "type": "stdio", "command": "uvx", "args": [ "sakila-mcp" ], "env": { "SAKILA_MCP_USER": "your-value", "SAKILA_MCP_PASSWORD": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For SAKILA_MCP_PASSWORD, SAKILA_MCP_USER, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Sakila MCP tools really show up.This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.
Already installed? Check first · Open Terminal, type this command and press Enter
uv --versionMac: press ⌘ + Space, type Terminal, press Enter
Windows: open Start, type Windows PowerShell, then Open
Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required
When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version
Install once; it works for everything that needs uv
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
These are program settings, not keys. No sign-up needed; fill them in as the maker describes.
SAKILA_MCP_USER MySQL account name. Give it read-only grants.Descriptions are as written by the maker.
In the Sakila MCP settings, SAKILA_MCP_PASSWORD, SAKILA_MCP_USER is empty; add your key and save
Paste the key only into the app’s field, never into a chat or to anyone
Use Sakila MCP and tell me what you can do for me, then show me one thing✓ If VS Code says it is using Sakila MCP or shows a Sakila MCP tool in the answer, you are connected
The command above works without these. Add them only if you want to change something, following the maker’s description.
SAKILA_MCP_HOST MySQL host. · default 127.0.0.1SAKILA_MCP_PORT MySQL port. · default 3306SAKILA_MCP_DATABASE_ALLOWLIST Comma-separated databases the agent may query. Empty means every non-system database.Descriptions are as written by the maker.
Menu names checked against VS Code’s help page on Nov 11, 2026 · your screen may differ slightly by app version
Other apps that use MCP, such as Windsurf, Zed or Gemini CLI, each add servers differently. See how in the app list.
JSON settings are under “For developers” below
Claude Code
claude mcp add --scope user sakila --env SAKILA_MCP_USER=your-value --env SAKILA_MCP_PASSWORD=your-value -- uvx sakila-mcpClaude Desktop (claude_desktop_config.json)
{
"mcpServers": {
"sakila": {
"command": "uvx",
"args": [
"sakila-mcp"
],
"env": {
"SAKILA_MCP_USER": "your-value",
"SAKILA_MCP_PASSWORD": "your-value"
}
}
}
}Cursor (~/.cursor/mcp.json)
{
"mcpServers": {
"sakila": {
"command": "uvx",
"args": [
"sakila-mcp"
],
"env": {
"SAKILA_MCP_USER": "your-value",
"SAKILA_MCP_PASSWORD": "your-value"
}
}
}
}VS Code (mcp.json)
{
"servers": {
"sakila": {
"type": "stdio",
"command": "uvx",
"args": [
"sakila-mcp"
],
"env": {
"SAKILA_MCP_USER": "your-value",
"SAKILA_MCP_PASSWORD": "your-value"
}
}
}
}SAKILA_MCP_USER required envSAKILA_MCP_PASSWORD secret required envSAKILA_MCP_HOST envSAKILA_MCP_PORT envSAKILA_MCP_DATABASE_ALLOWLIST envDescriptions are as written by the maker.
These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.
Based on how this server connects and on each app’s own docs, checked Nov 10, 2026.
Run on your computer in
ClaudeGooseLM StudioMsty StudioCherry StudioCursorVS Code + GitHub CopilotVisual StudioWindsurf (Devin Desktop)ZedKiroClineContinueJetBrains AI AssistantClaude CodeCodex CLIGemini CLIOpenCodenodecodeWarpLibreChatRaycast
Runs on your computer; the tool list appears in your AI app after you install it.
We check information anyone can see; we have not read the code. Checks that do not apply are left out of the count. · Checked Nov 19, 2026
The registry name was verified with the GitHub account pantoniades, which owns the repo
Code last changed yesterday
Uses Apache-2.0
This one runs on your computer; there is no internet endpoint
Runs on your computer and uses local settings instead
Runs on your computer; we can only read tool lists from internet endpoints
No entries on OSV.dev for sakila-mcp@0.1.2
Checks only this package version, not every dependency · checked Nov 18, 2026
If you made this, paste this code into your README. The badge links back to this page.
[](https://mcp.popnx.com/en/servers/pantoniades-sakila-mcp)Ask, share a tip or report that it does not work. Sorted by what people marked helpful.
No posts yet. Be the first to ask or share.
Posts here are written by users, not the PopNx team.
No reviews yet
Compared with every active server in this category in the registry. Stars count only when the publisher owns the repo.
It passed 3 of 3 applicable basic checks. We have not read the code. Before adding a key or token, see what access the server asks for and use a key with only the permissions you need.
You need to fill in: SAKILA_MCP_PASSWORD
It runs on your computer. Your AI app starts it when needed, and data does not pass through the maker’s servers (unless it calls an online service itself).
The GitHub repo last changed yesterday, and the latest version (0.1.2) reached the registry yesterday.
Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. You also need Python (uv) on your computer.
In the same category: QueryWeaver, Supabase, Neon, DBCode, Keboola MCP
Same category, other makers, commands already checked. Official ones first, then by stars.
Reading a card:↓ Downloads per weeki★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi
An MCP server for Text2SQL: transforms natural language into SQL using graph schema understanding.
Supabase’s official server lets AI create tables, query data and review project settings in your Supabase database.
Official Neon MCP server for managing Neon projects and Lakebase Postgres databases.
Query and explore 100+ databases through your DBCode connections.
Connect your AI assistants to Keboola and expose your data, transformations, SQL queries, ...
| This one Sakila MCP | QueryWeaver | Supabase | Neon | DBCode | Keboola MCP | |
|---|---|---|---|---|---|---|
| Runs where | Installs on your computer | Installs on your computer | Cloud or install on your computer | Runs in the cloud, nothing to install | Installs on your computer | Cloud or install on your computer |
| Needs a key | Yes | No | Yes | No | No | No |
| Add with + in Claude | No | No | Yes | Yes | No | No |
| Basic checks | 3/3 | 3/3 | 5/5 | 5/5 | 2/3 | 5/5 |
| License | Apache-2.0 | AGPL-3.0 | Apache-2.0 | MIT | NOASSERTION | MIT |
| Price | No cost listed in the registry | No cost listed in the registry | No cost listed in the registry | No cost listed in the registry | No cost listed in the registry | No cost listed in the registry |
Copied from the maker’s repo as written. PopNx MCP has not reviewed or endorsed it. HTML, images and scripts are removed. Links lead off this site.
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.
You need uv and a MySQL account that can only read (the grants are under Safety model).
cat > ~/.config/sakila-mcp.toml <<'EOF'
host = "db.example.internal" user = "sakila_mcp" password = "..." database_allowlist = ["app_db"] EOF chmod 600 ~/.config/sakila-mcp.toml
claude mcp add sakila -- uvx sakila-mcp --config ~/.config/sakila-mcp.toml
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.
LIMIT is ever added to a query.EXPLAIN FORMAT=JSON shapes.Six tools, all read-only:
| Tool | Returns |
|---|---|
server_info | MySQL version and release line (LTS / Innovation), uptime, session time zone, key globals (buffer pool, binlog format, GTID mode, read_only, sql_mode, charset), and the sakila-mcp version. |
list_databases | Databases you're allowed to query, system schemas flagged. |
list_tables | Tables and views in one database: engine, approximate rows, data and index size. |
describe_table | Columns, indexes (key parts in order, uniqueness, cardinality), foreign keys, engine, row format, collation. |
run_query | Columns and rows for one statement, capped at max_rows. Parameters via ? placeholders. |
explain_query | EXPLAIN FORMAT=JSON plus a summary (full table scans, filesort, temporary tables, largest row estimate), or FORMAT=TREE text. Doesn't run the query. |
Plus one resource, mysql://capabilities: version, release line, EXPLAIN JSON format version, and whether sys is visible.
Results are structured, not prose. DECIMAL comes back as a string so it stays exact, dates and times as ISO 8601, JSON parsed, binary as . Long cells are cut at max_cell_bytes with a marker saying how big they were.
When the server says no, the agent gets a result with refused: true, a reason and a suggestion, not an error, so it can rephrase. That includes SQL the classifier can't parse. Mistakes MySQL reports (unknown table or column, wrong parameter count) and infrastructure failures are tool errors.
Every session, on every pool checkout:
SET SESSION TRANSACTION READ ONLYmax_execution_time = statement_timeout_ms, lock_wait_timeout = 5 sprogram_name=sakila-mcp and sakila_mcp_version, and every statement is tagged /* sakila-mcp tool=... */, so you can find it in the processlist and performance_schemaEvery statement from run_query and explain_query goes through a SQL classifier (sqlglot plus token-level checks) before it reaches MySQL. It fails closed: if it can't parse it, it refuses it.
/*! ... */ version comments, INTO (OUTFILE, DUMPFILE, variables), locking reads (FOR UPDATE, FOR SHARE), := assignment, the SET_VAR hint, EXPLAIN ANALYZE (it executes), functions that block, lock, wait or read files (SLEEP, BENCHMARK, GET_LOCK, LOAD_FILE, ...), and any function that isn't a known built-in (stored functions can write).PREPARE / EXECUTE ... USING), never spliced into the SQL.max_rows; the query is cut off, not rewritten with a LIMIT.The database allowlist is a filter on names, not an isolation boundary. information_schema, performance_schema and sys are always readable, and SHOW PROCESSLIST, SHOW ENGINE INNODB STATUS and performance_schema statement history show other sessions' SQL, literal values included. The mysql schema is denied unless you list it.
The real boundary is the account's grants. Give sakila-mcp its own account with only what it needs:
CREATE USER 'sakila_mcp'@'%' IDENTIFIED BY '...';
GRANT SELECT, SHOW VIEW ON app_db.* TO 'sakila_mcp'@'%'; -- Optional: SHOW PROCESSLIST / SHOW REPLICA STATUS. PROCESS exposes other sessions' SQL. GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'sakila_mcp'@'%';
The password never appears in tool results, logs or error text. There's a test for that.
Nothing to install: uvx sakila-mcp downloads and runs the latest release. Pin a version with uvx sakila-mcp@0.1.2, or install it with uv tool install sakila-mcp.
uvx sakila-mcp --help
To run from a checkout instead, see Development.
Environment variables (SAKILA_MCP_*), a TOML file passed with --config, or both. Environment variables win over the file. Keep the password in the file, chmod 600 it, and keep it out of version control.
# ~/.config/sakila-mcp.toml
host = "db.example.internal" port = 3306 user = "sakila_mcp" password = "..." database_allowlist = ["app_db"] # empty = every non-system database
| Key | Env var | Default | |
|---|---|---|---|
host | SAKILA_MCP_HOST | 127.0.0.1 | |
port | SAKILA_MCP_PORT | 3306 | |
user | SAKILA_MCP_USER | (required) | |
password | SAKILA_MCP_PASSWORD | empty | |
database_allowlist | SAKILA_MCP_DATABASE_ALLOWLIST | empty (all) | comma-separated in the env var |
max_rows | SAKILA_MCP_MAX_ROWS | 200 | rows returned per query |
max_cell_bytes | SAKILA_MCP_MAX_CELL_BYTES | 4096 | longer cells are truncated |
statement_timeout_ms | SAKILA_MCP_STATEMENT_TIMEOUT_MS | 10000 | session max_execution_time |
pool_size | SAKILA_MCP_POOL_SIZE | 4 | |
read_only | SAKILA_MCP_READ_ONLY | true | false refuses to start; there is no write mode |
The server connects to MySQL on the first tool call, not at startup. It starts and lists its tools even when MySQL is down; a wrong host or password shows up as a tool error on the first call (and in stderr), and the next call tries again.
Claude Code:
claude mcp add sakila -- uvx sakila-mcp --config ~/.config/sakila-mcp.toml
Claude Desktop (claude_desktop_config.json):
{
"mcpServers": { "sakila": { "command": "uvx", "args": ["sakila-mcp", "--config", "/home/you/.config/sakila-mcp.toml"] } } }
Ollama, with local models. Ollama runs the model but isn't an MCP client itself, so use ollmcp (mcp-client-for-ollama), a terminal client that connects Ollama models to MCP servers:
uv tool install ollmcp
It reads the same mcpServers format as Claude Desktop. Save this as, say, ~/.config/sakila-mcp.ollmcp.json:
{
"mcpServers": { "sakila": { "command": "uvx", "args": ["sakila-mcp", "--config", "/home/you/.config/sakila-mcp.toml"] } } }
and start it with a model that supports tool calling. ollama show lists tools under Capabilities, and https://ollama.com/search?c=tools lists the models that have it:
ollmcp -j ~/.config/sakila-mcp.ollmcp.json -m <model>
/tools inside ollmcp turns individual tools on and off. Model choice matters more here than with a hosted model: a model that is too small may call the wrong tool, invent arguments, or stop after one call. If that happens, try a larger one. That's a model problem, not a safety one. The server enforces the same rules whatever is calling it.
Then ask it things like "what's in app_db and how do orders relate to customers?" or "why is this query slow?".
Write mode, more than one server per process, HTTP transport, replication / InnoDB / lock diagnostics, Enterprise Edition features, EXPLAIN ANALYZE, stored functions.
git clone https://github.com/pantoniades/sakila-mcp.git
cd sakila-mcp uv sync uv run ruff check . && uv run ruff format --check . && uv run mypy && uv run pytest
Integration tests need a MySQL server prepared once with tests/integration/setup.sh. Give it the address the server sees the tests connect from and a letters-and-digits password (extra arguments go to the mysql client), then point the tests at the server:
SAKILA_MCP_TEST_CLIENT_HOST=127.0.0.1 SAKILA_MCP_TEST_PASSWORD=<password> \
tests/integration/setup.sh -u root -p echo 'SAKILA_MCP_TEST_DSN=mysql://sakila_mcp_test: @ :3306/sakila_mcp_test' > .env.test
.env.test is gitignored. Without it the integration tests skip.
One test is opt-in: it drives Claude Code (claude -p) through every tool against the test server and checks that the client accepts each result. It needs the claude CLI, uses your account, and never runs in CI:
uv run pytest -m llm