Zee.Media Client Reporting MCP
Zee.Media 客户报告 — MCP 连接器
只读的远程 MCP 服务器,将客户仪表板数据(Supabase client_series + client_reports)作为自定义连接器暴露给 claude.ai,这样团队就可以向 Claude 询问任何客户,它会实时读取数据。设计上为只读。
工具
list_clients, get_dashboard(slug), get_audit(slug), get_reports(slug), search(query)
Related MCP server: MCP PostgreSQL
部署(Render)
将此仓库推送到 GitHub(已完成)。
Render → 新建 → Web 服务 → 连接此仓库。它会读取
render.yaml。设置环境变量:
SUPABASE_URL、SUPABASE_SERVICE_KEY、AUTHKIT_DOMAIN和PUBLIC_URL(= Render URL,例如 https://zm-reporting-mcp.onrender.com)。部署。MCP 端点:
<PUBLIC_URL>/mcp/。
认证(WorkOS AuthKit — 免费)
workos.com → 创建一个 AuthKit 应用;启用动态客户端注册。
添加 Google 连接;限制为 zee.media 工作区域名(仅限团队成员)。
添加重定向:
https://claude.ai/api/mcp/auth_callback。复制 AuthKit 域名 → Render 上的
AUTHKIT_DOMAIN环境变量。
添加到 claude.ai
设置 → 连接器 → 添加自定义连接器 → URL <PUBLIC_URL>/mcp/ → 授权。
Related MCP Connectors
- SupabaseOAuthcom.supabase
MCP server for interacting with the Supabase platform
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
Read-only MCP server for ClassQuill, a tutoring-business-management platform.
- mcpOAuthcom.gibsonai
GibsonAI MCP server: manage your databases with natural language
Related MCP Servers
- AlicenseAqualityCmaintenanceRead-only MCP server for Gingr pet-care facility data, enabling queries about owners, animals, reservations, appointments, services, and staff via natural language.713 npmMIT
- AlicenseNot gradedqualityDmaintenanceA read-only MCP server for PostgreSQL that enables safe database introspection and querying via natural language.476 npmMIT
- AlicenseNot gradedqualityFmaintenanceMCP server for self-hosted Supabase with RLS-aware PostgreSQL and PostgREST layers, enabling safe database introspection, SQL queries, and PostgREST access via natural language.MIT
- AlicenseAqualityCmaintenanceSecurity-first, read-only MCP server for Microsoft SQL Server, enabling safe natural-language querying of databases.58 npmMIT