Supabase
MCP server for interacting with the Supabase platform
作者提供的说明(英文原文)
Work with a remote host over FTP/FTPS/SFTP, SSH, and MySQL.
这三项永远不会合并成一个分数:意见、测量和人气是不同的东西。
我们还没有为它写通俗的介绍。下面是我们从注册中心读取到的事实。
选择你使用的 AI 应用,然后复制设置。
你需要
你用的是哪个应用?
在上方选择你的应用。我们会记住它,下次按钮会显示“安装到 …”。
打开 Claude Desktop → Settings → Developer → Edit Config,把下面的内容粘贴到 claude_desktop_config.json
{
"mcpServers": {
"ftp-ssh": {
"command": "npx",
"args": [
"-y",
"ftp-ssh-mcp"
]
}
}
}在终端中运行这条命令
claude mcp add ftp-ssh -- npx -y ftp-ssh-mcp粘贴到项目中的 .cursor/mcp.json,或 ~/.cursor/mcp.json
{
"mcpServers": {
"ftp-ssh": {
"command": "npx",
"args": [
"-y",
"ftp-ssh-mcp"
]
}
}
}浏览器会先询问是否打开应用,然后应用会显示设置并请你确认。密钥的值会留空,由你自己填写。
粘贴到项目中的 .vscode/mcp.json
{
"servers": {
"ftp-ssh": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"ftp-ssh-mcp"
]
}
}
}浏览器会先询问是否打开应用,然后应用会显示设置并请你确认。密钥的值会留空,由你自己填写。
这个服务器在你的电脑上运行,而 ChatGPT 只能连接互联网上的服务器。请选择其他应用。
你的选择通过 Cookie 保存在这台设备上,无需账户。
这些设置是根据作者在注册中心的条目生成的。如果 README 的写法不同,请以 README 为准。
它在你的电脑上运行;安装后,工具列表会显示在你的 AI 应用中。
我们检查的是任何人都能看到的信息;我们没有阅读代码。不适用的检查项不计入总数。 · 检查于 2026年11月7日
注册名称已通过 GitHub 账户 Chris221 验证,该账户拥有此仓库
我们还没有从 GitHub 读取这个仓库
我们还没有从 GitHub 读取这个仓库
它在你的电脑上运行,没有互联网端点
在你的电脑上运行,改用本地设置
它在你的电脑上运行;我们只能读取互联网端点的工具列表
与注册中心里这个分类中所有活跃的服务器比较。只有当发布者拥有该仓库时,星标数才计入。
它在 1 项适用的基础检查中通过了 1 项。我们没有阅读代码。在添加密钥或令牌之前,请先看看这个服务器要求哪些权限,并使用只具备所需权限的密钥。
注册中心没有列出必需的密钥,不过有些服务器会在首次使用时要求你登录。
它在你的电脑上运行。你的 AI 应用会在需要时启动它,数据不会经过作者的服务器(除非它自己调用在线服务)。
GitHub 仓库最后更新于–,最新版本(1.0.3)于44天前进入注册中心。
支持 MCP 的应用,例如 Claude Desktop、Claude Code、Cursor 和 VS Code。你的电脑上还需要有 Node.js。
同一分类中有:Supabase, MongoDB MCP Server, Elasticsearch MCP Server
同一分类中其他作者的服务器,按星标数排序。
如何看卡片:★ GitHub 星标i三大支柱:评价 · 检查 · 使用情况i更新 = 最新版本发布到注册中心的时间i
MCP server for interacting with the Supabase platform
MongoDB Model Context Protocol Server
MCP server for interacting with Elasticsearch
按原文从作者的仓库复制。PopNx MCP 没有审查或背书其内容。HTML、图片和脚本已被移除。链接会离开本站。
An MCP server for working with a single remote host over FTP, FTPS, SFTP, and SSH — the kind of host a typical shared-hosting plan or a plain VPS gives you, not a cloud provider's API. It groups its tools into three capability classes: file transfer (list, upload, download, mkdir, delete), shell execution over SSH, and a MySQL query wrapper that also runs over SSH. File transfer is the only capability enabled by default — shell execution and database access are both opt-in and stay off until you explicitly turn them on. Treat those two as equally dangerous: mysql_query runs arbitrary SQL on a production database and can escape to a shell, so it is not the milder of the pair.
Published to npm and run with npx — there is nothing to clone or build. Requires Node 20 or newer. Works on Windows, macOS and Linux.
On Windows, use the `cmd /c` form shown for each client below. Most clients spawn
commanddirectly rather than through a shell, andnpxon Windows is a.cmdshim that cannot be executed that way — the server simply fails to start, usually with no useful error. Treat this as the rule on Windows, not an edge case.
Claude Code — .mcp.json in the project root
{
"mcpServers": { "remote": { "command": "npx", "args": ["-y", "ftp-ssh-mcp@1"] } } }
Windows:
{
"mcpServers": { "remote": { "command": "cmd", "args": ["/c", "npx", "-y", "ftp-ssh-mcp@1"] } } }
Claude Desktop — claude_desktop_config.json
| OS | Path |
|---|---|
| Windows | %APPDATA%\Claude\claude_desktop_config.json |
| macOS | ~/Library/Application Support/Claude/claude_desktop_config.json |
| Linux | ~/.config/Claude/claude_desktop_config.json |
Same mcpServers shape as Claude Code. Claude Desktop has no project directory, so set MCP_ENV_FILE to an absolute path — see step 2.
Cursor — .cursor/mcp.json (project) or ~/.cursor/mcp.json (global)
Same mcpServers shape as Claude Code.
VS Code — .vscode/mcp.json (workspace), or MCP: Open User Configuration for global
VS Code uses servers, not mcpServers:
{
"servers": { "remote": { "command": "npx", "args": ["-y", "ftp-ssh-mcp@1"] } } }
Codex CLI — ~/.codex/config.toml , or .codex/config.toml in a trusted project
Codex uses TOML with a snake_case mcp_servers table:
[mcp_servers.remote]
command = "npx" args = ["-y", "ftp-ssh-mcp@1"]
Windows:
[mcp_servers.remote]
command = "cmd" args = ["/c", "npx", "-y", "ftp-ssh-mcp@1"]
Or add it from the shell: codex mcp add remote -- npx -y ftp-ssh-mcp@1
Create a .env file in your project root. The server reads it from the working directory, which is the project root for project-scoped clients:
REMOTE_HOST=ftp.example.com
REMOTE_USER=deploy REMOTE_PASSWORD=your-password REMOTE_BASE_DIR=/home/deploy/public_html
That is enough for the six file tools over FTPS. Keep this file out of version control — add .env and .env.* to .gitignore. Getting credentials out of a tracked config file is the reason the server reads .env at all.
If your client has no project directory (Claude Desktop), or you want several servers against different accounts, point each at its own file instead:
{
"mcpServers": { "prod": { "command": "npx", "args": ["-y", "ftp-ssh-mcp@1"], "env": { "MCP_ENV_FILE": "/absolute/path/to/.env.prod" } } } }
A fuller setup, adding shell execution and database access — both off unless you opt in:
REMOTE_HOST=example.com
REMOTE_USER=deploy REMOTE_PASSWORD=your-password REMOTE_BASE_DIR=/home/deploy/public_html
SSH_HOST_FINGERPRINT=SHA256:your-fingerprint-here SSH_PORT=22 SSH_BASE_DIR=/home/deploy SSH_ALLOW_EXEC=true SSH_ALLOWED_CMDS=@basic,@node
DB_USER=deploy_dbuser DB_PASSWORD=your-db-password DB_NAME=deploy_db
REMOTE_ALLOW_DELETE=true
See .env.example for every variable and Configuration below for what each does.
npx -y ftp-ssh-mcp@1 --selftest
Run it from the directory holding your .env. It resolves configuration, registers tools and prints a one-line summary — without opening a connection — then exits. Use it to confirm the right capabilities came up before wiring the server into a client:
ftp-ssh-mcp 1.0.1 selftest OK. env=.env, transport=ftp, host=example.com,
capabilities=[files, ssh, mysql], tools=[file_list, file_upload, ...]
It exits non-zero with a message naming the missing variable if configuration is incomplete. See Troubleshooting.
| Option | Does |
|---|---|
--selftest | Resolve the configuration, print the tools it would register, and exit. Opens no connection. |
-q, --quiet | Drop the informational startup warnings. |
-v, --version | Print the version and exit. |
-h, --help | Print usage and exit. |
--version and --help answer before any configuration is read, so they work on a machine with nothing set up yet. Both print to stdout; everything else the server says goes to stderr, because stdout is the JSON-RPC channel.
--quiet silences the warnings about a missing DB_PASSWORD, an MCP_CAPABILITIES entry that registered no tools, and a relative base directory. It deliberately does not silence the two that say your security posture is weaker than you might assume — an unverified host key, or path confinement switched off. A flag set once in a client's config file is never looked at again, so those stay visible until you fix them, which is the only silence worth having.
A capability's tools are only registered when it is both configured (its required variables are set) and, if MCP_CAPABILITIES restricts the set, named in that list.
| Capability | Tools | Enabled when |
|---|---|---|
files | file_list, file_upload, file_upload_dir, file_download, file_mkdir, file_delete | An FTP or SSH profile is configured. file_delete additionally requires REMOTE_ALLOW_DELETE=true; all writes require REMOTE_READONLY to be unset or false. |
ssh | ssh_exec | An SSH profile is configured with SSH_BASE_DIR set and SSH_ALLOW_EXEC=true. |
mysql | mysql_query | An SSH profile is configured, and DB_USER and DB_NAME are both set. DB_USER must be set explicitly — it does not inherit REMOTE_USER — so the capability cannot switch itself on. Blocked entirely by REMOTE_READONLY=true. DB_PASSWORD is not required — see below. |
The files tools are transport-neutral: they work over whichever transport FILE_TRANSPORT selects (ftp or sftp), and each call can override the transport for that one call if both profiles are configured. mysql_query is a convenience wrapper, not a database driver — it pipes SQL over SSH to the mysql client already installed on the host (mysql --user=... --database=... --table, with the SQL sent on stdin), then parses the CLI's table output. There is no connection pooling and no parameterised-query support. It exists because most shared hosts will not accept a database connection from outside the host itself; if you need a real client-side database integration, use one instead of mysql_query. Enable it with the same caution as `ssh_exec`, not less — see Security.
Every setting is resolved from environment variables in this order: a profile-specific variable (FTP_* or SSH_*) first, then the shared REMOTE_* fallback, then a built-in default. Two independent profiles exist — FTP and SSH — and you may configure either, both, or neither in isolation (though at least one is required to start).
Variables are normally read from process environment, but the server also loads a .env file from the current working directory before resolving configuration, so credentials can live outside the MCP client's own (often tracked) config file. A real environment variable already set takes precedence over the .env file. Point at a different file with MCP_ENV_FILE — a leading ~ is expanded to your home directory, a relative value is resolved against the working directory, and a set-but-unreadable one fails startup rather than silently falling back to .env and loading different credentials than the ones you named. The `.env` parser does not support inline comments — KEY=value # note treats everything after = as the value, including # note, so keep comments on their own line.
Non-secret settings (HOST, USER, BASE_DIR) fall back to REMOTE_* freely. Secrets (PASSWORD, PRIVATE_KEY, PASSPHRASE) fall back to REMOTE_PASSWORD **only when the profile does not set its own *_USER**. A profile that names its own user is declaring a distinct identity, and sending that identity a password meant for a different account causes repeated authentication failures — on many shared hosts, enough failures trip brute-force protection and lock the account out at the host level. If FTP_USER (or SSH_USER) is set, its password must be set explicitly too.
| Variable | Default | Notes |
|---|---|---|
REMOTE_HOST | — | Shared host, used when a profile does not set its own. |
REMOTE_USER | — | Shared user. |
REMOTE_PASSWORD | — | Shared secret. Only inherited by a profile with no *_USER of its own. |
REMOTE_BASE_DIR | — | Shared base directory that remote paths are confined to. A leading ~ is expanded to the account's login directory — see below. |
FTP_HOST | inherits REMOTE_HOST | |
FTP_PORT | 21 | |
FTP_USER | inherits REMOTE_USER | |
FTP_PASSWORD | see secret inheritance | |
FTP_BASE_DIR | inherits REMOTE_BASE_DIR, then SSH_BASE_DIR | Base directory the files tools are confined to on this transport. Accepts ~ or ~/ . |
FTP_SECURITY | ftps | ftps (explicit TLS), ftp (plaintext), or ftps-implicit. |
FTP_TLS_REJECT_UNAUTHORIZED | true | Set false to accept a self-signed or otherwise unverifiable certificate. |
FTP_TIMEOUT_MS | 30000 | |
SSH_HOST | inherits REMOTE_HOST | |
SSH_PORT | 22 | |
SSH_USER | inherits REMOTE_USER | |
SSH_PASSWORD | see secret inheritance | Password auth. Can be combined with a key; the server will try both. |
SSH_PRIVATE_KEY | see secret inheritance | Local path to a private key. A leading ~ is expanded. |
SSH_PASSPHRASE | see secret inheritance | Passphrase for SSH_PRIVATE_KEY. |
SSH_HOST_FINGERPRINT | inherits REMOTE_HOST_FINGERPRINT | SHA-256 host key fingerprint to pin. Accepts the SHA256: form or a bare hex digest. Not a secret, so it inherits freely. Unset means any host key is accepted, and the server warns at startup. See Security below. |
| `SSH_BASE_DIR
只显示了开头部分;其余内容请在仓库中阅读