Picobase MCP Server

An official Model Context Protocol (MCP) server for Picobase. This server allows AI assistants like Cursor and Claude to directly manage your Picobase schema and collections via natural language.

Features

• List Collections: View all existing schema collections.
• Get Collection: Inspect individual collection fields and rules.
• Create Collection: Add new collections (base, auth, or view) with defined fields.
• Update Collection: Modify the schema of an existing collection.
• Delete Collection: Remove a collection from the database.

Installation & Setup

1. Make sure you have Node.js installed on your machine.
2. Clone the Picobase repository or ensure this package is built:

   cd packages/mcp-server
   npm install
   npm run build

Using with Cursor

To connect Cursor to your Picobase instance, you need to add this MCP server in Cursor's settings.

1. Open Cursor Settings (Cmd/Ctrl + ,)
2. Go to Features -> MCP (Model Context Protocol)
3. Click + Add new MCP server
4. Configure it as follows (replace the absolute path and environment variables with your specific values):
   • Type: command
   • Name: picobase-mcp
   • Command: node
   • Args: /absolute/path/to/picobase/packages/mcp-server/dist/index.js
   • Env Variables: Add the following environment variables so it can authenticate to your Picobase instance:
     • PICOBASE_URL: e.g. http://localhost:8090 (or your production URL)
     • PICOBASE_ADMIN_API_KEY: Your Admin API Key generated from the dashboard

Click "Save" and ensure the status shows green (connected). You can now ask Cursor chat: "Create a tasks collection with a title and a boolean completed field" and it will directly execute schema modifications for you!

Using with Claude Desktop

Add the following to your claude_desktop_config.json (located via Claude Desktop settings > Developer > Edit Config):

{
  "mcpServers": {
    "picobase": {
      "command": "node",
      "args": ["/absolute/path/to/picobase/packages/mcp-server/dist/index.js"],
      "env": {
        "PICOBASE_URL": "http://localhost:8090",
        "PICOBASE_ADMIN_API_KEY": "pbk_xyz98765_xxxxxxxxxxxxxxxx"
      }
    }
  }
}

Restart Claude Desktop to apply the configuration.