Advanced PocketBase MCP ServerServer

DynamicEndpoints

databaseMCPPocketBase

Loading subscription status...

💡 Description

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

📝 JSON Entries

{
  "mcpServers": [
    {
      "Advanced PocketBase MCP Server": {
        "env": {
          "POCKETBASE_URL": "http://127.0.0.1:8090",
          "POCKETBASE_DATA_DIR": "<SECRET_DATA_DIR>",
          "POCKETBASE_ADMIN_EMAIL": "<SECRET_ADMIN_EMAIL>",
          "POCKETBASE_ADMIN_PASSWORD": "<SECRET_ADMIN_PASSWORD>"
        },
        "args": [],
        "command": "start"
      }
    }
  ]
}

🛠️ Tools

authenticate_with_oauth2create_usermigrate_collectionupdate_recordauthenticate_with_otpget_auth_infolist_recordsconfirm_email_change

⚡ Features

Advanced database operations
Schema management
Data manipulation

💬 Example Queries

// 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" });
// 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" });
// 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: { tags: "JSON.parse(oldTags)" } });