DynamicEndpoints_advanced-pocketbase-mcp-server

DynamicEndpoints_advanced-pocketbase-mcp-server

3.1

If you are the rightful owner of DynamicEndpoints_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.

A comprehensive MCP server that provides sophisticated tools for interacting with PocketBase databases.

The Advanced PocketBase MCP Server is a robust solution designed to facilitate advanced database operations, schema management, and data manipulation through the Model Context Protocol (MCP). It offers a wide range of features including collection management, record operations, user management, and database operations. The server supports enhanced admin authentication, error handling, and provides comprehensive TypeScript type definitions for a better development experience. It also integrates with Cline and supports multiple authentication methods. The server is highly configurable through environment variables and offers tools for database backup, data import/export, and schema migration. It is designed to ensure type safety and includes detailed error handling for all operations.

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 creation, password management, and role-based access control.
  • Database Operations: Backup and restore databases, optimize indexes, and perform batch operations.
  • Type Safety: Includes TypeScript definitions for all operations ensuring type safety.

Tools

  1. create_collection

    Create a new collection with custom schema

  2. get_collection_schema

    Get schema details for a collection

  3. migrate_collection

    Migrate collection schema with data preservation

  4. manage_indexes

    Create, delete, or list collection indexes

  5. create_record

    Create a new record in a collection

  6. list_records

    List records with optional filters and pagination

  7. update_record

    Update an existing record

  8. delete_record

    Delete a record

  9. query_collection

    Advanced query with filtering, sorting, and aggregation

  10. import_data

    Import data into a collection with create/update/upsert modes

  11. authenticate_user

    Authenticate a user and get auth token

  12. create_user

    Create a new user account

  13. list_auth_methods

    List all available authentication methods

  14. authenticate_with_oauth2

    Authenticate a user with OAuth2

  15. authenticate_with_otp

    Authenticate a user with one-time password

  16. auth_refresh

    Refresh authentication token

  17. request_verification

    Request email verification

  18. confirm_verification

    Confirm email verification with token

  19. request_password_reset

    Request password reset

  20. confirm_password_reset

    Confirm password reset with token

  21. request_email_change

    Request email change

  22. confirm_email_change

    Confirm email change with token

  23. impersonate_user

    Impersonate another user (admin only)

  24. backup_database

    Create a backup of the PocketBase database with format options