A Model Context Protocol (MCP) server for fast database access to the Roast My Post system.
This MCP server provides direct database access to Roast My Post, enabling fast queries and analytics without writing scripts.
For detailed documentation of all available tools and their parameters, see FEATURES.md.
Run this single command to set up everything:
cd mcp-server
npm run setupThis will:
- Install dependencies
- Build the server
- Configure Claude Desktop automatically
After running setup, restart Claude Desktop to load the MCP server.
cd mcp-server
npm installnpm run buildnpm run configureOr manually add to your Claude Desktop configuration:
macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json
{
"mcpServers": {
"roast-my-post": {
"command": "node",
"args": ["/absolute/path/to/mcp-server/dist/index.js"],
"env": {
"DATABASE_URL": "your-database-url",
"ROAST_MY_POST_MCP_USER_API_KEY": "rmp_your-api-key-here"
}
}
}
}To enable mutation operations (creating agent versions and spawning batch jobs), you need to create an API key:
- Log into the RoastMyPost web interface
- Navigate to your user settings or API keys page
- Create a new API key with a descriptive name
- Copy the API key (you won't be able to see it again)
- Add it to your Claude Desktop configuration as shown above
The API key gives the MCP server the same permissions as your user account.
Once configured, you can use these tools in Claude:
"Show me all active agents"
"Get failed evaluations for agent-123"
"What's the performance of the ASSESSOR agents over the last 30 days?"
"Search for documents by ozzie"
"Search for 'machine learning' in document content"
The MCP server now includes a powerful search_documents tool that uses the server's search API:
- Fast metadata search: Searches in titles, authors, platforms, URLs using the optimized
searchableTextfield - Optional content search: Enable
searchContent: trueto search within document content - Pagination support: Use
limitandoffsetfor paginated results - No direct database access: Uses the server's
/api/documents/searchendpoint for consistency
npm run devThis watches for changes and rebuilds automatically.
- Add the tool definition in the
ListToolsRequestSchemahandler - Add the argument schema using Zod
- Implement the tool logic in the
CallToolRequestSchemahandler - The tool will be automatically available in Claude after rebuilding
You can test the server manually:
echo '{"jsonrpc": "2.0", "method": "tools/list", "id": 1}' | node dist/index.js- Database Connection Issues: Ensure DATABASE_URL is correct and the database is accessible
- Prisma Client Errors: The MCP server uses the parent project's Prisma client - rebuild if you see import errors
- Server Not Available in Claude: Check the config file path and restart Claude Desktop
- Permission Errors: Ensure the built file has execute permissions
- Add write operations (update agent instructions, archive agents)
- Implement caching for frequently accessed data
- Add more analytical tools (trend analysis, comparison tools)
- Support for batch operations
- Real-time monitoring capabilities