Rice Stock Data Portal - MCP Server

A Model Context Protocol (MCP) server that provides natural language access to Rice Business Stock Market Data Portal through Claude Desktop.

Quick Start

For Users

1. Install the MCP server:

   npm install -g @kerryback/data-portal-mcp

1. Get your access token from your Rice Data Portal instance

1. Configure Claude Desktop by adding to your config file:

   {
     "mcpServers": {
       "rice-stock-data": {
         "command": "npx",
         "args": ["@kerryback/data-portal-mcp"],
         "env": {
           "KOYEB_APP_URL": "https://your-app.koyeb.app",
           "MCP_ACCESS_TOKEN": "your_access_token_here"
         }
       }
     }
   }

1. Start asking questions in Claude Desktop:

• "Show me Apple's financial ratios"
• "Find undervalued healthcare stocks"
• "What are the top technology companies by market cap?"

For Developers

This repository contains the MCP server implementation for the Rice Stock Data Portal. The server acts as a bridge between Claude Desktop and your deployed Flask application.

Features

• 🔒 Secure Token Storage - Access tokens stored in Claude Desktop configuration
• 💬 Natural Language Queries - Ask questions in plain English
• 📊 Real-time Data - Direct access to your MotherDuck financial database
• 🎓 University Integration - Designed for academic use with email verification
• ⚡ Fast Responses - Leverages existing OpenAI chat integration

Architecture

Claude Desktop → MCP Server → Flask App → MotherDuck Database

The MCP server forwards natural language queries to your Flask app's /chat endpoint, which uses OpenAI to understand the query and generate appropriate SQL.

Repository Structure

• src/index.ts - Main TypeScript MCP server implementation
• package.json - NPM package configuration
• Procfile - Koyeb deployment configuration
• FINAL_MCP_README.md - Complete user documentation
• DEPLOYMENT.md - Deployment guide

Development

# Install dependencies
npm install

# Build TypeScript
npm run build

# Run locally
npm start

# Test with environment variables
KOYEB_APP_URL=http://localhost:5000 \
MCP_ACCESS_TOKEN=your_token \
npm start

Deployment

This MCP server can be deployed to Koyeb for remote access:

1. Connect your GitHub repository to Koyeb
2. Set environment variables in Koyeb dashboard
3. Deploy using the provided Procfile

See DEPLOYMENT.md for complete instructions.

Documentation

• `FINAL_MCP_README.md` - Complete user guide
• `DEPLOYMENT.md` - Deployment instructions
• `claude_desktop_config.json` - Configuration example

Support

• Issues: GitHub Issues
• Main Portal: Rice Stock Data Portal

License

MIT License - See LICENSE file for details