Quickstart

What you need

The endpoint: https://mcp.911cpb.org/mcp
The auth token, stored in ~/projects/911cpb-mcp/.secrets as MCP_AUTH_TOKEN=...

Check that the server is up

export MCP_AUTH_TOKEN=$(cut -d= -f2 ~/projects/911cpb-mcp/.secrets)

curl -s https://mcp.911cpb.org/mcp \
  -H 'Content-Type: application/json' \
  -H 'Accept: application/json, text/event-stream' \
  -H "Authorization: Bearer $MCP_AUTH_TOKEN" \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/list"}'

The response is a Server-Sent Events message listing list_tables, describe_table and query.

Run a query

curl -s https://mcp.911cpb.org/mcp \
  -H 'Content-Type: application/json' \
  -H 'Accept: application/json, text/event-stream' \
  -H "Authorization: Bearer $MCP_AUTH_TOKEN" \
  -d '{"jsonrpc":"2.0","id":2,"method":"tools/call","params":{"name":"query","arguments":{"sql":"select count(*) from \"Note\""}}}'

Next steps