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 Streamable HTTP transport for Claude Code, Claude Desktop, Cursor, and Windsurf. No bridge required.

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

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

Streamable HTTP

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

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

Cursor

Streamable HTTP

Add to Cursor MCP settings:

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

Claude Code

Native HTTP

Native Streamable HTTP transport via CLI, no bridge needed:

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

# Or add via the legacy SSE transport
claude mcp add --transport sse cameodb http://localhost:9480/mcp/sse

# Verify connection
claude mcp get cameodb
claude mcp list

# Inside Claude Code, type /mcp to check status

Claude Desktop

Native HTTP

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

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

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 (2025-06-18) Negotiates the protocol version on initialize: 2025-06-18 by default, falling back to 2025-03-26 or 2024-11-05 when a client asks for one. Proper JSON-RPC 2.0, with structured endpoint and message events on the legacy SSE transport.
hub

Multiple Transport Modes Streamable HTTP on a single endpoint — POST, GET and DELETE /mcp — plus the legacy HTTP+SSE transport (GET /mcp/sse, POST /mcp/messages) and a POST /mcp/sse compatibility endpoint for already-configured clients.
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