# Butterbase AI MCP Server (MCP server)

> Butterbase AI MCP Server is an MCP server that adds database tools to AI assistants such as Claude Desktop, Claude Code and Cursor. Butterbase MCP server — manage your backend: schemas, auth, functions, storage, RAG, deploys. It has 3,686 GitHub stars, is released under the Apache-2.0 license and runs locally with npx -y @butterbase/mcp.

The official Model Context Protocol server for Butterbase — manage schemas, auth, functions, storage, RAG, realtime, and deploys on Butterbase from any MCP-capable client (Claude Code, Claude Desktop, Cursor, Windsurf, etc.).

## Key facts

| Fact | Value |
|---|---|
| Repository | https://github.com/butterbase-ai/butterbase |
| GitHub stars | 3,686 |
| License | Apache-2.0 |
| Language | TypeScript |
| Transport | stdio, streamable-http |
| Packages | npm: @butterbase/mcp |
| Remote URL | https://api.butterbase.ai/mcp |
| Needs API key | yes |
| Official | no |
| Works with | Claude Desktop, Claude Code, Cursor, VS Code, Claude.ai, ChatGPT |
| Category | Databases |
| Latest release | none |
| Last commit | Oct 6, 2026 |
| MCP registry name | io.github.butterbase-ai/mcp |

## Install

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "butterbase-ai-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@butterbase/mcp"
      ],
      "env": {
        "BUTTERBASE_API_KEY": "your-value"
      }
    }
  }
}
```

Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.

### Claude Code

```sh
claude mcp add --env BUTTERBASE_API_KEY=your-value --transport stdio butterbase-ai-mcp-server -- npx -y @butterbase/mcp
```

### Cursor (.cursor/mcp.json)

```json
{
  "mcpServers": {
    "butterbase-ai-mcp-server": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@butterbase/mcp"
      ],
      "env": {
        "BUTTERBASE_API_KEY": "your-value"
      }
    }
  }
}
```

Project file; use ~/.cursor/mcp.json to enable it in every project.

### VS Code (.vscode/mcp.json)

```json
{
  "inputs": [
    {
      "type": "promptString",
      "id": "butterbase_api_key",
      "description": "BUTTERBASE_API_KEY",
      "password": true
    }
  ],
  "servers": {
    "butterbase-ai-mcp-server": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@butterbase/mcp"
      ],
      "env": {
        "BUTTERBASE_API_KEY": "${input:butterbase_api_key}"
      }
    }
  }
}
```

### Claude Code (remote)

```sh
claude mcp add --transport http butterbase-ai-mcp-server "https://api.butterbase.ai/mcp"
```

The same server is also hosted as a remote MCP endpoint, so nothing runs on your machine.

Config formats checked against the official docs on 2026-10-07.

## Environment variables

- `BUTTERBASE_API_KEY` (secret) (required): Butterbase API key (bbsk...). Create one at https://butterbase.ai.

## Similar MCP servers

- [Dbx](https://appsgit.com/mcp-servers/dbx): Query databases from AI agents using connections configured in DBX. (24,945 stars, Apache-2.0)
- [DBHub](https://appsgit.com/mcp-servers/dbhub): Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite. (3,610 stars, MIT, needs API key)
- [LINQ to DB](https://appsgit.com/mcp-servers/linq-to-db): Inspect database schemas and execute SQL queries across multiple database providers with LINQ to DB. (3,332 stars, MIT)
- [Mindwtr](https://appsgit.com/mcp-servers/mindwtr): Task automation via SQLite, desktop Local API, or Mindwtr Cloud; read-only by default. (2,211 stars, AGPL-3.0, needs API key)
- [MCP Memory Service](https://appsgit.com/mcp-servers/mcp-memory-service): Open-source persistent memory for AI agent pipelines (LangGraph, CrewAI, AutoGen) and Claude. (1,988 stars, Apache-2.0)
- [Pg Aiguide](https://appsgit.com/mcp-servers/pg-aiguide): Comprehensive PostgreSQL documentation and best practices, including ecosystem tools. (1,857 stars, Apache-2.0, needs API key)

---

Canonical page: https://appsgit.com/mcp-servers/butterbase-ai-mcp-server
Source: appsgit (https://appsgit.com), the app store for github. Data from the GitHub API, refreshed nightly.
Machine access: JSON API https://appsgit.com/api/v1/apps (OpenAPI: https://appsgit.com/openapi.json), MCP server https://mcp.appsgit.com/mcp, full index https://appsgit.com/llms-full.txt.