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)
PostgreSQL-backed virtual filesystem for agents: session isolation, shared stores, POSIX ops, RLS.
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.
DATABASE_URL, VFS_AUTO_INIT, VFS_SESSION_ID, VFS_ENABLE_RLSValues marked secret are keys to your account. Never share them or paste them into a chat.
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": {
"virtual-fs": {
"command": "npx",
"args": [
"-y",
"mcp-virtual-fs"
],
"env": {
"DATABASE_URL": "your-value",
"VFS_AUTO_INIT": "your-value",
"VFS_SESSION_ID": "your-value",
"VFS_ENABLE_RLS": "your-value"
}
}
}
}Run this in your terminal
claude mcp add virtual-fs --env DATABASE_URL=your-value --env VFS_AUTO_INIT=your-value --env VFS_SESSION_ID=your-value --env VFS_ENABLE_RLS=your-value -- npx -y mcp-virtual-fsFill in the empty values before running it.
Paste into .cursor/mcp.json in your project, or ~/.cursor/mcp.json
{
"mcpServers": {
"virtual-fs": {
"command": "npx",
"args": [
"-y",
"mcp-virtual-fs"
],
"env": {
"DATABASE_URL": "your-value",
"VFS_AUTO_INIT": "your-value",
"VFS_SESSION_ID": "your-value",
"VFS_ENABLE_RLS": "your-value"
}
}
}
}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": {
"virtual-fs": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"mcp-virtual-fs"
],
"env": {
"DATABASE_URL": "your-value",
"VFS_AUTO_INIT": "your-value",
"VFS_SESSION_ID": "your-value",
"VFS_ENABLE_RLS": "your-value"
}
}
}
}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.
VFS_AUTO_INIT envVFS_SESSION_ID envVFS_ENABLE_RLS envThese 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 8, 2026
The registry name was verified with the GitHub account lu-zhengda, 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.
You need to fill in: DATABASE_URL
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 (0.2.2) reached the registry 9 months 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 that provides AI agents with a persistent, PostgreSQL-backed virtual filesystem. Supports session-isolated file operations, cross-session shared stores, glob/grep search, and Row Level Security — all exposed as standard Model Context Protocol tools.
Works with any MCP client: Claude Desktop, Claude Code, Cursor, Windsurf, Cline, and others.
read, write, append, stat, ls, mkdir, rm, mv, glob, grep, stores**/*.ts) or search content by regex, powered by PostgreSQL trigram indexesVFS_AUTO_INIT=trueAgents work well with filesystems for context management, but coupling storage to the agent runtime means data is lost when pods restart or containers are recycled. This MCP server decouples storage from runtime by moving file operations to PostgreSQL — giving agents persistent, isolated, and searchable file storage without touching the host filesystem.
pg_trgm extension — included in most distributions)# Using Docker
docker run -d --name vfs-postgres \ -e POSTGRES_DB=vfs \ -e POSTGRES_PASSWORD=postgres \ -p 5432:5432 \ postgres:16-alpine
Add to your MCP client config (e.g., Claude Desktop claude_desktop_config.json or Claude Code .mcp.json):
{
"mcpServers": { "virtual-fs": { "command": "npx", "args": ["-y", "mcp-virtual-fs"], "env": { "DATABASE_URL": "postgresql://postgres:postgres@localhost:5432/vfs", "VFS_AUTO_INIT": "true" } } } }
That's it. VFS_AUTO_INIT=true creates the tables on first run.
Tool names are short POSIX-style names:
write({ path: "/notes/todo.md", content: "# My Tasks\n- Ship feature" })
read({ path: "/notes/todo.md" }) ls({ path: "/notes" }) glob({ pattern: "**/*.md" }) grep({ pattern: "TODO" })
All tools return structured JSON responses.
| Tool | Parameters | Returns | Description |
|---|---|---|---|
read | path | {content, size} | Read file contents |
write | path, content | {path, size, has_parents} | Write file (creates parents automatically) |
append | path, content | {path, appended_bytes} | Append to file (creates if missing) |
stat | path | {exists, type?, size?, children?} | Check existence and get metadata |
ls | path | {entries: [{name, type}]} | List directory (dirs first, then alphabetical) |
mkdir | path | {path, already_existed} | Create directory and parents (mkdir -p) |
rm | path | {path, deleted} | Remove file or directory recursively |
mv | source, destination | {source, destination} | Move/rename file or directory |
glob | pattern | {files, count} | Find files by glob (e.g., **/*.ts, **/*.{js,ts}) |
grep | pattern, path_filter? | {matches, count} | Search file contents by regex |
stores | *(none)* | {stores, count} | List all persistent store names |
All tools (except stores) accept an optional store parameter for cross-session persistent storage.
Sessions are handled automatically — no session ID in tool parameters.
How it works:
| Transport | Session identity | Behavior |
|---|---|---|
| stdio | Auto-generated UUID per process | Each MCP connection = unique session |
| HTTP/SSE | Transport-provided sessionId | MCP protocol handles it |
| Any | VFS_SESSION_ID env var | Deterministic/resumable sessions |
Priority: transport sessionId > VFS_SESSION_ID env var > auto-generated UUID.
To resume a previous session across process restarts, set a deterministic session ID:
{
"env": { "DATABASE_URL": "postgresql://...", "VFS_SESSION_ID": "my-agent-session-1" } }
Named stores persist across sessions. Any session can read/write to a store by passing the store parameter:
// Session A writes to a store
write({ path: "/context.md", content: "project notes", store: "agent-memory" })
// Session B (days later) reads from the same store read({ path: "/context.md", store: "agent-memory" })
// Without store, operations target the session's own namespace write({ path: "/scratch.txt", content: "session-only data" })
// List all available stores stores()
Stores are auto-created on first use.
| Variable | Required | Default | Description |
|---|---|---|---|
DATABASE_URL | Yes | — | PostgreSQL connection string |
VFS_AUTO_INIT | No | false | Auto-create tables on startup |
VFS_SESSION_ID | No | random UUID | Deterministic session ID |
VFS_ENABLE_RLS | No | false | Enable Row Level Security |
VFS_STORAGE_BACKEND | No | postgres | Storage backend type |
If you prefer to manage the schema yourself instead of using VFS_AUTO_INIT:
psql $DATABASE_URL -f sql/schema.sql
RLS provides database-enforced session isolation. Even if application code has a bug that omits a WHERE session_id = clause, PostgreSQL itself prevents cross-session access.
# Run after schema.sql
psql $DATABASE_URL -f sql/rls.sql
psql $DATABASE_URL -c "ALTER ROLE vfs_app PASSWORD 'your-secure-password'"
Then configure the MCP server to connect as vfs_app:
{
"env": { "DATABASE_URL": "postgresql://vfs_app:your-secure-password@localhost:5432/vfs", "VFS_ENABLE_RLS": "true" } }
git clone https://github.com/lu-zhengda/mcp-virtual-fs.git
cd mcp-virtual-fs npm install npm run build
| Command | Description |
|---|---|
npm run build | Compile TypeScript |
npm test | Run all tests (requires Docker) |
npm run test:unit | Run unit tests only |
npm run test:integration | Run integration tests only |
npm run lint | Run ESLint |
npm run lint:fix | Auto-fix lint issues |
npm run dev | Run with tsx (no build step) |
Tests use testcontainers to spin up real PostgreSQL instances in Docker. No mocks — the integration tests exercise actual SQL queries, trigram indexes, and RLS policies.
# Requires Docker running
npm test
Ephemeral sessions can be cleaned up periodically:
DELETE FROM vfs_sessions
WHERE is_persistent = false AND created_at < now() - interval '7 days';
The ON DELETE CASCADE on vfs_nodes handles file cleanup automatically. Persistent stores (created via the store parameter) are never affected.
MIT