自托管开发环境工具集

Cloud MCP Server  →  Extract tool definitions  →  Generate SKILL.md
                     ("phone book")                (points to self-hosted tools)

cd /Users/lucassaintlaurent/Desktop/Workspace/GitHubVault/OfflineMPCs
source .venv/bin/activate

# Keyword search (fast, exact matches)
./tools/index-docs search "middleware authentication" --fts

# Semantic search (meaning-based, uses vector embeddings)
./tools/index-docs search "how to handle auth in middleware" --vec

# Hybrid search (both combined — default)
./tools/index-docs search "server components" --lib next.js

# Web search (DuckDuckGo)
./tools/search web "python sqlite fts5 tutorial"

# Query CSV/JSON/Parquet directly (no import needed)
./tools/db query "SELECT * FROM 'data.csv' LIMIT 10"

# Query SQLite databases
./tools/db query "SELECT * FROM issues" --db data/projects.db
./tools/db describe data/projects.db

./tools/pm project list
./tools/pm issue create OfflineMPCs "Add new docs repo" --priority high
./tools/pm issue list --status open
./tools/pm stats

./tools/msg send general "Build phase complete"
./tools/msg read general
./tools/msg search "authentication"

cd local-software
./start.sh                    # Start everything + open browser
./start.sh outline            # Start only Outline (http://localhost:3000)
./start.sh plane              # Start only Plane (http://localhost:8080)
./start.sh stop               # Stop all services
./start.sh logs               # Tail logs
./start.sh status             # Check what's running

source .venv/bin/activate
./tools/index-docs build --fts            # Rebuild keyword index (~16s)
./tools/index-docs build --vec --force    # Rebuild vector index (slow, one-time)
./tools/index-docs stats                  # Check index stats
./tools/index-docs libs                   # List indexed libraries

