pocketbase-mcp-server

Implementation Reference

• src/server.ts:297-327 (handler)

  Primary handler and registration for the 'list_collections' tool in the core MCP server. Fetches collections using getList(1, 100), filters system collections optionally, and returns formatted JSON.

  server.tool(
    'list_collections',
    {
      includeSystem: z.boolean().optional().default(false).describe('Whether to include system collections')
    },
    async ({ includeSystem }) => {
      try {
        const collections = await this.pb.collections.getList(1, 100);
        const filteredCollections = includeSystem
          ? collections.items
          : collections.items.filter((c: any) => !c.system);
  
        return {
          content: [{
            type: 'text',
            text: JSON.stringify(filteredCollections.map((c: any) => ({
              id: c.id,
              name: c.name,
              type: c.type,
              system: c.system,
              recordCount: c.recordCount || 0
            })), null, 2)
          }]
        };
      } catch (error: any) {
        return {
          content: [{ type: 'text', text: `Failed to list collections: ${error.message}` }],
          isError: true
        };
      }
    }

• src/agent-cloudflare.ts:314-329 (handler)

  Handler implementation in Cloudflare agent variant using getFullList() and returns full JSON of all collections.

  "list_collections",
  "List all collections in the PocketBase database",
  {},
  async () => {
    if (!this.pb) {
      throw new Error('PocketBase not initialized. Please configure POCKETBASE_URL.');
    }
  
    const collections = await this.pb.collections.getFullList();
    return {
      content: [{
        type: 'text',
        text: JSON.stringify(collections, null, 2)
      }]
    };
  }

• src/agent-simple.ts:418-439 (handler)

  Handler in simple agent using getFullList() with initialization check.

  'list_collections',
  {
    description: 'List all collections in the PocketBase database'
  },
  async () => {
    await this.ensureInitialized();
    if (!this.pb) {
      throw new Error('PocketBase not initialized');
    }
  
    try {
      const collections = await this.pb.collections.getFullList();
      return {
        content: [{
          type: 'text',
          text: JSON.stringify(collections, null, 2)
        }]
      };
    } catch (error: any) {
      throw new Error(`Failed to list collections: ${error.message}`);
    }
  }

• src/agent-worker-compatible.ts:319-337 (handler)

  Dedicated helper function listCollections() used in switch case for tool handling in worker-compatible agent.

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

• src/agent-worker-compatible.ts:170-220 (registration)

  Tool registration in listTools handler for worker-compatible agent, defining schema as empty object.

  this.server.setRequestHandler(ListToolsRequestSchema, async () => {
    return {
      tools: [
        {
          name: "health_check",
          description: "Check the health status of the MCP server",
          inputSchema: {
            type: "object",
            properties: {},
            required: []
          }
        },
        {
          name: "list_collections",
          description: "List all PocketBase collections",
          inputSchema: {
            type: "object",
            properties: {},
            required: []
          }
        },
        {
          name: "get_collection",
          description: "Get detailed information about a specific collection",
          inputSchema: {
            type: "object",
            properties: {
              name: {
                type: "string",
                description: "Collection name"
              }
            },
            required: ["name"]
          }
        },
        {
          name: "list_records",
          description: "List records from a collection",
          inputSchema: {
            type: "object",
            properties: {
              collection: {
                type: "string",
                description: "Collection name"
              },
              page: {
                type: "number",
                description: "Page number (default: 1)"
              },
              perPage: {
                type: "number",