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

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

3. 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"
         }
       }
     }
   }

4. 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.

Related MCP server: Yahoo Finance MCP Server

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