A backend built for agents to push around

What it does

Butterbase is a self-hostable backend-as-a-service that bundles Postgres with row-level security, serverless functions on Deno, file storage, realtime WebSockets, and an AI gateway into one control plane. It also ships a Model Context Protocol (MCP) server that exposes every capability—schema migrations, auth config, KV storage, RAG—as callable tools, so an agent can operate the backend directly rather than calling REST endpoints through hand-written wrappers.

The interesting bit

The project leans hard into being “AI-native”: it includes a Claude Code plugin with over 30 guided skills that walk an agent from idea to deployment, effectively treating the backend as infrastructure that builds itself. The architecture separates concerns into three Postgres planes—control, runtime, and per-app data—to keep tenant metadata, hot-path sessions, and user data isolated.

Key highlights

• Full BaaS feature set: declarative Postgres schemas with auto-generated REST endpoints, OAuth/email auth, S3/R2-backed storage, and durable per-key actors.
• Built-in AI gateway and RAG pipeline for chat, embeddings, and semantic search, plus Composio integrations for third-party tools.
• MCP server available over HTTP at /mcp and as a stdio binary (@butterbase/mcp), turning the entire backend into an agent tool surface.
• Self-hosted runtime includes unlimited quotas and no-op billing, but requires wiring your own BillingProvider, QuotaEnforcer, and RouterAdapter interfaces for production-grade AI routing.
• Multi-region app moves with retained source replicas, plus edge SSR and frontend hosting via Cloudflare Workers.

Caveats

• The Claude Code plugin lives in a git submodule that is empty on a default clone, so the agentic app-building workflow breaks silently if you skip --recurse-submodules.
• Local setup is not turnkey: schema migrations, user seeding, and environment wiring are manual, and the AI gateway runs without upstream router adapters in self-hosted mode.
• The managed offering at butterbase.ai holds the orchestration, billing, and ops dashboards; this repo is the runtime data plane only.

Verdict

Worth a look if you want a Supabase-flavored backend that agents can provision and mutate through MCP tools. Skip it if you need a fully managed, zero-config SaaS—this is a bring-your-own-orchestration runtime.