Skip to main content
Glama

Cloudflare Remote PostgreSQL Database MCP Server

prp-mcp-create.md4.85 kB
--- name: "prp-mcp-create" description: This command is designed to create a comprehensive Product Requirement Prompt (PRP) for building Model Context Protocol (MCP) servers referencing this codebase patterns mirroring tool setups for the users specific requirements. Usage: /prp-mcp-create path/to/prp.md Example usage: /prp-mcp-create weather-server "MCP server for weather data with API integration" Example usage: /prp-mcp-create file-manager "MCP server mirroring task master mcp" ``` --- # Create MCP Server PRP Create a comprehensive Product Requirement Prompt (PRP) for building Model Context Protocol (MCP) servers with authentication, database integration, and Cloudflare Workers deployment. Before you start ensure that you read these key files to get an understanding about the goal of the PRP: PRPs/README.md PRPs/templates/prp_cp_base.md ## Users MCP use case: $ARGUMENTS ## Purpose Generate context-rich PRPs specifically designed for MCP server development, using the proven patterns in this codebase that is a scaffolding of a MCP server setup that the user can build upon, including GitHub OAuth, and production-ready Cloudflare Workers deployment. None of the existing tools will likely be reused and the tools should be created for the users use case specifically tailored to their needs. ## Execution Process 1. **Research & Context Gathering** - Create clear todos and spawn subagents to search the codebase for similar features/patterns Think hard and plan your approach - Gather relevant documentation about MCP tools, resources, and authentication flows - Research existing tool patterns to understand how to build the users specified use case - Study existing integration patterns in the codebase 2. **Generate Comprehensive PRP** - Use the specialized `PRPs/templates/prp_mcp_base.md` template as the foundation - Customize the template with specific server requirements and functionality - Include all necessary context from the codebase patterns and ai_docs - Add specific validation loops for MCP server development - Include database integration patterns and security considerations 3. **Enhance with AI docs** - The use might have added docs in PRPs/ai_docs/ directory that you should read - If there are docs in the PRPs/ai_docs/ directory, review them and take them into context as you build the PRP ## Implementation Details ### PRP Structure for MCP Servers The generated PRP uses the specialized template `PRPs/templates/prp_mcp_base.md` and includes: - **Goal**: Clear description of the MCP server to be built with authentication and database integration - **Context**: All necessary documentation including PRPs/ai_docs/ references and existing codebase patterns - **Implementation Blueprint**: Step-by-step TypeScript tasks following Cloudflare Workers patterns - **Validation Loop**: Comprehensive MCP-specific testing from compilation to production deployment - **Security Considerations**: GitHub OAuth flows, database access patterns, and SQL injection protection ### Key Features - **Context-Rich**: Includes all patterns and references using relative paths from this proven codebase - **Validation-Driven**: Multi-level validation from syntax to production deployment - **Security-First**: Built-in authentication and authorization patterns - **Production-Ready**: Cloudflare Workers deployment and monitoring ### Research Areas 1. **MCP Protocol Patterns** - Tool registration and validation - Resource serving and caching - Error handling and logging - Client communication patterns 2. **Authentication Integration** - GitHub OAuth implementation - User permission systems - Token management and validation - Session handling patterns ## Output Creates a comprehensive PRP file in the PRPs/ directory with: - All necessary context and code patterns - Step-by-step implementation tasks - Validation loops for MCP server development ## Validation The command ensures: - All referenced code patterns exist in the codebase - Documentation links are valid and accessible - Implementation tasks are specific and actionable - Validation loops are comprehensive and executable by claude code (IMPORTANT) ## Integration with Existing Patterns - Uses specialized MCP template from `PRPs/templates/prp_mcp_base.md` - Follows the established directory structure and naming conventions - Integrates with existing validation patterns and tools - Leverages proven patterns from the current MCP server implementation in `src/` ## Notes - Generated PRPs are immediately executable with the companion `/prp-mcp-execute` command - All patterns are based on the proven implementation in this codebase - Includes comprehensive error handling and recovery patterns - Optimized for Claude Code's TodoWrite tool usage and validation loops

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/technophile-04/sre-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server