Skip to main content

Google Cloud Firestore MCP Server

Create a powerful Model Context Protocol (MCP) server for Google Cloud Firestore in minutes with our AI Gateway. This guide walks you through setting up seamless NoSQL database integration with real-time synchronization and instant API authentication.

About Google Cloud Firestore API​

Google Cloud Firestore is a flexible, scalable NoSQL cloud database for mobile, web, and server development. It provides real-time synchronization, offline support, and seamless integration with other Google Cloud services.

Key Capabilities​

  • Real-time Updates: Live data synchronization
  • Offline Support: Local caching and sync
  • ACID Transactions: Strong consistency
  • Flexible Queries: Complex filtering and sorting
  • Automatic Scaling: Handle any load
  • Security Rules: Fine-grained access control
  • Global Distribution: Multi-region replication
  • SDK Integration: Native mobile/web support

API Features​

  • RESTful API: Standard HTTP operations
  • gRPC Support: High-performance option
  • OAuth 2.0: Secure authentication
  • Batch Operations: Efficient bulk updates
  • Real-time Listeners: WebSocket connections
  • Export/Import: Backup and migration
  • Indexes: Custom query optimization
  • Monitoring: Usage metrics and logs

What You Can Do with Firestore MCP Server​

The MCP server transforms Firestore API into a natural language interface, enabling AI agents to:

Document Operations​

  • CRUD Operations

    • "Create user profile document"
    • "Update product inventory"
    • "Delete expired records"
    • "Read customer data"

  • Batch Operations

    • "Update prices for all products"
    • "Delete documents older than 30 days"
    • "Import user data from CSV"
    • "Export collection to backup"

  • Document Search

    • "Find orders from last week"
    • "Search products under $50"
    • "Get documents by status"
    • "Query with multiple filters"

Collection Management​

  • Collection Operations

    • "Create new collection"
    • "List all collections"
    • "Count documents in collection"
    • "Delete empty collections"

  • Subcollections

    • "Add reviews to product"
    • "Create nested structure"
    • "Query across subcollections"
    • "Manage hierarchical data"

  • Collection Groups

    • "Query all reviews"
    • "Search across subcollections"
    • "Aggregate nested data"
    • "Apply security rules"

Real-time Features​

  • Live Listeners

    • "Watch for new orders"
    • "Monitor inventory changes"
    • "Track user activity"
    • "Sync data updates"

  • Change Feeds

    • "Stream document changes"
    • "Get modification history"
    • "Track field updates"
    • "Monitor deletions"

  • Presence System

    • "Track online users"
    • "Show active sessions"
    • "Monitor connections"
    • "Handle disconnections"

Query Operations​

  • Simple Queries

    • "Get active users"
    • "Find completed orders"
    • "List featured products"
    • "Search by category"

  • Compound Queries

    • "Find orders over $100 from California"
    • "Get products in stock under $50"
    • "Search users by age and location"
    • "Filter by multiple conditions"

  • Aggregation Queries

    • "Count total orders"
    • "Sum revenue by month"
    • "Average product rating"
    • "Group by category"

Data Management​

  • Transactions

    • "Transfer funds between accounts"
    • "Update inventory atomically"
    • "Increment counters safely"
    • "Batch atomic updates"

  • Data Validation

    • "Enforce field types"
    • "Validate required fields"
    • "Check value ranges"
    • "Apply business rules"

  • Backup & Restore

    • "Export database backup"
    • "Schedule automatic backups"
    • "Restore from point in time"
    • "Migrate between projects"

Security & Access​

  • Security Rules

    • "Configure access control"
    • "Set user permissions"
    • "Validate data writes"
    • "Enforce rate limits"

  • Authentication

    • "Integrate with Firebase Auth"
    • "Custom authentication"
    • "Service account access"
    • "API key management"

  • Field-level Security

    • "Restrict sensitive fields"
    • "Role-based access"
    • "Conditional visibility"
    • "Audit data access"

Analytics & Monitoring​

  • Usage Metrics

    • "Show read/write operations"
    • "Monitor bandwidth usage"
    • "Track active connections"
    • "Calculate costs"

  • Performance Analysis

    • "Identify slow queries"
    • "Optimize indexes"
    • "Monitor latency"
    • "Track hotspots"

  • Audit Logs

    • "Track data changes"
    • "Monitor admin actions"
    • "Review access logs"
    • "Generate reports"

