Skip to main content
Glama
enesjakozh

pocketbase-mcp-server

by DynamicEndpoints
npmGitHub
JavaScript
MIT License
6
54
OverviewInspectNewEndpointsSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

Advanced PocketBase MCP Server

smithery badge A comprehensive MCP server that provides sophisticated tools for interacting with PocketBase databases. This server enables advanced database operations, schema management, and data manipulation through the Model Context Protocol (MCP).

Changelog

v2.1.0 (April 3, 2025)

Added

  • Added batch_update_records tool for updating multiple records at once.

  • Added batch_delete_records tool for deleting multiple records at once.

  • Added subscribe_to_collection tool for real-time event subscriptions (requires eventsource polyfill).

Fixed

  • Corrected schema for authenticate_user to allow admin authentication via environment variables without explicit email/password.

  • Added eventsource dependency and polyfill to enable real-time subscriptions in Node.js.

v2.0.0 (April 2, 2025)

Added

  • Enhanced admin authentication support with environment variables

  • Added support for admin impersonation via the impersonate_user tool

  • Improved error handling for authentication operations

  • Added comprehensive TypeScript type definitions for better development experience

  • Added support for Cline integration

Fixed

  • Fixed TypeScript errors in the PocketBase client implementation

  • Improved schema field handling with proper type annotations

  • Fixed issues with optional schema field properties

Changed

  • Updated the authentication flow to support multiple authentication methods

  • Improved documentation with more detailed examples

  • Enhanced environment variable configuration options

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

  • 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

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

The server requires the following environment variables:

Optional environment variables:

  • POCKETBASE_ADMIN_EMAIL: Admin email for certain operations

  • POCKETBASE_ADMIN_PASSWORD: Admin password

  • POCKETBASE_DATA_DIR: Custom data directory path

Usage Examples

Collection Management

// Create a new collection await mcp.use_tool("pocketbase", "create_collection", { name: "posts", schema: [ { name: "title", type: "text", required: true }, { name: "content", type: "text", required: true } ] }); // Manage indexes await mcp.use_tool("pocketbase", "manage_indexes", { collection: "posts", action: "create", index: { name: "title_idx", fields: ["title"], unique: true } });

Advanced Querying

// Query with filtering, sorting, and aggregation await mcp.use_tool("pocketbase", "query_collection", { collection: "posts", filter: "created >= '2024-01-01'", sort: "-created", aggregate: { totalLikes: "sum(likes)", avgRating: "avg(rating)" }, expand: "author,categories" });

Data Import/Export

// Import data with upsert mode await mcp.use_tool("pocketbase", "import_data", { collection: "posts", data: [ { title: "First Post", content: "Hello World" }, { title: "Second Post", content: "More content" } ], mode: "upsert" }); // Backup database await mcp.use_tool("pocketbase", "backup_database", { format: "json" // or "csv" });

Schema Migration

// Migrate collection schema await mcp.use_tool("pocketbase", "migrate_collection", { collection: "posts", newSchema: [ { name: "title", type: "text", required: true }, { name: "content", type: "text", required: true }, { name: "tags", type: "json", required: false } ], dataTransforms: { // Optional field transformations during migration tags: "JSON.parse(oldTags)" } });

Batch & Real-time Operations

// Batch update records await mcp.use_tool("pocketbase", "batch_update_records", { collection: "products", records: [ { id: "record_id_1", data: { price: 19.99 } }, { id: "record_id_2", data: { status: "published" } } ] }); // Batch delete records await mcp.use_tool("pocketbase", "batch_delete_records", { collection: "products", recordIds: ["record_id_3", "record_id_4"] }); // Subscribe to collection changes (logs events to server console) // Note: Requires 'eventsource' package installed in the Node.js environment running the server. await mcp.use_tool("pocketbase", "subscribe_to_collection", { collection: "products" }); // Subscribe to a specific record await mcp.use_tool("pocketbase", "subscribe_to_collection", { collection: "products", recordId: "specific_product_id" });

Authentication Methods

