Database · Developer Tools

Pocketbase MCP logo

Pocketbase MCP

mabeldata/pocketbase-mcp

This is an MCP server that interacts with a PocketBase instance. It allows you to fetch, list, create, update, and manage records and files in your PocketBase collections.

Install

npx -y @smithery/cli install @mabeldata/pocketbase-mcp --client claude

Client configuration

{
  "mcpServers": {
    "pocketbase-mcp": {
      "command": "node",
      "args": [
        "/path/to/pocketbase-mcp/build/index.js"
      ],
      "env": {
        "POCKETBASE_API_URL": "<POCKETBASE_API_URL>",
        "POCKETBASE_ADMIN_TOKEN": "<POCKETBASE_ADMIN_TOKEN>"
      }
    }
  }
}

Environment variables

POCKETBASE_API_URLPOCKETBASE_ADMIN_TOKEN
GitHub stars
8
Category
Database, Developer Tools
Updated
Oct 6, 2026

Tools (29)

  • fetch_record

    Fetch a single record from a PocketBase collection by ID.

  • create_record

    Create a new record in a PocketBase collection.

  • update_record

    Update an existing record in a PocketBase collection.

  • delete_record

    Delete a record from a PocketBase collection by ID (permanent).

  • batch_records

    Execute multiple record operations (create/update/upsert/delete) in ONE transactional batch — if any operation fails, the whole batch rolls back.

  • get_collection_schema

    Get the schema of a PocketBase collection.

  • upload_file

    Upload a file to a specific field in a PocketBase collection record.

  • download_file

    Get the download URL for a file stored in a PocketBase collection record.

  • get_collection_scaffolds

    Get example collection schema payloads (server >= v0.37) — an object keyed by collection type (base, auth, view) with ready-to-edit templates for building new…

  • dry_run_view_query

    Validate a VIEW collection SQL query without saving the collection (server >= v0.37).

  • get_log

    Get a single API request log by ID.

  • get_logs_stats

    Get API request logs statistics with optional filtering.

  • truncate_logs

    Delete ALL API request logs (server >= v0.40).

  • list_cron_jobs

    Returns list with all registered app level cron jobs.

  • run_cron_job

    Triggers a single cron job by its id.

  • create_backup

    Queue a new database+storage backup.

  • restore_backup

    Restore the instance from an existing backup key.

  • get_settings

    Fetch all app settings (sections: meta, logs, smtp, batch, backups, s3, rateLimits,...).

  • update_settings

    Bulk-update settings with a partial payload.

  • All-or-nothing.

    There is no read-only mode: SQL statements that modify or drop data (UPDATE, DELETE, DROP, PRAGMAs,...) are just as executable as SELECT.

  • Auditable.

    SQL calls land in the PocketBase request logs (POST /api/sql), so list_logs can reconstruct what ran.

  • set_migrations_directory

    Set the directory where migration files will be created and read from.

  • create_migration

    Create a new, empty PocketBase migration file with a timestamped name.

  • create_collection_migration

    Create a migration file specifically for creating a new PocketBase collection.

  • add_field_migration

    Create a migration file for adding a field to an existing collection.

  • apply_migration

    Apply a specific migration file.

  • revert_migration

    Revert a specific migration file.

  • apply_all_migrations

    Apply all pending migrations.

  • revert_to_migration

    Revert migrations up to a specific target.

Details on this page are taken from the project's README. Open README

Supported clients

Clients mentioned in this server's README:

View all
Claude Desktop logo

Claude Desktop

Desktop · Freemium · Proprietary

Anthropic's official Claude AI desktop application. Supports MCP servers to extend functionality.

WindowsMacOS
Cline logo

Cline

Desktop · Free · MIT

An AI coding assistant integrated into the IDE. Supports MCP servers for enhanced functionality.

WindowsMacOSLinux

Related MCP servers

More servers
Supabase MCP logo

Supabase MCP

supabase-community/supabase-mcp

1.3k

The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.

Database
Genai Toolbox logo

Genai Toolbox

googleapis/genai-toolbox

769

MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.

Database
Supabase MCP Server logo

Supabase MCP Server

alexander-zuev/supabase-mcp-server

677

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

Database
Awesome MCP List logo

Awesome MCP List

MobinX/awesome-mcp-list

645

This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.

Database
PostgreSQL Model Context Protocol (PG MCP) Server logo

PostgreSQL Model Context Protocol (PG MCP) Server

stuzero/pg-mcp-server

440

PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.

Database
dbhub logo

dbhub

bytebase/dbhub

332

[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.

Database