MCP D1 Submissions

MCP D1提交材料

Cloudflare Worker（Python）充当MCP服务器，用于向Cloudflare D1数据库提交黑客马拉松/项目条目。

添加到克劳德代码

claude mcp add impact-lab-submissions --transport http https://mcp-submissions.casper-studios.workers.dev/mcp

设置

先决条件

• （适用于牧马人CLI）
• Cloudflare帐户

安装牧马人

npm install -g wrangler
wrangler login

创建D1数据库

wrangler d1 create mcp-submissions-db

复制 database_id 从输出和替换 ` 在 wrangler.toml`.

应用架构

wrangler d1 execute mcp-submissions-db --remote --file=schema.sql

部署

wrangler deploy

MCP工具

submit_project

提交黑客马拉松/项目参赛作品。

参数：

submitted_at 是自动生成的服务器端（ISO 8601 UTC）。

连接MCP客户端

添加到MCP客户端配置（例如Claude Desktop claude_desktop_config.json):

{
  "mcpServers": {
    "submissions": {
      "url": "https://mcp-submissions.casper-studios.workers.dev/mcp"
    }
  }
}

卷曲测试

# Initialize
curl -X POST https://mcp-submissions.casper-studios.workers.dev/mcp \
  -H "Content-Type: application/json" \
  -d '{"jsonrpc":"2.0","id":1,"method":"initialize","params":{}}'

# List tools
curl -X POST https://mcp-submissions.casper-studios.workers.dev/mcp \
  -H "Content-Type: application/json" \
  -d '{"jsonrpc":"2.0","id":2,"method":"tools/list","params":{}}'

# Submit a project
curl -X POST https://mcp-submissions.casper-studios.workers.dev/mcp \
  -H "Content-Type: application/json" \
  -d '{"jsonrpc":"2.0","id":3,"method":"tools/call","params":{"name":"submit_project","arguments":{"team_name":"Team Alpha","github_url":"https://github.com/team-alpha/project","problem_statement":"Solving X with Y"}}}'

本地开发

wrangler dev

然后使用 http://localhost:8787/mcp 作为终点。