Appbase

io.github.CloudCorpRecords由 GitHub 帳號 CloudCorpRecords 發布v0.1.0更新於 Nov 1, 2026

Supabase projects, tables, SQL, migrations, and storage from your MCP client.

已驗證STDIO僅桌面資料庫雲端與基礎設施開發者工具

概覽

AI 產生的概覽

在 MCP 用戶端中管理 Supabase 專案：檢視資料表結構與遷移、執行 SQL、查看日誌、部署 Edge Functions、管理儲存桶與預覽分支。

可以做什麼
  • 列出、檢視、建立、暫停與還原專案及組織
  • 檢視資料庫結構：資料表、擴充功能與已套用的遷移
  • 執行原始 SQL 或套用可追蹤的遷移，並依結構產生 TypeScript 型別
  • 讀取各服務日誌與安全性或效能建議，取得專案 URL 與可發布金鑰
  • 列出並部署 Edge Functions，列出或建立儲存桶
  • 建立、合併、重設、變基與刪除預覽分支
適用情境
適合讓助理直接操作 Supabase：探索資料庫結構、執行查詢或 DDL 遷移、查看日誌與建議、部署 Edge Functions，或在對話中管理預覽分支與專案。
執行需求
透過 npx 或 Docker 映像以 stdio 在本機執行。需要將 Supabase 個人存取權杖放入 SUPABASE_ACCESS_TOKEN 環境變數，並能連線至 Supabase 管理 API。專案層級工具另需提供專案參照。
安裝前請注意
此權杖具帳戶層級權限，可存取 Supabase 專案與組織。工具可執行任意 SQL、套用遷移、部署 Edge Functions、建立或刪除分支，以及建立、暫停或還原專案；建立分支與專案需提供費用確認識別碼，可能產生費用。輸出中會回傳可發布金鑰與 anon 金鑰。

安裝

在 SourceWeft 中

  1. 開啟 儀表板中的 Appbase，將其新增到工作區。
  2. 為需要使用其工具的對話啟用該服務。

Desktop only，透過 STDIO。 STDIO 服務會啟動本機處理程序，因此需要 SourceWeft 桌面主機。

其他 MCP 客戶端

參照 儲存庫 中的啟動說明。

README

appbase

appbase puts a Supabase account within reach of an MCP client or a terminal. Projects and organizations can be listed, inspected, created, paused, and restored. Inside a project you can look at the schema (tables, extensions, migrations), run SQL or apply a tracked migration, read logs and security/performance advisors, fetch the project URL and publishable keys, generate TypeScript types from the live schema, list and deploy Edge Functions, manage storage buckets, and work with preview branches — create, merge, reset, rebase, and delete them.

A Supabase personal access token is required. Put it in the SUPABASE_ACCESS_TOKEN environment variable; it is sent to the Supabase Management API as a Bearer token and never appears in output. When the variable is missing, every call fails with an error that names it.

Install

bash
npx @reneturcios/appbase list_projects

Or run the container image:

bash
docker run -i -e SUPABASE_ACCESS_TOKEN ghcr.io/cloudcorprecords/appbase

The container defaults to the MCP server (see below). Pass CLI arguments to use it as a CLI instead.

CLI

Every MCP tool is also a CLI subcommand. Tool arguments are passed as one JSON object with --json; project-scoped tools take the project reference as project_id:

bash
export SUPABASE_ACCESS_TOKEN=<your Supabase personal access token>
appbase list_projectsappbase list_tables --json '{"project_id": "abcdefghijklmnopqrst"}'appbase execute_sql --json '{"project_id": "abcdefghijklmnopqrst", "query": "select 1"}'appbase get_advisors --json '{"project_id": "abcdefghijklmnopqrst", "type": "security"}'appbase create_branch --json '{"project_id": "abcdefghijklmnopqrst", "name": "feat-x"}'
appbase --version

Results print as JSON. Exit codes: 0 on success, 1 when an API call fails (including a missing SUPABASE_ACCESS_TOKEN), 2 for usage errors.

MCP server

One bin serves both faces. The mcp subcommand starts a stdio MCP server:

bash
npx -y @reneturcios/appbase mcp

MCP client configuration:

json
{  "mcpServers": {    "appbase": {      "command": "npx",      "args": ["-y", "@reneturcios/appbase", "mcp"],      "env": { "SUPABASE_ACCESS_TOKEN": "your Supabase personal access token" }    }  }}

Tools

