advanced-pocketbase-mcp-server
If you are the rightful owner of advanced-pocketbase-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
Advanced PocketBase MCP Server provides sophisticated tools for interacting with PocketBase databases, enabling advanced database operations, schema management, and data manipulation through the Model Context Protocol (MCP).
The Advanced PocketBase MCP Server is a comprehensive solution designed to facilitate complex interactions with PocketBase databases. It offers a wide range of tools for managing collections, performing CRUD operations, handling user authentication, and executing database operations. The server supports advanced querying, batch operations, and real-time event subscriptions, making it ideal for developers who need robust database management capabilities. With features like schema validation, type safety, and role-based access control, the server ensures secure and efficient data handling. It also includes tools for database backup, migration, and index optimization, providing a complete suite for database administration. The server is equipped with TypeScript type definitions for enhanced development experience and supports integration with various platforms through detailed usage examples and scripts.
Features
- Collection Management: Create and manage collections with custom schemas, migrate schemas, and manage indexes.
- Record Operations: Perform CRUD operations, advanced querying, batch import/export, and relationship expansion.
- User Management: Handle user authentication, account management, password management, and role-based access control.
- Database Operations: Backup and restore databases, perform data migrations, and optimize indexes.
- Real-time Subscriptions: Subscribe to real-time changes in collections with eventsource support.
Tools
create_collection
Create a new collection with custom schema
get_collection_schema
Get schema details for a collection
migrate_collection
Migrate collection schema with data preservation
manage_indexes
Create, delete, or list collection indexes
create_record
Create a new record in a collection
list_records
List records with optional filters and pagination
update_record
Update an existing record
delete_record
Delete a record
query_collection
Advanced query with filtering, sorting, and aggregation
batch_update_records
Update multiple records in a single call
batch_delete_records
Delete multiple records in a single call
subscribe_to_collection
Subscribe to real-time changes in a collection (requires eventsource package in Node.js environment)
import_data
Import data into a collection with create/update/upsert modes
authenticate_user
Authenticate a user and get auth token
create_user
Create a new user account
list_auth_methods
List all available authentication methods
authenticate_with_oauth2
Authenticate a user with OAuth2
authenticate_with_otp
Authenticate a user with one-time password
auth_refresh
Refresh authentication token
request_verification
Request email verification
confirm_verification
Confirm email verification with token
request_password_reset
Request password reset
confirm_password_reset
Confirm password reset with token
request_email_change
Request email change
confirm_email_change
Confirm email change with token
impersonate_user
Impersonate another user (admin only)
backup_database
Create a backup of the PocketBase database with format options
