MCP Server: Demo

What is MCP Server: Demo?

MCP Server: Demo is a demonstration MCP (Model Context Protocol) server built with the @modelcontextprotocol/sdk and Cloudflare's MCPAgent. It connects to a D1 database and provides tools for an LLM to query and introspect database schemas. Designed for developers learning to build MCP servers that access real database information.

How to use MCP Server: Demo?

Clone the repository, install dependencies with npm install, then run npm run dev for local development or npm run deploy to deploy to Cloudflare Workers. Integration tests are available with npm run test.

Key features of MCP Server: Demo

• Provides a query tool for sending SQL queries to the database.
• Includes a schema-introspection tool to help the LLM understand database structure.
• Implemented as a Cloudflare Durable Object with SSE transport.
• SQL migration files (up.sql, down.sql, seed.sql) for schema management.
• Built with the @modelcontextprotocol/sdk and MCPAgent.

Use cases of MCP Server: Demo

• Allowing an LLM to query a database and return results.
• Helping an LLM understand database schema before generating queries.
• Demonstrating how to build an MCP server connected to a Cloudflare D1 database.
• Using integration tests with vitest to validate server and tool functionality.

FAQ from MCP Server: Demo

What tools does MCP Server: Demo provide?

It provides two tools: query for sending SQL queries to the database, and schema-introspection for retrieving the database schema.

How is MCP Server: Demo deployed?

It is deployed to Cloudflare Workers using the Wrangler CLI: npm run deploy.

What transport does the server use?

It uses Server-Sent Events (SSE) as the transport, implemented via Cloudflare’s Durable Object.

What dependencies are required?

Requires Node.js and the Cloudflare Workers CLI (wrangler).

Is MCP Server: Demo intended for production use?

No, it is a demonstration. The query tool should be used with care and proper authorization in production.