GCP MCP

Instructions

    Create a backup for a Cloud SQL instance.
    
    Args:
        project_id: The ID of the GCP project
        instance_id: The ID of the Cloud SQL instance
        description: Optional description for the backup
    
    Returns:
        Result of the backup operation
    

Implementation Reference

• src/gcp_mcp/gcp_modules/databases/tools.py:185-228 (handler)

  The create_backup tool handler: creates an on-demand backup for a Cloud SQL instance using the GCP SQL Admin API.

      @mcp.tool()
      def create_backup(project_id: str, instance_id: str, description: Optional[str] = None) -> str:
          """
          Create a backup for a Cloud SQL instance.
          
          Args:
              project_id: The ID of the GCP project
              instance_id: The ID of the Cloud SQL instance
              description: Optional description for the backup
          
          Returns:
              Result of the backup operation
          """
          try:
              from googleapiclient import discovery
              
              # Initialize the Cloud SQL Admin API client
              service = discovery.build('sqladmin', 'v1')
              
              # Create backup
              backup_run_body = {}
              if description:
                  backup_run_body['description'] = description
              
              request = service.backupRuns().insert(project=project_id, instance=instance_id, body=backup_run_body)
              operation = request.execute()
              
              # Get operation ID and status
              operation_id = operation.get('name', 'Unknown')
              status = operation.get('status', 'Unknown')
              
              return f"""
  Backup operation initiated:
  - Instance: {instance_id}
  - Project: {project_id}
  - Description: {description or 'None provided'}
  
  Operation ID: {operation_id}
  Status: {status}
  
  The backup process may take some time to complete. You can check the status of the backup using the Cloud SQL Admin API or Google Cloud Console.
  """
          except Exception as e:
              return f"Error creating backup: {str(e)}"

• src/gcp_mcp/server.py:57-57 (registration)

  Registers the databases tools module, which contains the create_backup handler, with the MCP server instance.

  databases_tools.register_tools(mcp)