Skip to main content
Glama
QuickBase MCP Server

QuickBase MCP Server

QuickBase MCP Server

A Model Context Protocol (MCP) server that provides maximum flexibility for QuickBase operations. This server allows you to create tables, add fields, modify relationships, and perform all QuickBase operations through MCP tools.

Features

Application Management

  • Get application information

  • List all tables

  • Test connection

Table Operations

  • Create new tables

  • Get table information

  • Update table properties

  • Delete tables

Field Management

  • Get all fields for a table

  • Create new fields (all types supported)

  • Update existing fields

  • Delete fields

  • Support for lookups, formulas, relationships

Record Operations

  • Query records with filtering and sorting

  • Get specific records

  • Create single or multiple records

  • Update existing records

  • Delete records

  • Search records by text

  • Bulk operations

Relationship Management

  • Create parent-child relationships

  • Get existing relationships

  • Foreign key management

Utility Functions

  • Get and run reports

  • Advanced querying capabilities

  • Error handling and retry logic

Related MCP server: database-mcp-server

Installation

  1. Clone and setup the server:

cd quickbase-mcp-server
npm install
  1. Copy environment configuration:

cp env.example .env
  1. Configure your QuickBase credentials in .env:

# QuickBase Configuration
QB_REALM=yourname.quickbase.com
QB_USER_TOKEN=your_quickbase_user_token_here
QB_APP_ID=yourid

# Optional: Default settings
QB_DEFAULT_TIMEOUT=30000
QB_MAX_RETRIES=3

# MCP Server Configuration
MCP_SERVER_NAME=quickbase-mcp
MCP_SERVER_VERSION=1.0.0
  1. Build the project:

npm run build

Getting Your QuickBase User Token

  1. Go to QuickBase → My Apps → User Account

  2. Click "Manage user tokens"

  3. Click "New user token"

  4. Give it a name like "MCP Server"

  5. Set appropriate permissions

  6. Copy the token to your .env file

Usage

Run the server standalone:

npm start

Add to your MCP client configuration:

Add to your MCP client configuration (e.g., Claude Desktop):

{
  "mcpServers": {
    "quickbase": {
      "command": "node",
      "args": ["/path/to/quickbase-mcp-server/dist/index.js"],
      "env": {
        "QB_REALM": "yourname.quickbase.com",
        "QB_USER_TOKEN": "your_token_here",
        "QB_APP_ID": "yourid"
      }
    }
  }
}

Available Tools

Application Tools

  • quickbase_get_app_info - Get application information

  • quickbase_get_tables - List all tables

  • quickbase_test_connection - Test connection

Table Tools

  • quickbase_create_table - Create new table

  • quickbase_get_table_info - Get table details

  • quickbase_delete_table - Delete table

Field Tools

  • quickbase_get_table_fields - Get all fields

  • quickbase_create_field - Create new field

  • quickbase_update_field - Update existing field

  • quickbase_delete_field - Delete field

Record Tools

  • quickbase_query_records - Query with filters/sorting

  • quickbase_get_record - Get specific record

  • quickbase_create_record - Create new record

  • quickbase_update_record - Update existing record

  • quickbase_delete_record - Delete record

  • quickbase_bulk_create_records - Create multiple records

  • quickbase_search_records - Search by text

Relationship Tools

  • quickbase_create_relationship - Create table relationship

  • quickbase_get_relationships - Get existing relationships

Utility Tools

  • quickbase_get_reports - Get all reports

  • quickbase_run_report - Run specific report

Example Usage

Create a new table:

{
  "name": "quickbase_create_table",
  "arguments": {
    "name": "New Projects",
    "description": "Project tracking table"
  }
}

Add a field to a table:

{
  "name": "quickbase_create_field",
  "arguments": {
    "tableId": "bu65pc8px",
    "label": "Project Status",
    "fieldType": "text_choice",
    "choices": ["Planning", "Active", "Complete", "On Hold"],
    "required": true
  }
}

Query records with filtering:

{
  "name": "quickbase_query_records",
  "arguments": {
    "tableId": "bu65pc8px",
    "where": "{6.EX.'John'}",
    "top": 10,
    "sortBy": [{"fieldId": 3, "order": "DESC"}]
  }
}

Create a new record:

{
  "name": "quickbase_create_record",
  "arguments": {
    "tableId": "bu65pc8px",
    "fields": {
      "6": {"value": "John Doe"},
      "7": {"value": "123 Main St"},
      "8": {"value": "john@example.com"}
    }
  }
}

Field Types Supported

  • text - Single line text

  • text_choice - Single choice dropdown

  • text_multiline - Multi-line text

  • richtext - Rich text editor

  • numeric - Number field

  • currency - Currency field

  • percent - Percentage field

  • date - Date field

  • datetime - Date/time field

  • checkbox - Checkbox field

  • email - Email field

  • phone - Phone number field

  • url - URL field

  • address - Address field

  • file - File attachment

  • lookup - Lookup from another table

  • formula - Calculated field

  • reference - Table reference

Development

Run in development mode:

npm run dev

Run tests:

npm test

Troubleshooting

Common Issues

  1. Authentication Error

    • Check your user token is correct

    • Verify token permissions include your app

    • Ensure realm hostname is correct

  2. Table/Field Not Found

    • Verify table/field IDs are correct

    • Check if you have permissions to access

  3. Field Creation Fails

    • Check field type is supported

    • Verify choices are provided for choice fields

    • Ensure formula syntax is correct for formula fields

