Supabase
Supabase’s official server lets AI create tables, query data and review project settings in your Supabase database.
Description from the maker (original English)
Work with a remote host over FTP/FTPS/SFTP, SSH, and MySQL.
These three are never merged into one score: opinions, measurements and popularity are different things.
We have not written a plain-language summary for this one yet. Below are the facts we read from the registry.
Pick the AI app you use, then copy the settings.
You need
Which app do you use?
Pick your app above. We remember it, so next time the button says “Install in …”.
Open Claude Desktop → Settings → Developer → Edit Config, and paste this into claude_desktop_config.json
{
"mcpServers": {
"ftp-ssh": {
"command": "npx",
"args": [
"-y",
"ftp-ssh-mcp"
]
}
}
}Run this in your terminal
claude mcp add ftp-ssh -- npx -y ftp-ssh-mcpPaste into .cursor/mcp.json in your project, or ~/.cursor/mcp.json
{
"mcpServers": {
"ftp-ssh": {
"command": "npx",
"args": [
"-y",
"ftp-ssh-mcp"
]
}
}
}Your browser asks to open the app, then the app shows the settings and asks you to confirm. Key values are left empty for you to fill in.
Paste into .vscode/mcp.json in your project
{
"servers": {
"ftp-ssh": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"ftp-ssh-mcp"
]
}
}
}Your browser asks to open the app, then the app shows the settings and asks you to confirm. Key values are left empty for you to fill in.
This one runs on your computer, and ChatGPT can only connect to servers on the internet. Pick another app.
Your choice stays on this device in a cookie; no account needed.
These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.
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 7, 2026
The registry name was verified with the GitHub account Chris221, which owns the repo
We have not read this repo from GitHub yet
We have not read this repo from GitHub yet
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
Compared with every active server in this category in the registry. Stars count only when the publisher owns the repo.
It passed 1 of 1 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.
The registry does not list a required key, though some servers ask you to sign in on first use.
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 –, and the latest version (1.0.3) reached the registry 44 days ago.
Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. You also need Node.js on your computer.
In the same category: Supabase, MongoDB MCP Server, Elasticsearch MCP Server
Servers in the same category from other makers, sorted by stars.
Reading a card:★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi
Supabase’s official server lets AI create tables, query data and review project settings in your Supabase database.
MongoDB Model Context Protocol Server
MCP server for interacting with Elasticsearch
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.
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
Only the beginning is shown; read the rest in the repo