VS Code Copilot MCP服务

User: In Project #2, set the "Status" field to "In Progress" and "Priority" to "High" for issues #73 and #42
Copilot: [Uses bulk-set-project-field-values to update both issues]

# Required for database features
DATABASE_URL=postgresql://user:password@localhost:5432/dbname

# Required for GitHub Issues and Projects tools
GITHUB_TOKEN=ghp_your_personal_access_token

# Optional: For HTTP MCP transport authentication
# When `MCP_API_KEY` is set, MCP transport endpoints (eg. `/mcp`) and DB-dependent routes (`/api/*` for books/authors/ratings) require `Authorization: Bearer <MCP_API_KEY>`.
MCP_API_KEY=your-secret-key

> Note: The gateway key may also be sent via the `X-Mcp-Api-Key` header. This is a first-class, supported second factor for callers whose `Authorization` header already carries a Supabase user JWT (e.g. the website's admin requests, which send `Authorization: Bearer <SUPABASE_JWT>` + `X-Mcp-Api-Key: <MCP_API_KEY>`). Pure MCP clients may instead send the key directly as `Authorization: Bearer <MCP_API_KEY>`.

# Optional: For admin endpoints
INTERNAL_ADMIN_KEY=your-admin-key
ADMIN_DEBUG_ENABLED=true

# Optional: Sentry error alerting. When SENTRY_DSN is set, unhandled errors and
# every logger.error are reported to Sentry. Unset = disabled (dev/test default).
SENTRY_DSN=https://<key>@o<org>.ingest.sentry.io/<project>
# SENTRY_ENVIRONMENT=production        # defaults to NODE_ENV
# SENTRY_TRACES_SAMPLE_RATE=0          # 0..1; 0 = errors only (no perf tracing)
# SENTRY_RELEASE=mcp-server@0.1.0

{
  "servers": {
    "bryan-debaun-mcp": {
      "type": "http",
      "url": "https://mcp-server.onrender.com/mcp",
      "headers": {
        "Authorization": "Bearer ${input:mcpApiKey}"
      }
    }
  },
  "inputs": [
    {
      "id": "mcpApiKey",
      "type": "promptString",
      "description": "MCP API Key",
      "password": true
    }
  ]
}

{
  "servers": {
    "bryan-debaun-mcp-local": {
      "type": "stdio",
      "command": "node",
      "args": ["C:/path/to/mcp-server/dist/index.js"],
      "env": {
        "MCP_TRANSPORT": "stdio"
      }
    }
  }
}

{
  "servers": {
    "bryan-debaun-mcp": {
### VS Code Copilot

Once configured, the MCP tools are available in VS Code Copilot chat:

1. Open Copilot Chat (`Ctrl+Alt+I`)
2. Enable the MCP server from the Tools picker
3. Ask questions like:
   - "List open issues in bryan-debaun/mcp-server"
   - "Show me issue #2 in bryan-debaun/mcp-server"
   - "Create an issue titled 'Bug fix' in owner/repo"
   - "Close issue #5 in owner/repo with comment 'Fixed in PR #10'"
   - "List all books in the catalog"
   - "Show me books by Brandon Sanderson"

### HTTP API

The server also exposes HTTP endpoints for direct access:

#### Books

```bash
# List books
curl http://localhost:8080/api/books?limit=10

# Get book by ID
curl http://localhost:8080/api/books/1

# Create book (requires admin JWT)
curl -X POST http://localhost:8080/api/books \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_JWT" \
  -H "X-INTERNAL-KEY: YOUR_ADMIN_KEY" \
  -d '{
    "title": "New Book",
    "description": "A great book",
    "isbn": "978-1234567890",
    ├── db/
│   │   └── index.ts          # Prisma client initialization
│   ├── http/
│   │   ├── server.ts         # HTTP server setup
│   │   ├── books-route.ts    # Book catalog endpoints
│   │   ├── authors-route.ts  # Author endpoints
│   │   └── ratings-route.ts  # Rating endpoints
│   └── tools/
│       ├── index.ts          # Tool registration aggregator
│       ├── local.ts          # Tool dispatcher for HTTP routes
│       ├── github-issues/    # GitHub Issues tool category
│       │   ├── index.ts      # Registers all issue tools
│       │   ├── schemas.ts    # Zod schemas for inputs
│       │   ├── gh-cli.ts     # GitHub CLI wrapper
│       │   ├── results.ts    # Result helpers
│       │   └── *.ts          # Individual tool implementations
│       └── db/               # Database tool categories
│           ├── books/        # Book CRUD tools
│           ├── authors/      # Author CRUD tools
│           └── ratings/      # Rating CRUD tools
├── prisma/
│   ├── schema.prisma         # Database schema
│   ├── seed.ts               # Initial data seeding
│   └── migrations/           # Database migr
  -H "X-INTERNAL-KEY: YOUR_ADMIN_KEY" \
  -d '{"title": "Updated Title"}'

# Delete book
curl -X DELETE http://localhost:8080/api/books/1 \
  -H "Authorization: Bearer YOUR_JWT" \
  -H "X-INTERNAL-KEY: YOUR_ADMIN_KEY"

# List authors
curl http://localhost:8080/api/authors?limit=10

# Get author by ID (includes their books)
curl http://localhost:8080/api/authors/1

# Create author (requires admin JWT)
curl -X POST http://localhost:8080/api/authors \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_JWT" \
  -H "X-INTERNAL-KEY: YOUR_ADMIN_KEY" \
  -d '{
    "name": "New Author",
    "bio": "Author biography",
    "website": "https://example.com"
  }'

# List all ratings
curl http://localhost:8080/api/ratings?limit=10

# Get my ratings (requires JWT)
curl http://localhost:8080/api/users/me/ratings \
  -H "Authorization: Bearer YOUR_JWT"

# Create or update rating (requires JWT)
curl -X POST http://localhost:8080/api/ratings \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_JWT" \
  -d '{
    "bookId": 1,
    "rating": 8,
    "review": "Great book!"
  }'

# Delete rating (requires JWT, owner or admin)
curl -X DELETE http://localhost:8080/api/ratings/1 \
  -H "Authorization: Bearer YOUR_JWT"

# Build
pnpm run build

# Watch mode (rebuild on changes)
pnpm run dev

# Run tests
pnpm test

# Run tests in watch mode
pnpm run test:watch

# Type check
pnpm run typecheck

mcp-server/
├── src/
│   ├── index.ts              # Entry point, stdio transport setup
│   ├── server.ts             # McpServer factory
│   └── tools/
│       ├── index.ts          # Tool registration aggregator
│       └── github-issues/    # GitHub Issues tool category
│           ├── index.ts      # Registers all issue tools
│           ├── schemas.ts    # Zod schemas for inputs
│           ├── gh-cli.ts     # GitHub CLI wrapper
│           ├── results.ts    # Result helpers
│           └── *.ts          # Individual tool implementations
├── test/                     # Tests mirror src structure
├── dist/                     # Compiled output
└── .vscode/
    └── mcp.json              # VS Code MCP configuration