S&P 500
An MCP server and Next.js web app for querying S&P 500 company data from Supabase, with tools for company info, news, officers, and SEC filings, plus embedded MCP App UI resources, Elicitation, and Sampling support.
What is S&P 500?
S&P 500 is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to mcp server and next.js web app for querying s&p 500 company data from supabase, with tools for company info, news, officers, and sec filings, plus embedded mcp app ui resources, elicitation, and sampl...
An MCP server and Next.js web app for querying S&P 500 company data from Supabase, with tools for company info, news, officers, and SEC filings, plus embedded MCP App UI resources, Elicitation, and Sampling support.
This server falls under the Finance & Fintech category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- An MCP server and Next.js web app for querying S&P 500 compa
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx sp500Configuration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use S&P 500
The S&P 500 MCP Server is a TypeScript/Next.js application that exposes six structured financial data tools covering all companies in the S&P 500 index, backed by a Supabase database. AI assistants can query company fundamentals, annual financial metrics with chart-ready trend data, historical OHLCV price series, recent news with sentiment, executive officer compensation, and SEC filing histories with type and date filters. Analysts and developers use it to let Claude or another AI perform research on public company data — comparing financials, summarizing executive changes, or retrieving specific SEC filings — without manual data gathering.
Prerequisites
- Node.js 18 or later and pnpm installed
- A Supabase project with the S&P 500 data tables loaded (see repository for schema details)
- SUPABASE_URL and SUPABASE_ANON_KEY from your Supabase project settings
- An MCP-compatible client such as Claude Desktop or Cursor
Clone the repository
Download the monorepo which contains both the MCP server and the Next.js web app.
git clone https://github.com/zhensherlock/sp500-mcp-server.git
cd sp500-mcp-serverInstall dependencies
Use pnpm to install all workspace dependencies.
pnpm installSet environment variables
Create a .env.local file (or set environment variables) with your Supabase credentials.
SUPABASE_URL=https://your-project.supabase.co
SUPABASE_ANON_KEY=your_anon_key_here
MCP_MAX_DURATION=60Build the embedded MCP app UI
Build the web app assets before starting the dev server.
pnpm --filter @apps/web-app buildStart the development server
Run the Next.js dev server. The MCP SSE endpoint becomes available at /sse.
pnpm dev
# Web app: http://localhost:3000
# MCP endpoint: http://localhost:3000/sseConfigure your MCP client
Point your MCP client at the SSE endpoint to connect to the server.
{
"mcpServers": {
"sp500": {
"url": "http://localhost:3000/sse"
}
}
}S&P 500 Examples
Client configuration
MCP client config using the SSE transport to connect to the locally running S&P 500 server.
{
"mcpServers": {
"sp500": {
"url": "http://localhost:3000/sse"
}
}
}Prompts to try
Example prompts that exercise each of the six exposed tools.
- "Give me a business summary and key financials for Apple (AAPL)"
- "Show me the annual revenue trend for Microsoft over the last 5 years"
- "Get the daily closing price data for Tesla from 2023-01-01 to 2023-12-31"
- "What are the most recent news headlines for NVIDIA and their sentiment?"
- "Who are the top executive officers at Amazon and what is their compensation?"
- "List all 10-K filings for Meta Platforms in the last 3 years"Troubleshooting S&P 500
Tools return empty results or 'table not found' errors
The server requires pre-loaded S&P 500 data tables in your Supabase project. Check the repository for the expected schema and import the data before running the server.
SUPABASE_ANON_KEY errors or unauthorized responses
Copy the anon public key from your Supabase project's API settings page (not the service role key). Make sure it matches the project pointed to by SUPABASE_URL.
MCP client cannot reach the SSE endpoint
Confirm the dev server is running with 'pnpm dev' and listening on port 3000. If the port is in use, configure an alternative port and update the URL in your MCP client config.
Frequently Asked Questions about S&P 500
What is S&P 500?
S&P 500 is a Model Context Protocol (MCP) server that mcp server and next.js web app for querying s&p 500 company data from supabase, with tools for company info, news, officers, and sec filings, plus embedded mcp app ui resources, elicitation, and sampling support. It connects AI assistants to external tools and data sources through a standardized interface.
How do I install S&P 500?
Follow the installation instructions on the S&P 500 GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with S&P 500?
S&P 500 works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is S&P 500 free to use?
Yes, S&P 500 is open source and available under the AGPL-3.0 license. You can use it freely in both personal and commercial projects.
S&P 500 Alternatives — Similar Finance & Fintech Servers
Looking for alternatives to S&P 500? Here are other popular finance & fintech servers you can use with Claude, Cursor, and VS Code.
ValueCell
★ 10.7kValueCell is a community-driven, multi-agent platform for financial applications.
Vibe Trading
★ 8.1k'Vibe-Trading: Your Personal Trading Agent'
Quantdinger
★ 6.2kAI quantitative trading platform for crypto, stocks, and forex with backtesting, live trading, market data, and multi-agent research.vibe-trading ,trading-agents,ai-trader,ai-trading
TradingView
★ 2.8kReal-time crypto & stock screening, advanced technical indicators, Bollinger Bands intelligence, candlestick patterns + native Claude Desktop integration. Multi-exchange (Binance, KuCoin, Bybit+). Open-source AI trading infrastructure.
Financial Datasets
★ 2.1kProvides access to comprehensive financial data including income statements, balance sheets, cash flow statements, stock prices, company news, SEC filings, and cryptocurrency information with built-in financial ratio analysis.
Stripe
★ 1.6kThe Stripe Model Context Protocol server allows you to integrate with Stripe APIs through function calling. This protocol supports various tools to interact with different Stripe services.
Browse More Finance & Fintech MCP Servers
Explore all finance & fintech servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up S&P 500 in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use S&P 500?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.