{"_id":"@alpacacloud/mcp","_rev":"6-b22f558375e61372f813dde8e25623cc","name":"@alpacacloud/mcp","dist-tags":{"latest":"1.4.2"},"versions":{"1.1.0":{"name":"@alpacacloud/mcp","version":"1.1.0","keywords":["alpaca-cloud","alpacacloud","mcp","model-context-protocol","postgres","database","ai","agent","claude","cursor","windsurf","supabase-alternative"],"license":"MIT","_id":"@alpacacloud/mcp@1.1.0","maintainers":[{"name":"melgencer","email":"mel.genc@windowslive.com"}],"homepage":"https://alpaca-cloud.com","bugs":{"url":"https://github.com/Melgencer/alpaca-cloud/issues"},"bin":{"alpacacloud-mcp":"index.js"},"dist":{"shasum":"20351e5c31b55edb1e04e63998301cc46dd07c39","tarball":"https://registry.npmjs.org/@alpacacloud/mcp/-/mcp-1.1.0.tgz","fileCount":4,"integrity":"sha512-JvMwgRhrAoY2HK53uq+ePo1zegBtUBoVvk/yPOTZOTpyPBA2GghQ3K2sY3/TWWN7m1xBMMt2XR9pq8VT0ZlExA==","signatures":[{"sig":"MEUCIQDmuat/3h9SjaZdxVlx1wFvpN2MzxlGjEUNfltHGk9SngIgV4Xc1ODNtgZvzECICBL/oASoBphMO15zbfZEYXLrfg4=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":17593},"main":"index.js","engines":{"node":">=18.0.0"},"gitHead":"9aa69fe27f27d7d7b4b9238736cc69f8d2747928","scripts":{"start":"node index.js"},"_npmUser":{"name":"melgencer","email":"mel.genc@windowslive.com"},"repository":{"url":"git+https://github.com/Melgencer/alpaca-cloud.git","type":"git","directory":"mcp"},"_npmVersion":"10.8.2","description":"MCP server for Alpaca Cloud — lets Claude, Cursor, Windsurf and other AI tools connect directly to your Alpaca Cloud project database, auth, and storage.","directories":{},"_nodeVersion":"20.20.2","_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/mcp_1.1.0_1776373268219_0.760262246025829","host":"s3://npm-registry-packages-npm-production"}},"1.3.0":{"name":"@alpacacloud/mcp","version":"1.3.0","keywords":["alpacacloud","alpaca-cloud","mcp","model-context-protocol","postgres","ai","agent","claude","cursor"],"license":"MIT","_id":"@alpacacloud/mcp@1.3.0","maintainers":[{"name":"melgencer","email":"mel.genc@windowslive.com"}],"homepage":"https://docs.alpaca-cloud.com","bugs":{"url":"https://github.com/alpacacloud/mcp/issues"},"bin":{"alpacacloud-mcp":"bin/alpacacloud-mcp.js"},"dist":{"shasum":"ce52f437ac3614eda3d67df400a2ccfd585eedf7","tarball":"https://registry.npmjs.org/@alpacacloud/mcp/-/mcp-1.3.0.tgz","fileCount":4,"integrity":"sha512-qfTyczzE9KMqWDanQzYGvfPUYTCJbf1RLkEzAoKFTGHPqiy+/PC5/VH930bZAVhm11HVrQcUCA417/PNS4ETKQ==","signatures":[{"sig":"MEYCIQDNtXX/v0NpU1OR/1TBRntsVm578Y5STZVolnCBm3xVUQIhAKfut3DpJUVt2KpHKbVkLkKXQjujq6s93mU8Ab1QjcDF","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":52216},"main":"index.js","engines":{"node":">=18.0.0"},"gitHead":"f81ce001b7d3036413fca5305c0d29b2c6064ec6","scripts":{"start":"node index.js"},"_npmUser":{"name":"melgencer","email":"mel.genc@windowslive.com"},"repository":{"url":"git+https://github.com/alpacacloud/mcp.git","type":"git"},"_npmVersion":"10.9.4","description":"MCP server for Alpaca Cloud — AI agents connect to your project (Postgres, Auth, Storage), plus account-wide Sandboxes (code execution) and Workflows (automation).","directories":{},"_nodeVersion":"22.21.0","dependencies":{},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/mcp_1.3.0_1781659050803_0.662764678402469","host":"s3://npm-registry-packages-npm-production"}},"1.4.0":{"name":"@alpacacloud/mcp","version":"1.4.0","keywords":["alpacacloud","alpaca-cloud","mcp","model-context-protocol","postgres","ai","agent","claude","cursor"],"license":"MIT","_id":"@alpacacloud/mcp@1.4.0","maintainers":[{"name":"melgencer","email":"mel.genc@windowslive.com"}],"homepage":"https://docs.alpaca-cloud.com","bugs":{"url":"https://github.com/melgencer/alpaca-cloud/issues"},"bin":{"alpacacloud-mcp":"bin/alpacacloud-mcp.js"},"dist":{"shasum":"2750212ef9d3831f70123edcfbb6880619189afc","tarball":"https://registry.npmjs.org/@alpacacloud/mcp/-/mcp-1.4.0.tgz","fileCount":5,"integrity":"sha512-RbJhF2cRuNDEX/SMmu0/rKYaCxXMh8oNvOFV5WFgtAT7Jg8CX75EZsXCqfOmrYtAAQpN67jy7rCKduRG6xke/g==","signatures":[{"sig":"MEQCIFthY62z9opO41C1WJiWacjPkAWLGhfDwzuzLJxCtZBIAiANrI/hQEKvyIFC47rUk/MKBigP7er0vxv8Vn/qRwOo4w==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":59280},"main":"index.js","engines":{"node":">=18.0.0"},"gitHead":"3f7b7f2837d28a93fc81e3ec6267876898faa026","mcpName":"io.github.melgencer/alpacacloud-mcp","scripts":{"start":"node index.js"},"_npmUser":{"name":"melgencer","email":"mel.genc@windowslive.com"},"repository":{"url":"git+https://github.com/melgencer/alpaca-cloud.git","type":"git"},"_npmVersion":"10.9.4","description":"MCP server for Alpaca Cloud — AI agents connect to your project (Postgres, Auth, Storage), plus account-wide Sandboxes (code execution) and Workflows (automation).","directories":{},"_nodeVersion":"22.21.0","dependencies":{},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/mcp_1.4.0_1781754414729_0.8575543401402776","host":"s3://npm-registry-packages-npm-production"}},"1.4.1":{"name":"@alpacacloud/mcp","version":"1.4.1","keywords":["alpacacloud","alpaca-cloud","mcp","model-context-protocol","postgres","ai","agent","claude","cursor"],"license":"MIT","_id":"@alpacacloud/mcp@1.4.1","maintainers":[{"name":"melgencer","email":"mel.genc@windowslive.com"}],"homepage":"https://docs.alpaca-cloud.com","bugs":{"url":"https://github.com/melgencer/alpaca-cloud/issues"},"bin":{"alpacacloud-mcp":"bin/alpacacloud-mcp.js"},"dist":{"shasum":"0c29c847891c93062a28811c25e793a58f774680","tarball":"https://registry.npmjs.org/@alpacacloud/mcp/-/mcp-1.4.1.tgz","fileCount":6,"integrity":"sha512-nAMfealmQyNOdUX0vOmn0u+OGK1TKra3/ndRfF1brg3X9oiVhAaqb4JDqpXECZ89nm8IQJjxRriKImfsLXN2VQ==","signatures":[{"sig":"MEUCIHhq2nRtarwaDdogEfCSmfApUYtr4ZtKz9C3RGJZROT+AiEApzUqbutP4FXkvagVvEoAH1DhsDOkuzDBYFkE1mEZ9zg=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":20338515},"main":"index.js","engines":{"node":">=18.0.0"},"gitHead":"6c5bccd68ce36da5ac8baa8af86ad5d4e30f1069","mcpName":"io.github.Melgencer/alpacacloud-mcp","scripts":{"start":"node index.js"},"_npmUser":{"name":"melgencer","email":"mel.genc@windowslive.com"},"repository":{"url":"git+https://github.com/melgencer/alpaca-cloud.git","type":"git"},"_npmVersion":"10.9.4","description":"MCP server for Alpaca Cloud — AI agents connect to your project (Postgres, Auth, Storage), plus account-wide Sandboxes (code execution) and Workflows (automation).","directories":{},"_nodeVersion":"22.21.0","dependencies":{},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/mcp_1.4.1_1781755767299_0.38952799874782174","host":"s3://npm-registry-packages-npm-production"},"deprecated":"bundled a stray binary; use 1.4.2+"},"1.4.2":{"name":"@alpacacloud/mcp","version":"1.4.2","keywords":["alpacacloud","alpaca-cloud","mcp","model-context-protocol","postgres","ai","agent","claude","cursor"],"license":"MIT","_id":"@alpacacloud/mcp@1.4.2","maintainers":[{"name":"melgencer","email":"mel.genc@windowslive.com"}],"homepage":"https://docs.alpaca-cloud.com","bugs":{"url":"https://github.com/melgencer/alpaca-cloud/issues"},"bin":{"alpacacloud-mcp":"bin/alpacacloud-mcp.js"},"dist":{"shasum":"4975ce8b561bf7e2276a04d1a80ddfb9a16c74e0","tarball":"https://registry.npmjs.org/@alpacacloud/mcp/-/mcp-1.4.2.tgz","fileCount":5,"integrity":"sha512-zfBuJsG5tB7Qnigop2cm64quA02e9SdPkG/FOMn2Ek7pSo2Aixbeyy+3C5aHVvVp9DOkZyjAdv7AcBOlYod8qw==","signatures":[{"sig":"MEUCIQDd9YTaEHbclZ+FLEAW8wyKle1psvPCsDT7yy/U9faRGgIgRcpfTqwEEnWJYG1avwv89PdrXhrDJApbg2BQ67R9ul4=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":59306},"main":"index.js","engines":{"node":">=18.0.0"},"gitHead":"d68e28c26fa9eaea5f2d208beb94cf9fbf7771c7","mcpName":"io.github.Melgencer/alpacacloud-mcp","scripts":{"start":"node index.js"},"_npmUser":{"name":"melgencer","email":"mel.genc@windowslive.com"},"repository":{"url":"git+https://github.com/melgencer/alpaca-cloud.git","type":"git"},"_npmVersion":"10.9.4","description":"MCP server for Alpaca Cloud — AI agents connect to your project (Postgres, Auth, Storage), plus account-wide Sandboxes (code execution) and Workflows (automation).","directories":{},"_nodeVersion":"22.21.0","dependencies":{},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/mcp_1.4.2_1781756044339_0.3514002430223928","host":"s3://npm-registry-packages-npm-production"}}},"time":{"created":"2026-04-16T21:01:08.074Z","modified":"2026-06-18T04:16:18.475Z","1.1.0":"2026-04-16T21:01:08.360Z","1.3.0":"2026-06-17T01:17:30.936Z","1.4.0":"2026-06-18T03:46:54.868Z","1.4.1":"2026-06-18T04:09:27.570Z","1.4.2":"2026-06-18T04:14:04.533Z"},"bugs":{"url":"https://github.com/melgencer/alpaca-cloud/issues"},"license":"MIT","homepage":"https://docs.alpaca-cloud.com","keywords":["alpacacloud","alpaca-cloud","mcp","model-context-protocol","postgres","ai","agent","claude","cursor"],"repository":{"url":"git+https://github.com/melgencer/alpaca-cloud.git","type":"git"},"description":"MCP server for Alpaca Cloud — AI agents connect to your project (Postgres, Auth, Storage), plus account-wide Sandboxes (code execution) and Workflows (automation).","maintainers":[{"name":"melgencer","email":"mel.genc@windowslive.com"}],"readme":"# @alpacacloud/mcp\r\n\r\nModel Context Protocol (MCP) server for [Alpaca Cloud](https://alpaca-cloud.com).\r\n\r\nConnect an AI agent (Claude, Cursor, Windsurf, etc.) to an Alpaca Cloud project —\r\nrun SQL, manage schema, auth users, and storage, with no manual token plumbing.\r\n\r\nAlpaca Cloud is an all-in-one platform: **Postgres + Auth + Storage + Realtime +\r\nEdge Functions**, plus **static-site hosting** and **Docker app hosting** — one\r\nplatform, SDK, CLI, and MCP server.\r\n\r\n## Install / run\r\n\r\n```bash\r\nnpx @alpacacloud/mcp@latest --project-url=https://<project>.alpaca-cloud.com --apikey=<service_role_key>\r\n```\r\n\r\n**Claude Code** (one line):\r\n```bash\r\nclaude mcp add alpacacloud -- npx -y @alpacacloud/mcp@latest\r\n```\r\n\r\nOr in a Claude Desktop / Cursor MCP config:\r\n```json\r\n{\r\n  \"mcpServers\": {\r\n    \"alpacacloud\": {\r\n      \"command\": \"npx\",\r\n      \"args\": [\"@alpacacloud/mcp\", \"--project-url=https://<project>.alpaca-cloud.com\", \"--apikey=<service_role_key>\"]\r\n    }\r\n  }\r\n}\r\n```\r\n\r\nEnv vars also work (legacy `ALPACABASE_*` names still accepted as a fallback):\r\n\r\n| Var | Purpose |\r\n|---|---|\r\n| `ALPACACLOUD_URL` | Your project URL (project-scoped DB/Auth/Storage tools) |\r\n| `ALPACACLOUD_SERVICE_KEY` | Project service_role key |\r\n| `ALPACACLOUD_ACCOUNT_TOKEN` | Your **personal access token** (`alp_pat_…`) — unlocks the account-wide Sandboxes + Workflows tools. One token grants full account access; no separate sandbox permission. |\r\n| `ALPACACLOUD_API_URL` | Account API base. Defaults to `https://api.alpaca-cloud.com` |\r\n| `ALPACACLOUD_SANDBOX_TEMPLATE` | Default sandbox image (`python`/`node`/`base`). Defaults to `python` |\r\n| `ALPACACLOUD_SANDBOX_NETWORK` | `true` to allow outbound network (pip/npm installs) in new sandboxes. Defaults to `false` |\r\n\r\nHTTP transport (`--http`) requires `MCP_AUTH_TOKEN` unless bound to localhost.\r\n\r\n## Self-describing for any AI\r\n\r\nThe server advertises `tools`, `resources`, and `prompts` so any MCP-capable AI\r\ndiscovers the whole platform on connect — no prior knowledge needed:\r\n\r\n- **Resources** — readable markdown guides: `alpacacloud://overview`, `…/database`,\r\n  `…/auth`, `…/storage`, `…/realtime`, `…/edge-functions`, `…/frontend-hosting`,\r\n  `…/app-hosting`, `…/branching`, `…/backups-pitr`, `…/sandboxes` (beta),\r\n  `…/management-api`. Read `alpacacloud://overview` first.\r\n- **Prompts** — guided workflows: `explore-project`, `build-backend`,\r\n  `add-vector-search`, `setup-auth`, `deploy-site`, `deploy-docker-app`.\r\n- **Tools** — the 23 below, incl. `platform_capabilities` (machine-readable catalog).\r\n\r\n## Tools (23)\r\n\r\n**Discovery**\r\n- `platform_capabilities` — the full catalog of everything Alpaca Cloud can do, and\r\n  which parts are managed here vs via the account Management API. **Call this first.**\r\n- `get_project_info` — REST / auth / realtime endpoints + S3 details.\r\n\r\n**Database (Postgres 16)**\r\n- `run_sql` — any SQL via the service_role `run_sql` RPC (rows for SELECT, `{ok}` for DDL/DML)\r\n- `list_tables` · `get_table_schema` · `create_table` · `list_extensions` (pgvector-ready)\r\n\r\n**Auth (per-project end users)**\r\n- `list_auth_users` · `create_auth_user` · `delete_auth_user`\r\n\r\n**Storage**\r\n- `list_buckets` · `create_bucket` · `list_objects`\r\n  (upload/download/signed URLs via the SDK or the S3 API)\r\n\r\n**Sandboxes — code execution (E2B / Fly Machines style)** · needs `ALPACACLOUD_ACCOUNT_TOKEN`\r\n- `run_code` — one-off: spin up an ephemeral sandbox, run code, tear down\r\n- `create_sandbox` · `run_in_sandbox` · `list_sandboxes` · `delete_sandbox` — persistent sandboxes (exec commands/code, files)\r\n\r\n**Workflows — automation (n8n style, 400+ nodes)** · needs `ALPACACLOUD_ACCOUNT_TOKEN`\r\n- `list_workflows` · `create_workflow` · `run_workflow`\r\n- `list_workflow_node_types` (discover nodes before building) · `list_workflow_templates`\r\n\r\n## Project-scoped vs account-level\r\n\r\nTwo scopes:\r\n- **Project-scoped** (service_role key): Database, Auth, Storage.\r\n- **Account-scoped** (`ALPACACLOUD_ACCOUNT_TOKEN` = a personal access token from the\r\n  dashboard → API Tokens): **Sandboxes** (code execution) and **Workflows** (automation).\r\n  Set it via `--account-token=` or the `ALPACACLOUD_ACCOUNT_TOKEN` env var.\r\n\r\nOther account-wide actions — create projects, deploy frontends/apps, scaling, templates,\r\nalerting, billing — are exposed through the **Management API** (OAuth2) at\r\n`api.alpaca-cloud.com/mgmt/v1` or the dashboard. `platform_capabilities` lists all of it.\r\n\r\n## Security\r\nThe service_role key has full access and bypasses RLS — treat all results as\r\nprivileged. Tool errors are returned as `{ \"error\": \"…\" }` (not thrown). For the\r\nHTTP transport, always set `MCP_AUTH_TOKEN` and keep the bind localhost-only\r\nunless you intend otherwise.\r\n","readmeFilename":"README.md"}