by zhensherlock
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.
# Add to your Claude Code skills
git clone https://github.com/zhensherlock/sp500-mcp-serverGuides for using mcp servers skills like sp500-mcp-server.
An MCP (Model Context Protocol) server and Next.js web app for querying S&P 500 company data from Supabase. It exposes MCP tools for company fundamentals, annual financial metrics, historical price data, news sentiment, officers, and SEC filings, plus a web UI and embedded MCP App resources for browsing and testing those tools.
| Tool | Description |
| ------------------------ | --------------------------------------------------------------------- |
| get_company_info | Company basics, financials, leadership, address, and business summary |
| get_company_financials | Annual financial metrics with chart-ready trends and matrix output |
| get_company_price_data | Historical daily OHLCV price rows with date filters |
| get_company_news | Recent company news with sentiment filtering |
| get_company_officers | Executive officers and compensation |
| get_company_filings | SEC filings history, with filing type and date filters |
search_companies is an internal symbol resolver, not an exposed MCP tool. User queries are resolved through getCompanySymbol.
.nvmrc)apps/web)apps/web-app and served as tool UI resourcesNo comments yet. Be the first to share your thoughts!
Top skills in this category by stars
mcp-handlerapps/web/app/[transport]/route.ts/sseapps/web/app/[transport]/utils/supabase.tspackages/uipnpm install
SUPABASE_URL=your_supabase_url
SUPABASE_ANON_KEY=your_supabase_anon_key
MCP_MAX_DURATION=60
REDIS_URL=your_redis_url
LOGO_DEV_TOKEN=your_logo_dev_publishable_key
SUPABASE_URL and SUPABASE_ANON_KEY are required. REDIS_URL is only needed for production SSE. LOGO_DEV_TOKEN is required for the /api/logo/* proxy.
pnpm --filter @apps/web-app build
pnpm dev
The Next.js web app runs on http://localhost:3000; the MCP endpoint is http://localhost:3000/sse. The apps/web-app dev server proxies /sse to port 3000 when run separately.
pnpm dev # Start apps/* dev tasks via Turbo
pnpm build # Build apps/web and apps/web-app via Turbo
pnpm start # Start production server for apps/web
pnpm type-check # Type-check apps/web and apps/web-app
pnpm lint # ESLint + Prettier rule checks
Focused commands:
pnpm --filter @apps/web dev
pnpm --filter @apps/web-app dev
pnpm --filter @apps/web-app build
pnpm exec tsc -p apps/web/tsconfig.json --noEmit
pnpm exec tsc -p apps/web-app/tsconfig.json --noEmit
pnpm exec tsc -p packages/ui/tsconfig.json --noEmit
Tests are integration tests that connect a real MCP client to http://localhost:3000/sse, so start the dev server first:
pnpm --filter @apps/web-app build
pnpm dev
pnpm test
Run a single tool test:
pnpm vitest run apps/web/tests/tools/get-company-info-tool.test.ts
Generate coverage:
pnpm coverage
apps/web/
app/[transport]/route.ts MCP GET/POST/DELETE handler
app/[transport]/tools/ MCP tool registrations
app/[transport]/utils/ Supabase, symbol resolution, summaries
app/api/tools/call/route.ts HTTP proxy for the web tool tester
app/tools/ Tool catalog page
components/ App-specific UI
tests/tools/ MCP integration tests
apps/web-app/
src/pages/ Embedded MCP App pages, one per tool
src/components/ MCP App UI components
scripts/build-pages.js Builds each page into dist/*.html
dist/ Generated single-file HTML resources
packages/ui/
src/components/ Shared shadcn UI primitives
src/styles/globals.css Shared Tailwind CSS
apps/web/app/[transport]/tools/app-resource.ts reads generated HTML from apps/web-app/dist, so rebuild apps/web-app after changing embedded MCP App pages.
MCP_MAX_DURATION defaults to 60; set a higher duration for long-running production calls when your Vercel plan supports itdisableSse: false); production SSE requires Redis via REDIS_URLFull guides and examples: https://sp500-mcp.vercel.app/
Feel free to dive in! Open an issue or submit PRs.
Standard Readme follows the Contributor Covenant Code of Conduct.
This project exists thanks to all the people who contribute.
GNU Affero General Public License v3.0 © MichaelSun