Skip to main content
Glama
NazzyDee

Control Room MCP Server

by NazzyDee

Control Room MCP Server

This is a standalone Express server that implements the Model Context Protocol (MCP). It is used to securely expose Google Analytics data and Firebase Cloud Messaging capabilities to Spark/Gemini.

Why a Standalone Server?

MCP relies on Server-Sent Events (SSE) to maintain a live streaming connection with the AI agent. Serverless functions (like Netlify Functions or AWS Lambda) are stateless and automatically terminate connections, which instantly crashes the stream. This standalone Node.js server solves that by running continuously.

Related MCP server: Google Docs and Gmail MCP Server

Since this requires a persistent server, deploying to a free host like Render.com is the best option.

  1. Push to GitHub:

    • Create a new, empty repository on GitHub called control-room-mcp.

    • Open this folder (v:\New App Ideas\Work\control-room-mcp) in your terminal or VS Code.

    • Run the commands GitHub gives you to push an existing repository.

  2. Deploy to Render:

    • Go to Render.com and sign in.

    • Click New -> Web Service.

    • Connect your GitHub account and select your new control-room-mcp repo.

    • Settings:

      • Build Command: npm install

      • Start Command: npm start

      • Instance Type: Free

    • Environment Variables: Make sure you copy over these 3 variables exactly as they are in your Netlify Control Room app:

      • GOOGLE_PRIVATE_KEY

      • GOOGLE_CLIENT_EMAIL

      • VITE_GA_PROPERTY_ID

  3. Connect to Spark:

    • Once Render finishes deploying, it will give you a .onrender.com URL.

    • Go to Gemini -> Set up custom connected app.

    • Enter your Render URL with /mcp at the end (e.g. https://control-room-mcp.onrender.com/mcp).

    • Done! Spark is now securely connected to your Control Room.

Maintenance

ActivitySlowing
ResponsivenessNo issues

Related MCP Connectors

Related MCP Servers

  • A
    license
    Not graded
    quality
    D
    maintenance
    A powerful Model Context Protocol (MCP) server that provides comprehensive Google Analytics 4 (GA4), Google Search Console (GSC), and Google Merchant Center (GMC) integration for Claude Desktop and other MCP clients.
    Apache 2.0
  • A
    license
    Not graded
    quality
    C
    maintenance
    MCP server for querying Google Analytics accounts, properties, reports, and realtime data using the Data API and Admin API.
    Apache 2.0
  • F
    license
    Not graded
    quality
    C
    maintenance
    Production-ready MCP server integrating Google Search Console, GA4, and PageSpeed Insights for SEO and analytics intelligence, enabling natural-language queries to Google analytics data.
    -