list_collections

Retrieve and manage all collections within a PocketBase database using this tool. Simplify schema review, data organization, and operational workflows.

Input Schema

TableJSON Schema

Name	Required	Description	Default
No arguments

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",

pocketbase-mcp-server