Advanced PocketBase MCP Server

Features

Collection Management

• Create and manage collections with custom schemas

• Migrate collection schemas with data preservation

• Advanced index management (create, delete, list)

• Schema validation and type safety

• Retrieve collection schemas and metadata

Record Operations

• CRUD operations for records

• Advanced querying with filtering, sorting, and aggregation

• Batch import/export capabilities

• Relationship expansion support

• Pagination and cursor-based 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 restore

• Multiple export formats (JSON/CSV)

• Data migration tools

• Index optimization

• Batch operations

Available Tools

Collection Management

• 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

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: Advanced query with filtering, sorting, and aggregation

• import_data: Import data into a collection with create/update/upsert modes

User Management

• 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)

Database Operations

• backup_database: Create a backup of the PocketBase database with format options

• import_data: Import data with various modes (create/update/upsert)

Configuration

• POCKETBASE_URL: URL of your PocketBase instance (e.g., "http://127.0.0.1:8090")

• POCKETBASE_ADMIN_EMAIL: Admin email for certain operations

• POCKETBASE_ADMIN_PASSWORD: Admin password

• POCKETBASE_DATA_DIR: Custom data directory path

Usage Examples

Collection Management

Advanced Querying

Data Import/Export

Schema Migration

Authentication Methods

Error Handling

• Invalid request errors

• Authentication errors

• Database operation errors

• Schema validation errors

• Network errors

Type Safety

Best Practices

1. Always use proper error handling with try/catch blocks

2. Validate data before performing operations

3. Use appropriate indexes for better query performance

4. Regularly backup your 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

4. Build: npm run build

5. Start your PocketBase instance

6. The MCP server will automatically connect to your PocketBase instance

Installing via Smithery

Contributing

1. Fork the repository

2. Create a feature branch

3. Commit your changes

4. Push to the branch

5. Create a Pull Request

Advanced PocketBase MCP Server

Features

Collection Management

• Create and manage collections with custom schemas

• Migrate collection schemas with data preservation

• Advanced index management (create, delete, list)

• Schema validation and type safety

• Retrieve collection schemas and metadata

Record Operations

• CRUD operations for records

• Advanced querying with filtering, sorting, and aggregation

• Batch import/export capabilities

• Relationship expansion support

• Pagination and cursor-based 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 restore

• Multiple export formats (JSON/CSV)

• Data migration tools

• Index optimization

• Batch operations

Available Tools

Collection Management

• 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

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: Advanced query with filtering, sorting, and aggregation

• import_data: Import data into a collection with create/update/upsert modes

User Management

• 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)

Database Operations

• backup_database: Create a backup of the PocketBase database with format options

• import_data: Import data with various modes (create/update/upsert)

Configuration

• POCKETBASE_URL: URL of your PocketBase instance (e.g., "http://127.0.0.1:8090")

• POCKETBASE_ADMIN_EMAIL: Admin email for certain operations

• POCKETBASE_ADMIN_PASSWORD: Admin password

• POCKETBASE_DATA_DIR: Custom data directory path

Usage Examples

Collection Management

Advanced Querying

Data Import/Export

Schema Migration

Authentication Methods

Error Handling

• Invalid request errors

• Authentication errors

• Database operation errors

• Schema validation errors

• Network errors

Type Safety

Best Practices

1. Always use proper error handling with try/catch blocks

2. Validate data before performing operations

3. Use appropriate indexes for better query performance

4. Regularly backup your 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

4. Build: npm run build

5. Start your PocketBase instance

6. The MCP server will automatically connect to your PocketBase instance

Installing via Smithery

Contributing

1. Fork the repository

2. Create a feature branch

3. Commit your changes

4. Push to the branch

5. Create a Pull Request