Skip to main content
Glama
deenesjakoruzh
dannyzeemedia

Zee.Media Client Reporting MCP

by dannyzeemedia
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Remote

Zee.Media Client Reporting — MCP connector

Read-only remote MCP server that exposes the client-dashboard data (Supabase client_series + client_reports) to claude.ai as a custom connector, so the team can ask Claude about any client and it reads live. Read-only by design.

Tools

list_clients, get_dashboard(slug), get_audit(slug), get_reports(slug), search(query)

Related MCP server: MCP PostgreSQL

Deploy (Render)

  1. Push this repo to GitHub (done).

  2. Render → New → Web Service → connect this repo. It reads render.yaml.

  3. Set env vars: SUPABASE_URL, SUPABASE_SERVICE_KEY, AUTHKIT_DOMAIN, and PUBLIC_URL (= the Render URL, e.g. https://zm-reporting-mcp.onrender.com).

  4. Deploy. MCP endpoint: <PUBLIC_URL>/mcp/.

Auth (WorkOS AuthKit — free)

  1. workos.com → create an AuthKit app; enable Dynamic Client Registration.

  2. Add a Google connection; restrict to the zee.media workspace domain (team only).

  3. Add redirect: https://claude.ai/api/mcp/auth_callback.

  4. Copy the AuthKit domain → AUTHKIT_DOMAIN env on Render.

Add to claude.ai

Settings → Connectors → Add custom connector → URL <PUBLIC_URL>/mcp/ → authorize.

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityMaintained
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • gingr-mcp

    shashicandev
    A
    license
    A
    quality
    C
    maintenance
    Read-only MCP server for Gingr pet-care facility data, enabling queries about owners, animals, reservations, appointments, services, and staff via natural language.
    7
    5 npm
    MIT

  • MCP PostgreSQL

    cuevacelis
    A
    license
    Not graded
    quality
    D
    maintenance
    A read-only MCP server for PostgreSQL that enables safe database introspection and querying via natural language.
    529 npm
    MIT

  • airis-mcp-supabase-selfhost

    agiletec-inc
    A
    license
    Not graded
    quality
    F
    maintenance
    MCP 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

  • MSSQL-MCP

    esasiyun17
    A
    license
    A
    quality
    A
    maintenance
    Security-first, read-only MCP server for Microsoft SQL Server, enabling safe natural-language querying of databases.
    5
    7 npm
    MIT