Prerequisites​

  • Access to Cequence AI Gateway
  • Google Cloud Project
  • Firestore API enabled
  • Service account credentials

Step 1: Configure Firestore API Access​

1.1 Enable Firestore API​

  1. Go to Google Cloud Console
  2. Navigate to Firestore
  3. Click Create Database
  4. Choose mode:
    • Native Mode (recommended)
    • Datastore Mode

1.2 Create Service Account​

  1. Go to IAM & Admin Service Accounts
  2. Click Create Service Account
  3. Configure:
    • Name: "AI Gateway Firestore"
    • Role: Cloud Datastore User or Owner
  4. Create and download JSON key

1.3 Configure Database​

  1. Select database location (multi-region recommended)
  2. Configure security rules
  3. Set up indexes if needed
  4. Enable audit logs (optional)

1.4 OAuth 2.0 Setup (Alternative)​

For user-context access:

  1. Create OAuth 2.0 credentials
  2. Configure consent screen
  3. Add authorized redirect URIs

Step 2-4: Standard Setup​

Follow standard steps to access AI Gateway, find Firestore API, and create MCP server.

Step 5: Configure API Endpoints​

  1. Base URL: https://firestore.googleapis.com/v1
  2. Project ID: Your GCP project ID
  3. Database ID: (default) or custom
  4. Click Next

Step 6: MCP Server Configuration​

  1. Name: "Firestore Database"
  2. Description: "NoSQL real-time database"
  3. Request Timeout: 60 seconds
  4. Click Next

Step 7: Configure Authentication​

  1. Authentication Type: Service Account
  2. Upload service account JSON key
  3. Or configure OAuth 2.0:
    • Client ID and Secret
    • Required scopes
  4. Test connection

Available Firestore API Operations​

Document APIs​

  • Document Operations

    • Create document
    • Get document
    • Update document
    • Delete document
    • List documents

  • Batch Operations

    • Batch get
    • Batch write
    • Batch delete

Collection APIs​

  • Collection Operations
    • List collections
    • Query collection
    • Add to collection
    • Clear collection

Query APIs​

  • Query Operations
    • Simple queries
    • Compound queries
    • Collection group queries
    • Aggregation queries

Transaction APIs​

  • Transaction Operations
    • Begin transaction
    • Commit transaction
    • Rollback transaction

Real-time APIs​

  • Listen Operations
    • Document listeners
    • Collection listeners
    • Query listeners

Admin APIs​

  • Database Operations
    • Export database
    • Import database
    • Create indexes
    • Backup/restore

Step 8-10: Complete Setup​

Configure security settings, choose deployment options, and deploy your server.

Using Your Firestore MCP Server​

Setup Instructions:

Natural Language Commands​

  • "Create a new user document with email and name"
  • "Find all orders placed today with status pending"
  • "Update product inventory when order is placed"
  • "Watch for changes in the messages collection"
  • "Count total active users in the system"

Common Use Cases​

Mobile/Web Apps​

  • User profiles and settings
  • Real-time chat and messaging
  • Collaborative editing
  • Offline-first applications

E-commerce​

  • Product catalogs
  • Shopping carts
  • Order management
  • Inventory tracking

Gaming​

  • Player profiles
  • Leaderboards
  • Game state
  • Matchmaking

IoT & Sensor Data​

  • Device management
  • Sensor readings
  • Real-time monitoring
  • Event logging

Best Practices​

  1. Data Modeling:

    • Denormalize for performance
    • Use subcollections wisely
    • Consider query patterns
    • Avoid deep nesting

  2. Performance:

    • Create appropriate indexes
    • Limit document size (1MB max)
    • Use pagination for large results
    • Cache frequently accessed data

  3. Security:

    • Write comprehensive security rules
    • Validate data on write
    • Use least privilege access
    • Audit sensitive operations

Troubleshooting​

Common Issues​

  1. Permission Errors

    • Check service account roles
    • Verify security rules
    • Review OAuth scopes
    • Confirm project access

  2. Query Performance

    • Add composite indexes
    • Reduce result size
    • Optimize where clauses
    • Use query explain

  3. Real-time Issues

    • Check listener limits
    • Handle reconnection
    • Monitor bandwidth
    • Implement error retry

Getting Help​