QuickBase MCP Server

import { Tool } from '@modelcontextprotocol/sdk/types.js'; import { z } from 'zod'; // Tool parameter schemas const TableIdSchema = z.object({ tableId: z.string().describe('QuickBase table ID (e.g., "bu65pc8px")') }); const RecordIdSchema = z.object({ tableId: z.string().describe('QuickBase table ID'), recordId: z.number().describe('Record ID number') }); const CreateTableSchema = z.object({ name: z.string().describe('Table name'), description: z.string().optional().describe('Table description') }); const CreateFieldSchema = z.object({ tableId: z.string().describe('Table ID to add field to'), label: z.string().describe('Field label/name'), fieldType: z.enum([ 'text', 'text_choice', 'text_multiline', 'richtext', 'numeric', 'currency', 'percent', 'date', 'datetime', 'checkbox', 'email', 'phone', 'url', 'address', 'file', 'lookup', 'formula', 'reference' ]).describe('Type of field'), required: z.boolean().default(false).describe('Whether field is required'), unique: z.boolean().default(false).describe('Whether field must be unique'), choices: z.array(z.string()).optional().describe('Choices for choice fields'), formula: z.string().optional().describe('Formula for formula fields'), lookupTableId: z.string().optional().describe('Table ID for lookup fields'), lookupFieldId: z.number().optional().describe('Field ID for lookup fields') }); const QueryRecordsSchema = z.object({ tableId: z.string().describe('Table ID to query'), select: z.array(z.number()).optional().describe('Field IDs to select'), where: z.string().optional().describe('QuickBase query filter'), sortBy: z.array(z.object({ fieldId: z.number(), order: z.enum(['ASC', 'DESC']).default('ASC') })).optional().describe('Sort criteria'), top: z.number().optional().describe('Max number of records'), skip: z.number().optional().describe('Number of records to skip') }); const CreateRecordSchema = z.object({ tableId: z.string().describe('Table ID to create record in'), fields: z.record(z.any()).describe('Field values as fieldId: value pairs') }); const UpdateRecordSchema = z.object({ tableId: z.string().describe('Table ID'), recordId: z.number().describe('Record ID to update'), fields: z.record(z.any()).describe('Field values to update as fieldId: value pairs') }); const BulkCreateSchema = z.object({ tableId: z.string().describe('Table ID'), records: z.array(z.object({ fields: z.record(z.any()) })).describe('Array of records to create') }); const SearchRecordsSchema = z.object({ tableId: z.string().describe('Table ID to search'), searchTerm: z.string().describe('Text to search for'), fieldIds: z.array(z.number()).optional().describe('Field IDs to search in') }); const CreateRelationshipSchema = z.object({ parentTableId: z.string().describe('Parent table ID'), childTableId: z.string().describe('Child table ID'), foreignKeyFieldId: z.number().describe('Foreign key field ID in child table') }); const CreateAdvancedRelationshipSchema = z.object({ parentTableId: z.string().describe('Parent table ID'), childTableId: z.string().describe('Child table ID'), referenceFieldLabel: z.string().describe('Label for the reference field to create'), lookupFields: z.array(z.object({ parentFieldId: z.number().describe('Field ID in parent table to lookup'), childFieldLabel: z.string().describe('Label for lookup field in child table') })).optional().describe('Lookup fields to create automatically'), relationshipType: z.enum(['one-to-many', 'many-to-many']).default('one-to-many').describe('Type of relationship') }); const CreateLookupFieldSchema = z.object({ childTableId: z.string().describe('Child table ID where lookup field will be created'), parentTableId: z.string().describe('Parent table ID to lookup from'), referenceFieldId: z.number().describe('Reference field ID in child table'), parentFieldId: z.number().describe('Field ID in parent table to lookup'), lookupFieldLabel: z.string().describe('Label for the new lookup field') }); const ValidateRelationshipSchema = z.object({ parentTableId: z.string().describe('Parent table ID'), childTableId: z.string().describe('Child table ID'), foreignKeyFieldId: z.number().describe('Foreign key field ID to validate') }); // Define all MCP tools export const quickbaseTools: Tool[] = [ // ========== APPLICATION TOOLS ========== { name: 'quickbase_get_app_info', description: 'Get information about the QuickBase application', inputSchema: { type: 'object', properties: {}, required: [] } }, { name: 'quickbase_get_tables', description: 'Get list of all tables in the application', inputSchema: { type: 'object', properties: {}, required: [] } }, { name: 'quickbase_test_connection', description: 'Test connection to QuickBase', inputSchema: { type: 'object', properties: {}, required: [] } }, // ========== TABLE TOOLS ========== { name: 'quickbase_create_table', description: 'Create a new table in QuickBase', inputSchema: { type: 'object', properties: { name: { type: 'string', description: 'Table name' }, description: { type: 'string', description: 'Table description' } }, required: ['name'] } }, { name: 'quickbase_get_table_info', description: 'Get detailed information about a specific table', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'QuickBase table ID' } }, required: ['tableId'] } }, { name: 'quickbase_delete_table', description: 'Delete a table from QuickBase', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'QuickBase table ID to delete' } }, required: ['tableId'] } }, // ========== FIELD TOOLS ========== { name: 'quickbase_get_table_fields', description: 'Get all fields for a table', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'QuickBase table ID' } }, required: ['tableId'] } }, { name: 'quickbase_create_field', description: 'Create a new field in a table', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'Table ID to add field to' }, label: { type: 'string', description: 'Field label/name' }, fieldType: { type: 'string', enum: ['text', 'text_choice', 'text_multiline', 'richtext', 'numeric', 'currency', 'percent', 'date', 'datetime', 'checkbox', 'email', 'phone', 'url', 'address', 'file', 'lookup', 'formula', 'reference'], description: 'Type of field' }, required: { type: 'boolean', description: 'Whether field is required', default: false }, unique: { type: 'boolean', description: 'Whether field must be unique', default: false }, choices: { type: 'array', items: { type: 'string' }, description: 'Choices for choice fields' }, formula: { type: 'string', description: 'Formula for formula fields' }, lookupTableId: { type: 'string', description: 'Table ID for lookup fields' }, lookupFieldId: { type: 'number', description: 'Field ID for lookup fields' } }, required: ['tableId', 'label', 'fieldType'] } }, { name: 'quickbase_update_field', description: 'Update an existing field', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'Table ID' }, fieldId: { type: 'number', description: 'Field ID to update' }, label: { type: 'string', description: 'New field label' }, required: { type: 'boolean', description: 'Whether field is required' }, choices: { type: 'array', items: { type: 'string' }, description: 'New choices for choice fields' } }, required: ['tableId', 'fieldId'] } }, { name: 'quickbase_delete_field', description: 'Delete a field from a table', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'Table ID' }, fieldId: { type: 'number', description: 'Field ID to delete' } }, required: ['tableId', 'fieldId'] } }, // ========== RECORD TOOLS ========== { name: 'quickbase_query_records', description: 'Query records from a table with optional filtering and sorting', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'Table ID to query' }, select: { type: 'array', items: { type: 'number' }, description: 'Field IDs to select' }, where: { type: 'string', description: 'QuickBase query filter (e.g., "{6.EX.\'John\'}")' }, sortBy: { type: 'array', items: { type: 'object', properties: { fieldId: { type: 'number' }, order: { type: 'string', enum: ['ASC', 'DESC'] } } }, description: 'Sort criteria' }, top: { type: 'number', description: 'Max number of records' }, skip: { type: 'number', description: 'Number of records to skip' } }, required: ['tableId'] } }, { name: 'quickbase_get_record', description: 'Get a specific record by ID', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'Table ID' }, recordId: { type: 'number', description: 'Record ID' }, fieldIds: { type: 'array', items: { type: 'number' }, description: 'Specific field IDs to retrieve' } }, required: ['tableId', 'recordId'] } }, { name: 'quickbase_create_record', description: 'Create a new record in a table', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'Table ID to create record in' }, fields: { type: 'object', description: 'Field values as fieldId: {value: actualValue} pairs', additionalProperties: true } }, required: ['tableId', 'fields'] } }, { name: 'quickbase_update_record', description: 'Update an existing record', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'Table ID' }, recordId: { type: 'number', description: 'Record ID to update' }, fields: { type: 'object', description: 'Field values to update as fieldId: {value: actualValue} pairs', additionalProperties: true } }, required: ['tableId', 'recordId', 'fields'] } }, { name: 'quickbase_delete_record', description: 'Delete a record from a table', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'Table ID' }, recordId: { type: 'number', description: 'Record ID to delete' } }, required: ['tableId', 'recordId'] } }, { name: 'quickbase_bulk_create_records', description: 'Create multiple records at once', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'Table ID' }, records: { type: 'array', items: { type: 'object', properties: { fields: { type: 'object', additionalProperties: true } } }, description: 'Array of records to create' } }, required: ['tableId', 'records'] } }, { name: 'quickbase_search_records', description: 'Search for records containing specific text', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'Table ID to search' }, searchTerm: { type: 'string', description: 'Text to search for' }, fieldIds: { type: 'array', items: { type: 'number' }, description: 'Field IDs to search in' } }, required: ['tableId', 'searchTerm'] } }, // ========== RELATIONSHIP TOOLS ========== { name: 'quickbase_create_relationship', description: 'Create a parent-child relationship between tables', inputSchema: { type: 'object', properties: { parentTableId: { type: 'string', description: 'Parent table ID' }, childTableId: { type: 'string', description: 'Child table ID' }, foreignKeyFieldId: { type: 'number', description: 'Foreign key field ID in child table' } }, required: ['parentTableId', 'childTableId', 'foreignKeyFieldId'] } }, { name: 'quickbase_get_relationships', description: 'Get relationships for a table', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'Table ID' } }, required: ['tableId'] } }, // ========== UTILITY TOOLS ========== { name: 'quickbase_get_reports', description: 'Get all reports for a table', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'Table ID' } }, required: ['tableId'] } }, { name: 'quickbase_run_report', description: 'Run a specific report', inputSchema: { type: 'object', properties: { reportId: { type: 'string', description: 'Report ID' }, tableId: { type: 'string', description: 'Table ID' } }, required: ['reportId', 'tableId'] } }, // ========== ENHANCED RELATIONSHIP TOOLS ========== { name: 'quickbase_create_advanced_relationship', description: 'Create a comprehensive table relationship with automatic lookup fields', inputSchema: { type: 'object', properties: { parentTableId: { type: 'string', description: 'Parent table ID' }, childTableId: { type: 'string', description: 'Child table ID' }, referenceFieldLabel: { type: 'string', description: 'Label for the reference field to create' }, lookupFields: { type: 'array', items: { type: 'object', properties: { parentFieldId: { type: 'number', description: 'Field ID in parent table to lookup' }, childFieldLabel: { type: 'string', description: 'Label for lookup field in child table' } }, required: ['parentFieldId', 'childFieldLabel'] }, description: 'Lookup fields to create automatically' }, relationshipType: { type: 'string', enum: ['one-to-many', 'many-to-many'], default: 'one-to-many', description: 'Type of relationship' } }, required: ['parentTableId', 'childTableId', 'referenceFieldLabel'] } }, { name: 'quickbase_create_lookup_field', description: 'Create a lookup field to pull data from a related table', inputSchema: { type: 'object', properties: { childTableId: { type: 'string', description: 'Child table ID where lookup field will be created' }, parentTableId: { type: 'string', description: 'Parent table ID to lookup from' }, referenceFieldId: { type: 'number', description: 'Reference field ID in child table' }, parentFieldId: { type: 'number', description: 'Field ID in parent table to lookup' }, lookupFieldLabel: { type: 'string', description: 'Label for the new lookup field' } }, required: ['childTableId', 'parentTableId', 'referenceFieldId', 'parentFieldId', 'lookupFieldLabel'] } }, { name: 'quickbase_validate_relationship', description: 'Validate the integrity of a table relationship', inputSchema: { type: 'object', properties: { parentTableId: { type: 'string', description: 'Parent table ID' }, childTableId: { type: 'string', description: 'Child table ID' }, foreignKeyFieldId: { type: 'number', description: 'Foreign key field ID to validate' } }, required: ['parentTableId', 'childTableId', 'foreignKeyFieldId'] } }, { name: 'quickbase_get_relationship_details', description: 'Get detailed information about table relationships including lookup fields', inputSchema: { type: 'object', properties: { tableId: { type: 'string', description: 'Table ID to analyze relationships for' }, includeFields: { type: 'boolean', default: true, description: 'Include related field details' } }, required: ['tableId'] } }, { name: 'quickbase_create_junction_table', description: 'Create a junction table for many-to-many relationships', inputSchema: { type: 'object', properties: { junctionTableName: { type: 'string', description: 'Name for the junction table' }, table1Id: { type: 'string', description: 'First table ID' }, table2Id: { type: 'string', description: 'Second table ID' }, table1FieldLabel: { type: 'string', description: 'Label for reference to first table' }, table2FieldLabel: { type: 'string', description: 'Label for reference to second table' }, additionalFields: { type: 'array', items: { type: 'object', properties: { label: { type: 'string' }, fieldType: { type: 'string' } } }, description: 'Additional fields for the junction table' } }, required: ['junctionTableName', 'table1Id', 'table2Id', 'table1FieldLabel', 'table2FieldLabel'] } }, ]; // Export schemas for validation export { TableIdSchema, RecordIdSchema, CreateTableSchema, CreateFieldSchema, QueryRecordsSchema, CreateRecordSchema, UpdateRecordSchema, BulkCreateSchema, SearchRecordsSchema, CreateRelationshipSchema, CreateAdvancedRelationshipSchema, CreateLookupFieldSchema, ValidateRelationshipSchema };