pip install -e .

-- Connect to your PostgreSQL instance
CREATE DATABASE zotero_mcp;
CREATE USER zotero_user WITH PASSWORD 'your_password';
GRANT ALL PRIVILEGES ON DATABASE zotero_mcp TO zotero_user;

-- Enable pg-vector extension
\c zotero_mcp
CREATE EXTENSION vector;

zotero-mcp setup

{
  "mcpServers": {
    "zotero": {
      "command": "/path/to/zotero-mcp",
      "env": {
        "ZOTERO_DB_HOST": "your_host",
        "ZOTERO_DB_NAME": "zotero_mcp",
        "ZOTERO_EMBEDDING_PROVIDER": "ollama",
        "OLLAMA_HOST": "your_ollama_host"
      }
    }
  }
}

{
  "database": {
    "host": "localhost",
    "port": 5432,
    "database": "zotero_mcp",
    "username": "zotero_user",
    "password": "your_password",
    "schema": "public",
    "pool_size": 5
  },
  "embedding": {
    "provider": "ollama",
    "openai": {
      "api_key": "sk-...",
      "model": "text-embedding-3-small",
      "batch_size": 100
    },
    "ollama": {
      "host": "192.168.1.189:8182",
      "model": "nomic-embed-text",
      "timeout": 60
    }
  },
  "chunking": {
    "chunk_size": 1000,
    "overlap": 100,
    "min_chunk_size": 100,
    "max_chunks_per_item": 10,
    "chunking_strategy": "sentences"
  },
  "semantic_search": {
    "similarity_threshold": 0.7,
    "max_results": 50,
    "update_config": {
      "auto_update": false,
      "update_frequency": "manual",
      "batch_size": 50,
      "parallel_workers": 4
    }
  }
}

# Initial database population
zotero-mcp update-db --force-rebuild

# Incremental updates
zotero-mcp update-db

# Update with limit (for testing)
zotero-mcp update-db --limit 100

# Check status
zotero-mcp status

{
  "embedding": {
    "provider": "openai",
    "openai": {
      "api_key": "sk-...",
      "model": "text-embedding-3-small",
      "batch_size": 100,
      "rate_limit_rpm": 3000
    }
  }
}

{
  "embedding": {
    "provider": "ollama", 
    "ollama": {
      "host": "http://localhost:11434",
      "model": "nomic-embed-text",
      "timeout": 60
    }
  }
}

ollama pull nomic-embed-text

┌─────────────────┐    ┌─────────────────┐
│   Claude MCP    │───▶│  FastMCP Server │
│    Client       │    │   (server.py)   │
└─────────────────┘    └─────────────────┘
                               │
                               ▼
                    ┌─────────────────┐
                    │ Semantic Search │
                    │ (semantic_search.py) │
                    └─────────────────┘
                               │
                    ┌──────────┴──────────┐
                    ▼                     ▼
              ┌──────────────┐    ┌──────────────┐
              │ Vector Client│    │  Embedding   │
              │(vector_client)│    │   Service    │
              └──────────────┘    │(embedding_   │
                     │            │ service.py)  │
                     ▼            └──────────────┘
              ┌──────────────┐           │
              │ PostgreSQL   │           ▼
              │   + pgvector │    ┌──────────────┐
              └──────────────┘    │ OpenAI/Ollama│
                                  │   APIs       │
                                  └──────────────┘

-- Core embeddings table
CREATE TABLE zotero_embeddings (
    id SERIAL PRIMARY KEY,
    item_key VARCHAR(50) UNIQUE NOT NULL,
    item_type VARCHAR(50) NOT NULL,
    title TEXT,
    content TEXT NOT NULL,
    content_hash VARCHAR(64) NOT NULL,
    embedding vector(1536),
    embedding_model VARCHAR(100) NOT NULL,
    embedding_provider VARCHAR(50) NOT NULL,
    metadata JSONB NOT NULL DEFAULT '{}',
    created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);

-- Optimized indexes
CREATE INDEX idx_zotero_embedding_cosine 
    ON zotero_embeddings USING ivfflat (embedding vector_cosine_ops) 
    WITH (lists = 100);
CREATE INDEX idx_zotero_metadata_gin 
    ON zotero_embeddings USING gin(metadata);