Enable Debug Logging

Set environment variable:

DEBUG=quickbase-mcp:*

Implementation Notes

This server provides the maximum flexibility for QuickBase operations by:

  1. Direct API Access - Uses QuickBase REST API v1 directly

  2. Complete Field Support - Supports all QuickBase field types

  3. Relationship Management - Can create and manage table relationships

  4. Bulk Operations - Efficient bulk record operations

  5. Advanced Querying - Full QuickBase query syntax support

  6. Error Handling - Comprehensive error handling and retry logic

License

MIT License

Available Tools

26 tools
quickbase_bulk_create_recordsC

Create multiple records at once

Inputs: records (required), tableId (required).

quickbase_create_advanced_relationshipC

Create a comprehensive table relationship with automatic lookup fields

Inputs: childTableId (required), parentTableId (required), referenceFieldLabel (required), lookupFields, +1 more.

quickbase_create_fieldC

Create a new field in a table

Inputs: fieldType (required), label (required), tableId (required), choices, +5 more.

quickbase_create_junction_tableC

Create a junction table for many-to-many relationships

Inputs: junctionTableName (required), table1FieldLabel (required), table1Id (required), table2FieldLabel (required), +2 more.

quickbase_create_lookup_fieldC

Create a lookup field to pull data from a related table

Inputs: childTableId (required), lookupFieldLabel (required), parentFieldId (required), parentTableId (required), +1 more.

quickbase_create_recordC

Create a new record in a table

Inputs: fields (required), tableId (required).

quickbase_create_relationshipC

Create a parent-child relationship between tables

Inputs: childTableId (required), foreignKeyFieldId (required), parentTableId (required).

quickbase_create_tableC

Create a new table in QuickBase

Inputs: name (required), description.

quickbase_delete_fieldC

Delete a field from a table

Inputs: fieldId (required), tableId (required).

quickbase_delete_recordC

Delete a record from a table

Inputs: recordId (required), tableId (required).

quickbase_delete_tableC

Delete a table from QuickBase

Inputs: tableId (required).

quickbase_get_app_infoC

Get information about the QuickBase application

Inputs: no named parameters.

quickbase_get_recordC

Get a specific record by ID

Inputs: recordId (required), tableId (required), fieldIds.

quickbase_get_relationship_detailsB

Get detailed information about table relationships including lookup fields

Inputs: tableId (required), includeFields.

quickbase_get_relationshipsC

Get relationships for a table

Inputs: tableId (required).

quickbase_get_reportsC

Get all reports for a table

Inputs: tableId (required).

quickbase_get_table_fieldsC

Get all fields for a table

Inputs: tableId (required).

quickbase_get_table_infoC

Get detailed information about a specific table

Inputs: tableId (required).

quickbase_get_tablesB

Get list of all tables in the application

Inputs: no named parameters.

quickbase_query_recordsC

Query records from a table with optional filtering and sorting

Inputs: tableId (required), select, skip, sortBy, +2 more.

quickbase_run_reportC

Run a specific report

Inputs: reportId (required), tableId (required).

quickbase_search_recordsC

Search for records containing specific text

Inputs: searchTerm (required), tableId (required), fieldIds.

quickbase_test_connectionB

Test connection to QuickBase

Inputs: no named parameters.

quickbase_update_fieldC

Update an existing field

Inputs: fieldId (required), tableId (required), choices, label, +1 more.

quickbase_update_recordC

Update an existing record

Inputs: fields (required), recordId (required), tableId (required).

quickbase_validate_relationshipC

Validate the integrity of a table relationship

Inputs: childTableId (required), foreignKeyFieldId (required), parentTableId (required).

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.2/5.0

    Scored across 26 tools

    Disambiguation5/5

    Every tool has a clearly distinct purpose targeting specific QuickBase operations like table/field/record management, relationships, queries, and app info. No ambiguity exists between tools—each name precisely indicates its function (e.g., quickbase_create_field vs. quickbase_update_field).

    Naming Consistency5/5

    All tools follow a perfect verb_noun pattern with the 'quickbase_' prefix, using consistent snake_case throughout (e.g., quickbase_create_table, quickbase_get_record). The naming is highly predictable and readable across all 26 tools.

    Tool Count3/5

    With 26 tools, the count is borderline heavy for a single server, though QuickBase's complexity as a database platform justifies many operations. It feels comprehensive but could overwhelm agents; a more modular approach might improve scoping.

    Completeness5/5

    The toolset provides complete CRUD/lifecycle coverage for QuickBase's domain, including tables, fields, records, relationships, queries, reports, and app info. No obvious gaps exist—agents can perform all essential operations without dead ends.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      B
      maintenance
      A comprehensive Model Context Protocol server providing full CRUD operations for 29 QuickBooks Online entities and 11 financial reports.
      452
      Apache 2.0
    • A
      license
      Not graded
      quality
      D
      maintenance
      A Model Context Protocol server for unified database access and management, supporting multiple databases with CRUD operations, transactions, metadata queries, and built-in security features.
      9 npm
      1
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      A comprehensive MCP server for QuickBooks Online, providing 144 tools for full CRUD operations on 29 entity types and 11 financial reports, with built-in safety guards against unintended writes.
      5
      Apache 2.0