ToolInput (required in bold)What it does
list_tablesproject_id, schemasLists tables in the given schemas (default public).
list_extensionsproject_idLists installed database extensions.
list_migrationsproject_idLists applied migrations.
execute_sqlproject_id, queryRuns raw SQL in the project's database.
apply_migrationproject_id, name, queryApplies SQL as a tracked migration (for DDL).
get_logsproject_id, serviceRecent logs for one service.
get_advisorsproject_id, typeSecurity or performance advisors.
get_project_urlproject_idThe project's https://<ref>.supabase.co API URL.
get_publishable_keysproject_idPublishable / anon API keys for the project.
generate_typescript_typesproject_id, included_schemasTypeScript types generated from the schema.
list_edge_functionsproject_idLists Edge Functions.
get_edge_functionproject_id, function_slugOne Edge Function's details.
deploy_edge_functionproject_id, name, files, entrypoint_path, import_map_pathDeploys an Edge Function from inline files.
list_storage_bucketsproject_idLists storage buckets.
create_storage_bucketproject_id, name, public, file_size_limit, allowed_mime_typesCreates a storage bucket.
list_branchesproject_idLists preview branches.
create_branchproject_id, name, confirm_cost_idCreates a preview branch.
delete_branchproject_id, branch_idDeletes a preview branch.
merge_branchproject_id, branch_idMerges a branch's migrations and functions into production.
reset_branchproject_id, branch_id, migration_versionResets a branch to its parent state.
rebase_branchproject_id, branch_idRebases a branch onto its parent.
list_projects—Lists all projects for the user.
get_projectidOne project's details.
create_projectname, organization_id, region, confirm_cost_idCreates a project.
pause_projectproject_idPauses a project.
restore_projectproject_idRestores a paused project.
list_organizations—Lists the user's organizations.
get_organizationidOne organization's details.

All calls go to https://api.supabase.com/v1. SQL tools POST to the project's database/query endpoint; list_tables and list_extensions are catalog queries through that same endpoint, and all other SQL passes through exactly as given.

Development

bash
npm installnpm run build   # tsc -> dist/npm test        # node test runner over test/*.test.ts, no network (fake fetch fixtures)npm run dev     # run the CLI from source via tsx

License

MIT — see LICENSE.

來源：README.md，提交 8cc7b4a

工具

28

list_tables

Lists all tables within the specified schemas.

輸入參數schemasproject_id必填

list_extensions

Lists all extensions in the database.

輸入參數project_id必填

list_migrations

Lists all migrations in the database.

輸入參數project_id必填

execute_sql

Executes raw SQL in the database.

輸入參數query必填project_id必填

apply_migration

Applies a SQL migration to the database. SQL passed to this tool will be tracked within the database, so use this for DDL operations (schema changes).

輸入參數name必填query必填project_id必填

get_logs

Gets logs for a Supabase project by service (api, postgres, edge-function, auth, storage, realtime, or branch-action).

輸入參數service必填project_id必填

get_advisors

Gets advisory notices for a Supabase project, by type: security or performance.

輸入參數type必填project_id必填

get_project_url

Gets the API URL for a Supabase project.

輸入參數project_id必填

get_publishable_keys

Gets the publishable and anon API keys for a Supabase project.

輸入參數project_id必填

generate_typescript_types

Generates TypeScript types based on the database schema.

輸入參數project_id必填included_schemas

list_edge_functions

Lists all Edge Functions in a Supabase project.

輸入參數project_id必填

get_edge_function

Gets details for an Edge Function by slug.

輸入參數project_id必填function_slug必填

deploy_edge_function

Deploys an Edge Function to a Supabase project from inline files.

輸入參數name必填files必填project_id必填entrypoint_pathimport_map_path

list_storage_buckets

Lists all storage buckets in a Supabase project.

輸入參數project_id必填

create_storage_bucket

Creates a new storage bucket in a Supabase project.

輸入參數name必填publicproject_id必填file_size_limitallowed_mime_types

list_branches

Lists all development branches for a Supabase project.

輸入參數project_id必填

create_branch

Creates a new development branch for a Supabase project.

輸入參數name必填project_id必填confirm_cost_id

delete_branch

Deletes a development branch from a Supabase project.

輸入參數branch_id必填project_id必填

merge_branch

Merges migrations and edge functions from a development branch into production.

輸入參數branch_id必填project_id必填

reset_branch

Resets a development branch to its parent state, optionally at a migration version.

輸入參數branch_id必填project_id必填migration_version

rebase_branch

Rebases a development branch on its parent, applying newer migrations.

輸入參數branch_id必填project_id必填

list_projects

Lists all Supabase projects for the user.

無需輸入參數。

get_project

Gets details for a project.

輸入參數id必填

create_project

Creates a new Supabase project.

輸入參數name必填regionconfirm_cost_idorganization_id必填

pause_project

Pauses a project.

輸入參數project_id必填

restore_project

Restores a project.

輸入參數project_id必填

list_organizations

Lists all organizations that the user is a member of.

無需輸入參數。

get_organization

Gets details for an organization.

輸入參數id必填

版本歷史

1
  1. v0.1.0最新Nov 1, 2026

評分

已滿足適用檢查項的 90%

該評分衡量此收錄條目的完整程度，依據註冊中心條目、端點與公開來源計算得出。它不是對伺服器本身的評價，也不表示伺服器安全或目前可用：可連通性是帶日期的檢查結果，評分也不包含安裝量或使用者評價。

  • 近 30 天內可連通25 分
  • 已宣告認證方式10 分

    請在註冊中心條目中宣告憑證請求標頭，或保持端點能夠回應探測，以便判定其認證方式。

  • 已列出工具必需15 分
  • 描述必需15 分
  • 圖示10 分
  • 文件15 分
  • 授權條款10 分