sp500-mcp-server

Name: sp500-mcp-server
Author: zhensherlock

Verified

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.

105stars

1forks

TypeScript

Installation

# Add to your Claude Code skills
git clone https://github.com/zhensherlock/sp500-mcp-server

Getting Started

Guides for using mcp servers skills like sp500-mcp-server.

Best MCP Servers in 2026
Category-by-category picks: databases, dev tools, productivity, browser automation.
What is an AI Skills Marketplace?
Definitions, how marketplaces work, and how to choose between them in 2026.
Getting Started with AI Skills
First-time install walkthrough for Claude Code, Codex CLI, and ChatGPT.

Security ReportVerified

Last scanned: 5/30/2026

{
  "issues": [],
  "status": "PASSED",
  "scannedAt": "2026-05-30T17:02:17.351Z",
  "npmAuditRan": false,
  "pipAuditRan": true
}

README.md

Frequently Asked Questions

What is sp500-mcp-server?

sp500-mcp-server is an open-source mcp servers skill for AI coding assistants such as Claude Code, Codex CLI, and ChatGPT, built 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. It has 105 GitHub stars.

Is sp500-mcp-server safe to use?

Yes. sp500-mcp-server passed SkillsLLM's automated security scan — a dependency vulnerability audit plus prompt-injection heuristics — with no high-severity issues. You can read the full report in the Security Report section on this page.

How do I install sp500-mcp-server?

Clone the repository with "git clone https://github.com/zhensherlock/sp500-mcp-server" and add it to your Claude Code skills directory (see the Installation section above).

What programming language is sp500-mcp-server written in?

sp500-mcp-server is primarily written in TypeScript. It is open-source under zhensherlock on GitHub, so you can review or fork the full source.

Are there alternatives to sp500-mcp-server?

Yes. SkillsLLM lists many other MCP Servers skills you can browse and compare side by side. Open the MCP Servers category from the badge at the top of this page, or use the Related Skills and comparison links further down to weigh sp500-mcp-server against similar tools.

MCP for Beginners

Build MCP servers that give AI assistants real capabilities

36 minBeginner

Comments (0)

to leave a comment.

No comments yet. Be the first to share your thoughts!

Related Skills

ECC

by affaan-m

The agent harness performance optimization system. Skills, instincts, memory, security, and research-first development for Claude Code, Codex, Opencode, Cursor and beyond.

225,330

Popular in MCP Servers

Top skills in this category by stars

Scrapling

by D4Vinci

🕷️ An adaptive Web Scraping framework that handles everything from a single request to a full-scale crawl!

67,858

django-ai-boost fred-mcp-server

S&P 500 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.

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.

Tech Stack

Workspace: pnpm 10.33.3 + Turborepo
Runtime: Node 22 (.nvmrc)
Web app: Next.js 16 App Router, React 19, TypeScript strict mode (apps/web)
MCP Apps: Vite single-file React pages built from apps/web-app and served as tool UI resources
MCP: mcp-handler at apps/web/app/[transport]/route.ts; /sse is the public SSE endpoint
Database: Supabase client at apps/web/app/[transport]/utils/supabase.ts
UI: shared shadcn/Tailwind primitives in packages/ui

Getting Started

Prerequisites

Node.js 22
pnpm 10
Supabase project with the S&P 500 data tables used by the tools

Local Development

Install dependencies:

pnpm install

Create a local env file with Supabase credentials:

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.

Build the embedded MCP App HTML resources:

pnpm --filter @apps/web-app build

Start the apps:

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.

Commands

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

Testing

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

Project Layout

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.

Vercel Deployment

Requires Fluid compute
MCP_MAX_DURATION defaults to 60; set a higher duration for long-running production calls when your Vercel plan supports it
SSE is enabled (disableSse: false); production SSE requires Redis via REDIS_URL

Docs

Full guides and examples: https://sp500-mcp.vercel.app/

Contributing

Feel free to dive in! Open an issue or submit PRs.

Standard Readme follows the Contributor Covenant Code of Conduct.

Contributors

This project exists thanks to all the people who contribute.

sp500-mcp-server

Frequently Asked Questions

What is sp500-mcp-server?

Is sp500-mcp-server safe to use?

How do I install sp500-mcp-server?

What programming language is sp500-mcp-server written in?

Are there alternatives to sp500-mcp-server?

Related Skills

Popular in MCP Servers

S&P 500 MCP Server

Tools

Tech Stack

Getting Started

Prerequisites

Local Development

Commands

Testing

Project Layout

Vercel Deployment

Docs

Contributing

Contributors

License