// List available authentication methods await mcp.use_tool("pocketbase", "list_auth_methods", { collection: "users" }); // Authenticate with password await mcp.use_tool("pocketbase", "authenticate_user", { email: "user@example.com", password: "securepassword", collection: "users" }); // Authenticate with OAuth2 await mcp.use_tool("pocketbase", "authenticate_with_oauth2", { provider: "google", code: "auth_code_from_provider", codeVerifier: "code_verifier_from_pkce", redirectUrl: "https://your-app.com/auth/callback", collection: "users" }); // Request password reset await mcp.use_tool("pocketbase", "request_password_reset", { email: "user@example.com", collection: "users" }); // Confirm password reset await mcp.use_tool("pocketbase", "confirm_password_reset", { token: "verification_token", password: "new_password", passwordConfirm: "new_password", collection: "users" }); // Refresh authentication token await mcp.use_tool("pocketbase", "auth_refresh", { collection: "users" });

Error Handling

All tools include comprehensive error handling with detailed error messages. Errors are properly typed and include:

  • Invalid request errors

  • Authentication errors

  • Database operation errors

  • Schema validation errors

  • Network errors

Type Safety

The server includes TypeScript definitions for all operations, ensuring type safety when using the tools. Each tool's input schema is strictly typed and validated.

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

To install PocketBase Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install pocketbase-server --client claude

Contributing

  1. Fork the repository

  2. Create a feature branch

  3. Commit your changes

  4. Push to the branch

  5. Create a Pull Request

Deploy Server
A
security – no known vulnerabilities
A
license - permissive license
A
quality - confirmed to work

How are these scores calculated?

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

Tools

View all tools

A comprehensive MCP server that provides sophisticated tools for interacting with PocketBase databases. This server enables advanced database operations, schema management, and data manipulation through the Model Context Protocol (MCP).

  1. Changelog
    1. v2.1.0 (April 3, 2025)
    2. v2.0.0 (April 2, 2025)
  2. Features
    1. Collection Management
    2. Record Operations
    3. User Management
    4. Database Operations
  3. Available Tools
    1. Collection Management
    2. Record Operations
    3. User Management
    4. Database Operations
  4. Configuration
    1. Usage Examples
      1. Collection Management
      2. Advanced Querying
      3. Data Import/Export
      4. Schema Migration
      5. Batch & Real-time Operations
      6. Authentication Methods
    2. Error Handling
      1. Type Safety
        1. Best Practices
          1. Development
            1. Installing via Smithery
              1. Contributing

                Related MCP Servers

                • PocketBase MCP Server

                  imatrixme
                  -
                  security
                  A
                  license
                  -
                  quality
                  A comprehensive server that enables advanced database operations with PocketBase, providing tools for collection management, record operations, user management, and database administration through the Model Context Protocol.
                  Last updated -
                  6
                  MIT License

                • PocketBase MCP Server

                  mrwyndham
                  A
                  security
                  A
                  license
                  A
                  quality
                  Provides sophisticated tools for interacting with PocketBase databases, enabling advanced database operations, schema management, and data manipulation through the Model Context Protocol (MCP).
                  Last updated -
                  24
                  6
                  76
                  MIT License

                • Advanced PocketBase MCP Server

                  DynamicEndpoints
                  A
                  security
                  A
                  license
                  A
                  quality
                  A comprehensive server that enables sophisticated interactions with PocketBase databases through Model Context Protocol, offering collection management, record operations, user management, and advanced database operations.
                  Last updated -
                  14
                  6
                  54
                  MIT License

                • PocketBase MCP Server

                  mabeldata
                  A
                  security
                  A
                  license
                  A
                  quality
                  MCP server that allows interaction with PocketBase databases, enabling record operations (fetch, list, create, update), file management, and schema migrations through natural language.
                  Last updated -
                  20
                  20
                  MIT License
                  • Linux
                  • Apple

                View all related MCP servers

                Appeared in Searches

                New MCP Servers

                MCP directory API

                We provide all the information about MCP servers via our MCP API.

                curl -X GET 'https://glama.ai/api/mcp/v1/servers/DynamicEndpoints/pocketbase-mcp-server'

                If you have feedback or need assistance with the MCP directory API, please join our Discord server