PocketBase

What This Skill Does

The PocketBase skill empowers OpenClaw to interact seamlessly with PocketBase backends. It provides an abstracted interface to manage collections, handle user authentication, subscribe to realtime events, and perform file operations. By leveraging the official JavaScript SDK, it allows the agent to build, query, and maintain database-driven applications without writing boilerplate code, enabling efficient data-driven workflows directly through the AI agent interface.

Installation

To integrate this skill into your environment, use the OpenClaw CLI: clawhub install openclaw/skills/skills/ivangdavila/pocketbase

Use Cases

• Automated CRUD Operations: Quickly sync data from external sources into your PocketBase collections for persistent storage.
• Authentication Management: Securely handle user logins and maintain auth states within automated agent workflows.
• Realtime Monitoring: Set up listeners for database changes to trigger secondary agent tasks automatically upon record updates.
• File Handling: Upload, manage, and retrieve user documents or media assets tied to specific database records.
• Backend Prototyping: Rapidly structure database collections and apply access rules to build MVP backends during development sessions.

Example Prompts

1. "Fetch all active users from the 'profiles' collection that were created in 2024 and include their associated posts using the expand parameter."
2. "Subscribe to the 'orders' collection in real-time and log every new 'create' action to the console."
3. "Upload the file 'document.pdf' to the 'reports' collection under the 'file' field for the current user record."

Tips & Limitations

• Authentication Check: Always verify pb.authStore.isValid before executing operations to avoid stale data issues.
• Relationship Expansion: Remember that expanded data is nested within record.expand, not at the root level.
• Security: Be careful with Collection Rules; an empty string represents an 'open to everyone' rule, which can accidentally expose sensitive data if misconfigured.
• Performance: Hooks defined in pb_hooks run synchronously; avoid heavy logic here to prevent blocking user requests. Use the pb.js file extension strictly for hooks to ensure they are registered by the PocketBase engine. Always unsubscribe from realtime events to prevent memory leaks in long-running agent sessions.