Tenzetta Market Cap Updater

A service that automatically updates S&P 500 stock market capitalization data from the Tenzetta MCP server to a Supabase database.

Features

• Daily automatic updates of S&P 500 market cap data
• Fetches data from Tenzetta MCP server API
• Updates Supabase database with latest market cap values
• Runs via GitHub Actions workflow every day at midnight UTC
• Detailed logging of update operations

Setup

1. Clone this repository
2. Install dependencies:

   npm install
   

3. Create a .env file with your Supabase credentials:

   NEXT_PUBLIC_SUPABASE_URL=your-supabase-url
   NEXT_PUBLIC_SUPABASE_ANON_KEY=your-supabase-anon-key
   

4. Run the update script manually:

   node scripts/update-market-caps-daily.js
   

GitHub Actions Setup

This repository includes a GitHub Actions workflow that runs the update script daily. To use it:

1. Add your Supabase credentials as repository secrets:
   • NEXT_PUBLIC_SUPABASE_URL
   • NEXT_PUBLIC_SUPABASE_ANON_KEY
2. The workflow will run automatically every day at midnight UTC
3. You can also trigger it manually from the Actions tab

API Endpoints

The script fetches data from the Tenzetta MCP server:

• Base URL: https://mcp-server-tenzetta.replit.app/mcp/market-cap
• Individual stock endpoint: https://mcp-server-tenzetta.replit.app/mcp/market-cap/{symbol}

Database Structure

The script updates the following fields in the sp500_stocks table:

• market_cap: The market capitalization value in USD
• market_cap_date: The date of the market cap data

Logs

Update logs are stored in the logs/ directory with the naming convention market_cap_update_YYYY-MM-DD.log. These logs include:

• Total number of stocks processed
• Success and failure counts
• List of top 10 stocks by market cap