Dynamicendpoints Pocketbase MCP Server

🚀 Advanced PocketBase MCP Server

A feature - rich MCP server that offers advanced tools for interacting with the PocketBase database. This server enables complex database operations, schema management, and data processing through the Model Context Protocol (MCP).

✨ Features

Collection Management

• Create and manage collections with custom schemas.
• Migrate collections while retaining data.
• Advanced index management (create, delete, list).
• Schema validation and type safety.
• Retrieve collection schemas and metadata.

Record Operations

• CRUD operations on records.
• Advanced queries with filters, sorting, and aggregation.
• Batch import/export functionality.
• Support for relationship expansion.
• Pagination and cursor navigation.

User Management

• User authentication and token management.
• User account creation and management.
• Password management.
• Role - based access control.
• Session handling.

Database Operations

• Database backup and restoration.
• Multiple export formats (JSON/CSV).
• Data migration tools.
• Index optimization.
• Batch processing operations.

🛠️ Available Tools

Collection Management

• create_collection: Create a new collection with a custom schema.
• get_collection_schema: Get detailed schema information for a collection.
• migrate_collection: Migrate a collection schema while retaining data.
• manage_indexes: Create, delete, or list collection indexes.

Record Operations

• 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: Perform advanced queries with filters, sorting, and aggregation.
• import_data: Import data into a collection in create/update/insert mode.

User Management

• authenticate_user: Authenticate a user and obtain a token.
• create_user: Create a new user account.

Database Operations

• backup_database: Create a backup of the PocketBase database.
• import_data: Import data in a specified format.

🚫 Error Handling

All tools include comprehensive error handling with detailed error messages. Errors include:

• Invalid request errors.
• Authentication errors.
• Database operation errors.
• Schema validation errors.
• Network errors.

🔒 Type Safety

The server provides TypeScript definitions for all operations, ensuring type safety. The input schemas for each tool are strictly type - checked and validated.

💡 Best Practices

1. Always use appropriate error handling with try/catch blocks.
2. Validate data before performing operations.
3. Use appropriate indexes to improve query performance.
4. Regularly back up the database.
5. Use migrations for schema changes.
6. Follow security best practices for user management.
7. Monitor and optimize database performance.

🛠️ Development

1. Clone the repository.
2. Install dependencies: npm install.
3. Copy .env.example to .env and configure it.
4. Build: npm run build.
5. Start your PocketBase instance.
6. The MCP server will automatically connect to your PocketBase instance.

🤝 Contribution

1. Fork the repository.
2. Create a feature branch.
3. Commit your changes.
4. Push to the branch.
5. Create a Pull Request.