MCP Stack Setup Guide - WSL Ubuntu 22.04

SSOT Documentation - Last Updated: 2024-12-07

1. Ολοκληρωμένα Βήματα ✅

# WSL & Project Setup
wsl -d Ubuntu-22.04
cd ~/projects/LegalTextAnalysis
source .venv/bin/activate

# Dependencies
pip install mcp-server-sqlite python-dotenv httpx sqlalchemy

# Database Structure
mkdir -p data docs scripts/pipeline logs config
touch data/legal_text.db

# Database Schema
sqlite3 data/legal_text.db ".tables"
# Output: legal_cases text_metrics

# MCP Inspector
npm install -g @modelcontextprotocol/inspector

2. Επόμενα Βήματα

1. Claude Desktop Integration:

# Create Claude Desktop config
cat > ~/.config/claude/claude_desktop_config.json << EOL
{
  "mcpServers": {
    "sqlite": {
      "command": "mcp-server-sqlite",
      "args": ["--db-path", "/home/alex/projects/LegalTextAnalysis/data/legal_text.db"],
      "cwd": "/home/alex/projects/LegalTextAnalysis",
      "env": {
        "PYTHONIOENCODING": "utf-8",
        "UV_FORCE_STDIO": "1",
        "DEBUG": "mcp:*,sqlite:*"
      }
    }
  }
}
EOL

1. Start Services:

# Terminal 1 - MCP Server
mcp-server-sqlite --db-path data/legal_text.db

# Terminal 2 - MCP Inspector (Debug)
npx @modelcontextprotocol/inspector

3. Verification Tests

-- Test database setup
sqlite3 data/legal_text.db << EOF
SELECT name FROM sqlite_master WHERE type='table';
.tables
.schema legal_cases
.schema text_metrics
EOF

4. Next Chat Focus Points

1. Claude Desktop connection verification
2. Sample data insertion
3. Query testing through MCP