Quickbase MCP by usefulapi

io.usefulapi由 usefulapi.io 發布官方發布者v1.2.3更新於 Nov 5, 2026

Query records, run reports and formulas, and insert or update records in Quickbase.

發布方自己的服務:Ably MCP by usefulapi

已驗證Streamable HTTP可網頁執行資料庫資料與分析

概覽

AI 產生的概覽

託管的 Quickbase MCP 伺服器,讓助理檢視應用程式與資料表、查詢記錄、執行報表和公式,並新增或更新記錄。

可以做什麼
  • 檢視應用程式:取得應用程式屬性與變數,列出角色、資料表、資料表關聯、欄位及欄位詳細資料
  • 瀏覽報表:列出某個資料表的報表、讀取報表定義,並分頁執行已儲存的報表
  • 依 where 條件、排序、分組和指定欄位查詢記錄,並在資料表上計算公式且不儲存任何內容
  • 依電子郵件查詢帳戶使用者或列出使用者
  • 在資料表中新增或更新記錄,可依唯一欄位合併
  • 查看當月用量、提出缺少的功能需求,以及管理或取消付費方案
適用情境
適合在 Quickbase 中工作時使用:讓助理了解應用程式結構、取得並彙整記錄或已儲存的報表、測試公式,或直接在對話中寫入與更新記錄。
執行需求
遠端 MCP 端點,只需加入 URL,不需本機安裝。透過 OAuth 登入,首次連線時需提供 Quickbase realm 和 Quickbase 使用者權杖,伺服器會依使用者儲存。部分工具(例如列出應用程式角色)需要應用程式的管理員權限。
安裝前請注意
upsert 工具會寫入實際資料並變更記錄,執行前請先確認。Quickbase realm 與使用者權杖由第三方託管業者保存。用量有限制:免費方案每月 50 次工具呼叫,付費方案透過助理回傳的結帳連結付款。取消 Pro 後於付費期間結束時生效,當期不退費。

安裝

在 SourceWeft 中

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

Web executable,透過 Streamable HTTP。 遠端服務在工作區中設定後即可從網頁執行環境執行。

交給代理程式安裝

把這段提示詞貼上到 Claude Code、Codex、Cursor 等代理程式,或 SourceWeft 對話中。代理程式會讀取該伺服器的安裝指南,先向你展示發布者、端點和登入方式,經你同意後再把它新增到你的客戶端。金鑰不會寫進任何命令。

閱讀 https://sourceweft.com/mcp/io.usefulapi%2Fquickbase/install.md,並按其中說明把這個 MCP 伺服器接入我的客戶端。修改任何設定之前,先告訴我它的發布者、端點和登入方式,等我確認。不要把 API 金鑰寫進命令或我會提交的檔案;問我金鑰應從哪裡取得。

檢視代理程式所依據的安裝指南

其他 MCP 客戶端

把它新增到你客戶端的 mcpServers 設定中。

{
  "mcpServers": {
    "quickbase-by-usefulapi": {
      "type": "http",
      "url": "https://quickbase.usefulapi.io/mcp"
    }
  }
}

README

Quickbase MCP by usefulapi

Use your Quickbase account from Claude, Cursor, or any MCP client. Query records, run reports and formulas, and insert or update records. Hosted, no local install: connect with your own credentials.

Live endpoint: https://quickbase.usefulapi.io/mcp · Homepage: https://usefulapi.io

Connect

  • Claude (claude.ai, Desktop): open Customize → Connectors, click + Add → Add custom connector, and paste https://quickbase.usefulapi.io/mcp.
  • Claude Code: claude mcp add --transport http quickbase https://quickbase.usefulapi.io/mcp, then run /mcp to log in.
  • VS Code: Add to VS Code.
  • Cursor and other clients: add the URL as a remote MCP server:
json
{  "mcpServers": {    "quickbase": {      "url": "https://quickbase.usefulapi.io/mcp"    }  }}

Add only the URL. Do not add an Authorization header or an API key to the client config: the server signs you in with OAuth, and the login page asks for your Quickbase credentials.

Step-by-step setup, where to find your credentials, and FAQ: https://usefulapi.io/quickbase/

On first connect you provide your Quickbase realm (the part before .quickbase.com) and a Quickbase user token, which you create in your Quickbase user settings. The server validates them and stores them per user. No keys go in config files.

Tools