OfflineMPCs/
├── mcp-phonebooks/          # 11 cloned MCP server repos (REFERENCE ONLY)
│   ├── official-servers/        # filesystem (14), git (12), memory (9), fetch (1)
│   ├── github-mcp/              # 82 tools
│   ├── playwright-mcp/          # 26 tools
│   ├── notion-mcp/              # 22 tools
│   ├── atlassian-mcp/           # 46 tools (Jira 34 + Confluence 12)
│   ├── markdownify-mcp/         # 10 tools
│   ├── docker-mcp/              # 0 tools (gateway only)
│   ├── context7-mcp/            #  2 tools
│   ├── exa-mcp/                 #  9 tools
│   ├── firecrawl-mcp/           #  8 tools
│   └── supabase-mcp/            # 32 tools
│
├── skills/                  # SKILL.md files (ALL 11 READY)
│   ├── docs-lookup/SKILL.md     # ✓ Context7 → rg over local docs (4 ops)
│   ├── file-ops/SKILL.md        # ✓ Filesystem MCP → bash, find, rg (14 ops)
│   ├── git-ops/SKILL.md         # ✓ Git MCP → git CLI + gh CLI (12 ops)
│   ├── memory/SKILL.md          # ✓ Memory MCP → local JSON/SQLite (9 ops)
│   ├── container-ops/SKILL.md   # ✓ Docker MCP → docker CLI (14 ops)
│   ├── doc-conversion/SKILL.md  # ✓ Markdownify → Pandoc, Docling (10 ops)
│   ├── browser/SKILL.md         # ✓ Playwright → MCP stays live (26 ops)
│   ├── search/SKILL.md          # ✓ Exa/Firecrawl → ddgr + SQLite FTS5 (19 ops)
│   ├── database/SKILL.md        # ✓ Supabase → DuckDB + SQLite (15 ops)
│   ├── project-management/SKILL.md # ✓ Jira/Notion → SQLite CLI (16 ops)
│   └── messaging/SKILL.md       # ✓ Slack → SQLite messaging (12 ops)
│
├── docs/                    # 50 cloned library repos (~5.4 GB) — DATA IS HERE
│   ├── python/              # cpython, flask, django, fastapi, pydantic, requests,
│   │                        # sqlalchemy, pytest, pandas, numpy, pytorch,
│   │                        # transformers, langchain, llama_index
│   ├── javascript/          # node, next.js, react, vue, svelte, express, hono,
│   │                        # zod, tailwindcss, prisma, drizzle-orm, trpc, shadcn-ui
│   ├── rust/                # rust, rust-book, tokio, serde, axum, clap
│   ├── go/                  # go, gin, fiber, gorm
│   ├── ai-ml/               # anthropic-sdk, openai-sdk, diffusers, vllm,
│   │                        # llama.cpp, ollama, docling, chromadb, qdrant
│   └── infra/               # docker-docs, kubernetes, terraform, nginx
│
├── tools/                   # ✓ CLI wrapper scripts (ALL 5 BUILT)
│   ├── index-docs               # ✓ Python: hybrid FTS5 + ChromaDB vector search (430 lines)
│   ├── search                   # ✓ Python: unified local + web search (175 lines)
│   ├── db                       # ✓ Bash: DuckDB + SQLite query wrapper (205 lines)
│   ├── pm                       # ✓ Python: project management CRUD (310 lines)
│   └── msg                      # ✓ Python: agent messaging + channels (290 lines)
│
├── data/                    # ✓ SQLite databases (CREATED)
│   ├── docs-index.db            # ✓ FTS5 search index (163,973 chunks, 50 libraries)
│   ├── chromadb/                # ✓ Vector embeddings (all-MiniLM-L6-v2)
│   ├── projects.db              # ✓ Project management data
│   └── messages.db              # ✓ Agent messaging data (5 default channels)
│
├── .venv/                   # Python virtual environment (chromadb + deps)
│
├── local-software/             # Docker Compose configs (OPTIONAL web UIs)
│   ├── start.sh                    # ✓ Launcher script (macOS/Linux) — start, stop, status, logs
│   ├── start.ps1                   # ✓ Launcher script (Windows PowerShell)
│   ├── outline/                    # ✓ Knowledge base (Notion replacement)
│   │   ├── docker-compose.yml      #   3 containers: app + PostgreSQL + Valkey
│   │   └── docker.env              #   Environment config
│   └── plane/                      # ✓ Project boards (Jira replacement)
│       ├── docker-compose.yml      #   12 containers: full stack
│       └── plane.env               #   Environment config
│
├── manifests/
│   ├── phonebook-index.json     # 273 tool definitions from 11 MCPs
│   ├── clone-manifest.json      # 50 doc repos with hashes + sizes
│   └── skill-registry.json      # 11 ready skills + test results
│
└── tests/
    ├── test-structure.sh            # Level 1: structural validation
    ├── test-dependencies.sh         # Level 2: dependency validation
    ├── test-functional.sh           # Level 3: functional validation
    └── results/                     # JSON test results with timestamps

brew install ripgrep pandoc duckdb
pip install docling chromadb

# Resolve a library
find docs/ -maxdepth 2 -type d -iname "*next.js*"

# Search its docs
rg -n -C 3 --type md "middleware" docs/javascript/next.js/docs/

# Browse its API
rg -n "^export (default |const |function |class )" docs/javascript/next.js/packages/ --type ts | head -50

cd /Users/lucassaintlaurent/Desktop/Workspace/GitHubVault/OfflineMPCs

# Update doc repos
find docs/ -maxdepth 3 -name ".git" -type d | while read g; do
  r=$(dirname "$g"); echo "Updating $r..."; (cd "$r" && git pull --ff-only 2>/dev/null)
done

# Update MCP phone books
find mcp-phonebooks/ -maxdepth 2 -name ".git" -type d | while read g; do
  r=$(dirname "$g"); echo "Updating $r..."; (cd "$r" && git pull --ff-only 2>/dev/null)
done