Advanced PocketBase MCP Server

What is Advanced PocketBase MCP Server?

The Advanced PocketBase MCP Server is a comprehensive MCP (Model Context Protocol) server that provides sophisticated tools for interacting with PocketBase databases. It enables advanced database operations, schema management, and data manipulation through the MCP interface, targeting developers who need to manage PocketBase instances programmatically.

How to use Advanced PocketBase MCP Server?

Set the POCKETBASE_URL environment variable to point to your PocketBase instance (e.g., http://127.0.0.1:8090). Optionally configure POCKETBASE_ADMIN_EMAIL, POCKETBASE_ADMIN_PASSWORD, and POCKETBASE_DATA_DIR. Clone the repository, run npm install, build with npm run build, and start your PocketBase instance. The MCP server automatically connects to your PocketBase instance. Use the listed tools (e.g., create_collection, list_records, backup_database) via the MCP client.

Key features of Advanced PocketBase MCP Server

• Collection creation, migration, and index management
• Full CRUD operations for records with advanced querying
• User authentication and account management
• Database backup and restore in JSON/CSV formats
• Batch data import with create/update/upsert modes
• Schema validation and type safety with TypeScript definitions

Use cases of Advanced PocketBase MCP Server

• Manage collection schemas and indexes programmatically
• Perform record CRUD with filtering, sorting, and aggregation
• Authenticate users and manage their accounts
• Backup and export databases in multiple formats
• Migrate collection schemas while preserving existing data

FAQ from Advanced PocketBase MCP Server

What environment variables are required to run the server?

The server requires POCKETBASE_URL. Optional variables are POCKETBASE_ADMIN_EMAIL, POCKETBASE_ADMIN_PASSWORD, and POCKETBASE_DATA_DIR.

Does it support user authentication?

Yes. The authenticate_user tool authenticates a user and returns an authentication token. The create_user tool creates new user accounts.

Can I backup the database?

Yes. The backup_database tool creates a backup of the PocketBase database with format options (JSON or CSV).

What collection management operations are available?

You can create collections with custom schemas, retrieve schema details, migrate collection schemas with data preservation, and manage indexes (create, delete, list).

What types of errors does the server handle?

The server handles invalid request errors, authentication errors, database operation errors, schema validation errors, and network errors, all with detailed messages and proper typing.