Advanced PocketBase MCP Server

Implementation Reference

• src/agent-worker-compatible.ts:396-414 (handler)

  Core handler function that executes the get_record tool logic by fetching the record from PocketBase using collection.getOne(id). Dispatched from the main tool call handler.

  private async getRecord(collection: string, id: string) {
    if (!this.pb) {
      throw new Error('PocketBase not configured');
    }
  
    try {
      const record = await this.pb.collection(collection).getOne(id);
      return {
        content: [
          {
            type: "text",
            text: JSON.stringify(record, null, 2)
          }
        ]
      };
    } catch (error: any) {
      throw new Error(`Failed to get record: ${error.message}`);
    }
  }

• src/agent-worker-compatible.ts:236-252 (schema)

  Input schema for get_record tool defining required 'collection' and 'id' string parameters.

    name: "get_record",
    description: "Get a specific record by ID",
    inputSchema: {
      type: "object",
      properties: {
        collection: {
          type: "string",
          description: "Collection name"
        },
        id: {
          type: "string",
          description: "Record ID"
        }
      },
      required: ["collection", "id"]
    }
  },

• src/agent-simple.ts:502-528 (handler)

  Inline tool registration and handler for get_record in the simple agent implementation, using Zod schema validation and PocketBase getOne.

    'get_record',
    {
      description: 'Get a specific record by ID',
      inputSchema: {
        collection: z.string().describe('Collection name'),
        id: z.string().describe('Record ID')
      }
    },
    async ({ collection, id }) => {
      await this.ensureInitialized();
      if (!this.pb) {
        throw new Error('PocketBase not initialized');
      }
  
      try {
        const record = await this.pb.collection(collection).getOne(id);
        return {
          content: [{
            type: 'text',
            text: JSON.stringify(record, null, 2)
          }]
        };
      } catch (error: any) {
        throw new Error(`Failed to get record: ${error.message}`);
      }
    }
  );

• src/agent-cloudflare.ts:419-439 (handler)

  Tool handler for get_record in Cloudflare agent, supports optional expand parameter for relations.

  this.server.tool(
    "get_record",
    "Get a specific record by ID",
    {
      collection: z.string().describe('Collection name'),
      id: z.string().describe('Record ID'),
      expand: z.string().optional().describe('Relations to expand')
    },
    async ({ collection, id, expand }) => {
      if (!this.pb) {
        throw new Error('PocketBase not initialized');
      }
  
      const record = await this.pb.collection(collection).getOne(id, { expand });
      return {
        content: [{
          type: 'text',
          text: JSON.stringify(record, null, 2)
        }]
      };
    }