ToolTypeWhat it does
quickbase_get_appreadGet an app
quickbase_get_app_rolesreadGet app roles
quickbase_list_tablesreadList tables
quickbase_get_tablereadGet a table
quickbase_list_table_relationshipsreadList table relationships
quickbase_list_fieldsreadList fields
quickbase_get_fieldreadGet a field
quickbase_list_reportsreadList reports
quickbase_get_reportreadGet a report
quickbase_run_reportreadRun a report
quickbase_query_recordsreadQuery records
quickbase_run_formulareadRun a formula
quickbase_get_usersreadGet users
quickbase_upsert_recordswriteInsert or update records
quickbase_usage_statusmetaUsage status (free-tier meter)
quickbase_request_featuremetaRequest a missing feature
quickbase_upgrademetaUpgrade to Pro or Pro+
quickbase_cancel_subscriptionmetaCancel the Pro subscription

read tools are read-only; write tools mutate data (clients should confirm them); meta tools report usage, manage your subscription or send a feature request.

Pricing

PlanPriceLimit
Free$050 tool calls / month
Pro (per user)$9/mo or $90/yr (2 months free)Unlimited*

*Pro has a fair use limit of 10,000 tool calls a month on this server. For more, write to [email protected].

Pro covers this server only. Subscribe with quickbase_upgrade (it returns a Stripe Checkout link). Cancel any time with quickbase_cancel_subscription: Pro continues to the end of the paid period, with no refund for the current period, and running quickbase_upgrade before then undoes the cancel. Or write to [email protected].

License

MIT — see LICENSE. Documentation only; the server is hosted.

來源:servers/quickbase/README.md,提交 4046075

工具

14

quickbase_get_app

Get an app

Get the main properties of a Quickbase app, including its application variables. Quickbase API: GET /apps/{appId}.

輸入參數app_id必填

quickbase_get_app_roles

Get app roles

List the roles of a Quickbase app. Needs admin access to the app. Quickbase API: GET /apps/{appId}/roles.

輸入參數app_id必填

quickbase_list_tables

List tables

List all tables in a Quickbase app, with their ids, names and record names. Good first call to find table ids. Quickbase API: GET /tables?appId=.

輸入參數app_id必填

quickbase_get_table

Get a table

Get the properties of one table in a Quickbase app. Quickbase API: GET /tables/{tableId}?appId=.

輸入參數app_id必填table_id必填

quickbase_list_table_relationships

List table relationships

List the parent-child relationships of a table, with their definitions. Quickbase API: GET /tables/{tableId}/relationships.

輸入參數skiptable_id必填

quickbase_list_fields

List fields

List all fields of a table with their ids, labels, types and properties. Use the field ids in record queries. Quickbase API: GET /fields?tableId=.

輸入參數table_id必填include_field_permissions

quickbase_get_field

Get a field

Get one field of a table by its field id, including type-specific properties. Quickbase API: GET /fields/{fieldId}?tableId=.

輸入參數field_id必填table_id必填include_field_permissions

quickbase_list_reports

List reports

List the reports of a table (their ids, names and types). Quickbase API: GET /reports?tableId=.

輸入參數table_id必填

quickbase_get_report

Get a report

Get the definition of one report of a table. Quickbase API: GET /reports/{reportId}?tableId=.

輸入參數table_id必填report_id必填

quickbase_run_report

Run a report

Run a saved report and return its data (records for table reports, rows for summary reports). Quickbase pages the result: pass skip and top to read more. Quickbase API: POST /reports/{reportId}/run?tableId=.

輸入參數topskiptable_id必填report_id必填

quickbase_query_records

Query records

Query records of a table with a Quickbase query (where clause, sort, group, select fields). Quickbase pages the result: pass skip and top to read more. Quickbase API: POST /records/query. Example where: {6.EX.'Open'}.

輸入參數topskipwhereselectsort_bytable_id必填

quickbase_run_formula

Run a formula

Evaluate a Quickbase formula against a table (optionally for one record) and return the value. Nothing is saved. Quickbase API: POST /formula/run.

輸入參數formula必填table_id必填record_id

quickbase_get_users

Get users

Look up users of the account by email, or list the users of the account. Returns a nextPageToken when more pages exist. Quickbase API: POST /users.

輸入參數emailsapp_idsaccount_idnext_page_token

quickbase_upsert_records

Insert or update records

Insert new records into a table, or update existing ones when mergeFieldId names a unique field (for example the key field). Writes live data: it changes records. Each data item maps field ids to values, e.g. [{"6": {"value": "Open"}}]. Quickbase API: POST /records.

輸入參數data必填table_id必填merge_field_idfields_to_return

版本歷史

5
  1. v1.2.3最新Nov 5, 2026
  2. v1.2.2Nov 5, 2026
  3. v1.2.1Nov 4, 2026
  4. v1.2.0Nov 3, 2026
  5. v1.1.1Nov 3, 2026

評分

已滿足適用檢查項的 100%

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

  • 近 30 天內可連通必需25 分
  • 已宣告認證方式必需10 分
  • 已列出工具必需15 分
  • 描述必需15 分
  • 圖示10 分
  • 文件15 分
  • 授權條款10 分

其他 Usefulapi 整合