The AI CameoDB Way (MCP)

auto_awesome

Zero to AI in 60 Seconds

Import your own data (or try our examples) and instantly communicate with that knowledgebase via your favorite AI interface. No middleware required.

database

1. Ingest Data

Use the CLI to load our Books or TED Talks examples, or your own CSV/TSV.

data load books https://dl.cameodb.com/examples/data/booksummaries.tsv

settings_ethernet

2. Connect Agent

Native SSE transport for Claude Code, Claude Desktop, Cursor, and Windsurf. No bridge required.

"url": "http://localhost:9480/mcp/sse"

forum

3. Start Asking

The agent automatically discovers your schemas and queries the cluster.

"Find me books about space opera written in the 1990s."

cable Client Configurations

Note: CameoDB defaults to port 9480. The MCP endpoints are nested natively under the /mcp path.

Windsurf

SSE Transport

Add to .windsurf/mcp.json or via Settings → MCP:

{
  "mcpServers": {
    "cameodb": {
      "url": "http://localhost:9480/mcp/sse",
      "transport": "sse"
    }
  }
}

Cursor

SSE Transport

Add to Cursor MCP settings:

{
  "mcpServers": {
    "cameodb": {
      "url": "http://localhost:9480/mcp/sse",
      "transport": "sse"
    }
  }
}

Claude Code

Native SSE

Native SSE transport via CLI, no bridge needed:

# Add via CLI (project-scoped)
claude mcp add --transport sse cameodb http://localhost:9480/mcp/sse

# Or add as Streamable HTTP
claude mcp add --transport http cameodb http://localhost:9480/mcp

# Verify connection
claude mcp get cameodb
claude mcp list

# Inside Claude Code, type /mcp to check status

Claude Desktop

Native SSE

Add to ~/Library/Application Support/Claude/claude_desktop_config.json:

{
  "mcpServers": {
    "cameodb": {
      "type": "sse",
      "url": "http://localhost:9480/mcp/sse"
    }
  }
}

For auth headers, add "headers" object with Authorization key.

build Available MCP Tools, Prompts & Resources

6 tools, 1 prompt, and 4 resource URIs exposed securely (Read-Only) to the AI agent.

search_index Tool

Execute full-text search on a single CameoDB index.

Parameters

index (req)
query (req)
limit (opt)
fields (opt array)

"arguments": {
  "index": "papers",
  "query": "machine learning AND year:[2020 TO 2024]",
  "limit": 10,
  "fields": ["title", "author"]
}

search_indexes Federated

Execute federated search across multiple CameoDB indexes with per-index field projection.

"arguments": {
  "indexes": [
    {"index": "papers", "fields": ["title", "author"]},
    {"index": "books", "fields": ["title", "isbn"]}
  ],
  "query": "rust programming",
  "limit": 20
}

validate_query Linter

Validates query syntax against the schema. Returns fuzzy "did you mean" suggestions for unknown fields and syntax tips.

get_index

Retrieve schema and statistics for a single index.

list_indexes

List all available indexes and their schemas.

get_index_stats

Document counts, size, and aggregated cluster metadata.

cameodb-orchestrator Prompt

Universal data retrieval and orchestration skill injected into agent context. Guides the agent through schema discovery, query construction, and result interpretation.

Resource URIs

cameodb://indexes
cameodb://indexes/{index}
cameodb://indexes/{index}/schema
cameodb://indexes/{index}/stats

Self-Contained Discovery

Every index response includes per-field query hints. Agents go from zero knowledge to well-formed queries in two tool calls (list_indexes to search_index) with no prior configuration.

account_tree Implementation & Transport

dns

Shared-Port Architecture Runs in the same binary as CameoDB, sharing the same AppState and actor system. No sidecars needed.
rule

Strict Spec Compliance (2024-11-05) Implements proper JSON-RPC 2.0 over SSE. Emits structured endpoint and message events.
hub

Multiple Transport Modes Supports SSE (GET /mcp/sse), direct HTTP JSON-RPC (POST /mcp), and compatibility endpoint (POST /mcp/sse) for maximum client compatibility.
bolt

Asynchronous Processing Client POSTs to /mcp/messages are non-blocking. Server immediately returns 202 Accepted and processes via background tokio::spawn.
hourglass_empty

Session Management Automatic session registry with a 5-minute timeout cleanup. Keepalive messages sent every 15 seconds to maintain connection.

Agent Query Syntax

Agents use the validate_query tool to learn this dynamically, but here is the reference.

Syntax Type	Example Format
Basic Search	machine learning
Field-Targeted	title:rust
Phrase	title:"rust programming"
Boolean Operators	(title:rust OR title:go) AND year:[2020 TO 2024]
Range / Numeric	price:[10.0 TO *]
Date Comparisons	created_at:>2024-01-01
Inline Modifiers	title:rust return title,author limit 5

AI interface to your Data