# Prism Coder (MCP server)

> Prism Coder is an MCP server that adds database tools to AI assistants such as Claude Desktop, Claude Code and Cursor. Session memory for coding agents: local-first recall, drift detection, on-device inference. It has 157 GitHub stars, is released under the Apache-2.0 license and runs locally with npx -y prism-mcp-server.

Give your AI agent memory that lasts — and see the cloud tokens it never had to spend. Persistent sessions, knowledge graphs, offline tool-routing, and an auditable savings meter. Fully local and free.

## Key facts

| Fact | Value |
|---|---|
| Repository | https://github.com/dcostenco/prism-coder |
| GitHub stars | 157 |
| License | Apache-2.0 |
| Language | TypeScript |
| Transport | stdio |
| Packages | npm: prism-mcp-server |
| Remote URL | none |
| Needs API key | yes |
| Official | no |
| Works with | Claude Desktop, Claude Code, Cursor, VS Code |
| Category | Databases |
| Latest release | v15.2.1 (May 10, 2026) |
| Last commit | Oct 4, 2026 |
| MCP registry name | io.github.dcostenco/prism-coder |

## Install

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "prism-coder": {
      "command": "npx",
      "args": [
        "-y",
        "prism-mcp-server"
      ],
      "env": {
        "BRAVE_API_KEY": "your-value",
        "GEMINI_API_KEY": "your-value",
        "SUPABASE_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 BRAVE_API_KEY=your-value --env GEMINI_API_KEY=your-value --env SUPABASE_KEY=your-value --transport stdio prism-coder -- npx -y prism-mcp-server
```

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

```json
{
  "mcpServers": {
    "prism-coder": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "prism-mcp-server"
      ],
      "env": {
        "BRAVE_API_KEY": "your-value",
        "GEMINI_API_KEY": "your-value",
        "SUPABASE_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": "brave_api_key",
      "description": "BRAVE_API_KEY",
      "password": true
    },
    {
      "type": "promptString",
      "id": "gemini_api_key",
      "description": "GEMINI_API_KEY",
      "password": true
    },
    {
      "type": "promptString",
      "id": "supabase_key",
      "description": "SUPABASE_KEY",
      "password": true
    }
  ],
  "servers": {
    "prism-coder": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "prism-mcp-server"
      ],
      "env": {
        "BRAVE_API_KEY": "${input:brave_api_key}",
        "GEMINI_API_KEY": "${input:gemini_api_key}",
        "SUPABASE_KEY": "${input:supabase_key}"
      }
    }
  }
}
```

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

## Environment variables

- `BRAVE_API_KEY` (secret): Brave Search API key for web search tools
- `GEMINI_API_KEY` (secret): Google Gemini API key for AI-powered summarization and embeddings
- `SUPABASE_URL`: Supabase project URL for session memory and knowledge persistence
- `SUPABASE_KEY` (secret): Supabase service role key for database access
- `PRISM_USER_ID`: User ID for multi-tenant row-level security isolation (defaults to 'default')
- `GCP_PROJECT_ID`: Google Cloud project ID for Vertex AI Discovery Engine integration
- `VERTEX_LOCATION`: Vertex AI location/region (defaults to 'global')
- `VERTEX_DATA_STORE_ID`: Vertex AI Discovery Engine data store ID for enterprise search

## 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)
- [Butterbase AI MCP Server](https://appsgit.com/mcp-servers/butterbase-ai-mcp-server): Butterbase MCP server — manage your backend: schemas, auth, functions, storage, RAG, deploys. (3,686 stars, Apache-2.0, needs API key)
- [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)

---

Canonical page: https://appsgit.com/mcp-servers/prism-coder
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.