DynamicEndpoints_pocketbase-mcp-server
If you are the rightful owner of DynamicEndpoints_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.
A comprehensive MCP server that provides sophisticated tools for interacting with PocketBase databases.
The Advanced PocketBase MCP Server is designed to facilitate advanced database operations, schema management, and data manipulation through the Model Context Protocol (MCP). It offers a robust set of features for managing collections, performing CRUD operations on records, handling user authentication, and executing database operations such as backup and restore. The server is equipped with tools for schema validation, type safety, and advanced querying capabilities, making it an ideal solution for developers looking to leverage PocketBase's capabilities in a structured and efficient manner. With support for batch operations, relationship expansion, and role-based access control, the server ensures that users can manage their databases with precision and ease. Additionally, the server provides comprehensive error handling and type safety through TypeScript definitions, ensuring that operations are executed smoothly and securely.
Features
- Collection Management: Create and manage collections with custom schemas, migrate schemas, and manage indexes.
- Record Operations: Perform CRUD operations, advanced querying, and batch import/export.
- User Management: Handle user authentication, account creation, and role-based access control.
- Database Operations: Backup and restore databases, optimize indexes, and perform data migrations.
- Error Handling: Comprehensive error handling with detailed messages and type safety.
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
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
backup_database
Create a backup of the PocketBase database with format options
