QuickBase MCP Server
The QuickBase MCP Server is a flexible tool for comprehensive management of QuickBase applications, tables, fields, records, and relationships.
Application Management: Get app info, list tables, test connection
Table Operations: Create, get, update, and delete tables
Field Management: Get, create, update, delete fields; support for all field types including lookups, formulas, and relationships
Record Operations: Query, get, create, update, delete records; search and bulk operations
Relationship Management: Create and manage table relationships (parent-child, many-to-many, junction tables)
Utility Functions: Run reports, advanced querying, error handling, and retry logic
Manages environment configuration for QuickBase credentials, realm settings, and server parameters through a .env file.
Used for package management and running the server, with commands for installation, building, and executing the QuickBase MCP server.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@QuickBase MCP Server show me all the tables in my project management app"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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
Clone and setup the server:
cd quickbase-mcp-server
npm installCopy environment configuration:
cp env.example .envConfigure 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.0Build the project:
npm run buildGetting Your QuickBase User Token
Go to QuickBase → My Apps → User Account
Click "Manage user tokens"
Click "New user token"
Give it a name like "MCP Server"
Set appropriate permissions
Copy the token to your
.envfile
Usage
Run the server standalone:
npm startAdd 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 informationquickbase_get_tables- List all tablesquickbase_test_connection- Test connection
Table Tools
quickbase_create_table- Create new tablequickbase_get_table_info- Get table detailsquickbase_delete_table- Delete table
Field Tools
quickbase_get_table_fields- Get all fieldsquickbase_create_field- Create new fieldquickbase_update_field- Update existing fieldquickbase_delete_field- Delete field
Record Tools
quickbase_query_records- Query with filters/sortingquickbase_get_record- Get specific recordquickbase_create_record- Create new recordquickbase_update_record- Update existing recordquickbase_delete_record- Delete recordquickbase_bulk_create_records- Create multiple recordsquickbase_search_records- Search by text
Relationship Tools
quickbase_create_relationship- Create table relationshipquickbase_get_relationships- Get existing relationships
Utility Tools
quickbase_get_reports- Get all reportsquickbase_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 texttext_choice- Single choice dropdowntext_multiline- Multi-line textrichtext- Rich text editornumeric- Number fieldcurrency- Currency fieldpercent- Percentage fielddate- Date fielddatetime- Date/time fieldcheckbox- Checkbox fieldemail- Email fieldphone- Phone number fieldurl- URL fieldaddress- Address fieldfile- File attachmentlookup- Lookup from another tableformula- Calculated fieldreference- Table reference
Development
Run in development mode:
npm run devRun tests:
npm testTroubleshooting
Common Issues
Authentication Error
Check your user token is correct
Verify token permissions include your app
Ensure realm hostname is correct
Table/Field Not Found
Verify table/field IDs are correct
Check if you have permissions to access
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:
Direct API Access - Uses QuickBase REST API v1 directly
Complete Field Support - Supports all QuickBase field types
Relationship Management - Can create and manage table relationships
Bulk Operations - Efficient bulk record operations
Advanced Querying - Full QuickBase query syntax support
Error Handling - Comprehensive error handling and retry logic
License
MIT License
Available Tools
26 toolsquickbase_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
Scored across 26 tools
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).
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.
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.
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
Related MCP Connectors
Hosted MCP server for AI-driven data ops. Create apps, manage schemas, and CRUD structured data.
One MCP server for all your MCP servers: code mode, per-tool permissions, approvals and audit.
The best QuickBooks Desktop MCP server on the planet: every operation on every record type
Build and run AI workflows, agents, data tables and 1000+ API integrations from any MCP client.
Related MCP Servers
- AlicenseNot gradedqualityBmaintenanceA comprehensive Model Context Protocol server providing full CRUD operations for 29 QuickBooks Online entities and 11 financial reports.452Apache 2.0
- AlicenseNot gradedqualityDmaintenanceA 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 npm1MIT
- AlicenseAqualityDmaintenanceMCP server for interacting with Realm MinistryPlatform data, enabling queries, record creation, and updates from any MCP client.1MIT
- AlicenseNot gradedqualityDmaintenanceA 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.5Apache 2.0