Скачать или смотреть Build a Google Authenticated CloudFlare MCP Worker for ChatGPT - Step By Step

In this tutorial, we are going to build our first remote MCP server using CloudFlare + Google Authentication. We will use KV namespace to store client id and secrets and connect to D1 Sql database to allow MCP client to do DB operations.
Later, I'll show you how to connect this MCP server to ChatGPT.

Here's the Github of today's project (all important steps are mentioned):
https://github.com/ross-jill-ws/cloud...

Here's CloudFlare's MCP authentication library:
https://github.com/cloudflare/ai/tree...

If you want to do everything from scratch (like what we did in the video), start with the following CLI command:
`
npm create cloudflare@latest -- my-mcp-server --template=cloudflare/ai/demos/remote-mcp-google-oauth
`

Here's the Prompt to fix Google Auth c.env error:
`
Please replace all occurrences of `c.env.xxxxx` with `c.env.OAUTH_KV.get('xxxxx') ?? ''`
`

Here's the Prompt in AI Coder to add DB tools:
`
Remove this `add` tool, but add database tools like below:\
listTables: list all the tables from d1 EMPLOYEES db\\
readSchema: read the table schema of the given db table
query: only allow 'SELECT' sql statement and JOIN on the tables listed by listTables tool\
createOrUpdate: create or update data of the given table and conditions\
delete: delete data from the given table and conditions
`

Here's the prompt to fix (ignore) type errors:
`
There are typescript errors on: this.env.EMPLOYEES. can you use (this.env as any) to fix them?
`