Quickbase

You deploy this TypeScript MCP server to connect Claude Desktop and other AI assistants to Quickbase data. It provides a set of tools to manage Quickbase apps, tables, fields, records, files, relationships, and reporting through a consistent MCP interface, enabling automation and AI-powered workflows without building custom integrations from scratch.

How to use

You interact with the MCP server through an MCP client or Claude Desktop by configuring an MCP server entry. The server exposes a suite of actions that let you query, create, update, and manage Quickbase resources, as well as perform file operations and generate reports. Start the server and then invoke the corresponding tools from your MCP client to perform tasks like querying records, creating or updating records, managing tables and fields, uploading files, and running reports.

How to install

Prerequisites: you need Node.js version 18 or higher. You may also run the server via an MCP client using npx without installing locally.

# Option 1: Run directly with npx (no installation needed)
npx -y mcp-quickbase

# Option 1b: Install globally for reuse
npm install -g mcp-quickbase

Option 2: Install from source and build locally.

# Clone the repository
git clone https://github.com/danielbushman/MCP-Quickbase.git
cd MCP-Quickbase

# Install dependencies
npm install

# Build the project
npm run build

Configure Claude Desktop to use the MCP server. Use one of the following configurations depending on how you run the server.

{
  "mcpServers": {
    "quickbase": {
      "command": "npx",
      "args": ["-y", "mcp-quickbase"],
      "env": {
        "QUICKBASE_REALM_HOST": "your-realm.quickbase.com",
        "QUICKBASE_USER_TOKEN": "your-user-token",
        "QUICKBASE_APP_ID": "your-app-id"
      }
    }
  }
}

If you build from source and run the runtime from the built distribution, configure Claude Desktop to point to the local runtime file.

{
  "mcpServers": {
    "quickbase": {
      "command": "node",
      "args": ["/path/to/MCP-Quickbase/dist/mcp-stdio-server.js"],
      "env": {
        "QUICKBASE_REALM_HOST": "your-realm.quickbase.com",
        "QUICKBASE_USER_TOKEN": "your-user-token",
        "QUICKBASE_APP_ID": "your-app-id"
      }
    }
  }
}

Additional setup notes

The server can start without environment variables, but you must provide proper configuration for the tools to function. Use the check_configuration tool to verify that your Quickbase credentials and app context are correctly set.

Configuration and security

Key environment variables you may use include QUICKBASE_REALM_HOST, QUICKBASE_USER_TOKEN, and optionally QUICKBASE_APP_ID. Caching is configurable with caching options, and debug or log levels can be set to help diagnose issues. All API tokens are handled securely and never logged, and file operations are sandboxed to the working directory.

Usage notes and examples

Typical workflows include querying records with filters, creating new records, updating existing records, and bulk operations. You can also upload and download files to attachment fields and manage relationships between tables. You can run standard Quickbase reports to generate insights from your data.

Available tools

check_configuration

Verify that Quickbase configuration is properly set up and credentials are accessible.

test_connection

Test the connection to the Quickbase API to ensure reachable and authorized access.

configure_cache

Set up or adjust caching behavior to improve performance.

create_app

Create a new Quickbase application.

update_app

Update properties of an existing Quickbase application.

list_tables

List all tables within a given Quickbase application.

create_table

Create new tables within an application.

update_table

Update properties of existing tables.

get_table_fields

Retrieve field information for a specific table.

create_field

Create new fields within a table.

get_field

Retrieve properties of a specific field.

update_field

Update properties of a field.

delete_field

Delete a field from a table.

query_records

Query records with filtering, sorting, and grouping options.

create_record

Create a single new record.

update_record

Update an existing record.

bulk_create_records

Create multiple records in a single operation.

bulk_update_records

Update multiple records in a single operation.

upload_file

Upload a file to a file attachment field in a record.

download_file

Download a file from a record.

get_relationships

Retrieve table relationships.

create_relationship

Create a new relationship between tables.

update_relationship

Update an existing table relationship.

delete_relationship

Delete a table relationship.

run_report

Execute a Quickbase report.