get_record
Retrieve specific records from a PocketBase database using the Model Context Protocol (MCP). This tool enables precise data extraction with advanced querying capabilities for efficient database management.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Implementation Reference
- src/agent-worker-compatible.ts:396-414 (handler)Core handler implementation: fetches specific PocketBase record by collection and ID using getOne()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-simple.ts:502-528 (registration)Tool registration including inline handler, description, and Zod input schema validation for collection name and record ID'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}`); } } );
- Input schema definition for get_record tool in the tools list responsename: "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-cloudflare.ts:420-439 (registration)Cloudflare Agent-specific registration of get_record tool with Zod schema and inline handler supporting expand option"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) }] }; }