QuickBase

You have a QuickBase MCP Server that gives you full control over QuickBase operations through MCP tools. It lets you manage applications, tables, fields, records, relationships, and reports with flexible, scriptable access for automation and integration workflows.

How to use

You interact with the server through an MCP client. Start the server locally, then configure your client to connect using the provided runtime command and environment variables. Use the available tools to perform actions such as creating tables, adding fields, querying records, and managing relationships. For common workflows, set up your client to invoke the specific tool endpoints (for example, create a table, then add fields and records) in the sequence that matches your data model.

How to install

Prerequisites: You need Node.js installed on your machine. Ensure npm is available with your Node.js installation.

# 1. Clone the server repository (or download the source)
# 2. Install dependencies
cd quickbase-mcp-server
npm install

# 3. Copy environment configuration
cp env.example .env

# 4. Configure credentials in .env:
# QB_REALM=yourname.quickbase.com
# QB_USER_TOKEN=your_quickbase_user_token_here
# QB_APP_ID=yourid
# Optional defaults
# QB_DEFAULT_TIMEOUT=30000
# QB_MAX_RETRIES=3
# MCP server details
# MCP_SERVER_NAME=quickbase-mcp
# MCP_SERVER_VERSION=1.0.0

# 5. Build the project
npm run build

# 6. Start the server (standalone for testing)
npm start

Additional configuration and security

Environment variables define your QuickBase credentials and how the MCP server runs. The following variables are used to connect to QuickBase and authorize operations: QB_REALM, QB_USER_TOKEN, QB_APP_ID. Keep these values secure and do not commit them to version control.

To use a client configuration with the MCP server, specify the runtime command and environment in your MCP client setup as shown. This enables the client to launch the server process with the correct environment.

Enable debug logging during troubleshooting by setting the environment variable DEBUG=quickbase-mcp:* before launching the server.

Troubleshooting

Authentication errors typically indicate an incorrect user token, missing permissions for your app, or an incorrect realm hostname. Verify QB_USER_TOKEN, QB_APP_ID, and QB_REALM. If a table or field cannot be found, confirm IDs and permissions for access to the target object. When field creation fails, ensure the field type is supported, required options (like choices for lookups or select fields) are provided, and any formula syntax is correct for formula fields.

Notes on development and usage

This server exposes a comprehensive set of QuickBase operations through MCP tools, including application management, table and field management, record operations, relationships, and utility functions such as reports.

Available tools

quickbase_get_app_info

Retrieve information about the QuickBase application.

quickbase_get_tables

List all tables in the application.

quickbase_test_connection

Test the connection to QuickBase with provided credentials.

quickbase_create_table

Create a new table in the application.

quickbase_get_table_info

Get details about a specific table.

quickbase_delete_table

Delete a table from the application.

quickbase_get_table_fields

Fetch all fields for a given table.

quickbase_create_field

Create a new field in a table (all supported types).

quickbase_update_field

Update an existing field on a table.

quickbase_delete_field

Delete a field from a table.

quickbase_query_records

Query records with filters and sorting.

quickbase_get_record

Retrieve a specific record by its ID.

quickbase_create_record

Create a new record or multiple records in a table.

quickbase_update_record

Update an existing record.

quickbase_delete_record

Delete a record from a table.

quickbase_bulk_create_records

Create multiple records in a single operation.

quickbase_search_records

Search records by text across fields.

quickbase_create_relationship

Create a parent-child relationship between tables.

quickbase_get_relationships

Get existing relationships for tables.

quickbase_get_reports

Fetch available reports for the app.

quickbase_run_report

Run a specific report to retrieve results.