# sp500-mcp-server — Query S&P 500 Company Data via MCP

> sp500-mcp-server is an MCP server + Next.js app for querying S&P 500 company fundamentals, officers, filings, and news via Supabase.

## Install

Merge the JSON below into your `.mcp.json`:

## Quick Use

```bash
pnpm install
cp .env.example .env  # set SUPABASE_URL + SUPABASE_ANON_KEY
pnpm --filter @apps/web-app build
pnpm dev
# MCP endpoint:
echo 'http://localhost:3000/sse'
```

## Intro

sp500-mcp-server is an MCP server + Next.js app for querying S&P 500 company fundamentals, officers, filings, and news via Supabase.

**Best for:** Agents that need structured finance context (fundamentals, filings, news)

**Works with:** Node.js 22, pnpm, Supabase, MCP clients over SSE (/sse)

**Setup time:** 15-45 minutes

### Key facts (verified)

- GitHub: 91 stars · 1 forks · pushed 2026-05-13.
- License: AGPL-3.0 · owner avatar + repo URL verified via GitHub API.
- README-verified entrypoint: `pnpm install && pnpm dev`.

## Main

- Run it locally as a finance context backend: agents can call tools for company info, financial trends, officers, and filings instead of scraping pages.

- Treat Supabase as the source of truth; validate table/schema expectations before using it in production agent workflows.

- Use the included embedded MCP App resources as a test harness: build the web-app package and browse tool UIs while debugging.

### Source-backed notes

- README lists MCP tools like `get_company_info`, `get_company_financials`, and `get_company_filings` plus a web UI.
- README says the MCP endpoint is served at `http://localhost:3000/sse` during local dev.
- README documents pnpm-based setup and an env file requiring `SUPABASE_URL` and `SUPABASE_ANON_KEY`.

### FAQ

- **Do I need Supabase?**: Yes — README lists Supabase credentials as required for the tools to work.
- **Is SSE required?**: For MCP over HTTP/SSE, yes; the README calls out `/sse` as the public endpoint.
- **Can I deploy it?**: README includes Vercel notes; start local first to confirm schema and tool behavior.

## Source & Thanks

> Source: https://github.com/zhensherlock/sp500-mcp-server
> License: AGPL-3.0
> GitHub stars: 91 · forks: 1

---

<!-- ZH -->

## Quick Use

```bash
pnpm install
cp .env.example .env  # set SUPABASE_URL + SUPABASE_ANON_KEY
pnpm --filter @apps/web-app build
pnpm dev
# MCP endpoint:
echo 'http://localhost:3000/sse'
```

## Intro

sp500-mcp-server 提供 MCP + Next.js：从 Supabase 查询标普 500 公司基本面、管理层、SEC 文件与新闻情绪，并通过 `/sse` 作为 MCP 端点供 agent 调用。

**Best for:** 需要公司基本面/文件/新闻这类结构化金融上下文的 agent

**Works with:** Node.js 22；pnpm；Supabase；通过 SSE（/sse）接入的 MCP 客户端

**Setup time:** 15-45 minutes

### Key facts (verified)

- GitHub：91 stars · 1 forks；最近更新 2026-05-13。
- 许可证：AGPL-3.0；作者头像与仓库链接均已通过 GitHub API 复核。
- README 中核对过的入口命令：`pnpm install && pnpm dev`。

## Main

- 把它当作金融上下文后端：agent 直接调用 company info/财务趋势/高管/申报文件等工具，避免网页抓取。

- Supabase 是数据真源：上线前先核对表结构与字段，避免 agent 在错误 schema 上做推断。

- 用内置的 MCP App 资源当测试台：先 build web-app，然后用 Web UI/嵌入页面调试工具调用。

### Source-backed notes

- README 列出 MCP tools：`get_company_info`、`get_company_financials`、`get_company_filings` 等，并包含 Web UI。
- README 写明本地开发时 MCP 端点在 `http://localhost:3000/sse`。
- README 说明使用 pnpm，且 `.env` 必填 `SUPABASE_URL` 与 `SUPABASE_ANON_KEY`。

### FAQ

- **必须要 Supabase 吗？**：是。README 把 Supabase 凭证列为必需，否则工具无法查询数据。
- **一定要 SSE 吗？**：如果走 MCP 的 HTTP/SSE 方式，是的；README 将 `/sse` 标为公开端点。
- **能部署到线上吗？**：README 有 Vercel 部署说明；建议先本地跑通再迁移到线上并加上凭证/限流策略。

## Source & Thanks

> Source: https://github.com/zhensherlock/sp500-mcp-server
> License: AGPL-3.0
> GitHub stars: 91 · forks: 1


---
Source: https://tokrepo.com/en/workflows/sp500-mcp-server-query-s-p-500-company-data-via-mcp
Author: MCP Hub